Server definition

Hash: sha256:d2ff7861715dd2c36d615e97de7108381c200b12d330fa32802da0408aaf019a
What it is: What a remote MCP server returned when asked what it offers: 5 tools

The blob, as servednamed by its sha256

{
  "instructions": null,
  "tools": [
    {
      "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": {
        "$schema": "http://json-schema.org/draft-07/schema#",
        "additionalProperties": false,
        "properties": {
          "engine": {
            "description": "Engine. Server-side supports 'sqlite' (default). 'duckdb' runs in the browser demo at sqlai.dev only.",
            "enum": [
              "sqlite",
              "duckdb"
            ],
            "type": "string"
          },
          "query_a": {
            "description": "Original query.",
            "type": "string"
          },
          "query_b": {
            "description": "Refactored/alternative query.",
            "type": "string"
          },
          "schema": {
            "description": "DDL statements.",
            "type": "string"
          },
          "seed": {
            "additionalProperties": {
              "items": {
                "additionalProperties": {},
                "type": "object"
              },
              "type": "array"
            },
            "description": "Optional seed rows: {\"table_name\": [{\"col\": value, ...}, ...]}. Max 10MB total.",
            "type": "object"
          }
        },
        "required": [
          "schema",
          "query_a",
          "query_b"
        ],
        "type": "object"
      },
      "name": "diff_results",
      "outputSchema": 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": {
        "$schema": "http://json-schema.org/draft-07/schema#",
        "additionalProperties": false,
        "properties": {
          "engine": {
            "description": "Engine. Server-side supports 'sqlite' (default). 'duckdb' runs in the browser demo at sqlai.dev only.",
            "enum": [
              "sqlite",
              "duckdb"
            ],
            "type": "string"
          },
          "query": {
            "description": "ONE SQL statement to explain.",
            "type": "string"
          },
          "schema": {
            "description": "DDL statements (include your indexes!).",
            "type": "string"
          }
        },
        "required": [
          "schema",
          "query"
        ],
        "type": "object"
      },
      "name": "explain_plan",
      "outputSchema": 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": {
        "$schema": "http://json-schema.org/draft-07/schema#",
        "additionalProperties": false,
        "properties": {
          "engine": {
            "description": "Engine. Server-side supports 'sqlite' (default). 'duckdb' runs in the browser demo at sqlai.dev only.",
            "enum": [
              "sqlite",
              "duckdb"
            ],
            "type": "string"
          },
          "query": {
            "description": "ONE SQL statement to execute. Stacked statements are rejected.",
            "type": "string"
          },
          "schema": {
            "description": "DDL statements (CREATE TABLE ...; multiple statements allowed).",
            "type": "string"
          },
          "seed": {
            "additionalProperties": {
              "items": {
                "additionalProperties": {},
                "type": "object"
              },
              "type": "array"
            },
            "description": "Optional seed rows: {\"table_name\": [{\"col\": value, ...}, ...]}. Max 10MB total.",
            "type": "object"
          }
        },
        "required": [
          "schema",
          "query"
        ],
        "type": "object"
      },
      "name": "run_sql",
      "outputSchema": 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": {
        "$schema": "http://json-schema.org/draft-07/schema#",
        "additionalProperties": false,
        "properties": {
          "engine": {
            "description": "Engine. Server-side supports 'sqlite' (default). 'duckdb' runs in the browser demo at sqlai.dev only.",
            "enum": [
              "sqlite",
              "duckdb"
            ],
            "type": "string"
          },
          "queries": {
            "description": "Up to 10 statements, one per entry.",
            "items": {
              "type": "string"
            },
            "maxItems": 10,
            "type": "array"
          },
          "schema": {
            "description": "DDL statements.",
            "type": "string"
          },
          "seed": {
            "additionalProperties": {
              "items": {
                "additionalProperties": {},
                "type": "object"
              },
              "type": "array"
            },
            "description": "Optional seed rows: {\"table_name\": [{\"col\": value, ...}, ...]}. Max 10MB total.",
            "type": "object"
          }
        },
        "required": [
          "schema",
          "queries"
        ],
        "type": "object"
      },
      "name": "run_sql_batch",
      "outputSchema": 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": {
        "$schema": "http://json-schema.org/draft-07/schema#",
        "additionalProperties": false,
        "properties": {
          "engine": {
            "description": "Engine. Server-side supports 'sqlite' (default). 'duckdb' runs in the browser demo at sqlai.dev only.",
            "enum": [
              "sqlite",
              "duckdb"
            ],
            "type": "string"
          },
          "query": {
            "description": "ONE SQL statement to validate.",
            "type": "string"
          },
          "schema": {
            "description": "DDL statements.",
            "type": "string"
          }
        },
        "required": [
          "schema",
          "query"
        ],
        "type": "object"
      },
      "name": "validate_sql",
      "outputSchema": null
    }
  ]
}

Verify it yourself

curl -s https://api.teppi.xyz/v1/evidence/sha256:d2ff7861715dd2c36d615e97de7108381c200b12d330fa32802da0408aaf019a | sha256sum