MCP Server MCP

QueryPilot

By github 👁 1 views ▲ 0 votes

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

Homepage Verified source GitHub

Install

uvx querypilot

Configuration Example

{
  "remotes": [],
  "packages": [
    {
      "registryType": "pypi",
      "registryBaseUrl": "https://pypi.org",
      "identifier": "querypilot",
      "version": "0.1.1",
      "runtimeHint": "uvx",
      "transport": {
        "type": "stdio"
      },
      "packageArguments": [
        {
          "description": "Selects the `querypilot mcp` subcommand (as opposed to `serve` or `eval`).",
          "value": "mcp",
          "type": "positional"
        }
      ],
      "environmentVariables": [
        {
          "description": "SQLAlchemy-style database connection URL, e.g. sqlite:///demo.db or postgresql://user:pass@host:5432/db. Equivalent to --database-url.",
          "isRequired": true,
          "format": "string",
          "isSecret": true,
          "name": "QUERYPILOT_DATABASE_URL"
        },
        {
          "description": "SQL dialect for the connector. Equivalent to --dialect.",
          "format": "string",
          "default": "sqlite",
          "choices": [
            "sqlite",
            "postgres",
            "postgresql"
          ],
          "name": "QUERYPILOT_DIALECT"
        },
        {
          "description": "Maximum rows returned per query. Equivalent to --max-rows.",
          "format": "number",
          "default": "100",
          "name": "QUERYPILOT_MAX_ROWS"
        },
        {
          "description": "Query execution timeout in seconds. Equivalent to --timeout-seconds.",
          "format": "number",
          "default": "10",
          "name": "QUERYPILOT_TIMEOUT_SECONDS"
        },
        {
          "description": "JSON-encoded AccessPolicy (blocked_columns, allowed_columns, row_filters, masking_rules) enforced before execution. Equivalent to --access-policy-json.",
          "format": "string",
          "name": "QUERYPILOT_ACCESS_POLICY_JSON"
        },
        {
          "description": "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.",
          "format": "string",
          "default": "stdio",
          "choices": [
            "stdio",
            "streamable-http",
            "sse"
          ],
          "name": "QUERYPILOT_MCP_TRANSPORT"
        }
      ]
    }
  ]
}

mcp model-context-protocol pypi