skills.rest
ano4l
ano4lCOMMUNITY
Explore all skills by this author →
GitHub

database-schema-designer

Design relational database schemas and generate normalization-ready tables with migrations.

Updated Jun 2, 2026
Search Tags:#database#rls#migration#erd#schema-design#seed-data
One-click install
npx skills add https://github.com/ano4l/SiteRent --skill database-schema-designer-ano4l
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema-designer
Source: https://github.com/ano4l/SiteRent/tree/main/skills/database-schema-designer
Command: npx skills add https://github.com/ano4l/SiteRent --skill database-schema-designer-ano4l

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Design relational database schemas from requirements and generate normalized tables, relationships, constraints, and migration scripts. This skill helps teams translate business rules into a scalable data model and maintain consistency across schemas, seeds, and access policies.

Core Features & Use Cases

  • Schema design: normalize requirements into tables, relationships, and constraints.
  • Migration generation: produce migrations for Drizzle, Prisma, TypeORM, and Alembic.
  • Type generation: generate TypeScript interfaces and Python dataclasses/pydantic models.
  • RLS policies and indexing strategies: define access controls, soft deletes, and performance improvements.
  • ERD generation: create visual diagrams from schema.

Quick Start

Provide a requirements brief and receive a ready-to-use database schema, migrations, and seed templates.

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 database schema from business requirements?▼

Database schema design translates business requirements into normalized tables, relationships, and constraints. You provide a requirements brief and receive a ready-to-use schema with table relationships, indexing strategies, and seed data templates.

Can I generate migrations for Drizzle, Prisma, TypeORM, and Alembic from a schema?▼

Yes, schema migrations can be generated for Drizzle, Prisma, TypeORM, and Alembic. The design process outputs migration scripts alongside TypeScript interfaces and Python dataclasses or pydantic models.

What's the best way to add RLS policies and indexing to a multi-tenant database?▼

For multi-tenant architectures, schema design includes defining Row Level Security (RLS) policies and indexing strategies. This ensures proper access controls, soft deletes, and performance improvements are applied directly to the data model.

Does this schema design approach support ERD generation and audit tables?▼

Schema design supports ERD generation to create visual diagrams from the data model. It also includes optional audit and versioning constructs alongside core tables, constraints, and seed data generation.

How do I generate TypeScript and Python types from a relational database schema?▼

Type generation produces TypeScript interfaces and Python dataclasses or pydantic models directly from the relational database schema. This maintains consistency between the database layer and application code.

Related Skills

Explore More Software Engineering Skills→
dallenpyrahdallenpyrah

interview

Conduct five-question interviews to explore problem spaces and define constraints.

Community
Advanced
lagarcesslagarcess
1

database-schema-designer

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

Community
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
seb1nseb1n
147

database-schema-design

Design normalized relational database schemas and generate SQL DDL scripts.

Community
Intermediate