mysql
Manage MySQL databases via the mysql CLI. Use when querying, inspecting schema, or managing MySQL databases.
来源信息
- 仓库
- fworks-tech/agenthood
- 最近来源活动
- 2026年9月16日 21:10
- 检测到的 SKILL.md 语言
- 英语
- 星标
- 3
- 分支
- 0
安装方式
默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。
检查来源文件
决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。
正在显示 SKILL.md
SKILL.md
来源说明 · 只读预览- name
- mysql
- description
- Manage MySQL databases via the mysql CLI. Use when querying, inspecting schema, or managing MySQL databases.
- license
- MIT
- metadata
- {"category":"databases","dependencies":{"cli":"mysql","checkCommand":"mysql --version","install":{"darwin":"[Truncated]","linux":"[Truncated]","windows":"[Truncated]"}}}
# mysql
Use `mysql` to interact with MySQL databases.
## Common Commands
### Connection
- Connect: `mysql -h <host> -u <user> -p<password> <database>`
- Execute query: `mysql -e "SELECT * FROM table LIMIT 10" <database>`
### Inspection
- List databases: `SHOW DATABASES;`
- List tables: `SHOW TABLES;`
- Describe table: `DESCRIBE <table_name>;`
### Operations
- Execute from file: `mysql <database> < migration.sql`
- Export: `mysqldump -u <user> -p <database> > backup.sql`
- Import: `mysql <database> < backup.sql`
## Notes
- Avoid passing password as command-line argument in shared environments
- Use `~/.my.cnf` for stored credentials
在 GitHub 查看