QueryPilot MCP Server

by nickklos10io.github.nickklos10/querypilotv0.1.1

Safe SQL gateway for AI agents: SELECT-only validation, access policies, masking, audit trail, evals

1Pythonstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Maintained3mo ago

Install QueryPilot MCP server

claude mcp add querypilot -e QUERYPILOT_DATABASE_URL='<querypilot-database-url>' -- uvx querypilot mcp

{
  "mcpServers": {
    "querypilot": {
      "command": "uvx",
      "args": [
        "querypilot",
        "mcp"
      ],
      "env": {
        "QUERYPILOT_DATABASE_URL": "<querypilot-database-url>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "querypilot": {
      "command": "uvx",
      "args": [
        "querypilot",
        "mcp"
      ],
      "env": {
        "QUERYPILOT_DATABASE_URL": "<querypilot-database-url>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "querypilot": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "querypilot",
        "mcp"
      ],
      "env": {
        "QUERYPILOT_DATABASE_URL": "<querypilot-database-url>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "querypilot": {
      "command": "uvx",
      "args": [
        "querypilot",
        "mcp"
      ],
      "env": {
        "QUERYPILOT_DATABASE_URL": "<querypilot-database-url>"
      }
    }
  }
}

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

Configuration

Variable	Required	Secret	Description
QUERYPILOT_DATABASE_URL	yes	yes	SQLAlchemy-style database connection URL, e.g. sqlite:///demo.db or postgresql://user:pass@host:5432/db. Equivalent to --database-url.
QUERYPILOT_DIALECT	—	—	SQL dialect for the connector. Equivalent to --dialect.
QUERYPILOT_MAX_ROWS	—	—	Maximum rows returned per query. Equivalent to --max-rows.
QUERYPILOT_TIMEOUT_SECONDS	—	—	Query execution timeout in seconds. Equivalent to --timeout-seconds.
QUERYPILOT_ACCESS_POLICY_JSON	—	—	JSON-encoded AccessPolicy (blocked_columns, allowed_columns, row_filters, masking_rules) enforced before execution. Equivalent to --access-policy-json.
QUERYPILOT_MCP_TRANSPORT	—	—	MCP transport used by `querypilot mcp`. Equivalent to --transport. Most MCP clients should leave this at stdio; streamable-http is for clients that speak Streamable HTTP directly.

Freshness

Maintained — last maintenance signal 3mo ago. The newest of the signals below sets the band.

Last commit (default branch)
2026-07-11 · 3mo ago · GitHub
Latest release
2026-07-11 · 3mo ago · GitHub · v0.1.1
Package published
no data · npm/PyPI
Registry entry updated
2026-07-11 · 3mo ago · official registry · v0.1.1

FAQ

›How do I install the QueryPilot MCP server in Claude Code?

Run: claude mcp add querypilot -e QUERYPILOT_DATABASE_URL='<querypilot-database-url>' -- uvx querypilot mcp. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does QueryPilot require an API key?

Yes. It expects QUERYPILOT_DATABASE_URL, of which 1 is a secret.

›Can I use QueryPilot as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is QueryPilot in the official MCP registry?

Yes, as io.github.nickklos10/querypilot.