Database Schema Designer

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

Updated Mar 4, 2026

Search Tags:#typescript #schema design #database #migrations #python #sql #orm

Ready to run

npx skills add https://github.com/Tonybleything76/more-claude-skills --skill database-schema-designer-tonybleything76

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: Database Schema Designer
Source: https://github.com/Tonybleything76/more-claude-skills/tree/main/engineering/database-schema-designer
Command: npx skills add https://github.com/Tonybleything76/more-claude-skills --skill database-schema-designer-tonybleything76

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the complex and time-consuming process of designing relational database schemas and generating the necessary code for migrations, type definitions, and more.

Core Features & Use Cases

Schema Design: Normalize requirements into tables, relationships, and constraints.
Migration Generation: Create migrations for Drizzle, Prisma, TypeORM, and Alembic.
Type Generation: Produce TypeScript interfaces and Python dataclasses/Pydantic models.
RLS Policies: Implement Row-Level Security for multi-tenant applications.
Seed Data: Generate realistic test data for development and testing.
ERD Generation: Visualize schema designs using Mermaid diagrams.
Use Case: When building a new feature that requires database tables, this Skill can take your requirements, design the schema, and generate the Prisma schema, Drizzle migrations, and TypeScript types needed to implement it.

Quick Start

Design a database schema for a task management application based on the provided requirements.

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 Prisma or Drizzle ORM schemas from natural language requirements?▼

You can generate Prisma or Drizzle ORM schemas by inputting natural language requirements, which the system normalizes into relational tables and outputs as ready-to-use ORM migration files.

Can I design a multi-tenant database schema with Row-Level Security policies?▼

Yes, you can design multi-tenant database schemas with Row-Level Security policies by specifying the need in your requirements, prompting the generation of RLS policies for tenant isolation.

How do I create SQL migrations and TypeScript types for a new database feature?▼

To create SQL migrations and TypeScript types, define your feature requirements in natural language, and the system will output TypeORM or Alembic migrations alongside TypeScript interfaces.

What is the best way to visualize a relational database schema design?▼

The best way to visualize a relational database schema design is using generated Mermaid diagrams, which render entity-relationship diagrams directly from your normalized schema structure.

Does this database schema generator support Python dataclasses and Pydantic models?▼

Yes, the database schema generator supports Python by producing dataclasses and Pydantic models, translating your natural language requirements into typed Python definitions.

How do I generate realistic seed data for testing a new database schema?▼

You can generate realistic seed data for testing by requesting it during the schema design phase, automatically creating mock data that fits your normalized table constraints.