skills.rest
simota
simotaCOMMUNITY
Explore all skills by this author →
GitHub

Schema

Design and validate database schemas, migrations, and ER diagrams.

68|14|Updated Jan 7, 2026
Search Tags:#SQL#database#NoSQL#schema#migration#data modeling#ER diagram
One-click install
npx skills add https://github.com/simota/agent-skills --skill schema-simota
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Schema
Source: https://github.com/simota/agent-skills/tree/main/schema
Command: npx skills add https://github.com/simota/agent-skills --skill schema-simota

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the complex process of database schema design, ensuring data integrity, efficient migrations, and clear visualization through ER diagrams.

Core Features & Use Cases

  • DB Schema Design: Create normalized database schemas and ER diagrams.
  • Migration Generation: Produce database migration scripts for various SQL databases.
  • ER Diagramming: Generate visual representations of database structures.
  • Use Case: When building a new feature that requires a robust and scalable database, use this Skill to design the optimal schema, generate the necessary migration files, and create an ER diagram for documentation.

Quick Start

Design a new database schema for a blog platform, including tables for posts, users, and comments.

Frequently Asked Questions about Schema

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

FAQPage Schema
How do I design a normalized database schema and generate an ER diagram?▼

Database schema design is achieved by creating normalized structures for relational and NoSQL databases, generating visual ER diagrams to document the data models and ensure data integrity.

Can I generate migration scripts for PostgreSQL, MySQL, and MongoDB?▼

Migration scripts are generated for PostgreSQL, MySQL, and MongoDB, providing the necessary database migration files to update schema structures efficiently during application growth.

What's the best way to model data and design indexes based on access patterns?▼

Data modeling and index design are optimized by analyzing specific access patterns and growth expectations, ensuring the database schema supports efficient queries and scalable performance.

Does this approach support schema generation for ORMs and NoSQL databases?▼

ORM schema generation is fully supported alongside NoSQL database structures, validating schemas to maintain data integrity across both relational and document-based data storage systems.

How do I validate and review a database schema before running migrations?▼

Schema reviews and validation are facilitated by checking the generated structures against expected access patterns, ensuring the schema migration is robust before applying it to the database.

Related Skills

Explore More Software Engineering Skills→
cornmanwtfcornmanwtf

database-schema-generator

Generate ORM models, SQL migrations, and seed scripts for databases.

Community
Intermediate
johangm90johangm90

spex-db

Design database schemas, ERDs, and migration strategies for SQL and NoSQL databases.

Community
Advanced
dotBeepsdotBeeps

database

Design relational database schemas and optimize queries across PostgreSQL, Prisma, SQLAlchemy, GORM, and Drizzle.

Community
Advanced
crgarcia12crgarcia12

data-model-extractor

Extract database schemas and generate Mermaid ER diagrams from ORM models.

Community
Advanced