@sqlike/mcp
Advanced tools
+6
-6
| { | ||
| "name": "@sqlike/mcp", | ||
| "mcpName": "io.github.orifisher2/sqlike-mcp", | ||
| "version": "0.1.2", | ||
| "version": "0.1.3", | ||
| "description": "MCP server for sqlike — deterministic SQL static analysis. A thin remote client that tokenizes locally and forwards to the sqlike API.", | ||
@@ -34,8 +34,8 @@ "keywords": [ | ||
| "optionalDependencies": { | ||
| "@sqlike/mcp-darwin-arm64": "0.1.2", | ||
| "@sqlike/mcp-darwin-x64": "0.1.2", | ||
| "@sqlike/mcp-linux-arm64": "0.1.2", | ||
| "@sqlike/mcp-linux-x64": "0.1.2", | ||
| "@sqlike/mcp-win32-x64": "0.1.2" | ||
| "@sqlike/mcp-darwin-arm64": "0.1.3", | ||
| "@sqlike/mcp-darwin-x64": "0.1.3", | ||
| "@sqlike/mcp-linux-arm64": "0.1.3", | ||
| "@sqlike/mcp-linux-x64": "0.1.3", | ||
| "@sqlike/mcp-win32-x64": "0.1.3" | ||
| } | ||
| } |
+25
-13
| # @sqlike/mcp | ||
| MCP server for [sqlike](https://sqlike.com) — a deterministic SQL static analyzer and advisor | ||
| (validity, anti-patterns, rewrites, schema advice) for Postgres, MySQL, SQLite, and SQL Server. | ||
| MCP server for [sqlike](https://sqlike.com), a deterministic SQL static analyzer and advisor | ||
| (validity, anti-patterns, rewrites, index and schema advice) and query-equivalence checker for | ||
| Postgres, MySQL, MariaDB, SQLite, and SQL Server. | ||
| This package is a **thin remote client**: it tokenizes your SQL locally (identifiers and literals | ||
| are replaced before anything leaves your machine) and forwards the tokenized query to the sqlike | ||
| API for analysis. It contains no analysis engine. | ||
| Point your coding agent at it and the SQL it writes gets checked before it runs, by something with | ||
| no model in the loop and no opinion to guess with. | ||
| This package is a **thin remote client**. It tokenizes your SQL locally, so identifiers and literals | ||
| are masked before anything leaves your machine, and forwards only the tokenized query to the sqlike | ||
| API. There is no analysis engine in it. | ||
| ## Use it | ||
| No install needed — point your MCP client at it via `npx`: | ||
| No install needed. Point your MCP client at it via `npx`: | ||
@@ -27,5 +31,13 @@ ```json | ||
| - **`analyze`** — static analysis of a single SQL query. | ||
| - **`diff`** — whether two queries are equivalent. | ||
| - **`analyze`**: static analysis of one query. Takes `sql`, plus optional `schema` DDL for column | ||
| and type aware checks and a `dialect` of `postgres` (default), `mysql`, `mariadb`, `sqlite`, or | ||
| `mssql`. Returns the JSON analysis envelope. | ||
| - **`diff`**: whether two queries are equivalent. Takes `sql_a` and `sql_b`, plus the same optional | ||
| `schema` and `dialect`. Returns a verdict (`Equivalent`, `EquivalentWithNotes`, `Differs`, or | ||
| `Undecided`), a confidence level, and a report per property (columns, rows, cardinality, order). | ||
| `Undecided` never means equivalent. | ||
| A query that cannot be parsed cannot be tokenized, so the tool refuses rather than send raw SQL. | ||
| Overriding that is an explicit `allow_raw: true` on `analyze`. | ||
| ### Configuration | ||
@@ -35,4 +47,4 @@ | ||
| - `SQLIKE_URL` — API base URL (default `https://api.sqlike.com`). | ||
| - `SQLIKE_API_KEY` — optional; sent as a Bearer token for higher rate limits. | ||
| - `SQLIKE_URL`: API base URL (default `https://api.sqlike.com`). | ||
| - `SQLIKE_API_KEY`: optional, sent as a Bearer token for higher rate limits. | ||
@@ -54,5 +66,5 @@ ```json | ||
| The server is a native binary. Each platform's binary is published as its own optional-dependency | ||
| package (`@sqlike/mcp-linux-x64`, `@sqlike/mcp-darwin-arm64`, …); npm installs only the one matching | ||
| your OS and CPU. No install scripts run — this works with `--ignore-scripts` and in locked-down | ||
| environments. Supported: linux x64/arm64, macOS x64/arm64, Windows x64. | ||
| package (`@sqlike/mcp-linux-x64`, `@sqlike/mcp-darwin-arm64`, and so on), so npm installs only the | ||
| one matching your OS and CPU. No install scripts run, which means this works with `--ignore-scripts` | ||
| and in locked-down environments. Supported: linux x64 and arm64, macOS x64 and arm64, Windows x64. | ||
@@ -59,0 +71,0 @@ ## License |
5356
18.47%71
20.34%