How to add SQLite Explorer MCP Server to Claude Desktop

Safe, read-only SQLite database exploration and querying for LLMs, built on FastMCP. Paste the config into ~/Library/Application Support/Claude/claude_desktop_config.json and restart Claude Desktop.

Last updated June 14, 2026 · 105★ · stdio · no auth

Claude Desktop config for SQLite Explorer MCP Server

pip install -r requirements.txt

{
  "mcpServers": {
    "sqlite-explorer-mcp-server": {
      "command": "uv",
      "args": [
        "run",
        "--with",
        "fastmcp",
        "--with",
        "uvicorn",
        "fastmcp",
        "run",
        "/path/to/repo/sqlite_explorer.py"
      ],
      "env": {
        "SQLITE_DB_PATH": "/path/to/your/database.db"
      }
    }
  }
}

Setup steps

1Open Claude Desktop → Settings → Developer → Edit Config (this opens ~/Library/Application Support/Claude/claude_desktop_config.json).
2Paste the SQLite Explorer MCP Server config below under the top-level "mcpServers" key.
3Fill in any placeholder secrets (API keys, paths) in the snippet.
4Save the file, then fully quit and reopen Claude Desktop.
5Open a chat and confirm SQLite Explorer MCP Server's tools appear under the 🔌 tools menu.

Before you start

Python 3.6+
A SQLite database file (path set via the SQLITE_DB_PATH environment variable)
fastmcp (installed via requirements.txt)

What SQLite Explorer MCP Server can do in Claude Desktop

read_query

Execute a SELECT query on the database with built-in safety validations: query validation and sanitization, parameter binding support, row limit enforcement, and results formatted as dictionaries.

list_tables

List all available tables in the database with their names.

describe_table

Get detailed schema information for a specific table, including column names and types, NULL constraints, default values, and primary key information.

Security

Read-only access to SQLite databases. Queries are validated and sanitized, parameter binding is used for safe execution, and a row limit is enforced. The target database file is specified via the SQLITE_DB_PATH environment variable.

SQLite Explorer MCP Server + Claude Desktop FAQ

Where is the Claude Desktop config file?

Claude Desktop reads MCP servers from ~/Library/Application Support/Claude/claude_desktop_config.json. Paste the SQLite Explorer MCP Server config there under the "mcpServers" key and restart the client.

Is SQLite Explorer MCP Server safe to use with Claude Desktop?

Can this server modify my database?

No. The server provides read-only access. It only runs validated SELECT queries; queries are validated and sanitized, parameter binding is used, and a row limit is enforced.

How do I tell the server which database to use?

Set the SQLITE_DB_PATH environment variable to the full path of the SQLite database file you want to explore.

Which clients are documented for installation?

The README documents installing for Claude Desktop using `fastmcp install sqlite_explorer.py --name "SQLite Explorer" -e SQLITE_DB_PATH=/path/to/db`, and for the Cline VSCode plugin via its MCP settings JSON.

View repo Full SQLite Explorer MCP Server page