# mcp-sql-optimizer

> Use this tool when you need to optimize SQL queries across multiple database dialects, such as PostgreSQL, MySQL, Oracle, and SQL Server, to improve performance by analyzing and suggesting indexes. It takes SQL queries as input and provides optimized queries and index recommendations as output. Ideal for use cases where query performance is critical, such as large-scale data analysis and database optimization projects.

Canonical page: https://skillsregistry.net/skills/uddin-rajaul-mcp-sql-optimizer  
JSON: https://api.skillsregistry.net/v1/skills/uddin-rajaul-mcp-sql-optimizer

## Description

A powerful Model Context Protocol (MCP) server that analyzes, optimizes, and suggests indexes for SQL queries across multiple dialects (PostgreSQL, MySQL, Oracle, SQL Server). Built with Python and `sqlglot`.

## Trust

- **Trust score (0–1):** 0.50
- **Verification tier:** unverified

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** container
- **Runtime environment:** vm
- **Category:** database
- **Updated:** 2026-05-14

## Source

- **Source listing:** [Smithery](https://smithery.ai/server/uddin-rajaul/mcp-sql-optimizer)

## 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": "uddin-rajaul-mcp-sql-optimizer"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/uddin-rajaul-mcp-sql-optimizer` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/uddin-rajaul-mcp-sql-optimizer/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