Overview

Title: mcp-server-sql-analyzer

A Model Context Protocol (MCP) server that provides SQL analysis, linting, and dialect conversion using SQLGlot.

Key Features

• SQL syntax validation and linting
• Conversion between SQL dialects (e.g., MySQL to PostgreSQL)
• Table and column reference extraction
• Dependency and relationship analysis
• Support for multiple SQL dialects

How to Use

• Validate SQL queries with lint_sql
• Convert SQL between dialects with transpile_sql
• Analyze table and column references with get_all_table_references and get_all_column_references
• Configure via claude_desktop_config.json

Use Cases

• SQL query validation and error detection
• Database migration and dialect conversion
• Query optimization and dependency analysis
• AI-assisted SQL generation and troubleshooting