database-design

Database design principles and decision-making.

IndexedMIT★ 123

Install

Works with Claude Code, Claude apps, Codex, Cursor, Gemini CLI, GitHub Copilot, VS Code, OpenCode, Goose, Windsurf. Read the repository before you give any tool access to your data.

npx agentmarket install skill/agent-skills-hub-database-design

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

About

Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.

Use cases: design, backend, cloud

Reviews

Write a review

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this skill can do and what it asks for, from its SKILL.md. Checked Oct 25, 2026.

Tools: No tools found
Secrets: None asked for
Install scripts: None found
Runs as: Python package

Network hosts it talks to 1

codeload.github.com · found in install command

Files it touches

~/.claude/skills/database-design

Tools it pre-approves 5

From allowed-tools in SKILL.md: the agent may use these without asking you each time.

Read,
Write,
Edit,
Glob,
Grep

What's inside

Skill name: database-design
Description: Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
License: MIT
Allowed tools: Read,, Write,, Edit,, Glob,, Grep
Instructions: 48 lines in SKILL.md · view on GitHub

Before installing

Ships executable scripts

Files (8)

SKILL.md
database-selection.md
indexing.md
migrations.md
optimization.md
orm-selection.md
schema-design.md
schema_validator.py · scripts/

SKILL.md (first lines)

# 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

From agent-skills-hub/agent-skills-hub, MIT.

Signals

Stars: 123
Forks: 44
Open issues: 6
Last commit (this folder): Feb 10, 2026 (8 months ago)
Last release: Mar 2, 2026 (8 months ago)

From GitHub (fetched Oct 24, 2026).

Details

License: MIT
Repository: github.com/agent-skills-hub/agent-skills-hub
Website: agent-skills-hub.github.io/
First seen: Oct 24, 2026
Last checked: Oct 24, 2026
Source: GitHub github-graphql

Same skill elsewhere

Copies of this SKILL.md published by others; search shows only one of them.

More from agent-skills-hub

Cite this page

database-design skill. Agent Mart. https://agentmart.dev/skills/agent-skills-hub-database-design (last updated 2026-10-24)