relational-database
CommunityDesign relational schemas with enforced correctness.
Software Engineering#PostgreSQL#transactional integrity#database constraints#relational schema#zero-downtime migration#isolation level#index planning
Authormachenjie
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Prevents data corruption and performance surprises by turning relational storage decisions into explicit schema constraints, transaction boundaries, and safe migration plans.
Core Features & Use Cases
- Relational schema design with DB-enforced invariants: translate business rules into PK/FK, UNIQUE, CHECK, and NOT NULL constraints so correctness survives concurrent writers.
- Transaction, isolation, and locking guidance: define isolation levels, locking strategy, and conflict handling for concurrent update paths.
- Index and migration planning for production safety: align indexes to real query predicates and stage schema changes using expand-contract to minimize downtime and lock risk.
Quick Start
Use relational-database to produce a production-ready relational schema plan for your new entity relationships, including constraints, transaction settings, index rationale, and a zero-downtime expand-contract migration sequence.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: relational-database Download link: https://github.com/machenjie/rd-skills/archive/main.zip#relational-database Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.