Database Plan

Database architecture, schema design, and index planning

DongDuong2001 Updated 5 repo stars
PUDO Code System

File contents

Database Planning Skill

This skill is essential when designing data storage solutions and defining schema boundaries.

When to use this skill

  • When determining whether to use SQL vs NoSQL vs Time-Series databases.
  • When designing entity-relationship diagrams (ERD) schemas.
  • When planning indexing, partitioning, or sharding strategies.

Guidelines

  • Normalize data by default to reduce redundancy, but denormalize strategically for read-heavy performance bottlenecks.
  • Plan indexes based on expected query patterns, not just foreign keys. Remember that excessive indexing slows down write operations.
  • Avoid using UUIDs/GUIDs as primary clustered keys in massive tables where sequential inserts are critical for performance, unless mitigated by the DB engine.

DongDuong2001/pudo-code-system commit 774a5f85f0

Frequently asked questions

npx get-skill add dongduong2001/database-plan