SQL Analyzer
๐ - MCP server that provides SQL analysis, linting, and dialect conversion using [SQLGlot](https://github.com/tobymao/sqlglot)
What is SQL Analyzer?
SQL Analyzer is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to ๐ - mcp server that provides sql analysis, linting, and dialect conversion using [sqlglot](https://github.com/tobymao/sqlglot)
๐ - MCP server that provides SQL analysis, linting, and dialect conversion using [SQLGlot](https://github.com/tobymao/sqlglot)
This server falls under the Developer Tools category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- ๐ - MCP server that provides SQL analysis, linting, and dial
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx sql-analyzerConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use SQL Analyzer
The SQL Analyzer MCP Server brings SQL linting, validation, and cross-dialect transpilation to your AI assistant by wrapping the SQLGlot parsing library as an MCP tool. It exposes four tools for validating SQL syntax, converting queries between database dialects (such as MySQL to BigQuery or Spark SQL to PostgreSQL), and extracting table and column references from complex queries. Data engineers and analysts can use it to catch SQL errors, migrate queries between systems, and understand query structure without running queries against live databases.
Prerequisites
- Python 3.10 or higher installed
- uv or uvx package manager installed (recommended for running the server)
- An MCP-compatible client such as Claude Desktop
Install uv (if not already installed)
Install the uv package manager which is the recommended way to run this Python MCP server.
curl -LsSf https://astral.sh/uv/install.sh | shTest the server with uvx
Run the server directly using uvx to confirm it starts without errors. This will install the package from the repository and launch it.
uvx --from git+https://github.com/j4c0bs/mcp-server-sql-analyzer.git mcp-server-sql-analyzerConfigure Claude Desktop with uvx
Add the server to your Claude Desktop configuration using uvx to run the server directly from the Git repository โ no manual install required.
{
"mcpServers": {
"sql-analyzer": {
"command": "uvx",
"args": [
"--from",
"git+https://github.com/j4c0bs/mcp-server-sql-analyzer.git",
"mcp-server-sql-analyzer"
]
}
}
}Restart Claude Desktop
Fully quit and relaunch Claude Desktop to pick up the new server configuration. The SQL analysis tools should be available immediately.
Verify available SQL dialects
Ask Claude to retrieve the list of supported SQL dialects from the server's resource endpoint to confirm the integration is working.
SQL Analyzer Examples
Client configuration
Claude Desktop configuration for the SQL Analyzer MCP server using uvx โ no pre-installation required.
{
"mcpServers": {
"sql-analyzer": {
"command": "uvx",
"args": [
"--from",
"git+https://github.com/j4c0bs/mcp-server-sql-analyzer.git",
"mcp-server-sql-analyzer"
]
}
}
}Prompts to try
Example prompts for SQL linting, dialect conversion, and reference extraction.
- "Lint this SQL query and tell me if there are any syntax errors: SELECT * FORM users WHERE id = 1"
- "Convert this MySQL query to BigQuery SQL: SELECT DATE_FORMAT(created_at, '%Y-%m') AS month, COUNT(*) FROM orders GROUP BY month"
- "Extract all table references from this complex JOIN query: SELECT a.id, b.name FROM orders a JOIN customers b ON a.customer_id = b.id LEFT JOIN products c ON a.product_id = c.id"
- "Transpile this Spark SQL to PostgreSQL syntax and explain any differences"
- "What SQL dialects does the analyzer support?"Troubleshooting SQL Analyzer
uvx command not found when starting the server
Install uv by running 'curl -LsSf https://astral.sh/uv/install.sh | sh' and then restart your terminal. Verify it is on your PATH with 'which uvx'. You may also need to add ~/.cargo/bin or ~/.local/bin to your PATH depending on your system.
SQL transpilation produces incorrect output for a specific dialect
SQLGlot supports a wide range of dialects but may have edge cases for advanced dialect-specific syntax. Check the list of supported dialects via the 'dialects://all' resource and verify your source and target dialects are both fully supported. Report edge cases to the mcp-server-sql-analyzer GitHub repository.
Server takes a long time to start on first launch
On the first run, uvx downloads and installs the package from GitHub which can take 30-60 seconds. Subsequent launches use the cached installation and start much faster. If startup consistently fails, try cloning the repo locally and using the 'uv' installation method in the config instead of 'uvx'.
Frequently Asked Questions about SQL Analyzer
What is SQL Analyzer?
SQL Analyzer is a Model Context Protocol (MCP) server that ๐ - mcp server that provides sql analysis, linting, and dialect conversion using [sqlglot](https://github.com/tobymao/sqlglot) It connects AI assistants to external tools and data sources through a standardized interface.
How do I install SQL Analyzer?
Follow the installation instructions on the SQL Analyzer GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with SQL Analyzer?
SQL Analyzer works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is SQL Analyzer free to use?
Yes, SQL Analyzer is open source and available under the MIT license. You can use it freely in both personal and commercial projects.
SQL Analyzer Alternatives โ Similar Developer Tools Servers
Looking for alternatives to SQL Analyzer? Here are other popular developer tools servers you can use with Claude, Cursor, and VS Code.
Ecc
โ 188.2kThe agent harness performance optimization system. Skills, instincts, memory, security, and research-first development for Claude Code, Codex, Opencode, Cursor and beyond.
Javaguide
โ 155.8kJava ้ข่ฏ & ๅ็ซฏ้็จ้ข่ฏๆๅ๏ผ่ฆ็่ฎก็ฎๆบๅบ็กใๆฐๆฎๅบใๅๅธๅผใ้ซๅนถๅใ็ณป็ป่ฎพ่ฎกไธ AI ๅบ็จๅผๅ
Gemini CLI
โ 104.5kA secure MCP server that wraps the Google Gemini CLI, allowing clients to query Gemini models using local OAuth sessions without requiring an API key. It provides tools for model interaction and diagnostics with built-in protection against command in
Awesome MCP Servers
โ 87.3kโญ Curated list of Model Context Protocol (MCP) servers - tools that extend Claude Desktop, Cursor, Windsurf, and other MCP clients with custom capabilities.
MCP Servers
โ 86.0kModel Context Protocol Servers
CC Switch
โ 77.5kA cross-platform desktop All-in-One assistant for Claude Code, Codex, OpenCode, OpenClaw, Gemini CLI & Hermes Agent. Only official website: ccswitch.io
Browse More Developer Tools MCP Servers
Explore all developer tools servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up SQL Analyzer in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use SQL Analyzer?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.