← 返回 Skills 市场
ryanlee-gemini

MySQL Skill - 对话式数据库管理

作者 ryanlee-gemini · GitHub ↗ · v1.0.0 · MIT-0
cross-platform ⚠ suspicious
405
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install mysql-skill
功能描述
MySQL 数据库管理技能。通过自然语言查询、管理 MySQL 数据库,支持 SELECT/INSERT/UPDATE/DELETE、表管理、备份恢复等操作。当用户提到 MySQL、数据库查询、建表、数据备份时使用此技能。
安全使用建议
This skill is generally coherent with its stated purpose (generating and running MySQL commands), but check a few things before installing: 1) Resolve the packaging/metadata mismatch — the registry summary claims no required binaries while package.json lists mysql/mysqldump and provides install commands; confirm you are comfortable with the client installation. 2) Never put sensitive production credentials into tools without review — prefer a least-privilege DB user, avoid using a root/admin account, and protect ~/.my.cnf (file permissions) if you create it. 3) Understand that the agent can generate and run SQL: require explicit confirmation for destructive write operations or use read-only credentials for routine queries. 4) Verify the source (package.json lists a GitHub repo and homepage); if the origin is unknown/untrusted, inspect the repository or avoid installing. If you need higher assurance, ask the maintainer for clarification or request a signed/official release before use.
功能分析
Type: OpenClaw Skill Name: mysql-skill Version: 1.0.0 The skill provides the AI agent with broad capabilities to execute shell commands and manage databases using 'mysql' and 'mysqldump' (SKILL.md, package.json). While these functions are aligned with the stated purpose of database management, the inherent risk of allowing an AI to execute arbitrary SQL and shell commands makes it high-risk. The instructions also suggest storing credentials in '~/.my.cnf', which could be targeted for exfiltration if the agent is compromised via prompt injection.
能力评估
Purpose & Capability
The skill's name, description, and SKILL.md all describe MySQL management and the instructions and examples are coherent with that purpose. However, the registry metadata at the top states 'Required binaries: none' while the included package.json declares runtime requirements for the mysql and mysqldump clients and provides install commands — this mismatch is a packaging/metadata inconsistency that should be resolved.
Instruction Scope
SKILL.md stays within the stated purpose: it describes installing a MySQL client, configuring connection via ~/.my.cnf or environment variables, generating SQL, running mysql/mysqldump for backup/restore, and gives troubleshooting and safety advice. It does not instruct reading unrelated files or sending data to external endpoints.
Install Mechanism
There is no aggressive install (no remote arbitrary downloads). package.json includes an 'openclaw.install' section that recommends installing the MySQL client via apt/brew — a low-risk, standard system package install. But the registry summary said 'No install spec' while package.json includes install instructions; this inconsistency should be resolved.
Credentials
SKILL.md suggests using MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE or a ~/.my.cnf file — these are exactly the credentials needed for MySQL access and are proportionate to the skill's function. Note: storing plaintext passwords in ~/.my.cnf or environment vars is convenient but has security implications; the SKILL.md itself notes using env vars and least-privilege accounts, which is appropriate.
Persistence & Privilege
Skill is not always-enabled and does not request elevated persistent privileges. It suggests creating a per-user ~/.my.cnf (a normal, limited-scope config file). It does not attempt to modify other skills or system-wide settings beyond typical client installation guidance.
如何使用
  1. 确保已安装 OpenClaw(本地或 Docker 部署)
  2. 在对话框中输入安装命令:/install mysql-skill
  3. 安装完成后,直接呼叫该 Skill 的名称或使用 /mysql-skill 触发
  4. 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
v1.0.0
🎉 首发版本! 主要功能: • 🔍 智能查询 - 自然语言描述,自动生成 SQL • 📊 数据分析 - 快速统计、聚合、分组查询 • 🛠️ 表管理 - 建表、修改表结构、索引管理 • 💾 备份恢复 - 数据库/表级备份和恢复 • 🔧 优化建议 - 慢查询分析、索引优化建议 适合人群:开发者、数据分析师
元数据
Slug mysql-skill
版本 1.0.0
许可证 MIT-0
累计安装 0
当前安装数 0
历史版本数 1
常见问题

MySQL Skill - 对话式数据库管理 是什么?

MySQL 数据库管理技能。通过自然语言查询、管理 MySQL 数据库,支持 SELECT/INSERT/UPDATE/DELETE、表管理、备份恢复等操作。当用户提到 MySQL、数据库查询、建表、数据备份时使用此技能。 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 405 次。

如何安装 MySQL Skill - 对话式数据库管理?

在 OpenClaw 或 Claude Code 对话框中运行命令「/install mysql-skill」即可一键安装,无需额外配置。

MySQL Skill - 对话式数据库管理 是免费的吗?

是的,MySQL Skill - 对话式数据库管理 完全免费,采用 MIT-0 许可证,可自由下载、安装和使用。

MySQL Skill - 对话式数据库管理 支持哪些平台?

MySQL Skill - 对话式数据库管理 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。

谁开发了 MySQL Skill - 对话式数据库管理?

由 ryanlee-gemini(@ryanlee-gemini)开发并维护,当前版本 v1.0.0。

💬 留言讨论