skills.rest
Dokkabei97
Dokkabei97COMMUNITY
Explore all skills by this author →
GitHub

db-schema-designer

Design database schemas from domain descriptions for PostgreSQL, MySQL, and MongoDB.

2|Updated Feb 28, 2026
Search Tags:#SQL#schema design#database#migration#Prisma#ERD#MongoDB
One-click install
npx skills add https://github.com/Dokkabei97/forged-claude-code --skill db-schema-designer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-schema-designer
Source: https://github.com/Dokkabei97/forged-claude-code/tree/main/skills/cto/db-schema-designer
Command: npx skills add https://github.com/Dokkabei97/forged-claude-code --skill db-schema-designer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill automates the complex and time-consuming process of designing database schemas, generating essential artifacts like ERDs, migration scripts, and index strategies, thereby accelerating development cycles.

Core Features & Use Cases

  • Schema Generation: Creates database schemas for PostgreSQL, MySQL, and MongoDB based on natural language domain descriptions.
  • ORM Support: Generates models for popular ORMs like Prisma, Drizzle, and SQLAlchemy.
  • Migration Scripts: Produces ready-to-run migration scripts for various database systems.
  • Index Strategy: Recommends optimal indexing for performance.
  • ERD Visualization: Generates visual Entity-Relationship Diagrams using Mermaid syntax.
  • Use Case: A startup needs to define its core user and product data models. This Skill can take a description like "Users have many posts, and posts have many tags" and generate the corresponding Prisma schema, migration files, and an ERD.

Quick Start

Design a PostgreSQL database schema for a blog with users, posts, and comments, including relationships and indexes.

Frequently Asked Questions about db-schema-designer

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

FAQPage Schema
How do I design a database schema from a natural language domain model description?▼

Database schema design from natural language descriptions is automated by generating ERDs, migration scripts, and index strategies. You provide domain relationships like "users have many posts," and the Skill outputs structured schemas for PostgreSQL, MySQL, or MongoDB.

Can I generate Prisma models and migration scripts for PostgreSQL from a text description?▼

Yes, generating Prisma models and PostgreSQL migration scripts from text descriptions is fully supported. The Skill outputs ready-to-run Prisma schema files and corresponding migration scripts based on your domain model relationships.

Does this schema designer support MongoDB and SQLAlchemy alongside raw SQL?▼

Yes, MongoDB and SQLAlchemy are supported alongside raw SQL and Drizzle. The schema designer generates appropriate models, migration scripts, and index strategies tailored to each specific database system and ORM framework.

What is the best way to visualize database relationships and generate an ERD for SQL and MongoDB?▼

The best way to visualize database relationships is by generating an ERD using Mermaid syntax. The Skill automatically produces Entity-Relationship Diagrams from your domain descriptions, providing clear visual representations of SQL and MongoDB schema structures.

How do I get index strategy recommendations when creating database schemas?▼

Index strategy recommendations are generated automatically when creating database schemas. The Skill analyzes your domain model relationships and outputs optimal indexing suggestions for PostgreSQL, MySQL, and MongoDB to ensure efficient query performance.

What database migration formats can I generate for Drizzle and SQLAlchemy?▼

You can generate ready-to-run migration scripts for Drizzle, SQLAlchemy, Prisma, and raw SQL. The Skill produces migration files tailored to PostgreSQL, MySQL, and MongoDB systems, facilitating efficient data modeling and development workflows.

Related Skills

Explore More Software Engineering Skills→
AtharvaN16AtharvaN16

ubiquitous-language

Extract domain-specific terms and relationships from conversation text into a structured glossary.

Community
Advanced
sitharaj88sitharaj88
1

db-prisma

Generate Prisma schemas, migrations, queries, and seeding scripts for multiple databases.

Community
Advanced
jonnabiojonnabio
6

database-operations

Automate database migrations, schema changes, and query optimization.

Community
Advanced
zmh13928433602-syszmh13928433602-sys

drizzle

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

Community
Intermediate