Search / io.github.nickklos10/querypilot
QueryPilot
L0· runs locallySafe SQL gateway for AI agents: SELECT-only validation, access policies, masking, audit trail, evals
v0.1.1 · active · repository · website · descriptor JSON · versions
Search / io.github.nickklos10/querypilot
L0· runs locallySafe SQL gateway for AI agents: SELECT-only validation, access policies, masking, audit trail, evals
v0.1.1 · active · repository · website · descriptor JSON · versions
{
"mcpServers": {
"querypilot": {
"command": "uvx",
"args": [
"querypilot==0.1.1",
"mcp"
],
"env": {
"QUERYPILOT_DATABASE_URL": "${QUERYPILOT_DATABASE_URL}",
"QUERYPILOT_DIALECT": "sqlite",
"QUERYPILOT_MAX_ROWS": "100",
"QUERYPILOT_TIMEOUT_SECONDS": "10",
"QUERYPILOT_MCP_TRANSPORT": "stdio"
}
}
}
}claude mcp add querypilot -e "QUERYPILOT_DATABASE_URL=${QUERYPILOT_DATABASE_URL}" -e "QUERYPILOT_DIALECT=sqlite" -e "QUERYPILOT_MAX_ROWS=100" -e "QUERYPILOT_TIMEOUT_SECONDS=10" -e "QUERYPILOT_MCP_TRANSPORT=stdio" -- uvx querypilot==0.1.1 mcp[mcp_servers.querypilot]
command = "uvx"
args = ["querypilot==0.1.1", "mcp"]
env = { "QUERYPILOT_DATABASE_URL" = "${QUERYPILOT_DATABASE_URL}", "QUERYPILOT_DIALECT" = "sqlite", "QUERYPILOT_MAX_ROWS" = "100", "QUERYPILOT_TIMEOUT_SECONDS" = "10", "QUERYPILOT_MCP_TRANSPORT" = "stdio" }
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"querypilot": {
"type": "local",
"command": [
"uvx",
"querypilot==0.1.1",
"mcp"
],
"enabled": true,
"environment": {
"QUERYPILOT_DATABASE_URL": "{env:QUERYPILOT_DATABASE_URL}",
"QUERYPILOT_DIALECT": "sqlite",
"QUERYPILOT_MAX_ROWS": "100",
"QUERYPILOT_TIMEOUT_SECONDS": "10",
"QUERYPILOT_MCP_TRANSPORT": "stdio"
}
}
}
}{
"mcpServers": {
"querypilot": {
"command": "uvx",
"args": [
"querypilot==0.1.1",
"mcp"
],
"env": {
"QUERYPILOT_DATABASE_URL": "${QUERYPILOT_DATABASE_URL}",
"QUERYPILOT_DIALECT": "sqlite",
"QUERYPILOT_MAX_ROWS": "100",
"QUERYPILOT_TIMEOUT_SECONDS": "10",
"QUERYPILOT_MCP_TRANSPORT": "stdio"
}
}
},
"deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=querypilot&config=eyJjb21tYW5kIjoidXZ4IiwiYXJncyI6WyJxdWVyeXBpbG90PT0wLjEuMSIsIm1jcCJdLCJlbnYiOnsiUVVFUllQSUxPVF9EQVRBQkFTRV9VUkwiOiIke1FVRVJZUElMT1RfREFUQUJBU0VfVVJMfSIsIlFVRVJZUElMT1RfRElBTEVDVCI6InNxbGl0ZSIsIlFVRVJZUElMT1RfTUFYX1JPV1MiOiIxMDAiLCJRVUVSWVBJTE9UX1RJTUVPVVRfU0VDT05EUyI6IjEwIiwiUVVFUllQSUxPVF9NQ1BfVFJBTlNQT1JUIjoic3RkaW8ifX0%3D"
}{
"servers": {
"querypilot": {
"type": "stdio",
"command": "uvx",
"args": [
"querypilot==0.1.1",
"mcp"
],
"env": {
"QUERYPILOT_DATABASE_URL": "${QUERYPILOT_DATABASE_URL}",
"QUERYPILOT_DIALECT": "sqlite",
"QUERYPILOT_MAX_ROWS": "100",
"QUERYPILOT_TIMEOUT_SECONDS": "10",
"QUERYPILOT_MCP_TRANSPORT": "stdio"
}
}
}
}{
"mcpServers": {
"querypilot": {
"command": "uvx",
"args": [
"querypilot==0.1.1",
"mcp"
],
"env": {
"QUERYPILOT_DATABASE_URL": "${QUERYPILOT_DATABASE_URL}",
"QUERYPILOT_DIALECT": "sqlite",
"QUERYPILOT_MAX_ROWS": "100",
"QUERYPILOT_TIMEOUT_SECONDS": "10",
"QUERYPILOT_MCP_TRANSPORT": "stdio"
}
}
}
}extensions:
"querypilot":
enabled: true
name: "querypilot"
type: stdio
cmd: "uvx"
args:
- "querypilot==0.1.1"
- "mcp"
envs:
"QUERYPILOT_DATABASE_URL": "${QUERYPILOT_DATABASE_URL}"
"QUERYPILOT_DIALECT": "sqlite"
"QUERYPILOT_MAX_ROWS": "100"
"QUERYPILOT_TIMEOUT_SECONDS": "10"
"QUERYPILOT_MCP_TRANSPORT": "stdio"
timeout: 300
Placeholders to fill from your own secret store: ${QUERYPILOT_DATABASE_URL}. The registry never accepts secret values.
This is a local package: the command runs on your machine.
Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.
protocol.modern, protocol.stateless, protocol.transport, protocol.list_ttlno remote answered a protocol handshake (not probed yet, unreachable, or local-only)auth.prm, auth.as_metadata, auth.cimdno remote uses OAuthauth.secret_in_urlno templated URLtools.descriptions, tools.description_length, tools.schemas, tools.annotations, tools.directory_hints, tools.token_cost, tools.api_dumptool list unknown (behind auth, not probed, or empty)stability.changes, stability.rug_pulltool list unknowndeps.known_vulnsno known advisory in 10 resolved packagesdeps.mcp_sdk_versionthe official MCP SDK is not in the dependency graphdeps.resolvable[email protected] resolved: 10 packagesNo tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.
Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.
+repository +namespace-matches-repo +website ~liveness-unmeasured ~updated-101d-ago
Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.
[email protected] PyPI9 dependencies, resolved · advisories checked 2026-10-19
No known advisory affects this dependency graph.
Dependency graphs from deps.dev; advisories from OSV.dev, including the GitHub Advisory Database and the PyPI Advisory Database; all CC BY 4.0. The graph is what a clean install of this version resolves today; nothing was installed or run. How it is checked.
| package | registry | version | runtime | secrets |
|---|---|---|---|---|
querypilot | pypi | 0.1.1 | uvx | QUERYPILOT_DATABASE_URL |
No tools observed. Local packages are never executed by the registry.
Schemas: list_tools.
{
"name": "io.github.nickklos10/querypilot",
"_meta": {
"io.modelcontextprotocol.registry/publisher-provided": {
"tool": "manual",
"version": "0.1.1"
}
},
"title": "QueryPilot",
"$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
"version": "0.1.1",
"packages": [
{
"version": "0.1.1",
"transport": {
"type": "stdio"
},
"identifier": "querypilot",
"runtimeHint": "uvx",
"registryType": "pypi",
"registryBaseUrl": "https://pypi.org",
"packageArguments": [
{
"type": "positional",
"value": "mcp",
"description": "Selects the `querypilot mcp` subcommand (as opposed to `serve` or `eval`)."
}
],
"environmentVariables": [
{
"name": "QUERYPILOT_DATABASE_URL",
"format": "string",
"isSecret": true,
"isRequired": true,
"description": "SQLAlchemy-style database connection URL, e.g. sqlite:///demo.db or postgresql://user:pass@host:5432/db. Equivalent to --database-url."
},
{
"name": "QUERYPILOT_DIALECT",
"format": "string",
"choices": [
"sqlite",
"postgres",
"postgresql"
],
"default": "sqlite",
"description": "SQL dialect for the connector. Equivalent to --dialect."
},
{
"name": "QUERYPILOT_MAX_ROWS",
"format": "number",
"default": "100",
"description": "Maximum rows returned per query. Equivalent to --max-rows."
},
{
"name": "QUERYPILOT_TIMEOUT_SECONDS",
"format": "number",
"default": "10",
"description": "Query execution timeout in seconds. Equivalent to --timeout-seconds."
},
{
"name": "QUERYPILOT_ACCESS_POLICY_JSON",
"format": "string",
"description": "JSON-encoded AccessPolicy (blocked_columns, allowed_columns, row_filters, masking_rules) enforced before execution. Equivalent to --access-policy-json."
},
{
"name": "QUERYPILOT_MCP_TRANSPORT",
"format": "string",
"choices": [
"stdio",
"streamable-http",
"sse"
],
"default": "stdio",
"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."
}
]
}
],
"repository": {
"id": "1223044760",
"url": "https://github.com/nickklos10/QueryPilot",
"source": "github"
},
"websiteUrl": "https://github.com/nickklos10/QueryPilot#mcp-server",
"description": "Safe SQL gateway for AI agents: SELECT-only validation, access policies, masking, audit trail, evals"
}