skills.rest
MomoDaviluke
MomoDavilukeCOMMUNITY
Explore all skills by this author →
GitHub

Database Designer

Generate normalized database schemas, migrations, seed data, and ER diagrams.

2|Updated Mar 3, 2026
Search Tags:#design#indexing#database#migration#sql#normalization#er-diagram
One-click install
npx skills add https://github.com/MomoDaviluke/star-citizen-promotion --skill database-designer-momodaviluke
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Database Designer
Source: https://github.com/MomoDaviluke/star-citizen-promotion/tree/main/.agents/skills/database-design
Command: npx skills add https://github.com/MomoDaviluke/star-citizen-promotion --skill database-designer-momodaviluke

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Database design is often time-consuming and error-prone. This skill automates creating normalized schemas, indexing strategies, migration plans, seeds, and ER diagrams to speed up development and ensure consistency.

Core Features & Use Cases

  • Normalize schemas and ensure data integrity with standard database design practices.
  • Generate migrations, seed data, and ER diagrams to document and evolve the data model.
  • Provide indexing guidance and practical examples for common entities (users, orders, products) to improve query performance.
  • Use case: rapidly design a new application's data layer from requirements and generate ready-to-run SQL artifacts.

Quick Start

Describe your database needs and I will generate a normalized schema, migrations, and ER diagrams.

Frequently Asked Questions about Database Designer

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

FAQPage Schema
How do I generate a normalized database schema from application requirements?▼

To generate a normalized database schema, provide your application requirements and the system outputs standard normalized tables, indexing strategies, and supporting artifacts to ensure data integrity and consistency.

What is the best way to automate SQL migration script creation for existing databases?▼

Automating SQL migration script creation involves defining your schema evolution needs, which generates ready-to-run migration scripts and seed data to simplify database migration and documentation.

Can I automatically generate ER diagrams for my database design?▼

Yes, you can generate ER diagrams by providing your database structure or requirements. The system automatically documents the data model and outputs visual ER diagrams to map entity relationships.

How does indexing strategy generation work for common database entities?▼

Indexing strategy generation works by analyzing your normalized schema and providing practical indexing examples for common entities like users, orders, and products to improve query performance.

Do I need to manually write SQL to create seed data for a new application schema?▼

No, you do not need to manually write SQL for seed data. By describing your database needs, the system automatically generates seed data alongside migrations and normalized schemas.

Related Skills

Explore More Software Engineering Skills→
jonnabiojonnabio
6

audiocraft-audio-generation

Convert text descriptions into music and sound effects using audiocraft.

Community
Advanced
Interstellar-codeInterstellar-code
17

sql-cli

Execute SQL queries against MySQL and PostgreSQL databases from the command line.

Community
Advanced
DinxeshhDinxeshh

Schema

Design normalized database schemas, migration plans, and ER diagrams.

Community
Advanced
Eigo-Mt-FujiEigo-Mt-Fuji

database-schema-designer

Design database schemas, ER diagrams, and DDL for relational and NoSQL databases.

Community
Advanced