{"name":"io.github.nickklos10/querypilot","slug":"nickklos10-querypilot","title":"QueryPilot","description":"Safe SQL gateway for AI agents: SELECT-only validation, access policies, masking, audit trail, evals","url":"https://mcp.market/server/nickklos10-querypilot","rating":null,"grade":"B","score":78,"certified":false,"status":"active","category":"data","tags":["data"],"presence":{"score":23,"stars":1,"forks":0,"downloads_week":23,"last_push_at":"2026-07-11T21:54:02.000Z","license":"MIT"},"uptime":null,"claimed":false,"transport":"pypi","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/nickklos10/QueryPilot","website":"https://github.com/nickklos10/QueryPilot#mcp-server","version":"0.1.1","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"}]}],"tools":[{"name":"ask_database","description":"Ask a database question through QueryPilot's safe SQL flow.","write_action":false,"price_micros":0,"input_schema":null},{"name":"execute_sql","description":"Validate and execute read-only SQL safely.","write_action":true,"price_micros":0,"input_schema":null},{"name":"search_schema","description":"Search tables and columns relevant to a question.","write_action":false,"price_micros":0,"input_schema":null},{"name":"validate_sql","description":"Validate SQL and return policy metadata.","write_action":false,"price_micros":0,"input_schema":null}],"scan":{"score":78,"grade":"B","scanned_at":"2026-09-26T05:12:48.349Z","report":{"scannerVersion":"0.1.9","scannedAt":"2026-09-26T05:12:48.379Z","components":{"code":{"score":25,"max":25,"notes":["53 source files scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":6,"max":15,"notes":["static API keys via environment variables"]},"maintenance":{"score":12,"max":15,"notes":["last push 76 days ago"]},"identity":{"score":8,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[],"inputs":{"packages":[{"registryType":"pypi","identifier":"querypilot","version":"0.1.1","found":true,"weeklyDownloads":23,"license":"MIT","dependencyCount":19,"publishedAt":"2026-07-11T17:51:53.391581Z","repositoryUrl":"https://github.com/nickklos10/QueryPilot"}],"repo":{"found":true,"owner":"nickklos10","repo":"QueryPilot","archived":false,"pushedAt":"2026-07-11T21:54:02Z","stars":1,"forks":0,"openIssues":0,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/115585646?v=4","ownerCreatedAt":"2022-10-11T19:06:55Z","license":"MIT"},"icon":{"url":"https://avatars.githubusercontent.com/u/115585646?v=4&s=128","source":"github"},"presence":{"stars":1,"forks":0,"downloadsWeek":23,"license":"MIT","lastPushAt":"2026-07-11T21:54:02.000Z","score":23}}}},"grade_history":[],"reviews":[]}