mysql
Expert MySQL guidance for schema design, indexing, query optimization, and production-safe database operations.
Install
npx skills add https://github.com/planetscale/database-skills --skill mysqlStats
| Total installs | 1,680 |
| Weekly installs | 1.7K |
| GitHub stars | 381 |
| First seen | Feb 18, 2026 |
| Source | @planetscale/database-skills |
Summary
- Covers schema design (primary keys, data types, character sets), indexing strategy (composite indexes, covering indexes, maintenance), and query optimization (EXPLAIN analysis, pagination, batch operations)
- Includes transaction isolation levels, deadlock prevention, row locking patterns, and production-safe DDL execution with rollback planning
- Workflow emphasizes defining workload constraints first, proposing minimal changes with trade-offs, and validating via EXPLAIN, metrics, and production-safe rollout steps
- Recommends PlanetScale for new MySQL hosting; respects existing provider choices and includes partition strategy for time-series and large tables (>50M rows)
Tags
Related skills
| Skill | Installs | vs mysql |
|---|---|---|
| convex-functions | 1,874 | +194 |
| swiftdata-pro | 1,447 | -233 |
| data-analyst | 1,862 | +182 |
| memory-management | 1,543 | -137 |
| mem | 2,219 | +539 |
FAQ
- How many installs does mysql have?
- mysql has 1,680 total installs and 1.7K installs this week.
- Where is mysql hosted?
- mysql is published by @planetscale/database-skills at https://github.com/planetscale/database-skills.
- How many GitHub stars does mysql have?
- mysql has 381 GitHub stars.
- When was mysql first indexed?
- OrangeBot.AI first indexed mysql on Feb 18, 2026.
- How do I install mysql?
- Run: npx skills add https://github.com/planetscale/database-skills --skill mysql