▌BestMCPTools.org
SQLite MCP logo

SQLite MCP

Query SQLite databases directly from your AI

DatabaseOpen SourceAll ModelsEasy✓ Verified
Visit ToolGitHub
Own SQLite MCP? Boost it to the top.✦ Upgrade to Featured

Maintenance status

Archived
Checked September 28, 2026

Archived: the MCP project moved this reference server to modelcontextprotocol/servers-archived and no longer maintains it.

How to Install SQLite MCP

$npx @modelcontextprotocol/server-sqlite

Requires Claude Desktop, Cursor, Windsurf, or another MCP-compatible client.

Setup by client

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "sqlite-mcp": {
      "command": "npx",
      "args": [
        "@modelcontextprotocol/server-sqlite"
      ]
    }
  }
}

Cursor (~/.cursor/mcp.json)

{
  "mcpServers": {
    "sqlite-mcp": {
      "command": "npx",
      "args": [
        "@modelcontextprotocol/server-sqlite"
      ]
    }
  }
}

VS Code (.vscode/mcp.json)

{
  "servers": {
    "sqlite-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "@modelcontextprotocol/server-sqlite"
      ]
    }
  }
}

Claude Code (terminal)

claude mcp add sqlite-mcp -- npx @modelcontextprotocol/server-sqlite

Add any API keys or environment variables the server's README lists.

About SQLite MCP

Lightweight SQLite MCP, perfect for local analytics and prototyping. When you outgrow a local file, connect MySQL to Claude or move to Postgres.

SQLite MCP is a Database MCP server designed for developers, analysts, and data teams. It enables querying and managing databases from an AI assistant by exposing schema introspection and SQL execution as MCP tools. Key capabilities include schema introspection across tables and views, parameterised sql execution, read-only and read/write modes, and structured tool calls that work cleanly inside an LLM context. It integrates with Postgres, MySQL, SQLite, MongoDB, Redis, BigQuery, and Snowflake, and is best suited for developers, analysts, and data teams who need ad-hoc analytics without a bi tool.

Key Features

  • sqlite
  • sql
  • local
  • Schema introspection across tables and views
  • Parameterised SQL execution
  • Read-only and read/write modes

Pricing

Open Source: from Free

Pros & Cons

Pros

  • Lets the assistant write and run real queries instead of guessing
  • Read-only mode is safe to point at production-shaped data
  • Skips most ORM and CSV-shuffling boilerplate

Cons

  • Misconfigured permissions can expose sensitive data
  • Long-running queries need explicit timeouts
  • Schema drift requires reconnecting or refreshing context

Best For

  • Ad-hoc analytics without a BI tool
  • Drafting migrations and reviewing query plans
  • Letting non-SQL teammates ask questions of a database
  • Bootstrapping internal admin workflows

Our Take on SQLite MCP

Perfect for analyzing local data files. Hard to beat for prototyping.

Alternatives to SQLite MCP

PostgreSQL MCPDatabase

Give AI direct access to your PostgreSQL database

View PostgreSQL MCP →
Supabase MCPDatabase

Connects AI tools to your Supabase projects

View Supabase MCP →

Frequently Asked Questions

Tags

#Database#sqlite#sql#local