mcp-server-sql-analyzer
PythonSqlSqlAnalysisStaticAnalysisLintingDialectConversionJavascriptGoRubyR
Server Information
š Overview:
ā Key Points:
šÆ 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.
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.
- 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
- 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 .`.
š Main Findings:
š Details:
šÆ 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.
Server Features
lint_sql
Validates SQL query syntax and returns any errors
transpile_sql
Converts SQL between different dialects
get_all_table_references
Extracts table and CTE references from SQL
get_all_column_references
Extracts column references with table context
Provider Information
J4c0bs
cloud Provider
Quick Actions
MCP Configuration
Available Tools
lint_sqltranspile_sqlget_all_table_referencesget_all_column_references
Available Resources
SQL Dialect Discovery