Skip to content
PlanetScale Database Skills — The Complete Guide
On Trove · from PlanetScale

PlanetScale Database Skills — The Complete Guide

Comprehensive reference for MySQL/InnoDB, PostgreSQL, Vitess, and Neki from PlanetScale's open-source database-skills collection.

Read a preview

You can read the contents and the first 2,000 characters.
Free accounts get the whole book.

  • By PlanetScale
  • 5 chapters
  • Updated Nov 1, 2026
  • 73 readers

What’s inside

  • MySQL / InnoDB
  • PostgreSQL
  • Vitess
  • Neki — Sharded Postgres
  • Cross-Cutting Best Practices

What is PlanetScale Database Skills — The Complete Guide?

Comprehensive reference for MySQL/InnoDB, PostgreSQL, Vitess, and Neki from PlanetScale's open-source database-skills collection. Covers schema design, primary keys, indexing, query optimization, EXPLAIN analysis, transactions, isolation levels, sharding, VSchema, and pre-sharding readiness.

Read more

PlanetScale · markdown · Listed Feb 19, 2026

  • planetscale
  • postgres
  • mysql
  • neki
  • vitess
  • best-practices
  • skill

From the first page

A comprehensive reference for MySQL, PostgreSQL, Vitess, and Neki — compiled from PlanetScale's open-source database-skills collection.

Author: PlanetScale Version: 1.0.0 (February 2026) Source: github.com/planetscale/database-skills

1. MySQL / InnoDB - 1.1 Schema Design - 1.2 Primary Keys - 1.3 Indexing & Composite Indexes - 1.4 Query Optimization & EXPLAIN Analysis - 1.5 Transactions & Isolation Levels - 1.6 Operations 2. PostgreSQL - 2.1 Schema Design - 2.2 Indexing Best Practices - 2.3 Operations & Architecture - 2.4 PlanetScale-Specific Features 3. Vitess - 3.1 Overview & Key Concepts - 3.2 VSchema Design & Configuration - 3.3 SQL Compatibility & Limitations - 3.4 References (Schema Changes, VReplication, Architecture, Query Serving) 4. Neki — Sharded Postgres - 4.1 Overview - 4.2 Pre-Sharding Readiness Guide 5. Cross-Cutting Best Practices

Use this chapter to make safe, measurable MySQL/InnoDB changes.

Workflow: 1. Define workload and constraints (read/write mix, latency target, data volume, MySQL version, hosting platform). 2. Propose the smallest change that can solve the problem, including trade-offs. 3. Validate with evidence (EXPLAIN, EXPLAIN ANALYZE, lock/connection metrics, and production-safe rollout steps). 4. For production changes, include rollback and post-deploy verification.

Preview · 2,000 of 23,198 characters

Supabase PostgreSQL Best Practices
Prisma ORM 7 Complete Reference
Inside Claude Code: The Architecture
Jev & System One Models — a practitioner's guide with sources

Contents

  1. 01MySQL / InnoDBp.1
    1. Schema Designp.1
    2. Primary Keysp.1
    3. Indexing & Composite Indexesp.1
    4. Query Optimization & EXPLAIN Analysisp.1
    5. Transactions & Isolation Levelsp.1
    6. Operationsp.1
  2. 02PostgreSQLp.1
    1. Schema Designp.1
    2. Indexing Best Practicesp.1
    3. Operations & Architecturep.1
    4. PlanetScale-Specific Featuresp.1
  3. 03Vitessp.1
    1. Overview & Key Conceptsp.1
    2. VSchema Design & Configurationp.1
    3. SQL Compatibility & Limitationsp.1
  4. 04Neki — Sharded Postgresp.1
    1. Overviewp.1
    2. Pre-Sharding Readiness Guidep.1
  5. 05Cross-Cutting Best Practicesp.1