A set of command-line tools for connecting to MySQL databases, inspecting tables, and running SQL. MySQL is a database system, and SQL is the language used to read and change database data.

Testing connections, listing tables, viewing table columns and types, checking database information, and running SELECT, INSERT, UPDATE, or DELETE statements.

It provides direct scripts for common database work when a MySQL integration is unavailable or unnecessary.

mysql-tools — Skill for Claude Code and Codex by huangzt

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent

npx skills add huangzt/my-agent-skills --skill mysql-tools

Clone the repo

git clone --depth 1 https://github.com/huangzt/my-agent-skills

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/skills/huangzt/my-agent-skills/mysql-tools/github.svg)](https://agentmods.dev/skills/huangzt/my-agent-skills/mysql-tools)

Your own site

<a href="https://agentmods.dev/skills/huangzt/my-agent-skills/mysql-tools"><img src="https://agentmods.dev/badge/skills/huangzt/my-agent-skills/mysql-tools/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

Your own site · 80×15

<a href="https://agentmods.dev/skills/huangzt/my-agent-skills/mysql-tools"><img src="https://agentmods.dev/badge/skills/huangzt/my-agent-skills/mysql-tools.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 86 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.

When invoked 807 The whole file, excluding the scripts and references it only reads on demand.

Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.

Origin original No closer match found in the catalogue.

Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

Model	Per session	Once invoked
Fable 5.1	$0.00086	$0.00807
Opus 5.5	$0.00034	$0.00323
Sonnet 5.5	$0.00017	$0.00161
Haiku 4.5	$0.00009	$0.00081

Measured 2mo ago against content hash 171a21fe13be, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

mysql-tools scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2mo ago.

The scan reads SKILL.md. This mod also ships 5 executable files (scripts/mysql_connect.py, scripts/mysql_info.py, scripts/mysql_query.py, …), listed below but not scanned — reading those needs a real analyzer, not pattern matching.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills/mysql-tools/SKILL.md · 123 lines

What it actually says

MySQL 工具 Skill

用于操作 MySQL 数据库的工具集，提供连接测试、表管理和 SQL 执行功能。

快速开始

前置要求

pip install pymysql

平台兼容性

✅ Windows
✅ macOS
✅ Linux

连接参数

所有脚本支持以下参数：

参数	说明	默认值
`--host`	数据库主机地址	localhost
`--port`	数据库端口	3306
`--user`	数据库用户名	root
`--password`	数据库密码	必填
`--database`	数据库名称	必填

可用脚本

1. 测试数据库连接

验证数据库连接参数是否正确：

python scripts/mysql_connect.py --host 127.0.0.1 --port 3306 --user root --password YOUR_PASSWORD --database YOUR_DB

2. 列出所有表

获取数据库中的所有表名：

python scripts/mysql_tables.py --host 127.0.0.1 --user root --password YOUR_PASSWORD --database YOUR_DB

输出格式：表名列表，包含表类型（BASE TABLE / VIEW）

3. 查看表结构

显示指定表的字段信息：

python scripts/mysql_schema.py --host 127.0.0.1 --user root --password YOUR_PASSWORD --database YOUR_DB --table TABLE_NAME

输出格式：字段名、类型、是否可空、键类型、默认值、额外信息

4. 执行 SQL 查询

运行任意 SQL 语句：

python scripts/mysql_query.py --host 127.0.0.1 --user root --password YOUR_PASSWORD --database YOUR_DB --query "SELECT * FROM users LIMIT 10"

支持 SELECT、INSERT、UPDATE、DELETE 等所有 SQL 语句。

5. 查看数据库信息

获取数据库版本、大小等信息：

python scripts/mysql_info.py --host 127.0.0.1 --user root --password YOUR_PASSWORD --database YOUR_DB

输出格式

所有脚本输出 JSON 格式数据，便于解析：

{
  "success": true,
  "data": [...],
  "message": "操作成功"
}

错误时返回：

{
  "success": false,
  "error": "错误信息",
  "message": "操作失败"
}

常见用例

探索新数据库

测试连接：mysql_connect.py
列出所有表：mysql_tables.py
查看关键表结构：mysql_schema.py --table TABLE_NAME
查询示例数据：mysql_query.py --query "SELECT * FROM TABLE_NAME LIMIT 5"

数据分析

获取表记录数：mysql_query.py --query "SELECT COUNT(*) FROM TABLE_NAME"
分析数据分布：mysql_query.py --query "SELECT column, COUNT(*) FROM TABLE_NAME GROUP BY column"

参考更多 SQL 示例

查看 references/common_queries.md 获取常用 SQL 查询模板。

Files

What ships with it

6 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

2mo ago First seen · 123 lines · 86 tokens per session scan A 171a21fe13be

Subscribe to this mod's changes

mysql-tools is a skill published in the GitHub repository huangzt/my-agent-skills (20 stars, last pushed 10mo ago), licensed MIT. It adds 86 tokens to every session and 807 once invoked, about $0.0003 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Databases ai-agent ai-tools automation cross-platform dameng database-tools

mysql-tools next to 6 skills from other repositories
Mod	Type	Stars	Last push	Licence	Scan	Tokens	Works with
mysql-toolshuangzt/my-agent-skills	Skill	20	10mo ago	MIT	A	86	Claude Code, Codex
api-canvascyanheads/clipboard-mcp-server	Skill	3	9d ago	Apache-2.0	A	85	Claude Code
api-mirrorcyanheads/clipboard-mcp-server	Skill	3	9d ago	Apache-2.0	A	68	Claude Code
gonavi-cliSyngnat/GoNavi	Skill	2.1k	yesterday	Apache-2.0	A	144	Claude Code, Codex
omh-relational-dbrlaope/oh-my-hermes	Skill	5.2k	yesterday	MIT	A	100	Claude Code, Codex
redteam-sqli-detail-packNetw0rkNoob/VulnClaw	Skill	3.9k	8d ago	MIT	A	59	Claude Code, Codex
api-canvascyanheads/obsidian-mcp-server	Skill	702	6d ago	Apache-2.0	A	85	Claude Code