mcp-server-sql-analyzerMCP server for SQL static analysis.

— (0)

Reviewed by Daniel Nikulshyn·Updated July 2026

Overview

The SQL Analyzer MCP server provides tools for analyzing and working with SQL queries. It helps with SQL syntax validation and linting, converting queries between different SQL dialects, extracting and analyzing table references and dependencies, identifying column usage and relationships, and discovering supported SQL dialects. This server enhances the ability to help users work with SQL efficiently by providing query validation, dialect conversion, code analysis, and compatibility checking. It allows for more accurate and helpful SQL-related assistance while reducing the risk of syntax errors or dialect-specific issues.

Key features

SQL syntax validation and linting
SQL dialect conversion
Table and column reference analysis
Supported SQL dialect discovery
Integration with AI assistants like Claude

Pricing

Model: Free
Category: MCP Servers
Rating: No reviews yet

Use cases

SQL Query Validation

Validating SQL syntax before suggesting it to users, ensuring correct and dialect-appropriate queries.

Dialect Conversion

Converting SQL queries between different database systems while preserving query logic.

Pros & Cons

Pros

Provides SQL syntax validation and linting
Supports conversion between different SQL dialects
Analyzes table and column references
Discovers supported SQL dialects
Enhances AI assistant capabilities for SQL-related tasks

Cons

Limited information on scalability and performance
Dependent on SQLGlot library
May require configuration for specific use cases

Reviews

No reviews yet. Be the first!

Q&A

What are the main limitations when integrating mcp-server-sql-analyzer with other systems?

Limitations include unclear scalability and performance details, dependence on the SQLGlot library, and the need for configuration for specific use cases such as custom dialects or large query sets.

Asked by Nadia Petrova · Nov 22, 2025

Can the tool convert queries between different database dialects? Which dialects are supported?

Yes, the transpile_sql function can convert SQL from a source dialect to a target dialect (e.g., MySQL to PostgreSQL). The tool discovers supported dialects internally, but the exact list depends on SQLGlot’s capabilities at runtime.

Asked by Daniel Schmidt · Nov 18, 2025

How does mcp-server-sql-analyzer validate SQL syntax and what format does it return errors?

The server uses the SQLGlot library to lint queries via the lint_sql tool. It returns a ParseResult JSON with is_valid, a message string, and an optional position object indicating line and column of any syntax errors.

Asked by Bruno Kaufmann · Sep 30, 2025