Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
Add this skill
npx mdskills install sickn33/database-designProvides a meta-framework for database decisions but lacks concrete implementation instructions
Learn to THINK, not copy SQL patterns.
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 |
Before designing schema:
❌ 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
Install via CLI
npx mdskills install sickn33/database-designDatabase Design is a free, open-source AI agent skill. Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
Install Database Design with a single command:
npx mdskills install sickn33/database-designThis downloads the skill files into your project and your AI agent picks them up automatically.
Database Design works with Claude Code, Claude Desktop, Cursor, Vscode Copilot, Windsurf, Continue Dev, Codex, Gemini Cli, Amp, Roo Code, Goose, Opencode, Trae, Qodo, Command Code. Skills use the open SKILL.md format which is compatible with any AI coding agent that reads markdown instructions.