Skip to main content

mysql

Manage MySQL databases via the mysql CLI.

来源信息

仓库
olasunkanmi-SE/codebuddy
最近来源活动
2026年3月8日 03:01
检测到的 SKILL.md 语言
英语
星标
141
分支
44

安装方式

默认使用会先检查来源的 Prompt;你也可以切换为直接命令,或下载本地副本。

检查来源文件

决定是否安装前,请先阅读 SKILL.md,以及 SkillsMP 当前展示的配套文件。

文件资源管理器
2 个文件

正在显示 SKILL.md

SKILL.md
来源说明 · 只读预览
name
mysql
description
Manage MySQL databases via the mysql CLI.
metadata
{"displayName":"MySQL","icon":"database","category":"databases","version":"1.0.0","dependencies":{"cli":"mysql","checkCommand":"mysql --version","bundledInstall":"skills/mysql/install.sh","install":{"darwin":"[Truncated]","linux":"[Truncated]","windows":"[Truncated]"}},"config":[{"name":"MYSQL_HOST","label":"Host","type":"string","required":false,"placeholder":"localhost"},{"name":"MYSQL_PORT","label":"Port","type":"string","required":false,"placeholder":"3306"}],"auth":{"type":"basic"}}
# mysql Use `mysql` to interact with MySQL databases. ## Setup The `mysql` client is installed in `.codebuddy/bin/`. You can execute it directly or add it to your PATH. ## Common Commands ### Connection - Connect: `.codebuddy/bin/mysql -h <host> -P <port> -u <user> -p` - Connect (Docker example): `.codebuddy/bin/mysql -h 127.0.0.1 -P 3306 -u root -p` ### Quick Alias To make it easier to run, you can alias it in your shell: `alias mysql="./.codebuddy/bin/mysql"` ### Operations - Show databases: `SHOW DATABASES;` - Use database: `USE <dbname>;` - Show tables: `SHOW TABLES;` - Describe table: `DESCRIBE <table_name>;` - Execute query: `SELECT * FROM table LIMIT 10;` - Quit: `exit` ## Notes - The binary is located at: `.codebuddy/bin/mysql` - Password can be supplied via `MYSQL_PWD` environment variable (careful!) or typically prompted interactively.
在 GitHub 查看