SQLFluff Analyzer
About
Analyze, lint, and fix SQL queries using the SQLFluff linter.
Details
- Author
- antoprince001
- Categories
- Developer Tools, Other, Database
Jump to
Setup
Install SQLFluff Analyzer in your MCP client (Claude Desktop, Cursor, Windsurf, and others).
Repository: https://github.com/antoprince001/mcp-server-sqlfluff
Follow the installation instructions in the repository README, then restart your MCP client.
Analyze, lint, and fix SQL queries using the SQLFluff linter.
A Model Context Protocol (MCP) server that provides SQL analysis, linting, and fixing capabilities usingSQLFluff.
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.
- Lint SQL query and return syntax errors. Some syntax errors are not detected by the parser like trailing commas.
- Inputs:
- sql (string): SQL query to analyze.
- dialect (string, optional): SQL dialect (e.g., 'mysql', 'postgresql').
- List of linting results, each containing:
- start_line_no: Line number where the issue starts
- start_line_pos: Position in the line where the issue starts
- code: Error code
- description: Description of the issue
- name: Name of the linting rule
- warning: Whether it's a warning or an error
- fixes: List of possible fixes
- start_file_pos: Start position in the file
- end_line_no: Line number where the issue ends
- end_line_pos: Position in the line where the issue ends
- end_file_pos: End position in the file
- Fix SQL query and return the fixed version.
- Inputs:
- sql (string): SQL query to fix.
- dialect (string, optional): SQL dialect (e.g., 'mysql', 'postgresql').
- Parse SQL query and return the parsed tree.
- Inputs:
- sql (string): SQL query to parse.
- dialect (string, optional): SQL dialect (e.g., 'mysql', 'postgresql').
Returns a list of all supported SQL dialects for use in all tools.
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" ] } } }
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" ] } } }
# 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
Released under the MIT License. See the LICENSE file for details.
This is a web browser that enables your coding agent, such as Claude Code, to visit websites on your behalf and assist you in identifying bugs or creating UI test cases.
connect a read-only replica, analytics database, or staging database. Keep credentials on your machine while the tool discovers schema, generates safe SQL, previews it for approval, runs the query, and summarizes the result.
An example of a remote, authentication-free MCP server deployable on Cloudflare Workers.
Efficient, SQL-backed C++ project indexer designed for large codebases with low memory footprint.
MCPg - Production-grade PostgreSQL MCP Server
Safe-by-default PostgreSQL Model Context Protocol server for AI agents.
Interact with your product security findings using natural language.
MCP servers that give AI clients safe, structured access to SQL databases. One installable package per database engine. Every package exposes the same minimal two-tool surface, execute_sql and search_objects, with guardrails on by default: read-only mode, row caps, and statement timeouts.
Provides tools and resources for coding agents to interact with the Gel database, including automatic project configuration for query builders and ORMs.
MCP server that gives AI agents deep understanding of contemporary or legacy relational databases.
Browse, create, and manage schema projects on the Schematica schema library. 8 MCP tools for AI-powered schema design and data modeling.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
