database-schema-designer

Name: database-schema-designer
Availability: InStock
Author: sidjamyl

Generate normalized SQL and NoSQL schemas with indexing and reversible migration scripts.

Updated Feb 26, 2026

Search Tags:#indexing #SQL #schema design #database #NoSQL #migrations #normalization

Ready to run

npx skills add https://github.com/sidjamyl/GAMES-JTI- --skill database-schema-designer-sidjamyl

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-schema-designer
Source: https://github.com/sidjamyl/GAMES-JTI-/tree/main/.agents/skills/database-schema-designer
Command: npx skills add https://github.com/sidjamyl/GAMES-JTI- --skill database-schema-designer-sidjamyl

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill helps users design robust, scalable, and production-ready database schemas for both SQL and NoSQL databases, ensuring data integrity and optimal performance.

Core Features & Use Cases

Schema Design: Generates complete SQL or NoSQL schemas from natural language descriptions.
Normalization & Optimization: Applies best practices for normalization, indexing, and data types.
Migration Scripts: Creates reversible migration scripts for schema evolution.
Use Case: A startup needs to design a database for their new SaaS product. They describe their entities (users, products, orders) and relationships, and the Skill generates a normalized 3NF SQL schema with appropriate indexes and migration scripts.

Quick Start

Design a schema for an e-commerce platform with users, products, and orders.

Frequently Asked Questions about database-schema-designer

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

FAQPage Schema

How do I design a production-ready database schema from natural language?▼

Generating a database schema from natural language requires translating entity descriptions into structured models. This Skill produces complete SQL or NoSQL schemas, applying 3NF normalization, indexing strategies, and foreign key constraints to ensure data integrity and query performance.

Can I generate reversible migration scripts for schema evolution?▼

Yes, generating reversible migration scripts for schema evolution is supported. The Skill creates migration patterns that allow you to safely apply and roll back structural database changes, ensuring maintainable data models during application growth.

Does this database schema designer work with both NoSQL and SQL databases?▼

Yes, this database schema designer works with both SQL and NoSQL databases. It supports SQL databases like MySQL, PostgreSQL, and SQLite, alongside NoSQL platforms like MongoDB, applying appropriate data modeling practices for each environment.

What's the best way to normalize a SQL database schema to 3NF?▼

Normalizing a SQL database schema to 3NF involves structuring tables to eliminate data redundancy and ensure referential integrity. The Skill automatically applies 3NF normalization rules, foreign key constraints, and indexing strategies to optimize your data model.

How do I create an indexing strategy for my database schema?▼

Creating an indexing strategy for a database schema requires analyzing query patterns and table relationships. The Skill incorporates indexing strategies directly into the generated schema to optimize query performance and maintain efficient data retrieval.

When should I not use normalization for my database schema?▼

Normalization for database schemas might be bypassed when prioritizing read performance over data redundancy or when modeling NoSQL document structures. The Skill evaluates your use case to balance 3NF normalization with practical indexing and performance needs.