database-schema-designer

Designing a multi-tenant database schema involves normalizing tables up to BCNF and applying row-level security for tenant isolation. This skill generates schemas with audit fields, constraints, and RLS patterns to enforce secure data boundaries.

Yes, you can generate SQL migrations and type-safe ORM code directly from requirements. The skill outputs ready-to-use entities and migration scripts for Prisma, Drizzle, TypeORM, and raw SQL.

The best way to enforce tenant isolation is by applying row-level security (RLS) patterns within your relational schema. This approach ensures strict data boundaries for multi-tenant applications at the database level.

Yes, the database schema generator supports defensive design practices including soft deletes, optimistic locking, timestamps, and robust indexing strategies to ensure data integrity and performance.

Translating requirements into a relational schema involves entity-relationship design and normalization up to BCNF. The skill processes your feature requirements to generate appropriately constrained, normalized tables.

Yes, you can use Drizzle, TypeORM, or Prisma with a multi-tenant database schema. The skill generates type-safe interfaces and ORM entities specifically tailored to these frameworks alongside your SQL migrations.