# mcp-server-sql-analyzer

> Use this tool when you need to analyze and optimize SQL queries, as it provides SQL linting, dialect conversion, and table/column reference extraction, solving problems related to query validation and transpilation, and accepting SQL code as input to output analyzed and optimized queries. It is ideal for use cases involving SQL code review, migration, and optimization. The tool's output enables informed decision-making and streamlined database management.

Canonical page: https://skillsregistry.net/skills/j4c0bs-mcp-server-sql-analyzer  
JSON: https://api.skillsregistry.net/v1/skills/j4c0bs-mcp-server-sql-analyzer

## Description

Provides SQL analysis, linting, and dialect conversion using SQLGlot, enabling validation, transpilation, and extraction of table/column references.

## Trust

- **Trust score (0–1):** 1.00
- **Verification tier:** verified
- **Last scanned:** 2026-09-19

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-19

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/vmvigiouot)
- **Repository:** <https://github.com/j4c0bs/mcp-server-sql-analyzer>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "j4c0bs-mcp-server-sql-analyzer"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/j4c0bs-mcp-server-sql-analyzer` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/j4c0bs-mcp-server-sql-analyzer/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt