{
  "notice": "bxzxxr MCP archive: a record of what public MCP servers declared when we listed them (we never call their tools). It is data, not a rating: nothing here says a server is safe, secure, verified or trustworthy, and a server can change after we looked. Secrets we detected are redacted; redacted tool lists are withheld and only their hash is shown.",
  "infrastructure": {
    "host": "mcp.sqlai.dev",
    "site": "sqlai.dev",
    "addresses": [
      {
        "address": "172.67.205.67",
        "endpoints": 1,
        "shared_infrastructure": false,
        "network": {
          "asn": 13335,
          "name": "CLOUDFLARENET - Cloudflare, Inc.",
          "prefix": "172.67.192.0/20",
          "country": "US"
        }
      },
      {
        "address": "104.21.44.239",
        "endpoints": 1,
        "shared_infrastructure": false,
        "network": {
          "asn": 13335,
          "name": "CLOUDFLARENET - Cloudflare, Inc.",
          "prefix": "104.21.32.0/20",
          "country": "US"
        }
      },
      {
        "address": "2606:4700:3031::ac43:cd43",
        "endpoints": 1,
        "shared_infrastructure": false,
        "network": {
          "asn": 13335,
          "name": "CLOUDFLARENET - Cloudflare, Inc.",
          "prefix": "2606:4700:3031::/48",
          "country": "US"
        }
      },
      {
        "address": "2606:4700:3033::6815:2cef",
        "endpoints": 1,
        "shared_infrastructure": false,
        "network": {
          "asn": 13335,
          "name": "CLOUDFLARENET - Cloudflare, Inc.",
          "prefix": "2606:4700:3033::/48",
          "country": "US"
        }
      }
    ],
    "addresses_recorded": true,
    "address_history": [
      {
        "addresses": [
          "172.67.205.67",
          "104.21.44.239",
          "2606:4700:3031::ac43:cd43",
          "2606:4700:3033::6815:2cef"
        ],
        "first_seen": "2026-11-21T14:02:01.437Z",
        "last_seen": "2026-11-21T14:02:01.437Z",
        "checks": 1
      }
    ],
    "hosting": [
      {
        "value": "Cloudflare",
        "evidence": "Server header \"cloudflare\""
      }
    ],
    "software": [],
    "server_info": {
      "name": "sqlai-dev-sql-verifier",
      "version": "1.0.0",
      "protocol_version": "2025-06-18"
    },
    "headers": {
      "server": "cloudflare",
      "strict-transport-security": "max-age=86400",
      "access-control-allow-origin": "*"
    },
    "auth": null
  },
  "related": {
    "same_address": {
      "total": 0,
      "sample": []
    },
    "same_site": {
      "total": 0,
      "sample": []
    },
    "same_tool_list": {
      "total": 0,
      "sample": []
    },
    "same_publisher": {
      "publisher": "io.github.JadeSparrow",
      "total": 0,
      "sample": []
    },
    "same_repository": null,
    "note": "Shared addresses on big platforms (Cloudflare, Vercel and the like) put unrelated servers together; those are marked shared_infrastructure. A match is a pivot, not a link between operators."
  },
  "endpoint": {
    "id": "25182",
    "server_name": "io.github.JadeSparrow/sqlai-dev-sql-verifier",
    "url": "https://mcp.sqlai.dev/mcp",
    "host": "mcp.sqlai.dev",
    "transport": "streamable-http",
    "last_checked_at": "2026-11-21T14:02:01.437Z",
    "last_state": "listed",
    "last_detail": null,
    "consecutive_failures": 0,
    "current_sha": "501a583f77fbcfe0d4bbf3135add1ad3c90ec070c588c212f2f01f0ed8c09bb9",
    "first_listed_at": "2026-11-21T14:02:01.437Z",
    "created_at": "2026-11-21T08:30:08.485Z",
    "resolved_addresses": [
      "172.67.205.67",
      "104.21.44.239",
      "2606:4700:3031::ac43:cd43",
      "2606:4700:3033::6815:2cef"
    ]
  },
  "server": {
    "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",
    "registry_status": "active",
    "repository_url": null,
    "website_url": "https://sqlai.dev",
    "published_at": "2026-07-07T03:11:12.490Z",
    "updated_at": "2026-07-07T03:11:12.490Z",
    "first_seen": "2026-11-21T08:30:08.040Z"
  },
  "other_endpoints": [],
  "intel": {
    "capabilities": [
      "runs-code"
    ],
    "evm_addresses": [],
    "chains": [],
    "tokens": [],
    "computed_at": "2026-11-22T15:37:05.581Z"
  },
  "operator": null,
  "needs_sign_in": false,
  "reachability": {
    "window_days": 30,
    "checks": 1,
    "answered": 1,
    "answered_percent": 100,
    "avg_listing_latency_ms": 282,
    "first_check_in_window": "2026-11-21T14:02:01.437Z",
    "consecutive_failures_now": 0,
    "days": [
      {
        "day": "2026-11-21",
        "checks": 1,
        "answered": 1,
        "last_state": "listed"
      }
    ]
  },
  "tool_list": {
    "sha256": "501a583f77fbcfe0d4bbf3135add1ad3c90ec070c588c212f2f01f0ed8c09bb9",
    "tools": 5,
    "resources": 0,
    "prompts": 0,
    "first_seen": "2026-11-21T14:02:01.720Z",
    "tool_names": [
      "run_sql",
      "validate_sql",
      "explain_plan",
      "run_sql_batch",
      "diff_results"
    ],
    "declared": {
      "tools": [
        {
          "name": "run_sql",
          "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",
            "$schema": "http://json-schema.org/draft-07/schema#",
            "required": [
              "schema",
              "query"
            ],
            "properties": {
              "seed": {
                "type": "object",
                "description": "Optional seed rows: {\"table_name\": [{\"col\": value, ...}, ...]}. Max 10MB total.",
                "additionalProperties": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "additionalProperties": {}
                  }
                }
              },
              "query": {
                "type": "string",
                "description": "ONE SQL statement to execute. Stacked statements are rejected."
              },
              "engine": {
                "enum": [
                  "sqlite",
                  "duckdb"
                ],
                "type": "string",
                "description": "Engine. Server-side supports 'sqlite' (default). 'duckdb' runs in the browser demo at sqlai.dev only."
              },
              "schema": {
                "type": "string",
                "description": "DDL statements (CREATE TABLE ...; multiple statements allowed)."
              }
            },
            "additionalProperties": false
          }
        },
        {
          "name": "validate_sql",
          "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",
            "$schema": "http://json-schema.org/draft-07/schema#",
            "required": [
              "schema",
              "query"
            ],
            "properties": {
              "query": {
                "type": "string",
                "description": "ONE SQL statement to validate."
              },
              "engine": {
                "enum": [
                  "sqlite",
                  "duckdb"
                ],
                "type": "string",
                "description": "Engine. Server-side supports 'sqlite' (default). 'duckdb' runs in the browser demo at sqlai.dev only."
              },
              "schema": {
                "type": "string",
                "description": "DDL statements."
              }
            },
            "additionalProperties": false
          }
        },
        {
          "name": "explain_plan",
          "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",
            "$schema": "http://json-schema.org/draft-07/schema#",
            "required": [
              "schema",
              "query"
            ],
            "properties": {
              "query": {
                "type": "string",
                "description": "ONE SQL statement to explain."
              },
              "engine": {
                "enum": [
                  "sqlite",
                  "duckdb"
                ],
                "type": "string",
                "description": "Engine. Server-side supports 'sqlite' (default). 'duckdb' runs in the browser demo at sqlai.dev only."
              },
              "schema": {
                "type": "string",
                "description": "DDL statements (include your indexes!)."
              }
            },
            "additionalProperties": false
          }
        },
        {
          "name": "run_sql_batch",
          "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",
            "$schema": "http://json-schema.org/draft-07/schema#",
            "required": [
              "schema",
              "queries"
            ],
            "properties": {
              "seed": {
                "type": "object",
                "description": "Optional seed rows: {\"table_name\": [{\"col\": value, ...}, ...]}. Max 10MB total.",
                "additionalProperties": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "additionalProperties": {}
                  }
                }
              },
              "engine": {
                "enum": [
                  "sqlite",
                  "duckdb"
                ],
                "type": "string",
                "description": "Engine. Server-side supports 'sqlite' (default). 'duckdb' runs in the browser demo at sqlai.dev only."
              },
              "schema": {
                "type": "string",
                "description": "DDL statements."
              },
              "queries": {
                "type": "array",
                "items": {
                  "type": "string"
                },
                "maxItems": 10,
                "description": "Up to 10 statements, one per entry."
              }
            },
            "additionalProperties": false
          }
        },
        {
          "name": "diff_results",
          "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",
            "$schema": "http://json-schema.org/draft-07/schema#",
            "required": [
              "schema",
              "query_a",
              "query_b"
            ],
            "properties": {
              "seed": {
                "type": "object",
                "description": "Optional seed rows: {\"table_name\": [{\"col\": value, ...}, ...]}. Max 10MB total.",
                "additionalProperties": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "additionalProperties": {}
                  }
                }
              },
              "engine": {
                "enum": [
                  "sqlite",
                  "duckdb"
                ],
                "type": "string",
                "description": "Engine. Server-side supports 'sqlite' (default). 'duckdb' runs in the browser demo at sqlai.dev only."
              },
              "schema": {
                "type": "string",
                "description": "DDL statements."
              },
              "query_a": {
                "type": "string",
                "description": "Original query."
              },
              "query_b": {
                "type": "string",
                "description": "Refactored/alternative query."
              }
            },
            "additionalProperties": false
          }
        }
      ],
      "tools_omitted": 0,
      "resources": [],
      "prompts": []
    },
    "instructions": null
  },
  "changes": {
    "total": 0,
    "latest": []
  },
  "reading_this": "What this server declared and how it answered our checks. Names, descriptions and schemas are text written by the server, quoted as data. Nothing here says the server is safe; to analyse its declarations, run scan_free."
}