skills.rest
Kingdaddy007
Kingdaddy007COMMUNITY
Explore all skills by this author →
GitHub

DATABASE DESIGN & DATA MODELING

Define normalized database schemas with constraints, indexing, and versioned migrations.

2|Updated Apr 10, 2026
Search Tags:#database#migrations#sql#constraints#normalization#data-modeling#schema-design
One-click install
npx skills add https://github.com/Kingdaddy007/Antigravity-OS --skill database-design-data-modeling
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: DATABASE DESIGN & DATA MODELING
Source: https://github.com/Kingdaddy007/Antigravity-OS/tree/main/global/skills/database
Command: npx skills add https://github.com/Kingdaddy007/Antigravity-OS --skill database-design-data-modeling

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Domain knowledge for designing robust, scalable database schemas that preserve data integrity, align with real access patterns, and enable safe evolution over time.

Core Features & Use Cases

  • Normalize schemas starting from 3NF and document denormalization only when justified by workload.
  • Enforce data integrity with NOT NULL, UNIQUE, CHECK constraints, and FOREIGN KEYs; plan and validate migrations with the expand-and-contract pattern.
  • Optimize performance through indexing strategies tailored to actual query patterns and scalability requirements.
  • Use Case: Design a users, orders, and products schema with clear ownership and a zero-downtime migration plan.

Quick Start

Provide a normalized schema for a basic e-commerce domain (users, orders, products) and outline a safe, expandable migration plan.

Frequently Asked Questions about DATABASE DESIGN & DATA MODELING

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

FAQPage Schema
How do I design a normalized database schema for a basic e-commerce domain?▼

To design a normalized database schema, start from 3NF to eliminate data anomalies, then explicitly document any denormalization justified by actual workload requirements to preserve data integrity.

What's the best way to plan zero-downtime database migrations?▼

The best way to plan zero-downtime database migrations is using the expand-and-contract pattern, which validates schema changes safely while maintaining continuous availability for production systems.

When do I need database indexing strategies for query optimization?▼

You need database indexing strategies when optimizing performance for specific access patterns, ensuring indexes are tailored to actual query workloads and scalability requirements rather than theoretical usage.

How does enforcing data integrity with constraints work in schema design?▼

Enforcing data integrity works by applying NOT NULL, UNIQUE, CHECK constraints, and FOREIGN KEYs directly in the schema design to prevent invalid data entry and maintain relational consistency.

Can I apply relational data modeling techniques to document stores?▼

You can apply data modeling techniques across relational, document, and hybrid stores by adapting normalization rules and schema design to support specific access patterns and governance requirements.

Why should I not denormalize a database schema by default?▼

You should not denormalize by default because normalization starting from 3NF maximizes data integrity, and denormalization should only occur when explicitly justified by measured workload demands.

Related Skills

Explore More Software Engineering Skills→
hpsgdhpsgd

data-model

Design data models defining entities, relationships, constraints, and access patterns.

Official
Advanced
MicrockMicrock
322

data-migration

Plan and execute database migrations with rollback and integrity validation.

Community
Advanced
podversepodverse
6

podverse-orm-patterns

Document TypeORM entity, service, migration, and query builder patterns.

Official
Advanced
duylinhdang1998duylinhdang1998

nosql-expert

Design NoSQL data models and optimization strategies for MongoDB and DynamoDB.

Community
Advanced