# MySQL

> Use this tool when you need to interact with a MySQL database using a standardized JSON-RPC 2.0 interface, solving problems such as CRUD execution, transaction management, and DDL operations. It takes in JSON-RPC requests and returns JSON responses, providing a robust interface for database operations. Ideal for use cases like AI-assisted database administration, data analysis workflows, and building database-backed applications with natural language interfaces.

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

## Description

A MySQL database integration server built by huangfeng19820712 that provides standardized JSON-RPC 2.0 interface for database operations including CRUD execution, transaction management, and DDL operations. The implementation features separate tools for SELECT queries versus INSERT/UPDATE/DELETE operations, table introspection capabilities, SHOW statement execution, and EXPLAIN query analysis, with proper error handling and logging through the Pino library. Built with TypeScript and the mysql2 driver, it includes comprehensive test coverage and Docker support, making it useful for AI-assisted database administration, data analysis workflows, and building database-backed applications with natural language interfaces.

## Trust

- **Trust score (0–1):** 0.90
- **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:** [PulseMCP](https://www.pulsemcp.com/servers/huangfeng19820712-mysql)
- **Repository:** <https://github.com/huangfeng19820712/mcp-mysql-server>

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

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