SQL Analyzer

This MCP server provides SQL analysis, linting, and dialect conversion capabilities using SQLGlot, empowering you to validate queries, convert between dialects, and extract table/column references to understand complex SQL more clearly.

How to use

You interact with this server through an MCP client to analyze and transform SQL queries. Use it to validate syntax, lint queries, convert between dialects, and extract table or column usage to understand query structure. You can request the following capabilities: syntax validation, dialect conversion, table/CTE reference extraction, and column reference extraction. These tools help you catch errors early, migrate queries between databases, and understand dependencies within a query.

How to install

Prerequisites you need before installing this server are a runtime environment for the MCP client you plan to use and the ability to run the MCP command configurations. The following options show two common ways to run the server from your environment.

{
  "mcpServers": {
      "sql_analyzer": {
          "command": "uvx",
          "args": [
              "--from",
              "git+https://github.com/j4c0bs/mcp-server-sql-analyzer.git",
              "mcp-server-sql-analyzer"
          ]
      }
  }
}

Alternatively, you can run it with the uv CLI if you have the repository cloned locally.

{
  "mcpServers": {
      "sql_analyzer": {
          "command": "uv",
          "args": [
              "--directory",
              "/path/to/mcp-server-sql-analyzer",
              "run",
              "mcp-server-sql-analyzer"
          ]
      }
  }
}

Available tools

lint_sql

Validates SQL query syntax and returns any errors, helping you ensure queries are dialect-appropriate before use.

transpile_sql

Converts SQL between different dialects, preserving the query logic while adapting syntax to the target dialect.

get_all_table_references

Extracts table references and CTEs from a SQL statement, including aliases and fully qualified names.

get_all_column_references

Extracts column references with their table context, showing column usage within the query.