SQLite MCP Server

MCP Server Configuration

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

Available Tools

Tool	Description
read_query	Execute SELECT queries to read data
write_query	Execute INSERT, UPDATE, DELETE queries
create_table	Create new tables with schema definitions
list_tables	List all tables in the database
describe_table	Get table schema, columns, and types
append_insight	Save analysis insights as memo resources

Common Database Paths

Copy
# Typical locations
./data/app.db                    # Project-local database
~/Library/Application Support/*/  # macOS app databases
~/.local/share/*/                # Linux app databases
/tmp/scratch.db                  # Temporary analysis database

Setup

1. Identify or create your SQLite database file
2. Replace /path/to/database.db with the absolute path to your .db file
3. The server will create the file if it doesn't exist

Usage Examples

Once configured, you can ask Claude Code to:

• "Show me all tables and their schemas"
• "Query the users table for records created this month"
• "Create a migration to add an email column to the profiles table"
• "Analyze the data distribution in the orders table"
• "Export the results of this query as a CSV"

Security Notes

• SQLite databases are file-based - ensure proper file system permissions
• Back up your database before allowing write operations
• For read-only access, set file permissions to read-only (chmod 444)
• The server has full read/write access to the specified database file
• Do not point this at production databases without backups