Which ORMs and migration tools does this skill support?

The skill provides built-in support for popular tools including Drizzle, Prisma, TypeORM, and Alembic (SQLAlchemy).

How does it handle multi-tenancy?

It implements multi-tenant patterns by automatically scoping tables with organization IDs and generating appropriate Row-Level Security (RLS) policies for PostgreSQL.

Can it help with database performance optimization?

Yes, it analyzes query requirements to suggest composite, partial, and covering indexes to ensure your schema is optimized for production workloads.

Can I visualize the designed schema?

Yes, the skill can generate Mermaid-formatted Entity Relationship Diagrams (ERDs) to help visualize the architecture.

Does it generate application-side code?

Beyond SQL and migrations, it generates matching TypeScript interfaces or Python Pydantic models to keep your backend types in sync with your schema.

Database Schema Designer

Name: Database Schema Designer
Author: oabdelmaksoud

byoabdelmaksoud

0•

数据库管理

Architects production-grade relational database schemas, migrations, and type definitions from high-level requirements.

Database Schema Designer is a specialized engineering skill that transforms functional requirements into robust data architectures. It automates the creation of normalized schemas while addressing advanced production concerns like multi-tenancy, Row-Level Security (RLS) policies, soft deletes, and versioned audit trails. Whether you are starting a new SaaS project or refactoring a legacy system, this skill generates ready-to-use migration scripts for Drizzle, Prisma, or Alembic, alongside matching TypeScript or Python type definitions to ensure full-stack data integrity.

主要功能

01Requirement normalization into entities, relationships, and constraints

02Automatic type generation for TypeScript and Python/Pydantic models

03Optimized indexing strategies including partial and covering indexes

04Pre-configured patterns for multi-tenancy and Row-Level Security

05Automated migration generation for Prisma, Drizzle, TypeORM, and Alembic

060 GitHub stars

使用场景

01Implementing complex audit trails and soft-delete logic in existing schemas

02Architecting a new multi-tenant SaaS backend with secure data isolation

03Converting business requirements into a normalized ERD and migration script

主要功能

01Requirement normalization into entities, relationships, and constraints

02Automatic type generation for TypeScript and Python/Pydantic models

03Optimized indexing strategies including partial and covering indexes

04Pre-configured patterns for multi-tenancy and Row-Level Security

05Automated migration generation for Prisma, Drizzle, TypeORM, and Alembic

060 GitHub stars

使用场景

01Implementing complex audit trails and soft-delete logic in existing schemas

02Architecting a new multi-tenant SaaS backend with secure data isolation

03Converting business requirements into a normalized ERD and migration script