database-schema-designer
Use when the user asks to create ERD diagrams, normalize database schemas, design table relationships, or plan schema migrations.
Profile →npx skills add alirezarezvani/claude-skills --skill database-schema-designer --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Database Schema Designer **Tier:** POWERFUL **Category:** Engineering **Domain:** Data Architecture / Backend --- ## Overview Design relational database schemas from requirements and generate migrations, TypeScript/Python types, seed data, RLS policies, and indexes. Handles multi-tenancy, soft deletes, audit trails, versioning, and polymorphic associations. ## Core Capabilities - **Schema design** — normalize requirements into tables, relationships, constraints - **Migration generation** — Drizzle, Prisma, TypeORM, Alembic - **Type generation** — TypeScript interfaces, Python dataclasses/Pydantic models - **RLS policies** — Row-Level Security for multi-tenant apps - **Index strategy** — composite indexes, partial indexes, covering indexes - **Seed data** — realistic test data generation - **ERD generation** — Mermaid diagram from schema --- ## When to Use - Designing a new feature that needs database tables - Reviewing a schema for performance or normalization issues - Adding multi-tenancy to an existing schema - Generating TypeScript types from a Prisma schema - Planning a schema migration for a breaking change --- ## Schema Design Process ### Step 1: Requirements → Entities Giv
- Overview
- Core Capabilities
- When to Use
- Schema Design Process
- Step 1: Requirements → Entities
- Step 2: Identify Relationships
- Step 3: Add Cross-cutting Concerns
- Full Schema Example (Task Management SaaS)
- Row-Level Security (RLS) Policies
- Seed Data Generation
- ERD Generation (Mermaid)
- Common Pitfalls
- Best Practices
npx prisma-erd-generator
What does the database-schema-designer skill do?
Use when the user asks to create ERD diagrams, normalize database schemas, design table relationships, or plan schema migrations.
How do I install it?
Run `npx skills add alirezarezvani/claude-skills --skill database-schema-designer --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From alirezarezvani/claude-skills, a repository with 23,791 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.