skills.rest
zhangzhang-111-i
zhangzhang-111-iCOMMUNITY
Explore all skills by this author →
GitHub

database-schema-designer

Design relational database schemas from natural language requirements and generate SQL migrations.

2|Updated Mar 13, 2026
Search Tags:#typescript#schema design#database#migrations#python#backend#sql
One-click install
npx skills add https://github.com/zhangzhang-111-i/claude-skills111 --skill database-schema-designer-zhangzhang-111-i
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema-designer
Source: https://github.com/zhangzhang-111-i/claude-skills111/tree/main/engineering/database-schema-designer
Command: npx skills add https://github.com/zhangzhang-111-i/claude-skills111 --skill database-schema-designer-zhangzhang-111-i

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the complex and time-consuming process of designing relational database schemas, generating necessary code artifacts like migrations, and ensuring best practices are followed.

Core Features & Use Cases

  • Schema Design: Translates natural language requirements into normalized database schemas.
  • Code Generation: Creates migrations for Drizzle, Prisma, TypeORM, and Alembic.
  • Type Generation: Produces TypeScript interfaces and Python models.
  • Advanced Features: Supports multi-tenancy, soft deletes, audit trails, and RLS policies.
  • Use Case: When starting a new project, use this Skill to define your initial database structure, generate the corresponding migration files, and create type definitions for your backend code.

Quick Start

Use the database-schema-designer skill to design a schema for a blog with posts, users, and comments.

Frequently Asked Questions about database-schema-designer

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

FAQPage Schema
How do I generate database schemas and SQL migrations from natural language requirements?▼

To generate database schemas from natural language, you define your data structures in plain text and the tool outputs normalized relational schemas, SQL migrations, and corresponding TypeScript or Python type definitions automatically.

Can I generate migrations for Drizzle, Prisma, TypeORM, and Alembic using a single schema design?▼

Yes, you can design a single normalized relational schema and automatically generate corresponding database migrations for Drizzle, Prisma, TypeORM, and Alembic, alongside TypeScript interfaces and Python models.

What is the best way to implement multi-tenancy, soft deletes, and audit trails in a relational database?▼

The best way to implement multi-tenancy, soft deletes, and audit trails is to define these requirements in natural language, allowing the schema designer to structure the relational database and generate the necessary SQL policies and migration files.

Does this database schema generator support Row-Level Security (RLS) policies?▼

Yes, this database schema generator supports Row-Level Security (RLS) policies by translating your natural language security requirements into the appropriate SQL policy definitions within your generated database migrations.

How do I create backend type definitions and seed data for a new database architecture?▼

To create backend type definitions and seed data, you input your project requirements in natural language, and the schema designer outputs TypeScript interfaces, Python models, and initial seed data alongside the SQL migrations.

Related Skills

Explore More Software Engineering Skills→
Rubiss-ProjectsRubiss-Projects
25

speckit-specify

Generate feature specifications from natural language descriptions.

Official
Advanced
Matteo-Exp-TransformerMatteo-Exp-Transformer

calendarbackup-db

Manage database schema, migrations, RLS, SQL functions, and TypeScript types for Supabase.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
Tonybleything76Tonybleything76

Database Schema Designer

Design relational database schemas from natural language requirements and generate SQL migrations.

Community
Advanced