Can I visualize the generated schema?

Yes, the skill can generate Mermaid.js code to produce Entity-Relationship Diagrams (ERDs) directly from your requirements or schema definitions.

Which migration tools and ORMs are supported?

The skill supports a wide range of popular tools including Drizzle, Prisma, TypeORM, and Alembic for Python environments.

Does it assist with database performance?

Yes, it provides optimized indexing strategies, including composite and partial indexes, and identifies common pitfalls like missing indexes on soft-delete columns.

Does it support modern backend languages?

Absolutely. It generates type-safe TypeScript interfaces and Python Pydantic models or dataclasses to ensure frontend-to-backend data consistency.

How does this skill handle database security?

It implements Row-Level Security (RLS) policies specifically designed for multi-tenant applications, ensuring that users can only access data belonging to their organization.

Database Schema Designer

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

byzhangzhang-111-i

0•

数据库管理

Architects robust relational database schemas complete with migrations, type-safe models, and advanced security policies.

The Database Schema Designer skill streamlines the complex process of data architecture by transforming high-level requirements into normalized relational schemas. It automates the generation of migrations for popular ORMs like Prisma and Drizzle, creates type-safe interfaces for TypeScript or Python, and implements production-grade features such as Row-Level Security (RLS) and audit trails. Whether you are building a multi-tenant SaaS application or refactoring an existing database for performance, this skill ensures your data layer follows industry best practices for indexing, normalization, and security.

主要功能

01Type-safe model generation for TypeScript and Python

020 GitHub stars

03Migration generation for Drizzle, Prisma, TypeORM, and Alembic

04Visual ERD generation using Mermaid diagram syntax

05Automated schema normalization and entity relationship mapping

06Advanced Row-Level Security (RLS) policy implementation

使用场景

01Designing a new application feature with complex relational data requirements

02Generating realistic seed data and migration scripts for development environments

03Implementing multi-tenancy and data isolation in an existing 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

主要功能

01Type-safe model generation for TypeScript and Python

020 GitHub stars

03Migration generation for Drizzle, Prisma, TypeORM, and Alembic

04Visual ERD generation using Mermaid diagram syntax

05Automated schema normalization and entity relationship mapping

06Advanced Row-Level Security (RLS) policy implementation

使用场景

01Designing a new application feature with complex relational data requirements

02Generating realistic seed data and migration scripts for development environments

03Implementing multi-tenancy and data isolation in an existing 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