Database Architect

Designing a multi-tenant PostgreSQL schema involves creating user and tenant tables with row-level security. This approach isolates tenant data while providing patterns for efficient data handling using SQL, Prisma, and Drizzle ORM.

Optimize database queries for pagination and full-text search by applying targeted patterns for indexing, partitioning, and caching. This Skill provides specific query optimization techniques for aggregations and JSONB queries to ensure efficient data retrieval.

Yes, you can use Drizzle ORM or Prisma for database migration strategies. This Skill demonstrates specific migration patterns using both frameworks to help you plan and execute schema changes across various application types.

Handle schema design for e-commerce and CRM systems by applying tailored data layer patterns. This Skill provides examples for designing, optimizing, and migrating database schemas to ensure scalable data architectures across these application types.

You need to use partitioning and indexing in your database schema when optimizing large data sets for scalable applications. This Skill provides considerations for implementing these techniques alongside caching to ensure efficient query performance.