# mcp-db-analyzer

> Use this tool when you need to analyze and optimize database performance, inspect schemas, and troubleshoot query issues across PostgreSQL, MySQL, and SQLite. It solves problems related to index optimization, table bloat, and query plan analysis, providing deep visibility into database operations. The mcp-db-analyzer takes database connections as input and outputs detailed analysis and recommendations for improvement.

Canonical page: https://skillsregistry.net/skills/dmitriusan-mcp-db-analyzer  
JSON: https://api.skillsregistry.net/v1/skills/dmitriusan-mcp-db-analyzer

## Description

A Model Context Protocol (MCP) server that gives AI assistants deep visibility into databases, inspecting schemas, detecting index problems, analyzing table bloat, and explaining query plans across PostgreSQL, MySQL, and SQLite.

## Trust

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

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/i91c8xdljt)
- **Repository:** <https://github.com/Dmitriusan/mcp-db-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": "dmitriusan-mcp-db-analyzer"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/dmitriusan-mcp-db-analyzer` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/dmitriusan-mcp-db-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