How to add SQLite Explorer MCP Server to Windsurf

Safe, read-only SQLite database exploration and querying for LLMs, built on FastMCP. Paste the config into ~/.codeium/windsurf/mcp_config.json and restart Windsurf.

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

Windsurf 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 Windsurf → Cascade → the hammer/MCP icon → Configure (or edit ~/.codeium/windsurf/mcp_config.json).
2Paste the SQLite Explorer MCP Server config below.
3Fill in placeholder secrets, then save.
4Click Refresh in the MCP panel.
5SQLite Explorer MCP Server's tools become available to Cascade.

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 Windsurf

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 + Windsurf FAQ

Where is the Windsurf config file?

Windsurf reads MCP servers from ~/.codeium/windsurf/mcp_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 Windsurf?

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