database-patterns
✓PostgreSQL + Redis database design patterns. Use for data modeling, indexing, caching strategies. Covers JSONB, tiered storage, cache consistency.
Installation
SKILL.md
| Primary Key | UUID / BIGSERIAL | INT (range limits) | | Timestamps | TIMESTAMPTZ | TIMESTAMP (no timezone) | | Money | NUMERIC(19,4) | FLOAT (precision loss) | | Status | TEXT + CHECK | INT (unreadable) | | Semi-structured | JSONB | JSON (no indexing) | | Full-text | TSVECTOR | LIKE '%..%' |
| Cache objects | String | user:123 → JSON | | Counters | String + INCR | views:article:456 | | Sessions | Hash | session:abc → {userId, ...} | | Leaderboards | Sorted Set | scores → {userId: score} | | Queues | List/Stream | tasks → LPUSH/RPOP | | Unique sets | Set | onlineusers | | Real-time | Pub/Sub/Stream | Notifications |
Facts (cite-ready)
Stable fields and commands for AI/search citations.
- Install command
npx skills add https://github.com/majiayu000/claude-arsenal --skill database-patterns- Category
- {}Data Analysis
- Verified
- ✓
- First Seen
- 2026-02-01
- Updated
- 2026-02-18
Quick answers
What is database-patterns?
PostgreSQL + Redis database design patterns. Use for data modeling, indexing, caching strategies. Covers JSONB, tiered storage, cache consistency. Source: majiayu000/claude-arsenal.
How do I install database-patterns?
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/majiayu000/claude-arsenal --skill database-patterns Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code or Cursor
Where is the source repository?
https://github.com/majiayu000/claude-arsenal
Details
- Category
- {}Data Analysis
- Source
- skills.sh
- First Seen
- 2026-02-01