database-schema-designer

Design a multi-tenant database schema by extracting entities from requirements and applying RLS policy logic for tenant isolation. The schema includes table structures, constraints, and indexes to enforce secure data separation.

Model relational database entities by defining relationships and adding cross-cutting concerns like soft deletes, audit trails, and optimistic locking. This approach produces normalized table structures reflecting necessary constraints and versioning.

Generate migration-ready artifacts for common stacks including Prisma, Drizzle, TypeORM, and Alembic patterns. The process creates migration plans and typed outputs directly from your extracted entity models.

Create an ERD diagram in Mermaid format by extracting entities and relationships from your functional requirements. The output provides visual planning documentation alongside the generated table structures and indexes.

Database schema design includes indexing strategies by recommending partial indexes for active records. This ensures performance considerations are reflected directly within the normalized schema structure.

Designing a database schema from functional requirements focuses on relational structures, multi-tenancy, and migrations. It does not handle non-relational databases, as it specifically produces table structures, RLS policies, and ERD generation.