SQLite MCP Server

The SQLite MCP Server connects Claude to local SQLite databases. Great for data analysis on local datasets, application databases, and quick prototyping. Unlike PostgreSQL, SQLite needs no server — it works directly with .db files on your disk.

Installation & Configuration

Add this block to your claude_desktop_config.json (or your agent framework's MCP config file):

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

Config file location:

• macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
• Windows: %APPDATA%\Claude\claude_desktop_config.json
• Linux: ~/.config/claude/claude_desktop_config.json

Available Tools (6)

• read_query
• write_query
• create_table
• list_tables
• describe_table
• append_insight

Use Cases

• Local analytics — query app databases without setting up Postgres
• Rapid prototyping — build and populate test databases conversationally
• Data migration — extract and transform SQLite data with natural language

Source & Documentation