mysql

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":{"brew":"mysql-client"},"linux":{"apt":"mysql-client","dnf":"mysql"},"windows":{"winget":"Oracle.MySQL","choco":"mysql","scoop":"mysql"}}},"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.