{"data":{"name":"io.github.JadeSparrow/sqlai-dev-sql-verifier","title":"sqlai.dev SQL Verifier","description":"Executes SQL in a real ephemeral database: rows, typed errors with suggestions, plans, diffs.","version":"1.0.0","websiteUrl":"https://sqlai.dev","repositoryUrl":null,"remotes":[{"url":"https://mcp.sqlai.dev/mcp","type":"streamable-http"}],"packages":[],"status":"active","isLatest":true,"publishedAt":"2026-07-07T03:11:12.490Z","updatedAt":"2026-07-07T03:11:12.490Z","source":"official-registry","verification":"official","confidence":100,"stars":null,"sources":[{"stars":null,"title":"sqlai.dev SQL Verifier","source":"official-registry","sourceId":"io.github.JadeSparrow/sqlai-dev-sql-verifier","updatedAt":"2026-07-07T03:11:12.490Z","confidence":100,"websiteUrl":"https://sqlai.dev","description":"Executes SQL in a real ephemeral database: rows, typed errors with suggestions, plans, diffs.","verification":"official","repositoryUrl":null}],"toolIndex":{"tools":[{"serverName":"io.github.JadeSparrow/sqlai-dev-sql-verifier","endpointFingerprint":"4599a5b518b8c8d0deabcdeb24cc7e1a6ddc287d95599f8ee4d6196cfb266f14","name":"diff_results","title":null,"description":"Answer \"do these two queries return the same thing?\" — the self-check for query refactors. Executes query_a and query_b against identical fresh databases and compares result multisets (order-insensitive; order divergence reported separately when ORDER BY is present). Returns equal:boolean, row counts, and capped row-level diffs (only_in_a / only_in_b).","inputSchema":{"type":"object","properties":{"schema":{"type":"string","description":"DDL statements."},"seed":{"type":"object","additionalProperties":{"type":"array","items":{"type":"object","additionalProperties":{}}},"description":"Optional seed rows: {\"table_name\": [{\"col\": value, ...}, ...]}. Max 10MB total."},"query_a":{"type":"string","description":"Original query."},"query_b":{"type":"string","description":"Refactored/alternative query."},"engine":{"type":"string","enum":["sqlite","duckdb"],"description":"Engine. Server-side supports 'sqlite' (default). 'duckdb' runs in the browser demo at sqlai.dev only."}},"required":["schema","query_a","query_b"],"additionalProperties":false,"$schema":"http://json-schema.org/draft-07/schema#"},"annotations":null,"definitionHash":"2c786e31797e3adbad478affeefdf69140878fc3b13fff356c6bc9f4bce190ea","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T19:46:55.462Z","metadataTrust":"untrusted"},{"serverName":"io.github.JadeSparrow/sqlai-dev-sql-verifier","endpointFingerprint":"4599a5b518b8c8d0deabcdeb24cc7e1a6ddc287d95599f8ee4d6196cfb266f14","name":"explain_plan","title":null,"description":"Return the engine-native query plan for a query (SQLite: EXPLAIN QUERY PLAN) plus full-table-scan warnings. Use it to check whether an index would be used before recommending one. Example: \"SELECT * FROM orders WHERE status=?\" on an unindexed column → plan [\"SCAN orders\"], warning about the full scan.","inputSchema":{"type":"object","properties":{"schema":{"type":"string","description":"DDL statements (include your indexes!)."},"query":{"type":"string","description":"ONE SQL statement to explain."},"engine":{"type":"string","enum":["sqlite","duckdb"],"description":"Engine. Server-side supports 'sqlite' (default). 'duckdb' runs in the browser demo at sqlai.dev only."}},"required":["schema","query"],"additionalProperties":false,"$schema":"http://json-schema.org/draft-07/schema#"},"annotations":null,"definitionHash":"ef9e33146cca2c9945add9313c14475e57092923566602b0beb274331b48caca","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T19:46:55.462Z","metadataTrust":"untrusted"},{"serverName":"io.github.JadeSparrow/sqlai-dev-sql-verifier","endpointFingerprint":"4599a5b518b8c8d0deabcdeb24cc7e1a6ddc287d95599f8ee4d6196cfb266f14","name":"run_sql","title":null,"description":"Execute a SQL query against a fresh ephemeral in-memory database built from your schema (and optional seed rows). Returns real rows (max 500, truncation flagged), column names+types, row_count, and dialect notes. Errors come back as structured JSON with type/position/suggestion — a failed query is a useful answer, not a failure of this tool. Example: schema \"CREATE TABLE t(id INTEGER, name TEXT);\", query \"SELECT name FROM t WHERE id=1\", seed {\"t\":[{\"id\":1,\"name\":\"ada\"}]} → rows [[\"ada\"]].","inputSchema":{"type":"object","properties":{"schema":{"type":"string","description":"DDL statements (CREATE TABLE ...; multiple statements allowed)."},"query":{"type":"string","description":"ONE SQL statement to execute. Stacked statements are rejected."},"seed":{"type":"object","additionalProperties":{"type":"array","items":{"type":"object","additionalProperties":{}}},"description":"Optional seed rows: {\"table_name\": [{\"col\": value, ...}, ...]}. Max 10MB total."},"engine":{"type":"string","enum":["sqlite","duckdb"],"description":"Engine. Server-side supports 'sqlite' (default). 'duckdb' runs in the browser demo at sqlai.dev only."}},"required":["schema","query"],"additionalProperties":false,"$schema":"http://json-schema.org/draft-07/schema#"},"annotations":null,"definitionHash":"0ec1cfce6faaa3782288193a349e36681e8525123d38f8625c3de17951c960c0","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T19:46:55.462Z","metadataTrust":"untrusted"},{"serverName":"io.github.JadeSparrow/sqlai-dev-sql-verifier","endpointFingerprint":"4599a5b518b8c8d0deabcdeb24cc7e1a6ddc287d95599f8ee4d6196cfb266f14","name":"run_sql_batch","title":null,"description":"Run up to 10 queries against the same schema+seed. Each query executes in its OWN fresh database — writes in one query are NOT visible to the next (use this for testing variants, not for multi-statement transactions). Returns an array of run_sql results in order.","inputSchema":{"type":"object","properties":{"schema":{"type":"string","description":"DDL statements."},"queries":{"type":"array","items":{"type":"string"},"maxItems":10,"description":"Up to 10 statements, one per entry."},"seed":{"type":"object","additionalProperties":{"type":"array","items":{"type":"object","additionalProperties":{}}},"description":"Optional seed rows: {\"table_name\": [{\"col\": value, ...}, ...]}. Max 10MB total."},"engine":{"type":"string","enum":["sqlite","duckdb"],"description":"Engine. Server-side supports 'sqlite' (default). 'duckdb' runs in the browser demo at sqlai.dev only."}},"required":["schema","queries"],"additionalProperties":false,"$schema":"http://json-schema.org/draft-07/schema#"},"annotations":null,"definitionHash":"b316d6b2245cee36b75aa8c6d9a350a5801728379f8ce97a68090c29f5cc382a","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T19:46:55.462Z","metadataTrust":"untrusted"},{"serverName":"io.github.JadeSparrow/sqlai-dev-sql-verifier","endpointFingerprint":"4599a5b518b8c8d0deabcdeb24cc7e1a6ddc287d95599f8ee4d6196cfb266f14","name":"validate_sql","title":null,"description":"Validate a SQL query against a schema WITHOUT executing it (parse + name/type binding via EXPLAIN). Returns ok with referenced tables, or a structured error: {type: unknown_column|unknown_table|syntax|..., message, position, suggestion}. The suggestion is rule-based (edit distance against your schema). Example: query \"SELECT nmae FROM users\" → error type unknown_column, suggestion 'did you mean \"name\"?'.","inputSchema":{"type":"object","properties":{"schema":{"type":"string","description":"DDL statements."},"query":{"type":"string","description":"ONE SQL statement to validate."},"engine":{"type":"string","enum":["sqlite","duckdb"],"description":"Engine. Server-side supports 'sqlite' (default). 'duckdb' runs in the browser demo at sqlai.dev only."}},"required":["schema","query"],"additionalProperties":false,"$schema":"http://json-schema.org/draft-07/schema#"},"annotations":null,"definitionHash":"9774fd419ec7877417674d6c0a92f59125321867a8f0631ed38afb17d4514ccd","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T19:46:55.462Z","metadataTrust":"untrusted"}],"endpoints":[{"endpointFingerprint":"4599a5b518b8c8d0deabcdeb24cc7e1a6ddc287d95599f8ee4d6196cfb266f14","protocol":"streamable-http","status":"indexed","toolCount":5,"observedAt":"2026-11-19T19:46:55.462Z"}],"authentication":"unknown"},"connectionConfigurations":{"status":"ready","authentication":"not embedded","clients":{"Claude Desktop":{"mcpServers":{"io.github.JadeSparrow/sqlai-dev-sql-verifier":{"url":"https://mcp.sqlai.dev/mcp"}}},"Cursor":{"mcpServers":{"io.github.JadeSparrow/sqlai-dev-sql-verifier":{"url":"https://mcp.sqlai.dev/mcp"}}},"VS Code":{"servers":{"io.github.JadeSparrow/sqlai-dev-sql-verifier":{"type":"http","url":"https://mcp.sqlai.dev/mcp"}}}}},"resourceType":"mcp-server","callable":true,"runtime":{"callable":true,"protocols":["mcp"]},"interfaces":[{"protocol":"mcp","transport":"streamable-http","url":"https://mcp.sqlai.dev/mcp"}],"profile":{"apiVersion":"1","schemaVersion":"1","id":"mcp-server:io.github.JadeSparrow%2Fsqlai-dev-sql-verifier","resourceType":"mcp-server","canonicalUrl":"https://www.agentsjunction.com/api/v1/servers/io.github.JadeSparrow%2Fsqlai-dev-sql-verifier","name":"io.github.JadeSparrow/sqlai-dev-sql-verifier","description":"Executes SQL in a real ephemeral database: rows, typed errors with suggestions, plans, diffs.","interfaces":[{"protocol":"mcp","transport":"streamable-http","url":"https://mcp.sqlai.dev/mcp"}],"capabilities":[],"identity":{"source":"official-registry","websiteUrl":"https://sqlai.dev","repositoryUrl":null,"version":"1.0.0"},"verification":{"state":"official","confidence":100},"operations":{"resourceType":"mcp-server","name":"io.github.JadeSparrow/sqlai-dev-sql-verifier","status":"online","lastCheckedAt":"2026-11-20T04:17:14.868Z","lastSuccessfulCheck":"2026-11-20T04:17:14.868Z","latencyMs":97,"consecutiveFailures":0,"isStale":false,"checks":{"endpointReachable":true,"protocolValid":true,"agentCardValid":null,"mcpHandshakeValid":true},"lastSeen":null,"lastSuccessfulInteraction":null,"lastHealthCheck":"2026-11-20T04:17:14.868Z","source":{"type":"health-check","url":null},"observedAt":"2026-11-20T04:17:14.868Z"},"security":null,"timestamps":{"createdAt":"2026-07-07T03:11:12.490Z","updatedAt":"2026-07-07T03:11:12.490Z","observedAt":"2026-11-20T04:17:14.868Z"},"compatibility":{"serverVersion":"1.0.0","protocolVersions":[{"protocol":"mcp","version":null}]}}}}