mcp-server-sql-analyzer

📋 Overview:

This webpage is the GitHub repository page for "mcp-server-sql-analyzer", a Model Context Protocol (MCP) server designed for SQL static analysis. The server offers functionalities including SQL syntax validation, dialect conversion, and extraction of table/column references. It's intended to be used as a tool by AI assistants like Claude to improve SQL-related assistance by ensuring query accuracy and compatibility.

⭐ Key Points:

• The repository hosts an MCP server for SQL analysis.


• The server leverages SQLGlot for its functionalities.


• It primarily supports syntax validation, dialect conversion, and reference extraction.


• It offers the ability to list supported SQL dialects.


• The server is configured using JSON and can be deployed using uv or uvx.


• The project has an MIT License.


🔍 Main Findings:

• The MCP server aids in SQL query validation, conversion between dialects, and code analysis.


• Claude, an AI assistant, can use this server to improve SQL-related assistance and ensure accurate, dialect-appropriate suggestions.


• The repository contains instructions on how to run the server in development mode and execute unit tests.


• The main resource is README.md


• It has 1 star and 0 forks


📊 Details:

• Tools:


• lint_sql: Validates SQL syntax and returns error messages.


• transpile_sql: Converts SQL between different dialects.


• getalltable_references: Extracts table references.


• getallcolumn_references: Extracts column references.


• Configuration: The server requires configuration via a JSON file (`claudedesktopconfig.json`) specifying the command and arguments for execution, and includes examples for both `uvx` (recommended) and `uv` deployment.


• Development: Instructions are provided for cloning the repository and running the server in development mode using `npx @modelcontextprotocol/inspector uv`. Unit tests can be executed using `uv run pytest .`.

🎯 Conclusion:
The "mcp-server-sql-analyzer" repository provides a valuable tool for SQL analysis, particularly for AI assistants requiring accurate and context-aware SQL handling. It is configured to work with Claude, and detailed instructions are available for setup, usage, and development.