database-design skill
Designs or reviews relational, document, key-value, graph, or search data models with ownership, invariants, access paths, migrations, consistency, retention, privacy, and recovery behavior. Use for schema changes, new data stores, indexes, migrations, persistence boundaries, or query-driven design. Not for a query-only bug without a model change or for API contract design.
- GitHub stars
- 100
- Files
- 2
- Last commit
- Aug 26, 2026
- License
- MIT
- Allowed tools
- —
What does the database-design skill do?
database-design designs or reviews relational, document, key-value, graph, or search data models with ownership, invariants, access paths, migrations, consistency, retention, privacy, and recovery behavior. Use for schema changes, new data stores, indexes, migrations, persistence boundaries, or query-driven design. Not for a query-only bug without a model change or for API contract design.
How to install the database-design skill
Each command copies the skill folder into the client's skills directory. Restart the client or start a new session to load it.Install the database-design skill in Plugin
/plugin marketplace add thiientv/godmode /plugin install godmode@godmode
Install the database-design skill in Claude Code
~/.claude/skills/database-design/SKILL.md
$ npx degit thiientv/godmode/skills/database-design ~/.claude/skills/database-designInstall the database-design skill in Claude Code (project)
.claude/skills/database-design/SKILL.md
$ npx degit thiientv/godmode/skills/database-design .claude/skills/database-designInstall the database-design skill in Codex
~/.agents/skills/database-design/SKILL.md
$ npx degit thiientv/godmode/skills/database-design ~/.agents/skills/database-designInstall the database-design skill in Gemini CLI
~/.gemini/skills/database-design/SKILL.md
$ npx degit thiientv/godmode/skills/database-design ~/.gemini/skills/database-designInstall the database-design skill in Claude.ai
npx degit thiientv/godmode/skills/database-design database-design && zip -r database-design.zip database-design # claude.ai → Customize → Skills → + → Create skill → Upload a skill → database-design.zip
SKILL.md
View on GitHubDatabase Design
Start from invariants and access patterns; a schema is an operational contract.
Design sequence
- Identify entities, ownership, lifecycle, source of truth, cardinality, and deletion/retention rules.
- Write invariants and transaction boundaries before choosing tables or collections.
- Map real reads, writes, filters, sorts, joins, uniqueness, and expected scale. Add indexes for measured access paths, not guesses.
- Decide consistency, isolation, idempotency, concurrency, and failure recovery at each boundary.
- Design an expand-migrate-contract migration: backward-compatible expand, backfill/dual-write when needed, cutover, verification, and cleanup.
- Protect sensitive data with least privilege, encryption, minimization, auditability, and retention limits.
Read schema-checklist.md. Include rollback, backup/restore, lock duration, online migration behavior, and observability in the plan. Treat production data as irreplaceable unless a tested recovery path proves otherwise.
Evidence
Use representative query plans, migration rehearsal on a safe fixture, invariant tests, concurrency checks, and restore evidence. A migration that applies once is not proven safe to roll forward, retry, or roll back.
Completion condition
The model's invariants, access paths, migration lifecycle, privacy boundary, recovery path, and proof commands are explicit.
Files in this skill
2database-design skill questions
How do I install the database-design skill in Claude Code?
Run npx degit thiientv/godmode/skills/database-design ~/.claude/skills/database-design. Claude Code loads skills from ~/.claude/skills (all projects) or .claude/skills (one project) and uses a skill when its description matches the task.
Which clients can use the database-design skill?
Any client that reads the Agent Skills format: Claude Code, Codex, Gemini CLI and claude.ai (upload as a ZIP). Scripts in the skill run only where the client allows code execution.