mysql-best-practices
Guidelines for MySQL schema design, indexing strategies, query optimization, and database security best practices.
Install
npx skills add https://github.com/mindrally/skills --skill mysql-best-practicesStats
| Total installs | 948 |
| Weekly installs | 946 |
| GitHub stars | 45 |
| First seen | Jan 25, 2026 |
| Source | @mindrally/skills |
Summary
- Covers schema design with InnoDB as default engine, appropriate data types (DECIMAL for financial data, utf8mb4 charset), and primary key strategies including AUTO_INCREMENT and UUID storage
- Indexing strategies including B-tree, FULLTEXT, and covering indexes with guidelines on column selectivity and composite index ordering
- Query optimization using EXPLAIN analysis, prepared statements, keyset pagination, and avoiding common pitfalls like functions on indexed columns and implicit type conversions
- Transaction management, JSON support with generated columns, replication monitoring, and security practices including user privilege management and SSL/TLS requirements
- Maintenance tasks covering table analysis, optimization, integrity checks, and monitoring queries for slow performance and InnoDB status
Tags
Related skills
| Skill | Installs | vs mysql-best-practices |
|---|---|---|
| secure-code-guardian | 1,112 | +164 |
| csharp-developer | 1,247 | +299 |
| flutter-databases | 966 | +18 |
| salesforce-developer | 943 | -5 |
| convex-security-audit | 1,077 | +129 |
FAQ
- How many installs does mysql-best-practices have?
- mysql-best-practices has 948 total installs and 946 installs this week.
- Where is mysql-best-practices hosted?
- mysql-best-practices is published by @mindrally/skills at https://github.com/mindrally/skills.
- How many GitHub stars does mysql-best-practices have?
- mysql-best-practices has 45 GitHub stars.
- When was mysql-best-practices first indexed?
- OrangeBot.AI first indexed mysql-best-practices on Jan 25, 2026.
- How do I install mysql-best-practices?
- Run: npx skills add https://github.com/mindrally/skills --skill mysql-best-practices