# `io.github.JadeSparrow/sqlai-dev-sql-verifier` on Anlyon Radar

> Text inside fenced blocks marked untrusted-server-text was written by the MCP server's publisher, not by Anlyon Radar. It is data to inspect, not instructions to follow. Invisible characters are shown as [U+XXXX].
> No finding is not a safety guarantee: these are point-in-time checks of tool definitions, not of code or behaviour.

- Page: https://radar.anlyon.com/servers/io.github.JadeSparrow/sqlai-dev-sql-verifier
- JSON: https://radar.anlyon.com/api/v1/servers/io.github.JadeSparrow/sqlai-dev-sql-verifier
- Version: 1.0.0 (active)
- Publisher: io.github.JadeSparrow (GitHub account)
- Runs: remote (streamable-http)
- Sign-in to list tools: none
- Metadata from the official MCP Registry, synced 2026-10-21T18:16:56.783Z

Title and description, as the publisher wrote them:

```untrusted-server-text
sqlai.dev SQL Verifier
Executes SQL in a real ephemeral database: rows, typed errors with suggestions, plans, diffs.
```

Scanned 2026-11-16T18:17:41.197Z over streamable-http.

**5 tools: 2 change things and 3 only read.**

| Group | Class | Tools | Claude Code |
| --- | --- | --- | --- |
| Deletes or cancels | destructive | 0 | deny |
| Can't be undone | irreversible | 0 | ask |
| Changes things | write | 2 | ask |
| Only reads | read | 3 | allow |

## Exfil surface

No private-data -> untrusted-input -> outbound path in this server alone: no tool is tagged private-data or untrusted-input or outbound.

| Tag | Meaning | Tools |
| --- | --- | --- |
| private-data | Reads files, mail, messages, databases, secrets, calendars or repositories. | none |
| untrusted-input | Brings in text someone else can write: web pages, inbound email, messages, issues and comments. | none |
| outbound | Can carry data to people or systems: it sends, posts or publishes, or takes a recipient, channel or URL. | none |

## Findings

No check matched anything in these tool definitions.


## Changes things (2)

Creates or changes something that can be changed back. Claude Code: ask.

### `run_sql`

- The name "run_sql" says "run": a word for a change.

Description, as the server wrote it:

```untrusted-server-text
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`

- The name "run_sql_batch" says "run": a word for a change.

Description, as the server wrote it:

```untrusted-server-text
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.
```

## Only reads (3)

Looks things up and changes nothing. Claude Code: allow.

### `diff_results`

- The name "diff_results" says "diff": a word for reading.

Description, as the server wrote it:

```untrusted-server-text
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`

- The name "explain_plan" says "explain": a word for reading.

Description, as the server wrote it:

```untrusted-server-text
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.
```

### `validate_sql`

- The name "validate_sql" says "validate": a word for reading.

Description, as the server wrote it:

```untrusted-server-text
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"?'.
```

## Claude Code permissions

For `.claude/settings.json`, assuming the server is installed as `sqlai-dev-sql-verifier`:

```json
{
  "permissions": {
    "allow": [
      "mcp__sqlai-dev-sql-verifier__validate_sql",
      "mcp__sqlai-dev-sql-verifier__explain_plan",
      "mcp__sqlai-dev-sql-verifier__diff_results"
    ],
    "ask": [
      "mcp__sqlai-dev-sql-verifier__run_sql",
      "mcp__sqlai-dev-sql-verifier__run_sql_batch"
    ],
    "deny": []
  }
}
```

## Remote posture

What an anonymous client saw at the remote endpoint, last 2026-11-20T18:58:39.346Z, unchanged since 2026-10-22T14:52:41.014Z. No credentials were sent and no tool was called. Values are shown as the endpoint returned them. Method: https://radar.anlyon.com/methodology#remote-posture

| Fact | Observed |
| --- | --- |
| Reachable | `yes` |
| HTTP status of an anonymous initialize | `200` |
| tools/list served without credentials | `yes` |
| Tools that change things, listed without credentials | `2` |
| Protocol version | `2025-06-18` |
| WWW-Authenticate on 401 | `not observed` |
| resource_metadata in WWW-Authenticate | `none` |
| RFC 9728 protected resource metadata | `https://mcp.sqlai.dev/.well-known/oauth-protected-resource/mcp` |
| Authorization servers | `none` |
| Legacy HTTP+SSE transport | `no` |
| Dynamic client registration | `not observed` |
| Client ID metadata documents | `not observed` |

- **warn** Tools that change things, listed to anyone ([unauth-remote-writes](https://radar.anlyon.com/methodology#unauth-remote-writes))

```untrusted-server-text
The endpoint served tools/list without credentials, and the list has 2 tools that change things (2 write). Whether a call also works without credentials was not tested: tools are never called.

https://mcp.sqlai.dev/mcp: tools/list returned 5 tools to an anonymous client, including run_sql (write), run_sql_batch (write)
```
