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

Ready to run

npx skills add https://github.com/simota/agent-skills --skill schema-simota

💬 Prompt for ChatGPT / Claude Chat▼

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.