Database Schema Designer
You point this at your database needs and it generates normalized schemas with proper relationships, indexes, and constraints. Good for when you're prototyping a new project or refactoring an existing data model and want to avoid the usual pitfalls like missing foreign keys or poorly indexed queries. It understands different database paradigms and can explain the tradeoffs between normalization levels. The output is actual DDL you can run, not pseudocode, which saves the translation step. Most useful early in a project when the schema is still fluid, less so when you're deep in domain-specific optimization territory.
- skills.sh installs
- 722
- GitHub stars
- 29.5K
- last updated
- Aug 21, 2026
Install
$ npx -y skills add alirezarezvani/claude-skills --skill database-schema-designer --agent claude-codeInstalls into .claude/skills of the current project.
Files
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
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/alirezarezvani/claude-skills
- Categories
- Backend & APIs, Productivity & Planning, Design & UI/UX, Databases
- First seen
- Jun 3, 2026
More from alirezarezvani/claude-skills
All 267- Ai Security720
- Brand Guidelines720
- Docker Development720
- Content Strategy719
- Dependency Auditor711
- Page Cro709
- Llm Wiki706
- Secrets Vault Manager705
- Agent Designer703
- Ci Cd Pipeline Builder702
- Pr Review Expert701
- Product Analytics700
- Apple Hig Expert692
- Atlassian Admin691
- Atlassian Templates691
- Saas Metrics Coach690
- Social Content690
- Observability Designer688
- Founder Coach687
- Playwright Pro687
- Pricing Strategy687
- Env Secrets Manager685
- Competitive Teardown684
- Interview System Designer684
Recommended
More Backend & APIs
database-performanceaaronontheweb/dotnet-skillsDatabase access patterns for performance. Separate read/write models, avoid N+1 queries, use AsNoTracking, apply row limits, and never do application-side joins700skills.sh installsapi-designaaronontheweb/dotnet-skillsDesign stable, compatible public APIs using extend-only design principles. Manage API compatibility, wire compatibility, and versioning for NuGet packages and d690skills.sh installs
viewcomfy-api-rulesmindrally/skillsExpert guidance for integrating ViewComfy API into web applications using Python and FastAPI686skills.sh installs
