# MySQL Read-Only

> Use this tool when you need to analyze database structures or extract information from MySQL databases without modifying the data. It provides read-only access to MySQL databases, enabling AI models to inspect schemas and execute SQL queries, and is ideal for data analysis workflows requiring secure and non-intrusive data exploration. The tool accepts configurable connection parameters as input and returns comprehensive schema information and query results as output.

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

## Description

MCP Server for MySQL provides read-only access to MySQL databases, enabling AI models to inspect database schemas and execute SQL queries. Built by Ben Borla, it connects to MySQL servers using configurable connection parameters, enforces read-only transactions for security, and supports comprehensive schema information retrieval. The implementation is written in TypeScript using Node.js and the mysql2 library, with Docker support for easy deployment. It's particularly valuable for data analysis workflows where AI assistants need to explore database structures and extract information without modifying the underlying data.

## Trust

- **Trust score (0–1):** 0.93
- **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/benborla-mysql-readonly)
- **Repository:** <https://github.com/zhaoxin34/mcp-server-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": "benborla-mysql-readonly"
    }
  }
}
```

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