## what it does

What it does

The SQLite MCP server connects your agent to a local SQLite database file. The agent can inspect the schema, run SELECT queries for analysis, and execute INSERT/UPDATE/DELETE for data modification.

A unique feature is the append_insight tool — the server maintains a memo of analytical insights the agent discovers, building a running summary of what it has learned about the dataset.

Installation

# Point it at your .db file:
npx -y @modelcontextprotocol/server-sqlite ~/data/myapp.db

# Or install globally:
npm install -g @modelcontextprotocol/server-sqlite

Claude Desktop configuration

{
  "mcpServers": {
    "sqlite": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/server-sqlite", "/Users/you/data/myapp.db"]
    }
  }
}

Available tools

Tool	Description
`read_query`	Execute a SELECT — returns rows as JSON
`write_query`	Execute INSERT/UPDATE/DELETE/CREATE
`create_table`	Create a new table with schema
`list_tables`	List all tables in the database
`describe_table`	Get column names and types for a table
`append_insight`	Log an analytical finding to the memo

Practical use cases

Data exploration: “What are the top 10 users by order count?”
Schema inspection: “What tables exist and how are they related?”
Reporting: “Give me monthly revenue by product category”
Migration assistance: “Here’s the schema — help me write the migration”

Notes

The server operates on a single database file. To work across multiple databases, run multiple server instances. Write operations are not automatically rolled back on error — your agent should use transactions for multi-step data modifications.

## compatibility

claude-desktop ✓

claude-code ✓

cline ✓

cursor ~

## exposed tools

→ read_query

→ write_query

→ create_table

→ list_tables

→ describe_table

→ append_insight

## embed this badge

cache ✓ in cache.directory


![cached](https://cache.directory/badge/sqlite-mcp.svg)

SQLite MCP Server