mysql-best-practices
mysql best practices
What it does
- Design schemas with appropriate storage engines (InnoDB for most use cases)
- Optimize queries using EXPLAIN and proper indexing
- Use proper data types to minimize storage and improve performance
- Implement connection pooling and query caching appropriately
- Follow MySQL-specific security hardening practices
- Use InnoDB as the default engine (ACID compliant, row-level locking)
- Consider MyISAM only for read-heavy, non-transactional workloads
Requirements & configuration
- Use smallest data type that fits your needs
- ALTER USER 'appuser'@'%' REQUIRE SSL;
Derived from the skill's own SKILL.md documentation · extracted 2026-07-23
mysql-best-practices FAQ
What does the mysql-best-practices skill do?
MySQL development best practices for schema design, query optimization, and database administration Design schemas with appropriate storage engines (InnoDB for most use cases) Optimize queries using EXPLAIN and proper indexing
What does mysql-best-practices require?
Use smallest data type that fits your needs ALTER USER 'appuser'@'%' REQUIRE SSL;
How do I install mysql-best-practices?
Run: npx -y skills add https://github.com/mindrally/skills --skill mysql-best-practices --agent claude-code — the source lives at github.com/mindrally/skills.
Maintain mysql-best-practices?
Let people know it's listed here — add the badge (live metrics, light/dark aware) or a plain link to your README or docs.
[mysql-best-practices on getagentictools](https://getagentictools.com/skills/mindrally-skills-mysql-best-practices?ref=badge) npx agentictools info skills/mindrally-skills-mysql-best-practices The second line is the CLI lookup for this page — handy in READMEs and docs.
