database-design · davila7 — Claude Code skill: what it does, how to install
This skill guides Claude Code through database and ORM selection, schema design, and query tuning. It stops the model from blindly picking PostgreSQL for every project.
npx claude-code-templates@latest --skill development/database-designWhat database-design does
The skill provides architectural rules and reference guides for data modeling. Instead of pasting generic SQL templates, the agent evaluates project requirements, asks clarifying questions, and picks the right engine. It will suggest SQLite for small tools rather than defaulting to PostgreSQL.
Its documentation is split into focused files: database evaluation across PostgreSQL, Neon, Turso, and SQLite (database-selection.md), ORM comparisons for Drizzle, Prisma, and Kysely (orm-selection.md), schema normalization (schema-design.md), indexing strategies (indexing.md), safe migrations (migrations.md), and query optimization with EXPLAIN ANALYZE (optimization.md). The assistant only inspects the file that answers the immediate question.
The checklist stops bad habits like relying on SELECT * in production code or dumping structured entities into JSON columns. The agent will not assemble tables until it confirms the deployment setup and table relationships.
What it helps with
- Pick an optimal database engine between SQLite, PostgreSQL, Neon, and Turso
- Compare ORM and query builder options such as Drizzle, Prisma, or Kysely
- Design normalized database schemas, primary keys, and relations
- Plan index configurations and eliminate N+1 query bottlenecks
- Prepare safe migration steps for serverless database environments
Example prompts for the agent
- Help me design a database schema for an e-commerce backend and suggest composite indexes.
- Which stack works better for a serverless API: Turso with Drizzle or PostgreSQL with Prisma?
- Audit my current queries for N+1 issues and explain the execution plan.
How to install database-design
1claude-code-templates
npx claude-code-templates@latest --skill development/database-design2Skills CLI (Vercel)
npx skills add davila7/claude-code-templates --skill database-design -a claude-code3Manually: put the files in place
~/.claude/skills/database-design/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/database-design/
Manually: put the files in place
.agents/skills/database-design/SKILL.mdFor all projects use ~/.agents/skills/
Manually: put the files in place
.cursor/skills/database-design/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install davila7/claude-code-templates database-design2Manually: put the files in place
.github/skills/database-design/SKILL.mdPlatform CLI
gemini skills install https://github.com/davila7/claude-code-templates --path cli-tool/components/skills/development/database-designManually: put the files in place
.devin/skills/database-design/SKILL.mdThe legacy .windsurf/skills/ path still works
Claude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about database-design
How to install database-design in Claude Code?
Run npx claude-code-templates@latest --skill development/database-design in your terminal.
What does the database-design skill do?
It equips Claude Code with decision frameworks for database architecture, schema normalization, indexing, and migration planning. It enforces context-aware technical choices instead of repeated SQL defaults.
Which bad practices does this skill prevent?
It restricts the agent from using SELECT * queries in production, storing structured data inside raw JSON fields, and ignoring N+1 query issues. It also prevents picking PostgreSQL when a lighter engine like SQLite fits better.
Similar skills
All skills for Data and databases →database-design by other authors comes first.
