mysql
Manage MySQL databases via the mysql CLI.
Source facts
- Repository
- olasunkanmi-SE/codebuddy
- Last source activity
- March 8, 2026 at 03:01
- Detected SKILL.md language
- English
- Stars
- 141
- Forks
- 44
Install options
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Review the source files
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
File Explorer
2 filesShowing SKILL.md
SKILL.md
Source instructions · Read-only preview- 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.
View on GitHub