database-design

Database design technology selection depends on your deployment context: PostgreSQL suits traditional relational workloads, Neon offers serverless scaling, Turso targets edge environments, and SQLite provides embedded local storage. Evaluate your application's latency and scaling requirements to select the appropriate database technology.

Database indexing and query optimization prevent N+1 problems by strategically applying indexes to foreign keys and frequently filtered columns. Proper schema design combined with ORM eager loading configurations eliminates redundant queries and significantly improves database performance.

Safe schema migrations with zero downtime require applying database design best practices like expanding schemas in phases, dual-writing during transitions, and backfilling data before removing old columns. This ensures database availability while executing structural changes.

ORM selection for database schema design depends on your control needs: Drizzle offers SQL-like flexibility, Prisma provides a strongly typed schema-first workflow, and Kysely delivers pure TypeScript query building. Match the ORM to your team's preferred database abstraction level.

Python3 is required to run the database-design skill's scripts and access its references. Ensure your environment has Python3 installed to execute the schema optimization, indexing, and migration guidance workflows.

Database schema design principles for normalization involve reducing data redundancy by structuring relationships properly, selecting appropriate primary keys, and ensuring referential integrity. Correct normalization balances query performance against data integrity requirements.