Search / io.github.JadeSparrow/sqlai-dev-sql-verifier
sqlai.dev SQL Verifier
R0· no sign-inExecutes SQL in a real ephemeral database: rows, typed errors with suggestions, plans, diffs.
v1.0.0 · active · website · descriptor JSON · versions
Search / io.github.JadeSparrow/sqlai-dev-sql-verifier
R0· no sign-inExecutes SQL in a real ephemeral database: rows, typed errors with suggestions, plans, diffs.
v1.0.0 · active · website · descriptor JSON · versions
{
"mcpServers": {
"sqlai-dev-sql-verifier": {
"type": "http",
"url": "https://mcp.sqlai.dev/mcp"
}
}
}claude mcp add --transport http sqlai-dev-sql-verifier https://mcp.sqlai.dev/mcp[mcp_servers.sqlai-dev-sql-verifier]
url = "https://mcp.sqlai.dev/mcp"
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"sqlai-dev-sql-verifier": {
"type": "remote",
"url": "https://mcp.sqlai.dev/mcp",
"enabled": true
}
}
}{
"mcpServers": {
"sqlai-dev-sql-verifier": {
"type": "http",
"url": "https://mcp.sqlai.dev/mcp"
}
},
"deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=sqlai-dev-sql-verifier&config=eyJ0eXBlIjoiaHR0cCIsInVybCI6Imh0dHBzOi8vbWNwLnNxbGFpLmRldi9tY3AifQ%3D%3D"
}{
"servers": {
"sqlai-dev-sql-verifier": {
"type": "http",
"url": "https://mcp.sqlai.dev/mcp"
}
}
}{
"mcpServers": {
"sqlai-dev-sql-verifier": {
"httpUrl": "https://mcp.sqlai.dev/mcp"
}
}
}extensions:
"sqlai-dev-sql-verifier":
enabled: true
name: "sqlai-dev-sql-verifier"
type: streamable_http
uri: "https://mcp.sqlai.dev/mcp"
timeout: 300
protocol.modernnewest supported version is 2025-11-25; 2026-07-28 not supported, older versions are deprecated until 2027-07-28protocol.statelessonly applies to 2026-07-28 serversprotocol.transportstreamable HTTPprotocol.list_ttlonly applies to 2026-07-28 serversauth.prm, auth.as_metadata, auth.cimdno remote uses OAuthauth.secret_in_urlno templated URLtools.descriptionsevery tool has a descriptiontools.description_lengthdescriptions are concisetools.schemasevery tool has an object input schematools.annotationsno tool declares readOnlyHint or destructiveHint, so clients cannot tell safe calls from risky onestools.directory_hintsno tool declares all four of readOnlyHint, destructiveHint, idempotentHint and openWorldHint; missing: run_sql (readOnlyHint, destructiveHint, idempotentHint, openWorldHint); validate_sql (readOnlyHint, destructiveHint, idempotentHint, openWorldHint); explain_plan (readOnlyHint, destructiveHint, idempotentHint, openWorldHint); …tools.token_costabout 1,252 tokens to load every tooltools.api_dumptools are not a one-to-one API dumpstability.changesno tool changes in 30 daysstability.rug_pullno tool changed its meaning under the same namedeps.known_vulns, deps.mcp_sdk_version, deps.resolvableno npm or PyPI packageNo 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.
+website +reachable +uptime-96% ~updated-105d-ago -no-repository
Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.
| remote | auth | reachable | uptime 30d | p50 | protocol | last ok |
|---|---|---|---|---|---|---|
https://mcp.sqlai.dev/mcp streamable-http | none | yes | 96% | 385 ms | 2025-11-25 | 2026-10-20 |
diff_results | 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). |
explain_plan | 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. |
run_sql | 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"]]. |
run_sql_batch | 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. |
validate_sql | 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"?'. |
Schemas: list_tools.
{
"name": "io.github.JadeSparrow/sqlai-dev-sql-verifier",
"title": "sqlai.dev SQL Verifier",
"$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
"remotes": [
{
"url": "https://mcp.sqlai.dev/mcp",
"type": "streamable-http"
}
],
"version": "1.0.0",
"websiteUrl": "https://sqlai.dev",
"description": "Executes SQL in a real ephemeral database: rows, typed errors with suggestions, plans, diffs."
}