Database Design Patterns
Schema design, normalization decisions, indexing strategies, and migration safety for relational databases. Use when designing tables, choosing between normalize vs denormalize, selecting index types, planning zero-downtime migrations, or setting up connection pooling. Activate on "schema design", "normalization", "denormalization", "foreign key", "index strategy", "migration", "connection pooling", "composite key", "surrogate key", "soft delete", "polymorphic association". NOT for PostgreSQL-specific query tuning or EXPLAIN analysis (use postgresql-optimization), NoSQL or document database de
Install
/plugin marketplace add curiositech/some_claude_skillsThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add curiositech/some_claude_skills --skill database-design-patternsgit clone --depth 1 https://github.com/curiositech/some_claude_skills.git /tmp/some_claude_skills
mkdir -p ~/.claude/skills
cp -r /tmp/some_claude_skills/.claude/skills/database-design-patterns ~/.claude/skills/database-design-patternsPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# Database Design Patterns Relational database schema design expert. Covers normalization decisions, index selection, migration safety, and connection pooling — the structural foundations that determine whether a database performs well at scale or becomes a maintenance burden. ## When to Use Use for: - Designing new schemas or refactoring existing ones - Deciding whether to normalize or denormalize for a specific query pattern - Choosing index types (B-tree, GIN, GiST, hash, partial, covering) - Planning migrations that must not break running production systems - Implementing soft deletes, polymorphic associations, or composite keys - Configuring PgBouncer or Prisma connection pools NOT for: - Running EXPLAIN ANALYZE or reading query plans → use **postgresql-optimization** - Document model design (MongoDB, DynamoDB) → use a NoSQL skill - Database provisioning, replicas, or infrastructure → use a cloud/infra skill - ORM-specific code generation → use the relevant ORM skill --- ## Normalize vs. Denormalize Decision Tree
Details
- Skill name
database-design-patterns- Repository
- curiositech/some_claude_skills
- Path
.claude/skills/database-design-patterns/SKILL.md- License
- MIT
- Repo updated
- 5 November 2026
FAQ
What does the Database Design Patterns skill do?
Schema design, normalization decisions, indexing strategies, and migration safety for relational databases. Use when designing tables, choosing between normalize vs denormalize, selecting index types, planning zero-downtime migrations, or setting up connection pooling. Activate on "schema design", "normalization", "denormalization", "foreign key", "index strategy", "migration", "connection pooling", "composite key", "surrogate key", "soft delete", "polymorphic association". NOT for PostgreSQL-specific query tuning or EXPLAIN analysis (use postgresql-optimization), NoSQL or document database de
How do I install the Database Design Patterns skill?
Claude Code plugin: /plugin marketplace add curiositech/some_claude_skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Database Design Patterns popular?
It lives in curiositech/some_claude_skills, which has 272 GitHub stars and 46 forks.
Related skills
Email Composer
272curiositech/some_claude_skills
Draft professional emails for various contexts including business, technical, and customer communication. Use when the user needs help writing emails or composing professional messages.
2000s Visualization Expert
272curiositech/some_claude_skills
Expert in 2000s-era music visualization (Milkdrop, AVS, Geiss) and modern WebGL implementations. Specializes in Butterchurn integration, Web Audio API AnalyserNode FFT data, GLSL shaders for audio-reactive visuals, and psychedelic generative art. Activate on "Milkdrop", "music visualization", "WebGL visualizer", "Butterchurn", "audio reactive", "FFT visualization", "spectrum analyzer". NOT for simple bar charts/waveforms (use basic canvas), video editing, or non-audio visuals.
2026 Legal Research Agent
272curiositech/some_claude_skills
Expert legal research agent for finding and scraping expungement data state by state. Knows authoritative sources, URL patterns, Firecrawl configuration, and 2026 legal landscape. Activate on "find expungement data", "scrape state laws", "legal research", "court URLs", "statute sources", "Clean Slate laws", "automatic expungement research". NOT for interpreting laws (use national-expungement-expert), building UI, or legal advice.
Drizzle Migrations
272curiositech/some_claude_skills
Drizzle ORM schema management and SQLite migrations — adding tables, modifying columns, creating indexes, generating and running migrations, Drizzle query patterns. NOT for Prisma, TypeORM, Sequelize, or raw SQL migration tools.
Caching Strategies
272curiositech/some_claude_skills
Design multi-tier caching architectures for web applications — cache-aside vs write-through vs write-behind, TTL design, cache invalidation, Redis patterns, CDN configuration, browser caching, and stampede prevention. Use when choosing a caching pattern, designing cache invalidation strategies, implementing Redis caching, configuring Cache-Control headers, or preventing cache stampedes. Activate on "cache invalidation", "cache-aside", "write-through", "TTL", "Redis cache", "CDN caching", "cache stampede", "stale data", "browser cache". NOT for database query caching within an ORM, memoization
Postgres Helper
192smallnest/goskills
[TODO: Complete and informative explanation of what the skill does and when to use it. Include WHEN to use this skill - specific scenarios, file types, or tasks that trigger it.]
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.