sqlike: MCP server & clients

Deterministic SQL static analysis and query-equivalence checking for Postgres, MySQL, SQLite, and SQL Server, as an MCP server, a CLI, and a shared client library. Part of sqlike.

These are thin remote clients. They tokenize your SQL locally (identifiers and literals are masked before anything leaves your machine) and forward the tokenized query to the sqlike API for analysis. They contain no analysis engine; that runs server-side and is closed.

Install the MCP server

Add it to any MCP client (Claude Desktop, Cursor, etc.):

{
  "mcpServers": {
    "sqlike": { "command": "npx", "args": ["-y", "@sqlike/mcp"] }
  }
}

Or install via Smithery. An optional SQLIKE_API_KEY environment variable raises rate limits; without it you get the open anonymous tier.

Tools

analyze

Static analysis of one SQL query: validity, anti-patterns, suggested rewrites, and schema/index advice. Returns the JSON analysis envelope.

Argument	Type	Description
sql	string	The SQL query to analyze. Required.
schema	string	Optional DDL (CREATE TABLE / CREATE INDEX) for column- & type-aware checks.
dialect	string	postgres (default), mysql, sqlite, or mssql.
allow_raw	boolean	Only used when a query fails to parse (so can't be tokenized): send raw SQL for a parse diagnostic. Default false.

diff

Check whether two SQL queries are equivalent (result-preserving), for verifying a rewrite or refactor. Returns a verdict (Equivalent / EquivalentWithNotes / Differs / Undecided), a confidence level, and a per-property report (columns, rows, cardinality, order). Undecided never means equivalent. This is a judgement an LLM cannot reliably self-grade.

Argument	Type	Description
sql_a	string	The original query. Required.
sql_b	string	The rewritten query to check against sql_a. Required.
schema	string	Optional DDL both queries resolve against (one shared schema).
dialect	string	postgres (default), mysql, sqlite, or mssql.

CLI

crates/cli builds sqlike, a command-line client:

sqlike check "SELECT * FROM users WHERE id = 1" --remote https://api.sqlike.com

What's here

• crates/mcp: sqlike-mcp, the MCP server. Ships to npm as @sqlike/mcp.
• crates/cli: sqlike, the command-line client.
• crates/client: the shared, engine-free forwarder: tokenize → call API → detokenize.
• crates/core-parse: the SQL parser, stage model, tokenizer, and result types.
• packages/: the npm packaging for @sqlike/mcp (per-platform prebuilt binaries).

Privacy

Tokenization happens here, on your machine, before any request. If a query can't be parsed it can't be tokenized; the client then refuses to send it rather than transmit raw SQL, unless you explicitly opt in (allow_raw / --allow-raw).

Note

This repository is generated from the upstream monorepo (the source of truth). Please file issues here; code changes are made upstream and mirrored.

License

MIT OR Apache-2.0, at your option.