Database Management Patterns

This is your reference guide when you need to make informed decisions between PostgreSQL and MongoDB, or when you're optimizing either one in production. It covers the practical stuff: normalization strategies and when to break them, foreign key cascade patterns, indexing approaches for both relational and document models, transaction isolation levels, and sharding configurations. The CAP theorem comparison is honest about tradeoffs rather than dogmatic. What I appreciate here is the side-by-side treatment of SQL and NoSQL patterns, so you're not just learning one paradigm in isolation. Most useful when you're past the tutorial phase and dealing with real schema design decisions or performance bottlenecks.

skills.sh installs: 467
GitHub stars: 63
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add manutej/luxor-claude-marketplace --skill database-management-patterns --agent claude-code

Installs into .claude/skills of the current project.

Files

Database Management Patterns

A comprehensive skill for mastering database management across SQL (PostgreSQL) and NoSQL (MongoDB) systems. This skill covers schema design, indexing strategies, transaction management, replication, sharding, and performance optimization for production-grade applications.

When to Use This Skill

Use this skill when:

Designing database schemas for new applications or refactoring existing ones
Choosing between SQL and NoSQL databases for your use case
Optimizing query performance with proper indexing strategies
Implementing data consistency with transactions and ACID guarantees
Scaling databases horizontally with sharding and replication
Managing high-traffic applications requiring distributed databases
Ensuring data integrity with constraints, triggers, and validation
Troubleshooting performance issues using explain plans and query analysis
Building fault-tolerant systems with replication and failover strategies
Working with complex data relationships (relational) or flexible schemas (document)