Skip to content
MCP server

text2sql

Ask any SQL database in natural language. Agent explores schema, writes SQL…

Runs locallyStatus and history
Install
Pricing
Open source
Runs
Locally
Version
0.1.2
Listing updated
4 days ago

About text2sql

text2sql is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.

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

Install

Run in a terminal

claude mcp add text2sql-mcp --env TEXT2SQL_DATABASE_URL='<TEXT2SQL_DATABASE_URL>' --env ANTHROPIC_API_KEY='<ANTHROPIC_API_KEY>' --env OPENAI_API_KEY='<OPENAI_API_KEY>' -- uvx text2sql-mcp

Add to claude_desktop_config.json

{
  "mcpServers": {
    "text2sql-mcp": {
      "command": "uvx",
      "args": [
        "text2sql-mcp"
      ],
      "env": {
        "TEXT2SQL_DATABASE_URL": "<TEXT2SQL_DATABASE_URL>",
        "ANTHROPIC_API_KEY": "<ANTHROPIC_API_KEY>",
        "OPENAI_API_KEY": "<OPENAI_API_KEY>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "text2sql-mcp": {
      "command": "uvx",
      "args": [
        "text2sql-mcp"
      ],
      "env": {
        "TEXT2SQL_DATABASE_URL": "<TEXT2SQL_DATABASE_URL>",
        "ANTHROPIC_API_KEY": "<ANTHROPIC_API_KEY>",
        "OPENAI_API_KEY": "<OPENAI_API_KEY>"
      }
    }
  }
}

Add to .vscode/mcp.json

{
  "servers": {
    "text2sql-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "text2sql-mcp"
      ],
      "env": {
        "TEXT2SQL_DATABASE_URL": "<TEXT2SQL_DATABASE_URL>",
        "ANTHROPIC_API_KEY": "<ANTHROPIC_API_KEY>",
        "OPENAI_API_KEY": "<OPENAI_API_KEY>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "text2sql-mcp": {
      "command": "uvx",
      "args": [
        "text2sql-mcp"
      ],
      "env": {
        "TEXT2SQL_DATABASE_URL": "<TEXT2SQL_DATABASE_URL>",
        "ANTHROPIC_API_KEY": "<ANTHROPIC_API_KEY>",
        "OPENAI_API_KEY": "<OPENAI_API_KEY>"
      }
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "text2sql-mcp": {
      "command": "uvx",
      "args": [
        "text2sql-mcp"
      ],
      "env": {
        "TEXT2SQL_DATABASE_URL": "<TEXT2SQL_DATABASE_URL>",
        "ANTHROPIC_API_KEY": "<ANTHROPIC_API_KEY>",
        "OPENAI_API_KEY": "<OPENAI_API_KEY>"
      }
    }
  }
}

Configuration

  • TEXT2SQL_DATABASE_URLSQLAlchemy connection URL, e.g. sqlite:///mydb.db or postgresql://user:pass@host/dbRequired
  • ANTHROPIC_API_KEYAnthropic API key (required if using the default Anthropic model)
  • OPENAI_API_KEYOpenAI API key (required when TEXT2SQL_MODEL is set to an openai:* model)
  • TEXT2SQL_MODELOptional LangChain model id (default: anthropic:claude-sonnet-4-6)

Pricing

Open source

text2sql FAQ

Is text2sql free?

Yes. text2sql is open source, so you can use and self-host it for free.

How do I add text2sql to Claude Code?

Run this command in your terminal: claude mcp add text2sql-mcp --env TEXT2SQL_DATABASE_URL='<TEXT2SQL_DATABASE_URL>' --env ANTHROPIC_API_KEY='<ANTHROPIC_API_KEY>' --env OPENAI_API_KEY='<OPENAI_API_KEY>' -- uvx text2sql-mcp

What are the best alternatives to text2sql?

The closest alternatives to text2sql are Midplane, PlatypusDB, Lorebase, Sovaria and model2data studio.

Alternatives to text2sql

  1. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  2. PlatypusDB

    MCP server

    Gives MCP clients access to your PlatypusDB database connections, scoped per agent

    Runs locally
    • Open source
    • Databases
  3. Lorebase

    MCP server

    Lets agents read and change a governed, versioned Postgres knowledge graph

    Runs locally
    • Open source
    • Knowledge and memory
  4. Sovaria

    MCP server

    Manage a Sovaria backend (Postgres, auth, storage, functions) from an AI assistant

    Not checked yet
    • 4 tools
    • Remote
    • Freemium
    • Databases
  5. Generate realistic connected test data, dbt projects and dashboards from a schema

    • Remote
    • Freemium
    • Databases
  6. semlayer

    MCP server

    Infers a semantic layer from your data warehouse and serves it to agents

    Runs locally
    • Free
    • Databases