skills.rest
jcteague
jcteagueCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/jcteague/wheelbase --skill database-schema-design-jcteague
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
musujmusuj

phase-1-schema

Define project terminology, entities, relationships, and data structures.

Community
Intermediate
JesusFigueroa25JesusFigueroa25

Database Optimizer

Optimize PostgreSQL and MySQL database performance through schema, query, and indexing analysis.

Community
Advanced
crgarcia12crgarcia12

data-model-extractor

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

Community
Advanced
afsjrafsjr

reversa-data-master

Generate ERD and markdown documentation from legacy database artifacts.

Community
Advanced