mcp-server-sql-analyzer

mcp-server-sql-analyzer

PythonSqlSqlAnalysisStaticAnalysisLintingDialectConversionJavascriptGoRubyR

About This Server

MCP server for SQL static analysis.

Server Information

šŸ“‹ 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.

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 logo

J4c0bs

cloud Provider

Visit Provider Website

Quick Actions

Visit Website

MCP Configuration

Available Tools

lint_sqltranspile_sqlget_all_table_referencesget_all_column_references

Available Resources

SQL Dialect Discovery