lint_sqlLABSCO SUMMARY
A syntax check for SQL an assistant just wrote.
The failure mode this addresses is a plausible-looking query that is wrong for your engine. Because nothing connects to a database, the check is safe to run on statements you have not decided to trust yet — and the same parse tells you which tables the query would have touched.
What it is
Static SQL analysis built on SQLGlot. It parses a statement without connecting to any database, so validation, dialect conversion and reference extraction all happen before anything executes.
What you get
- Syntax validation with the line and column of the error when there is one
- Conversion of a statement from one SQL dialect to another
- Every table and CTE a query references
- Every column reference in the query
- Dialect-aware parsing, so 'valid' means valid for the engine you named
Requirements
uvx on your PATH. No database connection and no credentials — it reads the SQL text, not your data.
Setup effort
Add the configuration to your client
USE CASES
01
Checking a generated query before anyone runs it
Validate the statement against the dialect you actually use. An error comes back with its position, so the fix goes to the right line instead of a rewrite.
02
Moving a query to a different database
Convert the statement from the source dialect to the target one and keep the logic, instead of hand-porting functions and quoting rules during a migration.
03
Working out what a long query depends on
Pull every table and CTE the statement reads, so the blast radius of a schema change is a list rather than a careful read of the whole query.
04
Tracing which columns are in play
Extract the column references behind a query — the starting point when you are asked whether a field is safe to drop or rename.
4 tools
Listed in project docs. Your client may show a different list.
transpile_sqlget_all_table_referencesget_all_column_referencesBEFORE YOU INSTALL
What to know first
Tools you get
4 tools named in the project's documentation.
Where it runs
The documented client runs the server on your machine.
INSTALLATION
Connect your client
MCP Clients
Claude Desktop
CLAUDE DESKTOP · JSON
{
"mcpServers": {
"sql-analyzer": {
"command": "uvx",
"args": [
"--from",
"git+https://github.com/j4c0bs/mcp-server-sql-analyzer.git",
"mcp-server-sql-analyzer"
]
}
}
}
