SQLite MCP Server

Official

Query and analyze SQLite databases with your AI assistant

sqlitesqldatabaseofficiallocalno-server

The official SQLite MCP server gives your AI assistant full access to any SQLite database file. Unlike PostgreSQL, SQLite requires no running server — just point the MCP server at a `.db` file and you are ready. Supports both read and write operations, making it ideal for local development, prototyping, and data analysis workflows. The server also exposes business intelligence tools that let the AI generate summary statistics and insights.

Install Config

Config file: ~/Library/Application Support/Claude/claude_desktop_config.json· Windows: %APPDATA%\Claude\claude_desktop_config.json

{
  "mcpServers": {
    "sqlite": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-sqlite",
        "/path/to/your/database.db"
      ]
    }
  }
}

Available Tools (6)

Tool name	Description
read_query	Execute a SELECT query on the SQLite database
write_query	Execute INSERT, UPDATE, or DELETE queries
create_table	Create a new table in the database
list_tables	List all tables in the database
describe_table	Get the schema for a specific table
append_insight	Add a business insight to the memo

Example Prompts

“What tables are in my database?”
“Summarize the sales data by month”
“Create a table for tracking expenses”
“Insert 3 sample records into the products table”
“What are the top 5 customers by total spend?”

Pros & Cons

Pros

No database server required — just a .db file
Supports both read and write operations
Great for local development and prototyping
Zero external dependencies

Cons

SQLite only — not suitable for production multi-user databases
Not appropriate for large databases (>1GB)

Who Is This For?

·Developers doing local prototyping
·Data analysts working with exported database files
·Anyone who wants to query a local SQLite file with AI

When to use: Use SQLite MCP when you don't have a running database server or are working with a local `.db` file. It's the easiest database server to get started with.