Can I visualize my schema with this skill?

Yes, it can generate Mermaid.js diagrams to provide a visual entity-relationship view of your database structure.

Which ORMs are supported for migration generation?

The skill generates migrations and schemas for popular tools including Drizzle, Prisma, TypeORM, and Alembic.

Can it handle multi-tenant applications?

Yes, it provides specific strategies for multi-tenancy, including organization-based scoping and Row-Level Security (RLS) policies.

How does it help with database performance?

It suggests optimal indexing strategies, including composite, partial, and covering indexes based on your query patterns.

Database Schema Designer

Name: Database Schema Designer
Author: zhangzhang-111-i

byzhangzhang-111-i

0•

Database Management

Architects relational database schemas and generates migrations, TypeScript/Python types, and RLS policies for robust backend development.

The Database Schema Designer skill empowers developers to transform complex requirements into normalized relational database architectures. It handles the entire data lifecycle, from initial entity-relationship mapping to the generation of migration scripts for frameworks like Prisma and Drizzle. Beyond basic table creation, it specializes in enterprise-grade features including multi-tenant row-level security (RLS), optimistic locking, soft delete patterns, and automated documentation through Mermaid ERD diagrams. It is particularly useful for building scalable, secure, and well-indexed SaaS applications where data integrity and developer productivity are paramount.

Key Features

01Row-Level Security (RLS) Policy Implementation

020 GitHub stars

03Requirement-to-Schema Normalization

04Multi-Framework Migration Generation (Prisma, Drizzle, Alembic)

05Automated Type and Seed Data Generation

06Mermaid-based ERD Diagram Visualization

Use Cases

01Refactoring existing schemas to improve performance via indexing strategies

02Designing a new SaaS backend with multi-tenancy and audit logs

03Generating synchronized TypeScript types and Python models from a database schema

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add zhangzhang-111-i/claude-skills111 database-schema-designer

For use in Claude.ai and ChatGPT

Key Features

01Row-Level Security (RLS) Policy Implementation

020 GitHub stars

03Requirement-to-Schema Normalization

04Multi-Framework Migration Generation (Prisma, Drizzle, Alembic)

05Automated Type and Seed Data Generation

06Mermaid-based ERD Diagram Visualization

Use Cases

01Refactoring existing schemas to improve performance via indexing strategies

02Designing a new SaaS backend with multi-tenancy and audit logs

03Generating synchronized TypeScript types and Python models from a database schema

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add zhangzhang-111-i/claude-skills111 database-schema-designer

For use in Claude.ai and ChatGPT