AI for data analysis · How Founders Use AI
Can AI write SQL for me and query my database in plain English?
Yes. Text-to-SQL now hits 85 to 95 percent accuracy on everyday SELECT, JOIN, and GROUP BY questions, and MCP connectors let Claude or Codex query your Postgres in plain English. Most wrong answers come from fuzzy definitions (what is an active user?), so write yours down where the AI can read them. Then give it a read-only database user and spot-check questions whose answers you already know.
On the AI map, 29 October 2026 Spreadsheets, data and internal toolsFinance and accounting
Go deeper19 sources
-
How Anthropic enables self-service data analytics with Claude
Anthropic · Article · Jun 2026
Anthropic's data team on automating its own business questions with Claude: why accuracy is a context and definitions problem, the three failure modes, and the setup they use.
-
Text-to-SQL Complete Guide: Tools, Accuracy, Real Examples
AI2SQL · Guide · 2026
Explains how schema-aware SQL generation actually works and its real accuracy numbers.
-
Top 5 Text-to-SQL Query Tools
Bytebase · Article · 2026
A database-tooling company's current shortlist, updated as the field moves.
-
Best Text-to-SQL Tools for AI Analytics
Select Star · Article · 2025
Covers the metadata-only options that never send your actual rows to the model.
-
Vanna 2.0: build agents your users can actually use
Vanna AI · Tool · 2025
The best-known open-source route to chatting with your own SQL database.
-
vanna-ai/vanna on GitHub
Vanna AI · Guide · 2025
The repo plus docs, with RAG-based training on your schema for accurate SQL.
-
Vanna AI: Build SQL AI Chatbots To Talk To Database (open source)
Universe of AI · Video · Apr 2025
Watch the full setup so you know what you're committing to before trying it.
All 19 sources
-
Text to SQL with Ollama and Vanna, locally, with any database
Fahd Mirza · Video · 2024
The fully local, private variant for founders nervous about data leaving the building.
-
Vanna: Chat (RAG) With SQL Databases
MG · Video · 2024
A short conceptual demo of why retrieval training makes generated SQL accurate.
-
Natural Language Access to Postgres with Claude Desktop and MCP
Kyle Hailey · Article · 2025
A database performance veteran connects Claude straight to Postgres, no code layer.
-
Securely connect Claude Code to Postgres via MCP
Tailscale · Guide · 2025
The security-first version: least-privilege roles and network isolation done right.
-
Introducing the pgEdge Postgres MCP Server
pgEdge · Article · 2025
A production-ready open-source MCP server maintained by a Postgres company.
-
The Ultimate Guide to Postgres MCP for Claude Desktop
OpsTree · Guide · Sep 2025
A step-by-step Docker setup an ops-minded founder can follow in an evening.
-
How to Connect PostgreSQL to Claude in 1 Minute (No-Code MCP)
Windsor.ai · Guide · 2025
The fastest no-code path if you just want to ask your database questions today.
-
Building My First MCP Server: Connecting Claude to PostgreSQL
Umar M · Article · 2025
A first-person build log with the mistakes left in, useful for realistic expectations.
-
Text2SQL.ai: text to SQL and AI query generator
Text2SQL.ai · Tool · 2025
A free-to-try generator that works from just your schema, no data upload.
-
Best SQL AI Tools in 2025: Complete Comparison Guide
Text2SQL.ai · Article · 2025
Compares the field including which tools process metadata only, a key privacy line.
-
ChartDB Text to SQL converter
ChartDB · Tool · 2025
A free schema-aware converter, handy for one-off queries without a subscription.
-
Vanna.ai: Chat with your SQL database (Hacker News discussion)
Hacker News · Thread · Jan 2024
Engineers debating where text-to-SQL breaks, the caveats vendors won't tell you.