database-design
Data, Backend & APIDatabase design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
Documentation
Database Design
> Learn to THINK, not copy SQL patterns.
🎯 Selective Reading Rule
Read ONLY files relevant to the request! Check the content map, find what you need.
| File | Description | When to Read |
|------|-------------|--------------|
| database-selection.md | PostgreSQL vs Neon vs Turso vs SQLite | Choosing database |
| orm-selection.md | Drizzle vs Prisma vs Kysely | Choosing ORM |
| schema-design.md | Normalization, PKs, relationships | Designing schema |
| indexing.md | Index types, composite indexes | Performance tuning |
| optimization.md | N+1, EXPLAIN ANALYZE | Query optimization |
| migrations.md | Safe migrations, serverless DBs | Schema changes |
---
⚠️ Core Principle
---
Decision Checklist
Before designing schema:
---
Anti-Patterns
❌ Default to PostgreSQL for simple apps (SQLite may suffice)
❌ Skip indexing
❌ Use SELECT * in production
❌ Store JSON when structured data is better
❌ Ignore N+1 queries
Compétences similaires
Explorez d'autres agents de la catégorie Data, Backend & API
fp-ts-pragmatic
A practical, jargon-free guide to fp-ts functional programming - the 80/20 approach that gets results without the academic overhead. Use when writing TypeScript with fp-ts library.
clickhouse-io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
similarity-search-patterns
Implement efficient similarity search with vector databases. Use when building semantic search, implementing nearest neighbor queries, or optimizing retrieval performance.