Text2sql

Ask any SQL database in natural language. Agent explores schema, writes SQL, self-corrects.

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to Cursor Add to VS Code

Not yet automatically verified

We haven't yet run this listing's install command through our automated sandbox check. This isn't a red flag — we're steadily working through the catalog.

Manual Client & Custom JSON ConfigExpand JSON ▾

Client Config & Setup

Choose your client or environment

Target File:~/Library/Application Support/Claude/claude_desktop_config.json

claude_desktop_config.json

{
  "mcpServers": {
    "text2sql": {
      "command": "uvx",
      "args": [
        "text2sql-mcp"
      ]
    }
  }
}

💡 Paste the JSON block into your client's configuration file under mcpServers, then restart the application.

Documentation Overview

text2sql-mcp

MCP server for text2sql-framework. Plugs into Claude Desktop, Cursor, Goose, or any other MCP-compatible assistant and lets it ask a SQL database questions in natural language.

The agent explores the schema, writes SQL, executes it against the real DB, and self-corrects on errors — no RAG layer, no schema descriptions, no pre-computed embeddings.

Install

Out of the box, text2sql-mcp supports SQLite + Anthropic:

Terminal

pip install text2sql-mcp
# or
uvx text2sql-mcp

For other databases or LLM providers, install with the matching extra so the right driver gets installed:

You want…	Install command
SQLite (default)	`uvx text2sql-mcp`
Postgres	`uvx 'text2sql-mcp[postgres]'`
MySQL	`uvx 'text2sql-mcp[mysql]'`
Snowflake	`uvx 'text2sql-mcp[snowflake]'`
BigQuery	`uvx 'text2sql-mcp[bigquery]'`
OpenAI models	add `openai`, e.g. `uvx 'text2sql-mcp[postgres,openai]'`

Configure

Set environment variables in your MCP client config:

Variable	Required	Description
`TEXT2SQL_DATABASE_URL`	yes	SQLAlchemy URL, e.g. `sqlite:///mydb.db`, `postgresql://user:pass@host/db`
`ANTHROPIC_API_KEY` or `OPENAI_API_KEY`	yes	LLM provider key
`TEXT2SQL_MODEL`	no	LangChain model id (default: `anthropic:claude-sonnet-4-6`)
`TEXT2SQL_INSTRUCTIONS`	no	Business rules / hints, e.g. "Revenue = net of refunds."
`TEXT2SQL_EXAMPLES`	no	Path to a scenarios.md file for the agent's `lookup_example` tool

Claude Desktop / Cursor / generic MCP

config.json

{
  "mcpServers": {
    "text2sql": {
      "command": "uvx",
      "args": ["text2sql-mcp"],
      "env": {
        "TEXT2SQL_DATABASE_URL": "sqlite:///mydb.db",
        "ANTHROPIC_API_KEY": "sk-ant-..."
      }
    }
  }
}

Goose CLI

bash

goose configure
# Add Extension → Command-line Extension
# Name: text2sql
# Command: uvx text2sql-mcp
# Env: TEXT2SQL_DATABASE_URL, ANTHROPIC_API_KEY

Tools

query(question, max_rows=100) — ask the database a natural-language question. Returns {sql, data, error, row_count, tool_calls_made}.

How it works

Under the hood this is a thin wrapper around text2sql-framework, which uses LangChain Deep Agents to do iterative tool-calling against a single execute_sql tool. See the framework README for benchmarks (19/20 on Spider zero-shot across 80 tables) and architecture details.

License

MIT

Read the full README →View source on GitHub →

Related MCP Servers

View all in Databases View all alternatives

Reviews

No reviews yet — be the first to share how this listing worked for you.

Frequently Asked Questions about Text2sql

Add the following block to your claude_desktop_config.json under mcpServers: "mcpServers": { "text2sql": { "command": "npx", "args": ["-y", "text2sql"] } }

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:

Live Dynamic SVG Preview

Markdown (GitHub README)

[![AllMCPs](https://allmcps.com/api/badge/text2sql?style=directory)](https://allmcps.com/mcp/text2sql)

HTML Embed

<a href="https://allmcps.com/mcp/text2sql"><img src="https://allmcps.com/api/badge/text2sql?style=directory" alt="Text2sql on AllMCPs" /></a>

Technical Specs & Signals

CategoryDatabases

36Quality signal: Fair · 36/100How this signal is calculated ▾

Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership10/20

Documentation & tools16/30

Adoption & activity1/15

Community engagement0/10

A guidance signal from public completeness & health data — not a user rating. New listings start lower and rise as they add docs, get verified, and grow adoption. Signals we can't observe for a listing are skipped, not counted against it.

★ Featured

AllMCPs Server

The official MCP server for AllMCPs.com - submit and manage tools directly from your AI. The open directory for MCP servers. Connect Claude, Cursor, Windsurf, and AI agents to databases, tools, files, and APIs. Explore 10,000+ servers. AllMCPs is the premier, open directory for discovering, evaluating, and installing Model Context Protocol (MCP) servers to equip AI agents and LLMs with real-world superpowers.

Explore Server →

Own this project?

This directory is pre-filled from public sources. Claim via GitHub README, site badge, or DNS TXT to unlock edit access and the Official badge and attach your website — proof is checked automatically, then reviewed by our team.

Free dofollow backlink: add your website and place the AllMCPs badge on it — no claim needed. We detect it automatically and keep it verified as long as the badge stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in 🗄️ Databases →Best MCP servers for Databases →Alternatives to Text2sql →Install in Claude Desktop Install in Cursor Install in VS Code