SQLite MCP Server

The SQLite MCP Server is an official Model Context Protocol reference server developed by the MCP core engineering team. Enabling AI coding agents and desktop clients (including Claude Desktop, Cursor, Roo Code, and Cline) to directly connect to local SQLite database files, it provides safe SQL execution, schema exploration, table indexing, and query optimization without requiring external database drivers.

Exposed MCP Tools & Capabilities

• read_query: Executes read-only SQL queries (SELECT statements) against local database tables with formatted tabular return sets.
• write_query: Executes state-changing SQL statements (INSERT, UPDATE, DELETE, CREATE TABLE) for data manipulation and schema migrations.
• describe_table: Returns comprehensive column names, data types, primary keys, and foreign key relationships for any target table.
• list_tables: Lists all available database tables, views, and system catalog tables in the SQLite database file.

Configuration & Setup

Add the SQLite MCP Server to your claude_desktop_config.json or Roo Code settings:

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

Frequently Asked Questions