database-schema-designer

Name: database-schema-designer
Availability: InStock
Author: patasse97

Design relational database schemas and generate migrations, types, and seed data.

Updated Apr 9, 2026

Search Tags:#design #database #rls #schema #migration #erd #multitenancy

Ready to run

npx skills add https://github.com/Patasse97/claude-skills --skill database-schema-designer-patasse97

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-schema-designer
Source: https://github.com/Patasse97/claude-skills/tree/main/engineering/database-schema-designer
Command: npx skills add https://github.com/Patasse97/claude-skills --skill database-schema-designer-patasse97

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Design relational database schemas from requirements and generate migrations, TypeScript/Python types, seed data, and policy definitions for multi-tenant apps.

Core Features & Use Cases

Schema design and normalization into tables with relationships and constraints
Migration generation for Drizzle, Prisma, TypeORM, and Alembic
Type generation for TypeScript interfaces and Python models
Row-Level Security and multi-tenant policy definitions
Seed data generation to create realistic test data
ERD generation to visualize schemas with Mermaid

Quick Start

Describe your database requirements and this skill will output a complete schema plan and migration artifacts.

Frequently Asked Questions about database-schema-designer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I design a multi-tenant database schema with row-level security policies?▼

To design a multi-tenant database schema with row-level security, you define relational tables, constraints, and RLS policies directly from your application requirements. This process generates schema plans, access control definitions, and seed data for testing.

What's the best way to generate database migrations and type definitions from schema requirements?▼

Generating database migrations and type definitions from schema requirements involves normalizing data into tables and outputting framework-specific migration files. You get TypeScript interfaces, Python models, and schema versioning artifacts for Drizzle, Prisma, TypeORM, or Alembic.

How do I create an entity relationship diagram for a relational database schema?▼

Creating an entity relationship diagram for a relational database schema involves translating your structured requirements into normalized tables and constraints. The schema design process outputs Mermaid ERD visualizations alongside your migration files and type definitions.

Can I generate seed data and soft delete policies for a multi-tenant database?▼

Yes, you can generate seed data and soft delete policies for a multi-tenant database. By applying your schema requirements, the design process produces realistic test data, auditing structures, and policy-driven access control rules.

Does this database schema designer work with Prisma and Alembic migration tools?▼

Yes, the database schema designer works with Prisma and Alembic migration tools. It supports generating migration files for Drizzle, Prisma, TypeORM, and Alembic, alongside TypeScript and Python type definitions based on your relational schema.

How do I optimize database schema performance and normalization for complex applications?▼

Optimizing database schema performance and normalization involves structuring tables with proper relationships, indexing strategies, and constraints. The schema design process satisfies normalization requirements and outputs optimized migration artifacts and policy definitions.