SQL Analyzer MCP Server
Perform SQL linting, dialect transpilation, and query structure analysis.
Data last scanned today · Reviewed today
Overview
SQL Analyzer MCP Server leverages SQLGlot to provide robust SQL query processing. It enables AI assistants to perform syntax validation, convert queries between different database dialects, and extract detailed table or column dependencies from existing SQL statements. By integrating these tools, users can ensure their database code is syntactically correct and compatible with their target environments. To utilize this server, AI clients can call the linting and transpilation tools directly during the code generation process. Providing table and column references further assists the model in understanding the context of complex analytical queries, facilitating better optimization suggestions and schema understanding.
Our verdict
This server carries a high risk level with a security score of 23/100. The project is community-maintained rather than vendor-backed, has not undergone editorial review, and has not received any commits in over 434 days. Given these factors, it is best suited for local experimentation in non-critical environments rather than production workflows.
- Uses SQLGlot for reliable query dialect transpilation
- Zero direct dependencies minimizes supply-chain surface area
- Includes clear documentation for all provided tools
- High security risk score of 23/100
- Last repository update occurred over 434 days ago
- Lacks active editorial oversight or vendor support
Tools
| Tool | Description | Risk |
|---|---|---|
| lint_sql | Validates SQL query syntax and returns any errors | low |
| transpile_sql | Converts SQL between different dialects | low |
| get_all_table_references | Extracts table and CTE references from SQL | low |
| get_all_column_references | Extracts column references with table context | low |
Compatibility
| Client | Local | Docker | Remote | Read-only |
|---|---|---|---|---|
| Claude Desktop | ||||
| Cursor | ||||
| VS Code | ||||
| Windsurf | ||||
| ChatGPT |
Frequently asked questions
›What is the recommended method to install this server?
The recommended installation method is using uvx by adding the server configuration to your claude_desktop_config.json file.
›How can I see which SQL dialects are supported by the server?
You can access the list of supported dialects by utilizing the resource at dialects://all.
›Can I automatically validate SQL generated by an AI assistant?
Yes, you can configure your Claude Desktop settings to request that all generated SQL be validated using the lint_sql tool.
›What does the transpile_sql tool do?
This tool converts SQL statements from one dialect to another, such as migrating a query from MySQL to PostgreSQL.
›What information does the get_all_table_references tool provide?
It extracts table and CTE references from a SQL query, returning details like the table name, catalog, database, alias, and fully qualified name.
Alternatives
Badge
Maintain this server? Add the live badge to your README.