QueryPilot MCP Server

io.github.nickklos10/querypilot

Repository Registry

What is the QueryPilot MCP server?

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

How to install QueryPilot

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

QUERYPILOT_DATABASE_URL
required
secret
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.

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "querypilot": {
      "command": "uvx",
      "args": [
        "querypilot",
        "mcp"
      ],
      "env": {
        "QUERYPILOT_DATABASE_URL": "<YOUR_QUERYPILOT_DATABASE_URL>",
        "QUERYPILOT_DIALECT": "<YOUR_QUERYPILOT_DIALECT>",
        "QUERYPILOT_MAX_ROWS": "<YOUR_QUERYPILOT_MAX_ROWS>",
        "QUERYPILOT_TIMEOUT_SECONDS": "<YOUR_QUERYPILOT_TIMEOUT_SECONDS>",
        "QUERYPILOT_ACCESS_POLICY_JSON": "<YOUR_QUERYPILOT_ACCESS_POLICY_JSON>",
        "QUERYPILOT_MCP_TRANSPORT": "<YOUR_QUERYPILOT_MCP_TRANSPORT>"
      }
    }
  }
}

Related MCP servers

io.github.nicklasmenschel/gerezi-mcp

Manage restaurant bookings via Claude — read covers, find guests, move tables, send wedding quotes.

View repository →

Doc_Conv — Document to Markdown

Active

Convert PDF/Word/Excel/PowerPoint documents to Markdown, paid in USDC via x402.

Python

MIT

View repository →

io.github.nickoc/bearing-local-business

Reference MCP server: a demo bakery agents can query for hours, menu, availability, and orders.

io.github.nicktcode/swissgroceries-mcp

Maintained

Search products, compare prices, and plan shopping trips across Swiss grocery chains in real-time.

TypeScript

View repository →

io.github.nickymitnick/probo-connect-mcp

MCP server for Probo print-on-demand — search products, configure orders, track shipments.

View repository →

io.github.nickzitzer/servicenow-nodejs

Active

Multi-instance ServiceNow MCP server with 480+ auto-generated tools, intelligent schema discovery, and natural language search.

JavaScript

Apache-2.0

View repository →