skills sourced live from GitHub · all skills listed are free · each skill is provided under its author's license.
home / Database / Database Schema Designer Skill by @alirezarezvani
The skill is the engineering/skills/database-schema-designer folder inside that repository. Copy it into the folder your agent loads skills from; check your agent's documentation for where that is.
Produces relational schemas from requirements, with an ERD, normalised DDL, migration steps and supporting types.
Walks from entities to relationships to cross-cutting concerns like multi-tenancy, soft deletes, audit trails and versioning, with a full worked task-management example. Also covers seed data, indexes and row-level security.
The original SKILL.md is organised into these sections:
Written and maintained by @alirezarezvani. It is published under the MIT license, which allows reuse with attribution. See the author profile. SkillDirectory does not claim authorship: this page adds our own review and links back to the original, and the skill's text belongs to its author.
# 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 …
Excerpt only, quoted from the author's repository. Open the repository for the complete file.