database-schema-design

Design scalable SQL and NoSQL database schemas with normalization and indexing.

Updated Mar 6, 2026

Search Tags:#database #migrations #sql #normalization #nosql #erd #schema-design

Ready to run

npx skills add https://github.com/jcteague/wheelbase --skill database-schema-design-jcteague

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-schema-design
Source: https://github.com/jcteague/wheelbase/tree/main/.agents/skills/database-schema-design
Command: npx skills add https://github.com/jcteague/wheelbase --skill database-schema-design-jcteague

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Design and optimize database schemas for SQL and NoSQL databases to ensure data integrity, scalability, and efficient querying across various workloads.

Core Features & Use Cases

Entity-relationship modeling, normalization up to 3NF, and constraint design for OLTP systems.
Indexing strategies, migration planning, and ERD documentation to support evolving data needs.
Real-world scenarios include building new applications, refactoring existing schemas, and migrating between database systems.

Quick Start

Design a normalized PostgreSQL schema for a new app with Users, Products, and Orders, including appropriate relationships and indexing.

Frequently Asked Questions about database-schema-design

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

FAQPage Schema

How do I design a normalized PostgreSQL schema for a new application?▼

To design a normalized PostgreSQL schema, apply entity-relationship modeling and normalization up to 3NF to define tables, relationships, constraints, and indexing strategies for optimal data integrity.

What is the best way to plan database migrations between SQL and NoSQL systems?▼

Planning database migrations between SQL and NoSQL systems involves generating migration scripts and applying schema refactoring strategies to transition structures while maintaining efficient querying across workloads.

How do I apply indexing strategies and constraints for scalable OLTP schemas?▼

Apply indexing strategies and constraints for scalable OLTP schemas by defining primary and foreign keys, enforcing validation rules, and generating ERD documentation to support evolving data needs.

Can I refactor an existing MySQL schema to improve query performance?▼

You can refactor an existing MySQL schema to improve query performance by re-evaluating normalization levels, adjusting constraint designs, and optimizing indexing strategies tailored to your specific workloads.

Does this database schema design approach work for MongoDB?▼

Yes, this database schema design approach works for MongoDB by adapting entity-relationship modeling principles to NoSQL structures, ensuring scalable designs and efficient querying for document-based workloads.