Designs production-grade PostgreSQL database schemas and optimized Prisma ORM models for Node.js applications.
This skill transforms complex data requirements into robust, high-performance PostgreSQL schemas using Prisma ORM. It focuses on enforcing data integrity through native database constraints, implementing efficient indexing strategies for high-scale applications, and utilizing advanced PostgreSQL features like JSONB and full-text search. Whether you are starting a new project or optimizing an existing database, it provides domain-specific guidance on migrations, naming conventions, and avoiding common performance pitfalls like N+1 queries through the lens of modern Node.js development.
