mysql
Manage MySQL databases via the mysql CLI.
Informations de source
- Dépôt
- olasunkanmi-SE/codebuddy
- Dernière activité de la source
- 8 mars 2026 à 03:01
- Langue détectée de SKILL.md
- anglais
- Étoiles
- 141
- Forks
- 44
Options d'installation
Le prompt qui vérifie d'abord la source est sélectionné par défaut. Vous pouvez passer à une commande directe ou télécharger une copie locale.
Vérifiez les fichiers source
Lisez SKILL.md et les fichiers associés affichés par SkillsMP avant de décider de l'installer.
Explorateur de fichiers
2 fichiersAffichage de SKILL.md
SKILL.md
Instructions source · Aperçu en lecture seule- 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.
Voir sur GitHub