skills.rest
amanhsn
amanhsnCOMMUNITY
Explore all skills by this author →
GitHub

Database Schema Designer

Generate relational database schemas, SQL migrations, and type definitions from natural language requirements.

Updated Feb 27, 2026
Search Tags:#typescript#schema design#database#python#migration#sql#orm
One-click install
npx skills add https://github.com/amanhsn/flyerbuild --skill database-schema-designer-amanhsn
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Database Schema Designer
Source: https://github.com/amanhsn/flyerbuild/tree/main/.cursor/skills/database-schema-designer
Command: npx skills add https://github.com/amanhsn/flyerbuild --skill database-schema-designer-amanhsn

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the complex process of designing, implementing, and maintaining relational database schemas, reducing the risk of errors and improving development speed.

Core Features & Use Cases

  • Schema Design: Translate natural language requirements into normalized database schemas.
  • Migration Generation: Create migration scripts for popular ORMs like Drizzle, Prisma, and Alembic.
  • Type Generation: Automatically generate TypeScript or Python type definitions from your schema.
  • Advanced Features: Supports multi-tenancy, soft deletes, audit trails, and polymorphic associations.
  • Use Case: You need to design a new set of tables for a task management feature, including user assignments, project structures, and audit logging. This Skill can generate the Prisma schema, Drizzle types, and an Alembic migration script for you.

Quick Start

Design a database schema for a blog with posts, authors, and comments, and generate Prisma schema code.

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?▼

You can generate normalized database schemas and SQL migration scripts by providing natural language requirements. This translates your text into structured schemas, type definitions, and migration files for ORMs like Drizzle, Prisma, and Alembic.

Can I generate TypeScript and Python type definitions directly from an existing database schema?▼

Yes, generating TypeScript and Python type definitions from your database schema is fully supported. The schema design process automatically produces these type definitions alongside your SQL migrations to ensure type safety.

Does this support advanced database schema features like multi-tenancy, soft deletes, and audit trails?▼

Yes, schema design supports advanced features including multi-tenancy, soft deletes, audit trails, versioning, and polymorphic associations. These are integrated directly into the generated SQL migrations and ORM configurations.

What is the best way to create a Prisma schema and Alembic migration for a task management database?▼

The best way is to describe the task management feature in natural language, including user assignments and project structures. The tool then outputs normalized schemas, Prisma schema code, and Alembic migration scripts automatically.

How do ERDs and RLS policies fit into the relational database schema design process?▼

ERDs and RLS policies are generated as part of the relational database schema design process. They provide visual entity-relationship diagrams and row-level security configurations alongside your ORM migration scripts.

Do I need to specify an ORM before generating database migrations and type definitions?▼

You should specify your target ORM such as Drizzle, Prisma, TypeORM, or Alembic to get accurate outputs. Specifying the ORM ensures the generated SQL migrations, type definitions, and schema code match your framework.

Related Skills

Explore More Software Engineering Skills→
zmh13928433602-syszmh13928433602-sys

drizzle

Define and manage PostgreSQL schemas and migrations with Drizzle ORM in TypeScript.

Community
Intermediate
titabashtitabash

supabase-migration

Manage Supabase PostgreSQL schema migrations with Drizzle ORM and TypeScript.

Community
Advanced
twlinestwlines

wire-feature

Scaffold full-stack features across server, shared types, and client layers.

Community
Intermediate
ntaksh42ntaksh42
1

database-migration-generator

Generate SQL and TypeORM database migration scripts with rollback support.

Community
Intermediate