skills.rest
Tonybleything76
Tonybleything76COMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/Tonybleything76/more-claude-skills --skill database-schema-designer-tonybleything76
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
nettenette
41

nette-schema

Validate and normalize PHP data structures with Nette Schema.

Official
Intermediate
titabashtitabash

supabase-migration

Manage Supabase PostgreSQL schema migrations with Drizzle ORM and TypeScript.

Community
Advanced
WesleySmitsWesleySmits
6

managing-database-schemas

Analyze database schemas and generate improvement recommendations for Prisma, TypeORM, or Drizzle.

Community
Advanced
CuriousLearnerCuriousLearner
27

schema-visualizer

Generate ERDs and Mermaid diagrams from ORM models, migrations, or SQL dumps.

Community
Intermediate