database-patterns

Design relational schemas with normalization, indexing, and migration strategies.

Updated Feb 1, 2026

Search Tags:#design #indexing #database #migrations #ORM #transactions #normalization

Ready to run

npx skills add https://github.com/jralph/.config-opencode --skill database-patterns-jralph

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-patterns
Source: https://github.com/jralph/.config-opencode/tree/main/skills/database-patterns
Command: npx skills add https://github.com/jralph/.config-opencode --skill database-patterns-jralph

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides proven database design patterns to reduce redundancy, improve performance, and enable scalable migrations across evolving applications.

Core Features & Use Cases

Normalization & Denormalization: Establish clear data separation with 3NF and selective denormalization for read performance.
Indexing & Query Strategy: Create targeted indexes, covering indexes, and efficient join paths to speed up common queries.
Migrations & Transactions: Define versioned, reversible migrations and reliable transactional boundaries to preserve data integrity.
Use Case: Design a multi-tenant schema with users, posts, and orders that scales horizontally while maintaining referential integrity.

Quick Start

Design a relational schema for a multi-tenant app with users, posts, and orders, including primary keys, foreign keys, and indexing strategy.

Frequently Asked Questions about database-patterns

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

FAQPage Schema

How do I design a relational database schema for a multi-tenant application?▼

Designing a multi-tenant database schema involves structuring users, posts, and orders with primary keys, foreign keys, and constraints to maintain referential integrity while scaling horizontally.

When should I use normalization versus denormalization in database design?▼

Use database normalization to establish clear data separation with 3NF, and apply selective denormalization when you need to optimize read performance for specific query paths.

What is the best way to create database indexes for query optimization?▼

The best way to optimize database queries is by creating targeted indexes, covering indexes, and efficient join paths to speed up common query patterns.

How do I manage database migrations to preserve data integrity?▼

Manage database migrations by defining versioned, reversible workflows and establishing reliable transactional boundaries to preserve data integrity during schema updates.

What naming conventions and constraints should I enforce for scalable database schemas?▼

Scalable database schemas require enforcing concrete guidelines for naming conventions, constraints, and keys to ensure maintainable structures across evolving applications.

Can I apply these database design patterns to e-commerce and content platforms?▼

Yes, these database design principles apply across typical application domains such as e-commerce and content platforms to reduce redundancy and improve performance.