Sql Analyzer MCP Server

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

Local serverstdio

What is the Sql Analyzer MCP server?

Sql analyzer mcp server connects Sql Analyzer to AI assistants that speak the Model Context Protocol. A Model Context Protocol (MCP) server that provides SQL analysis, linting, and dialect conversion capabilities using SQLGlot.

What Sql Analyzer does

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

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

Tools it exposes

Once connected, the assistant can call these 4 tools directly:

  • Input — - sql (string): SQL query to analyze
  • Returns — ParseResult containing:
  • Inputs — - sql (string): SQL statement to transpile
  • Tips — Update your personal preferences in Claude Desktop settings to request that generated SQL is first validated using the lint_sql tool

Installing the sql analyzer mcp server

The server is distributed via npm as @modelcontextprotocol/inspector, so most clients can run it without a manual build step. Add it to your MCP client's configuration and restart the client to pick it up — the copy-paste configs for Claude Desktop, Claude Code and Cursor are on this page.

Where it fits

Database servers turn schema archaeology and ad-hoc reporting into conversation, which is why they tend to be the second or third server people install. Sql Analyzer sits in that group, and the shape of its toolset — Input, Returns, Inputs among others — tells you what it is really for. Worth comparing against the other databases servers in this directory before you commit to one, since several overlap in scope but differ sharply in setup cost and permissions.

Practical notes

  • This server runs locally, so it operates with whatever access your machine and its credentials already have. Scope that deliberately rather than by default.
  • Maintained by j4c0bs.
  • MCP clients ask for confirmation before each tool call by default. Keep that on while you learn what the sql analyzer mcp server actually does with your data.
  • Every entry in this directory is reviewed by hand before it goes live, and details are checked against the project's own documentation.

Available tools

ToolWhat it does
Input- sql (string): SQL query to analyze
ReturnsParseResult containing:
Inputs- sql (string): SQL statement to transpile
TipsUpdate your personal preferences in Claude Desktop settings to request that generated SQL is first validated using the lint_sql tool.

How to install the Sql Analyzer MCP server

{
  "mcpServers": {
    "server-sql-analyzer": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/inspector"]
    }
  }
}

Add to claude_desktop_config.json, then restart Claude Desktop.

Example prompts to try

  • Use Sql Analyzer to Input.
  • Use Sql Analyzer to Returns.
  • Use Sql Analyzer to Inputs.

Frequently asked questions

It connects Sql Analyzer to MCP-compatible AI assistants such as Claude and Cursor, exposing 4 tools (Input, Returns, Inputs, and more) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with Sql Analyzer directly.