Mysql
Manage MySQL databases via the mysql CLI. Use when querying, inspecting schema, or managing MySQL databases.From its SKILL.md
npx -y skills add fworks-tech/agenthood --skill mysqlAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
2 things to look at
- reads credentialsReads from 1 credential source: `~/.my.cnf`.
- 2 stars2 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
SKILL.md
1.0 KB, 180 tokens by cl100k_base, as published. Nobody here has run it
mysql
Use mysql to interact with MySQL databases.
Common Commands
Connection
- Connect:
mysql -h <host> -u <user> -p<password> <database> - Execute query:
mysql -e "SELECT * FROM table LIMIT 10" <database>
Inspection
- List databases:
SHOW DATABASES; - List tables:
SHOW TABLES; - Describe table:
DESCRIBE <table_name>;
Operations
- Execute from file:
mysql <database> < migration.sql - Export:
mysqldump -u <user> -p <database> > backup.sql - Import:
mysql <database> < backup.sql
Notes
- Avoid passing password as command-line argument in shared environments
- Use
~/.my.cnffor stored credentials
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.
Gives 0 of the 12 instructions most databases sql skills give in 180 tokens
Counted across 609 of the 712 authors here whose files we hold, read 2026-09-06
- Index all foreign key columnsin 26 of 609
- Use cursor pagination instead of offsetin 25 of 609, across 20 files
- Use timestamptz for timestampsin 21 of 609
- Specify columns instead of using select starin 20 of 609, across 10 files
- Use parameterized queries for all database interactionsin 20 of 609, across 19 files
- Use Enum for categorical datain 17 of 609, across 7 files
- Order by frequently filtered columnsin 17 of 609, across 7 files
- Batch data insertsin 17 of 609, across 7 files
- Use expand-contract pattern for schema changesin 17 of 609
- Use materialized views for real-time aggregationsin 16 of 609, across 6 files
- Partition tables by timein 16 of 609, across 6 files
- Use smallest appropriate data typesin 16 of 609, across 6 files
Said here and by no other author read
- Use mysql CLI for database interaction
- Use ~/.my.cnf for stored credentials
Grouped from the skills themselves: near-identical wordings counted once, and counted by distinct author, so one author publishing three of these counts once. Length counted with cl100k_base; the agent that loads this file may tokenize it differently.