mysql — Skills — getagentictools

What it does

Prefer narrow, monotonic PKs (BIGINT UNSIGNED AUTOINCREMENT) for write-heavy OLTP tables.

Avoid random UUID values as clustered PKs; if external IDs are required, keep UUID in a secondary unique column.

Always utf8mb4 / utf8mb40900aici. Prefer NOT NULL, DATETIME over TIMESTAMP.

Lookup tables over ENUM. Normalize to 3NF; denormalize only for measured hot paths.

primary-keys

character-sets

json-column-patterns

mysql

Source

Repository: https://github.com/planetscale/database-skills

mysql FAQ

What does the mysql skill do?

Plan and review MySQL/InnoDB schema, indexing, query tuning, transactions, and operations. Use when creating or modifying MySQL tables, indexes, or queries; diagnosing slow/locking behavior; planning migrations; or troubleshooting replication and connection issues. Load when using a MySQL database. Prefer narrow, monotonic PKs (BIGINT UNSIGNED AUTOINCREMENT) for write-heavy OLTP tables. Avoid random UUID values as clustered PKs; if external IDs are required, keep UUID in a secondary unique column.

What does mysql require?

Configuration keys: EXPLAIN, BIGINT, DATETIME, TIMESTAMP, ENUM, MAXVALUE, OFFSET, WHERE.

How do I install mysql?

Run: npx -y skills add https://github.com/planetscale/database-skills --skill mysql --agent claude-code — the source lives at github.com/planetscale/database-skills.

Maintain mysql?

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 on getagentictools](https://getagentictools.com/badge/skills/planetscale-database-skills-mysql.svg)](https://getagentictools.com/skills/planetscale-database-skills-mysql?ref=badge)

npx agentictools info skills/planetscale-database-skills-mysql

The second line is the CLI lookup for this page — handy in READMEs and docs.