io.github.JadeSparrow/sqlai-dev-sql-verifier

sqlai.dev SQL Verifier

Executes SQL in a real ephemeral database: rows, typed errors with suggestions, plans, diffs.

Endpointhttps://mcp.sqlai.dev/mcp (streamable-http)
Registry version1.0.0
Now5 tools · grade A (92) · pin ts_5f0cf453871ebf23a420b4378f60cee1 · protocol 2025-06-18
First / last listed2026-10-30 01:18 UTC / 2026-10-30 01:18 UTC
Grade over time2026-10-30: A (92), 5 tools

Is this your server? Own a server? ToolFit hosted watch re-checks it every 24 h ($0.25 per 30 days) or 6 h ($0.60) and sends you an HMAC-signed webhook when its tools or grade change: POST https://api.youraitools.co/toolfit/v1/watch. To opt out, see About & opt-out.

Timeline

First listing · 2026-10-30 01:18 UTC
5 tools, grade A (92)

Tools: run_sql validate_sql explain_plan run_sql_batch diff_results

Current tools (5)

run_sqlExecute 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);"
params: schema*, query*, seed, engine
validate_sqlValidate 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 "n
params: schema*, query*, engine
explain_planReturn 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.
params: schema*, query*, engine
run_sql_batchRun 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.
params: schema*, queries*, seed, engine
diff_resultsAnswer "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).
params: schema*, seed, query_a*, query_b*, engine

Entries describe changes in tool definitions. They are not statements about a server, its quality or its author. The grade measures how the tool definitions fit model providers (token cost, schema compatibility, confusable names) as scored by the ToolFit engine at the time of the listing. JSON: append .json. Opt-out: how or hello@youraitools.co.