database-design – Design & UI skill for AI agents
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
Install the database-design skill with one command
Pick the tool you use, copy the command and paste it in your terminal. The skill lands in that tool's skills folder and is ready in your next session.
Claude Code
mkdir -p ~/.claude/skills && curl -fsSL https://skill.dn1nguoi.com/z/database-design-af7b0.tgz | tar xz -C ~/.claude/skills
Call it in Claude Code: /database-design – then describe the task you want done.
Codex
mkdir -p ~/.codex/skills && curl -fsSL https://skill.dn1nguoi.com/z/database-design-af7b0.tgz | tar xz -C ~/.codex/skills
Call it in Codex: $database-design – then describe the task you want done.
Hermes Agent
mkdir -p ~/.hermes/skills && curl -fsSL https://skill.dn1nguoi.com/z/database-design-af7b0.tgz | tar xz -C ~/.hermes/skills
Call it in Hermes Agent: /database-design – then describe the task you want done.
DeepSeek
mkdir -p ~/.deepcode/skills && curl -fsSL https://skill.dn1nguoi.com/z/database-design-af7b0.tgz | tar xz -C ~/.deepcode/skills
Call it in DeepSeek: /database-design – then describe the task you want done.
SKILL.md content
Database Design
> Learn to THINK, not copy SQL patterns.
🎯 Selective Reading Rule
Read ONLY files relevant to the request! Check the content map, find what you need.
| File | Description | When to Read |
|------|-------------|--------------|
| database-selection.md | PostgreSQL vs Neon vs Turso vs SQLite | Choosing database |
| orm-selection.md | Drizzle vs Prisma vs Kysely | Choosing ORM |
| schema-design.md | Normalization, PKs, relationships | Designing schema |
| indexing.md | Index types, composite indexes | Performance tuning |
| optimization.md | N+1, EXPLAIN ANALYZE | Query optimization |
| migrations.md | Safe migrations, serverless DBs | Schema changes |
---
⚠️ Core Principle
- ASK user for database preferences when unclear
- Choose database/ORM based on CONTEXT
- Don't default to PostgreSQL for everything
---
Decision Checklist
Before designing schema:
- [ ] Asked user about database preference?
- [ ] Chosen database for THIS context?
- [ ] Considered deployment environment?
- [ ] Planned index strategy?
- [ ] Defined relationship types?
---
Anti-Patterns
❌ Default to PostgreSQL for simple apps (SQLite may suffice)
❌ Skip indexing
❌ Use SELECT * in production
❌ Store JSON when structured data is better
❌ Ignore N+1 queries
When to Use
Use when selecting a database model, reviewing schema relationships and indexes, or assessing a proposed schema with the bundled advisory tools.
Schema helper
scripts/schema_validator.py is a read-only heuristic inventory, not a Prisma or Drizzle parser. Missing schemas, unsupported formats and heuristic-only results return nonzero with passed: false and analysis_complete: false. Use the project-local ORM validator for syntax and type checks; review migration and constraint semantics separately.
Limitations
- Use this skill only when the task clearly matches the scope described above.
- Do not treat the output as a substitute for environment-specific validation, testing, or expert review.
- Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.
Related skills
- segment-anything-model – SAM: zero-shot image segmentation via points, boxes, masks.
- ddd-strategic-design – Design DDD strategic artifacts including subdomains, bounded contexts, and ubiquitous…
- visual-recon – Screenshot all live hosts for rapid visual triage and technology fingerprinting.
- observability-designer – Design production-ready observability strategies combining metrics, logs, and traces…
- design-it – Routes frontend design tasks to 48 specific UI styles. Triggers for websites, app…
- design-md – Analyze Stitch projects and synthesize a semantic design system into DESIGN.md files
- design-philosophy – Visual philosophy and art-direction for frontend. Use when creating high-concept work…
- design-spatial – Design — spatial composition