Name: Database Design
Author: tontide1

Overview

This skill covers database design principles, schema modeling, and technology selection for modern applications. It emphasizes choosing the right tool for the job based on context rather than defaulting to a single technology.

Decision Workflow

Ask the user for database preferences when unclear.
Choose between PostgreSQL, Neon, Turso, or SQLite based on deployment environment and scale.
Select ORM (Drizzle, Prisma, Kysely) according to project needs.
Design normalized schemas with clear primary keys and relationships.
Plan indexing strategies (composite, GIN, BRIN) for performance tuning.

Best Practices

Use EXPLAIN ANALYZE for query optimization.
Avoid SELECT * in production code.
Store structured data correctly instead of defaulting to JSON.
Implement safe migrations and plan for serverless database environments.
Monitor and fix N+1 query issues.

Overview

Decision Workflow

Ask the user for database preferences when unclear.
Choose between PostgreSQL, Neon, Turso, or SQLite based on deployment environment and scale.
Select ORM (Drizzle, Prisma, Kysely) according to project needs.
Design normalized schemas with clear primary keys and relationships.
Plan indexing strategies (composite, GIN, BRIN) for performance tuning.

Best Practices

Use EXPLAIN ANALYZE for query optimization.
Avoid SELECT * in production code.
Store structured data correctly instead of defaulting to JSON.
Implement safe migrations and plan for serverless database environments.
Monitor and fix N+1 query issues.

Database Design

Overview

Decision Workflow

Best Practices

Database Design

Overview

Decision Workflow

Best Practices

Anti-Patterns to Avoid

Postgres Patterns

Postgres Patterns

Database Migrations

Postgres Patterns

Postgres Patterns

Jpa Patterns