database-design
/database-design
Picks a database and ORM, designs schemas and indexes, plans safe migrations. Use when designing a schema, adding indexes or planning a migration.
- Author
- jeffersonvalente ↗
- Repository
- cardume ↗
- Licence
- MIT
- Last repository change
- 04.11.2026
Assessment and security
- Files in this package
- 8
- Scripts
- 1
- HTML comments
- 0
- URLs in SKILL.md
- 0
No signals detected. Repository changed on 04.11.2026, without references to retired models or APIs.
MIT, open: use and modify while retaining author attribution.
- 1 scripts in this package. Review them before installing, as Claude may execute them.
Scripts: scripts/schema_validator.py
What it does and when to use it
Picks a database and ORM, designs schemas and indexes, plans safe migrations. Use when designing a schema, adding indexes or planning a migration.
Original author description
Picks a database and ORM, designs schemas and indexes, plans safe migrations. Use when designing a schema, adding indexes or planning a migration.
How it works
- Selective Reading
- ⚠️ Core Principle
- Decision Checklist
- Anti-Patterns
SKILL.md preview
--- name: database-design description: "Picks a database and ORM, designs schemas and indexes, plans safe migrations. Use when designing a schema, adding indexes or planning a migration." allowed-tools: Read Write Edit Glob Grep --- # Database Design > Reason from principles rather than copying SQL patterns. ## Selective Reading Read only the files relevant to the request, using this map, to keep context small. | 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 (UUIDv7), 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
Files in this package (8)
- SKILL.md 2 KB
- database-selection.md 1 KB
- indexing.md 1 KB
- migrations.md 1 KB
- optimization.md 1 KB
- orm-selection.md 1 KB
- schema-design.md 2 KB
- scripts/schema_validator.py 5 KB
Versions
| Repository | Score | Licence |
|---|---|---|
| This page · jeffersonvalente/cardume | 90 | MIT |
| Reprograme/redevkit | 100 | MIT |
| svngoku/coding-agents-skills | 100 | MIT |
| projanvil/mindforge | 100 | MIT |
| krzysztofsurdy/code-virtuoso | 100 | MIT |
| projanvil/mindforge | 100 | MIT |
| RainingDaemons/agents | 100 | MIT |
| cloudai-x/claude-workflow-v2 | 100 | MIT |
| MoizIbnYousaf/ai-agent-skills | 100 | MIT |
Database snapshot: 13.11.2026 · package version ace25cddabfc (SHA-256 digest of the entire package)
Downloads in the last 30 days: 0 · ranking
Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.
Similar skills
- 100database-migrations
Plans and writes zero-downtime database schema migrations (expand/contract, safe indexes, batched backfills, rollback). Use when adding, renaming or dropping columns or tables, changing types or constraints, adding indexes, or backfilling data on a live database. - 100database-schema-designer
Design a new relational schema from product requirements: tables, ORM models, RLS, indexes, migrations and an ERD. Use when modelling a new feature, adding multi-tenancy or soft deletes, or writing Drizzle/Prisma/Alembic schemas. - 100designing-database-schemas
Process use when you need to work with database schema design. This skill provides schema design and migrations with comprehensive guidance and automation. Trigger with phrases like "design schema", "create migration", or "model database". - 100designing-database-schemas
Process use when you need to work with database schema design. This skill provides schema design and migrations with comprehensive guidance and automation. Trigger with phrases like "design schema", "create migration", or "model database". - 100uw-analyze-database
Use when analyzing the database layer including schema, migrations, ORM configuration, and data access patterns - 100db-stinger
Design PostgreSQL data layers. Use for schema, indexes, migrations, query performance, ORM choice, or serverless databases. Read guides/ for the decision path.