mysql · Oracle
MySQL CLI Agent 使用指南
隔离凭据和数据库写入，以非交互方式运行 MySQL 查询。
官方工具操作风险: R0–R3verified
为 Agent 安装
选择与运行环境匹配的官方安装方式。在团队或 CI 环境中固定版本，并先运行版本检查。
用于稳定自动化的结构化输出
优先使用机器可读格式，并把 stdout 作为结果、stderr 作为诊断信息分别处理。
R0–R3 命令风险指南
风险按单条命令判断。R0 是本地或远程只读，R1 是可逆的本地写入，R2 会改变远程状态，R3 可能造成不可逆或生产级影响。
只读不等于可公开
R0 只表示命令不更改本地或远程状态。只读命令仍可能返回令牌、身份信息、配置或生产数据；只展示完成任务所需的最少内容，不得写入日志、Prompt 或提交内容。
Agent Readiness 评分依据
适配度描述 Agent 操作工具的稳定程度，不代表所有命令都安全，也不替代独立执行测试。
文档证据对应的 Agent Readiness 为 83/100；已记录 8.0.45 的有限本地 Smoke Test，使用未测试命令前仍需查看证据边界。
生成 Skill 或 Agent 策略
选择目标 Agent 和安全模式，生成包含安装、允许命令、确认边界与证据说明的可复制产物。
生成结果预览
SKILL.md
---
name: mysql-cli-agent-workflow
description: Use MySQL CLI for MySQL queries, schema inspection, batch SQL with explicit command risk and evidence boundaries.
---
# MySQL CLI agent workflow
Use this skill when the task needs MySQL queries, schema inspection, batch SQL, tabular export.
## Evidence boundary
- Registry confidence: `verified`
- Documentation checked: `2026-07-10`
- Locally tested version: `8.0.45`
- Treat only the recorded executed checks as independently verified; every unlisted command remains documentation-only.
## Executed smoke checks
- `mysql --version` — passed; exit 0. The recorded smoke check completed successfully.
- `mysql --help` — passed; exit 0. The recorded smoke check completed successfully.
## Installation
- Homebrew client (macos, linux): `brew install mysql-client`
## Authentication
- Methods: option file, login path, password, TLS certificate
- Secret environment variables: `MYSQL_PWD`
- Minimum permissions: Use a read-only user, require TLS, and prefer a protected option file over command-line passwords.
- Credential storage: For headless runs, inject MYSQL_PWD from the CI or platform secret manager at process start. For local interactive use, prefer the CLI or operating-system credential store when the official client supports one. Never save values in repository files.
- Never print, persist, or commit credential values.
## Allowed commands (read-only)
- `mysql --batch --raw --execute "SELECT * FROM table_name LIMIT 20" DATABASE` — R0: Reads a bounded result set without an interactive prompt.
## Commands requiring explicit approval (read-only)
- None recorded.
## Forbidden commands (read-only)
- R2 `mysql --execute "UPDATE table_name SET ... WHERE ..." DATABASE` — Changes remote database records.
- R3 `mysql --execute "DROP DATABASE database_name"` — Permanently deletes a database.
## Execution rules
1. Mode boundary: R0 exact commands may be used; R1, R2, and R3 commands are forbidden.
2. Confirm the selected account, project, context, database, namespace, or environment before any command.
3. Prefer structured output using `--batch`, `--raw`, `--skip-column-names`.
4. Capture the exact command, exit code, stdout, and stderr separately.
5. A generated prefix policy must prompt unless that exact prefix is explicitly marked suffix-safe; do not infer safety from the executable name.
6. Never broaden credentials or disable safety controls to make a command succeed.
## Official sources
- [MySQL command-line client documentation](https://dev.mysql.com/doc/refman/8.0/en/mysql.html)
验证记录与官方证据
CLI Finder 分开记录文档检查和真实执行。未执行过的安装、帮助、退出码与输出不能标为 Verified。