mcp-server-sql-analyzer

A Model Context Protocol (MCP) server that provides SQL analysis, linting, and fixing capabilities using SQLFluff.

Overview

The sqlfluff MCP server provides tools for analyzing and working with SQL queries. It helps with:

• Lint SQL query and return syntax errors
• Fix SQL query and return the fixed version.
• Parse SQL query and return the parsed tree.

Tools

1. lint_sql

2. fix_sql

3. parse_sql

Resources

SQL Dialect Discovery

dialects://all

Returns a list of all supported SQL dialects for use in all tools.

Configuration

Using uvx

Add this to your your MCP client config file:

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

Using uv

After cloning this repo, add this to your MCP client config file:

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

Development

To run the server in development mode:

# Clone the repository
git clone git@github.com:antoprince001/mcp-server-sqlfluff.git

# Run the server
npx @modelcontextprotocol/inspector uv --directory /path/to/mcp-server-sqlfluff run mcp-server-sqlfluff

To run unit tests:

uv run pytest .

License

Released under the MIT License. See the LICENSE file for details.