planetscale/database-skills▌

Comprehensive Postgres guidance covering schema design, query optimization, replication, and PlanetScale-specific operations. \n \n Covers eight core topics: schema design, indexing, partitioning, query patterns, MVCC/VACUUM, process and memory architecture, WAL operations, and backup/recovery \n Includes PlanetScale-specific references for connection pooling, PgBouncer configuration, extensions, and the pscale CLI \n Provides optimization checklists, monitoring strategies via pg_stat views, and

Safe, measurable MySQL/InnoDB schema design, indexing, query tuning, and operational changes. \n \n Covers schema design (primary keys, data types, character sets), indexing strategy (composite indexes, covering indexes, maintenance), and query optimization (EXPLAIN analysis, pagination, batch operations) \n Includes transaction isolation levels, deadlock prevention, row locking patterns, and production-safe DDL execution with rollback planning \n Workflow emphasizes defining workload constraint

Note: Neki is not yet a released product, but will be available soon. Information here will be updated regularly.

Vitess is a MySQL-compatible, cloud-native database system originally built at YouTube to scale MySQL. PlanetScale runs Vitess as a managed service. Core capabilities: