# mysql-readonly-mcp

> Use this tool when you need to securely expose your MySQL database for read-only operations, ensuring safety by restricting queries to SELECT, SHOW, DESCRIBE, and EXPLAIN statements. It solves problems related to data protection and access control by providing a configurable and table-blacklist-supported interface. Ideal for use cases where you want to limit database interactions to safe read-only queries, with inputs including database connections and SQL queries, and outputs including query results and error messages.

Canonical page: https://skillsregistry.net/skills/ibeancn-mysql-mcp-only-read  
JSON: https://api.skillsregistry.net/v1/skills/ibeancn-mysql-mcp-only-read

## Description

A readonly MCP server for MySQL databases that ensures safety by whitelisting only SELECT, SHOW, DESCRIBE, and EXPLAIN statements, with table blacklist support and configurable limits.

## Trust

- **Trust score (0–1):** 0.68
- **Verification tier:** scanned
- **Last scanned:** 2026-08-31

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/vjlqzqdni8)
- **Repository:** <https://github.com/IBeanCN/mysql-mcp-only-read>

## 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": "ibeancn-mysql-mcp-only-read"
    }
  }
}
```

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