# MySQL Explorer

> Use this tool when you need to analyze and optimize MySQL databases with advanced data analytics and caching capabilities. It solves problems related to database performance, relationship mapping, and user behavior insights, providing in-depth analysis and high-performance caching. Ideal for use cases requiring expert-level database querying and optimization, with inputs including MySQL databases and outputs including detailed analytics and performance reports.

Canonical page: https://skillsregistry.net/skills/ttpears-mcp-mysql  
JSON: https://api.skillsregistry.net/v1/skills/ttpears-mcp-mysql

## Description

An intelligent MySQL MCP Server with expert data analytics capabilities and comprehensive caching. Goes beyond basic querying to provide in-depth database analysis, relationship mapping, and user behavior insights with high-performance caching system.

## 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:** container
- **Runtime environment:** vm
- **Category:** database
- **Updated:** 2026-09-19

## Source

- **Source listing:** [Smithery](https://smithery.ai/server/ttpears/mcp-mysql)
- **Repository:** <https://github.com/ttpears/mcp-mysql>

## 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": "ttpears-mcp-mysql"
    }
  }
}
```

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