MCP Server SQL Analyzer

1# mcp-server-sql-analyzer
2 
3A Model Context Protocol (MCP) server that provides SQL analysis, linting, and dialect conversion capabilities using [SQLGlot](https://sqlglot.com/sqlglot.html).
4 
5## Overview
6 
7The SQL Analyzer MCP server provides tools for analyzing and working with SQL queries. It helps with:
8 
9- SQL syntax validation and linting
10- Converting queries between different SQL dialects (e.g., MySQL to PostgreSQL)
11- Extracting and analyzing table references and dependencies
12- Identifying column usage and relationships
13- Discovering supported SQL dialects
14 
15### How Claude Uses This Server
16 
17As an AI assistant, this server enhances my ability to help users work with SQL efficiently by:
18 
191. **Query Validation**: I can instantly validate SQL syntax before suggesting it to users, ensuring I provide correct and dialect-appropriate queries.
20 
212. **Dialect Conversion**: When users need to migrate queries between different database systems, I can accurately convert the syntax while preserving the query's logic.
22 
233. **Code Analysis**: The table and column reference analysis helps me understand complex queries, making it easier to explain query structure and suggest optimizations.
24 
254. **Compatibility Checking**: By knowing the supported dialects and their specific features, I can guide users toward database-specific best practices.
26 
27This toolset allows me to provide more accurate and helpful SQL-related assistance while reducing the risk of syntax errors or dialect-specific issues.
28 
29### Tips
30 
31Update your personal preferences in Claude Desktop settings to request that generated SQL is first validated using the `lint_sql` tool.
32 
33## Tools
34 
351. lint_sql
36   - Validates SQL query syntax and returns any errors
37   - Input:
38     - sql (string): SQL query to analyze
39     - dialect (string, optional): SQL dialect (e.g., 'mysql', 'postgres')
40   - Returns: ParseResult containing:
41     - is_valid (boolean): Whether the SQL is valid
42     - message (string): Error message or "No syntax errors"
43     - position (object, optional): Line and column of error if present
44 
452. transpile_sql
46   - Converts SQL between different dialects
47   - Inputs:
48     - sql (string): SQL statement to transpile
49     - read_dialect (string): Source SQL dialect
50     - write_dialect (string): Target SQL dialect
51   - Returns: TranspileResult containing:
52     - is_valid (boolean): Whether transpilation succeeded
53     - message (string): Error message or success confirmation
54     - sql (string): Transpiled SQL if successful
55 
563. get_all_table_references
57   - Extracts table and CTE references from SQL
58   - Inputs:
59     - sql (string): SQL statement to analyze
60     - dialect (string, optional): SQL dialect
61   - Returns: TableReferencesResult containing:
62     - is_valid (boolean): Whether analysis succeeded
63     - message (string): Status message
64     - tables (array): List of table references with type, catalog, database, table name, alias, and fully qualified name
65 
664. get_all_column_references
67   - Extracts column references with table context
68   - Inputs:
69     - sql (string): SQL statement to analyze
70     - dialect (string, optional): SQL dialect
71   - Returns: ColumnReferencesResult containing:
72     - is_valid (boolean): Whether analysis succeeded
73     - message (string): Status message
74     - columns (array): List of column references with column name, table name, and fully qualified name
75 
76## Resources
77 
78### SQL Dialect Discovery
79 
80```
81dialects://all
82```
83 
84Returns a list of all supported SQL dialects for use in all tools.
85 
86## Configuration
87 
88### Using uvx (recommended)
89 
90Add this to your `claude_desktop_config.json`:
91 
92```json
93{
94  "mcpServers": {
95      "sql-analyzer": {
96          "command": "uvx",
97          "args": [
98              "--from",
99              "git+https://github.com/j4c0bs/mcp-server-sql-analyzer.git",
100              "mcp-server-sql-analyzer"
101          ]
102      }
103  }
104}
105```
106 
107### Using uv
108 
109After cloning this repo, add this to your `claude_desktop_config.json`:
110 
111```json
112{
113  "mcpServers": {
114      "sql-analyzer": {
115          "command": "uv",
116          "args": [
117              "--directory",
118              "/path/to/mcp-server-sql-analyzer",
119              "run",
120              "mcp-server-sql-analyzer"
121          ]
122      }
123  }
124}
125```
126 
127## Development
128 
129To run the server in development mode:
130 
131```bash
132# Clone the repository
133git clone git@github.com:j4c0bs/mcp-server-sql-analyzer.git
134 
135# Run the server
136npx @modelcontextprotocol/inspector uv --directory /path/to/mcp-server-sql-analyzer run mcp-server-sql-analyzer
137```
138 
139To run unit tests:
140 
141```bash
142uv run pytest .
143```
144 
145## License
146 
147MIT
148