database

Database schema design for scalable apps involves applying normalization, indexing, and denormalization principles across PostgreSQL and MongoDB to ensure data integrity and performance. This skill provides guidance on balancing these techniques for both relational and document models.

Safe database migrations are managed through version-controlled tooling like Prisma Migrate and Alembic to evolve schemas safely in production. This skill enforces migration-driven deployments and transaction management to prevent data loss during schema changes.

Database seeding is best handled by defining your core entities and relationships, then generating starter schema and seed data for your chosen stack. This approach supports reliable development operations and consistent data modeling across environments.

Yes, this database skill works with ORM workflows like Prisma for Node.js and SQLAlchemy for Python, alongside safe indexing strategies and raw query patterns. It ensures consistent data access and transaction management across PostgreSQL, MySQL, and SQLite.

Denormalization for performance should be applied in document stores like MongoDB when complex joins slow down read operations and data integrity allows nested data structures. This skill provides schema design principles to determine the right balance for scalable applications.