j4c0bs/mcp-server-sql-analyzer

3.5

If you are the rightful owner of mcp-server-sql-analyzer and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

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

Tools

Functions exposed to the LLM to take actions

lint_sql

Lint SQL query and return syntax errors

Some syntax errors are not detected by the parser like trailing commas

Args: sql: SQL query to analyze dialect: Optional SQL dialect (e.g., 'mysql', 'postgres')

Returns: error message or "No syntax errors" if parsing succeeds

transpile_sql

Transpile SQL statement to another dialect

Args: sql: SQL statement to transpile read_dialect: SQL dialect to read from write_dialect: SQL dialect to write to

Returns: transpiled SQL or syntax error

get_all_table_references

Extract table and CTE names from SQL statement

Args: sql: SQL statement to analyze dialect: Optional SQL dialect (e.g., 'mysql', 'postgres') Returns: JSON object containing tables with catalog, database, and alias attributes CTEs are returned as "cte" type

get_all_column_references

Extract column references from SQL statement with table context

Args: sql: SQL statement to analyze dialect: Optional SQL dialect (e.g., 'mysql', 'postgres') Returns: JSON object containing column references with table context and any errors

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

list_sql_dialects

URI: dialects://all

MIME: text/plain

List all supported SQL dialects

Returns: list of supported SQL dialects

Author

j4c0bs

Claim Ownership

Verify you have write access to the repository

Repository

https://github.com/j4c0bs/mcp-server-sql-analyzer

GitHub Stars

License

MIT License

Last publish date

2025-01-23

Last update date

2025-08-28

Server configs

via uvx in claude desktop

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

in claude desktop

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

Top Comments

Related MCP Servers

View all databases servers →

mcp-notion-server

4.4

by suekou

MCP Server for the Notion API, enabling LLM to interact with Notion workspaces. Additionally, it employs Markdown conversion to reduce context size when communicating with LLMs, optimizing token usage and making interactions more efficient.

j4c0bs/mcp-server-sql-analyzer

Tools

lint_sql

transpile_sql

get_all_table_references

get_all_column_references

Prompts

No prompts

Resources

list_sql_dialects

Related MCP Servers

mcp-notion-server

mcp-alchemy

notion-mcp-server

mongodb-mcp-server

prisma

mcp-server-qdrant

genai-toolbox

supabase-mcp-server

mysql_mcp_server_pro

sqlite-explorer-fastmcp-mcp-server

mcp-server

mcp-server-neon

osv-mcp

azure-mcp

mcp-server-mysql

mcp-server-motherduck

openehr-mcp-server

mcp-server-milvus

mcp-redis

mariadb-mcp-server

prometheus-mcp-server

mcp-database-server

postg-mem

mssql_mcp_server

mongo-mcp

mcp-snowflake-server

mcp-server-starrocks