Add the SQLite (DBHub) MCP server to Windsurf

Config last verified Jun 1, 2026

The exact config to run SQLite (DBHub) in Windsurf — paste it in, restart, and the tools load.

Prerequisites

Windsurf installed.
DSN — Database connection string. For SQLite use sqlite:///path/to/database.db. Can be passed as --dsn or via the DSN env var.

Setup

1. Open `~/.codeium/windsurf/mcp_config.json`

On Windows the file lives at %USERPROFILE%\.codeium\windsurf\mcp_config.json.

2. Add this configuration

Add to ~/.codeium/windsurf/mcp_config.json

~/.codeium/windsurf/mcp_config.json

json

{
  "mcpServers": {
    "sqlite": {
      "command": "npx",
      "args": [
        "-y",
        "@bytebase/dbhub",
        "--transport",
        "stdio",
        "--dsn",
        "sqlite:///path/to/database.db"
      ]
    }
  }
}

3. Restart Windsurf and confirm the SQLite (DBHub) tools load.

Gotchas

Windsurf's Cascade reads MCP servers from an "mcpServers" object in ~/.codeium/windsurf/mcp_config.json. Unlike most clients, remote servers are configured with the "serverUrl" field rather than "url", so a config that uses "url" silently fails to connect. Native remote transport is supported without an OAuth flow.

← Back to the SQLite (DBHub) MCP server