ReddRadar
Agent skill
mysql
Manage MySQL databases via the mysql CLI.
Install this agent skill to your Project
npx add-skill https://github.com/olasunkanmi-SE/codebuddy/tree/main/skills/mysql
Metadata
Additional technical details for this skill
- auth
-
{ "type": "basic" } - icon
- database
- config
-
[ { "name": "MYSQL_HOST", "type": "string", "label": "Host", "required": false, "placeholder": "localhost" }, { "name": "MYSQL_PORT", "type": "string", "label": "Port", "required": false, "placeholder": "3306" } ] - version
- 1.0.0
- category
- databases
- displayName
- MySQL
- dependencies
-
{ "cli": "mysql", "install": { "linux": { "apt": "mysql-client", "dnf": "mysql" }, "darwin": { "brew": "mysql-client" }, "windows": { "choco": "mysql", "scoop": "mysql", "winget": "Oracle.MySQL" } }, "checkCommand": "mysql --version", "bundledInstall": "skills/mysql/install.sh" }
SKILL.md
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_PWDenvironment variable (careful!) or typically prompted interactively.
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
olasunkanmi-SE/codebuddy
Send emails using mailsend-go CLI
olasunkanmi-SE/codebuddy
aws
Manage AWS resources via the aws CLI.
olasunkanmi-SE/codebuddy
telegram
Send Telegram messages, files, and interact with Telegram bots via the telegram-send CLI tool.
olasunkanmi-SE/codebuddy
redis
Manage Redis databases via the redis-cli tool.
olasunkanmi-SE/codebuddy
datadog
Query metrics, manage monitors, post events, and interact with Datadog via the dogshell CLI.
olasunkanmi-SE/codebuddy
linear
Manage Linear issues via the linear-cli (unofficial or custom wrapper).
Didn't find tool you were looking for?