Mysql
A comprehensive skill catalog for AI agents
npx -y skills add G1Joshi/Agent-Skills --skill mysqlAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 10 stars10 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.
What its author says it does
Copied from the file, not written here
MySQL relational database with InnoDB, replication, and stored procedures. Use for MySQL operations.
SKILL.md
1.8 KB, 432 tokens by cl100k_base, as published. Nobody here has run it
MySQL
MySQL is a widely used relational database management system (RDBMS). It is the "M" in the LAMP stack and powers huge platforms like Facebook and WordPress.
When to Use
- Web Applications: Standard for PHP/Laravel/Wordpress ecosystems.
- Read-Heavy Workloads: Historically very fast for simple read operations.
- Replication: Huge ecosystem of tools for Master-Slave replication and clustering (Galera, InnoDB Cluster).
Quick Start
-- Upsert (Insert or Update)
INSERT INTO users (id, name) VALUES (1, 'Jane')
ON DUPLICATE KEY UPDATE name = 'Jane';
Core Concepts
Storage Engines
- InnoDB: The default. Supports transactions (ACID), row-level locking, and foreign keys. Always use this.
- MyISAM: Legacy. Fast reads but table-level locking and no transactions. Avoid.
Explain
Prefix any query with EXPLAIN to see how MySQL executes it (indexes used, rows scanned).
EXPLAIN SELECT * FROM users WHERE email = '[email protected]';
Replication
MySQL replication is often asynchronous by default, meaning slaves might lag behind master.
Best Practices (2025)
Do:
- Use MySQL 8.4+: For LTS features like
EXPLAIN ANALYZEand CTE support. - Use
utf8mb4: The real UTF-8. The standardutf8in MySQL is a partial implementation (max 3 bytes). - Disable
mysql_native_password: In 8.4+, usecaching_sha2_passwordfor security.
Don't:
- Don't use MyISAM: It is effectively obsolete for modern apps.
- Don't store logic in Stored Procedures: Hard to version control and debug. Keep logic in the app layer.