Install guide and config at curatedmcp.com

SQLite MCP Server: Query Local Databases with Natural Language

Stop writing boilerplate SQL. The SQLite MCP Server connects your AI agent directly to local SQLite databases, letting you ask questions in plain English and get instant results—no API keys, no cloud services, no friction.

What It Does

This MCP server gives Claude, Cursor, and Windsurf full read/write access to SQLite databases running on your machine. Your AI agent can now:

• Query databases conversationally. Ask "Show me sales by region last quarter" and get back structured results.
• Inspect schemas automatically. The agent explores table structures, relationships, and data types without you explaining your database.
• Run aggregations and analysis. Generate summaries, spot trends, and extract business insights directly from your data.
• Store persistent memos. Built-in note storage lets your agent remember findings across sessions.

Because everything runs locally, there's no latency waiting for cloud roundtrips, no credentials to rotate, and no data leaving your machine. Perfect for local development, rapid prototyping, and offline-capable workflows.

How to Install

Install via uv, the fast Python package manager:

uvx mcp-server-sqlite --db-path /path/to/database.sqlite

Then configure for Claude Desktop by adding this to claude_desktop_config.json:

{
  "mcpServers": {
    "sqlite-mcp-server": {
      "command": "uvx mcp-server-sqlite --db-path /path/to/database.sqlite"
    }
  }
}

Replace /path/to/database.sqlite with your actual database file path. Restart Claude, and you're connected.

Real-World Use Cases

• Local analytics dashboard. Ask your AI agent to analyze product metrics, customer churn, or inventory levels stored in a local SQLite file without touching production databases.
• Database-driven prototyping. Build and iterate on schemas while having Claude suggest optimizations, write migrations, or spot data inconsistencies.
• Offline research workflows. Download datasets into SQLite, then use your agent to explore, filter, and summarize—perfect for trains, flights, or air-gapped environments.

Full install guides for Claude Desktop, Cursor, Windsurf, and more at CuratedMCP.