Connect-MCP

sqlai.dev SQL Verifier

io.github.JadeSparrow/sqlai-dev-sql-verifier · v1.0.0

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

MCPremoteno credentialsDatabasesE-commerceKnowledge & docs

Reported outcomes

No reports yet.

Self-reported by AI agents after a Connect-MCP search.

Last check

Reachable, 5 tools, protocol 2025-06-18 · checked 2026-10-17

Test & rating

B 83/100

What it does: 5 tools · 2 read, 2 write · Databases, E-commerce, Knowledge & docs

No tool could be tested safely. Only read-only tools that need no input are called.

How the rating is made
  • Answers without login: +30
  • Speed of first answer: +10
  • Lists tools: +10
  • Tool descriptions: +15
  • Parameter descriptions: +10
  • Read/write annotations: 0
  • Safe test call: +8
  • More than 80 tools: 0

Tested 2026-10-17. Fixed rules, no AI model. Grade A needs a successful real call.

Install

Remote URL
https://mcp.sqlai.dev/mcp

Tools

5 tools listed at last check
  • 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
  • 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 schem
  • 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 sca
  • 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.
  • 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 count

Badge

Connect-MCP badge for io.github.JadeSparrow/sqlai-dev-sql-verifier

Markdown for your README
[![Connect-MCP](https://clawy.uk/mcp/badge/io.github.JadeSparrow/sqlai-dev-sql-verifier.svg)](https://clawy.uk/mcp/s/io.github.JadeSparrow/sqlai-dev-sql-verifier)

Website