Does it generate visual diagrams?

Yes, it can automatically generate Mermaid-based Entity Relationship Diagrams (ERDs) to help you visualize and document your database structure.

Can I use this for optimizing existing databases?

Absolutely. It can review your current schema for performance bottlenecks, suggest composite indexes, and plan migrations for structural changes.

Which migration tools does this skill support?

The skill supports a wide range of popular ORMs and migration tools including Prisma, Drizzle, TypeORM, and Alembic (SQLAlchemy).

Can it help with multi-tenant application security?

Yes, it specializes in designing Row-Level Security (RLS) policies to ensure robust data isolation in multi-tenant SaaS environments.

Database Schema Designer

Name: Database Schema Designer
Author: alirezarezvani

byalirezarezvani

•

9,958

•

데이터베이스 관리

Designs optimized relational database schemas, generates migrations, and implements advanced data patterns like RLS and multi-tenancy.

This skill transforms high-level requirements into production-ready data architectures, handling everything from initial entity-relationship modeling to the generation of framework-specific migrations and type definitions. It goes beyond simple table creation by incorporating professional engineering patterns such as Row-Level Security (RLS) for multi-tenancy, soft delete strategies, audit trails, and optimistic locking to ensure data integrity and performance. Whether you are starting a new project or refactoring a complex legacy system, it provides the architectural guidance needed for scalable, type-safe database design.

주요 기능

01Implementation of Row-Level Security (RLS) policies for multi-tenant isolation

02Performance-optimized indexing strategies including composite and partial indexes

03Type-safe code generation for TypeScript interfaces and Pydantic models

04Visual ERD generation using Mermaid syntax for architectural documentation

059,958 GitHub stars

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

사용 사례

01Refactoring existing schemas to improve normalization or add audit logging capabilities

02Designing a new feature with complex relational requirements and multi-tenant security

03Generating realistic seed data and unit-testable database types for full-stack development

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add alirezarezvani/claude-skills database-schema-designer

For use in Claude.ai and ChatGPT

주요 기능

01Implementation of Row-Level Security (RLS) policies for multi-tenant isolation

02Performance-optimized indexing strategies including composite and partial indexes

03Type-safe code generation for TypeScript interfaces and Pydantic models

04Visual ERD generation using Mermaid syntax for architectural documentation

059,958 GitHub stars

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

사용 사례

01Refactoring existing schemas to improve normalization or add audit logging capabilities

02Designing a new feature with complex relational requirements and multi-tenant security

03Generating realistic seed data and unit-testable database types for full-stack development