Database Design
Schema, indexing, query-optimization and migration playbook for SQL/NoSQL
Test report
- Verdict
- Tested · Works
- Score
- Tested
- Jul 20, 2026
- Environment
- Claude Code 2.x (agent harness)
- Upstream re-checked
- Aug 10, 2026 · 7b18c69
Trigger phrasings — SHOULD load: (1) "Design a schema for a multi-tenant orders system"; (2) "This Prisma query is slow, I think I have an N+1 problem"; (3) "How do I plan a zero-downtime migration to rename a column?". Should NOT load: (4) "Build me a dashboard UI that displays user data" (frontend, adjacent via 'data'); (5) "Debug why my REST endpoint returns 500" (backend, no DB work). All 5 judged correctly = 5/5. Output measured: skill-guided result added a trigger-maintained comment_count counter, a partial index WHERE status='pending', CONCURRENTLY index creation, and cursor pagination that the baseline missed — clearly better with specifics (8/10). Docs claims (SQL+NoSQL schema/indexing/query-opt/migrations) match the body with no overselling.
Scored on four weighted criteria — install, triggering, output vs. baseline, docs. How scoring works
- Installs cleanly 5/5
- Triggers reliably 5/5
- Output vs. baseline 8/10
- Docs & honesty 5/5
What Database Design does
A pure-prompt reference skill that guides schema normalization, index selection, EXPLAIN reading, N+1 prevention, zero-downtime migrations, connection pooling, and ORM/NoSQL patterns. Triggers when the task involves designing tables, optimizing queries, planning migrations, or fixing database performance. Self-contained markdown with concrete SQL/Python/JS examples.
How to install Database Design
Clone the repo and copy the skill directory into your Claude config: `git clone https://github.com/CloudAI-X/claude-workflow-v2 && cp -r claude-workflow-v2/skills/database-design ~/.claude/skills/`. Or add the whole marketplace as the `project-starter` plugin via `/plugin marketplace add CloudAI-X/claude-workflow-v2`.
Skills live in ~/.claude/skills/ (global) or .claude/skills/
(per-project). Restart Claude Code after installing.
Commands — how to trigger Database Design
-
/database-designSchema, indexing, query-optimization and migration playbook for SQL/NoSQL
It also activates on plain-language prompts like these:
-
Design a schema for this new feature's data -
Fix the N+1 query problem in this endpoint -
Plan a migration for adding this new table
Frequently asked questions
- Is the Database Design skill free?
- Yes. The skill itself is free from CloudAI-X/claude-workflow-v2. SkillProof publishes the install command and an independent test verdict at no cost.
- Does Database Design work with Claude Code?
- We tested it with Claude Code 2.x (agent harness) on Jul 20, 2026. Verdict: Tested · Works. Trigger phrasings — SHOULD load: (1) "Design a schema for a multi-tenant orders system"; (2) "This Prisma query is slow, I think I have an N+1 problem"; (3) "How do I plan a zero-downtime migration to rename a column?". Should NOT load: (4) "Build me a dashboard UI that displays user data" (frontend, adjacent via 'data'); (5) "Debug why my REST endpoint returns 500" (backend, no DB work). All 5 judged correctly = 5/5. Output measured: skill-guided result added a trigger-maintained comment_count counter, a partial index WHERE status='pending', CONCURRENTLY index creation, and cursor pagination that the baseline missed — clearly better with specifics (8/10). Docs claims (SQL+NoSQL schema/indexing/query-opt/migrations) match the body with no overselling.
- What is the Database Design SkillProof Score?
- 9.2/10 — installs cleanly 5/5, triggers reliably 5/5, output vs. baseline 8/10, docs & honesty 5/5.
- How do I install Database Design?
- Copy the install command from this page, run it in your terminal, and restart Claude Code. Skills live in ~/.claude/skills/ (global) or .claude/skills/ inside a project.
- Can I use Database Design with Cursor, Copilot, Gemini CLI, Codex or other AI tools?
- The SKILL.md format is native to Claude (Claude Code, Desktop, claude.ai). The instructions inside adapt to other assistants: Cursor rules, GitHub Copilot instructions, Windsurf rules, Custom GPTs, AGENTS.md for OpenAI Codex, and GEMINI.md for Google Gemini CLI — our conversion guides cover each, and the free converter on the tools page does the wrapping for you.