JPeetz/agent-skills / skills/data/database-schema-designer
database-schema-designer
VerifiedUse this skill when designing or reviewing database schemas for SQL and NoSQL databases. Covers normalization, indexing strategy, migration management with rollback safety, query optimization, and multi-tenant patterns. Supports PostgreSQL, MySQL, SQLite, MongoDB, and Vitess.
| File | Kind | Size |
|---|---|---|
| CHANGELOG.md | markdown | 864 B |
| LICENSE | other | 1.1 KB |
| SKILL.md | skill md | 10.0 KB |
| corrections.log | other | 108 B |
| evals/cases.md | markdown | 2.7 KB |
| evals/evals.json | config | 3.2 KB |
CHANGELOG.md
View on GitHub# Changelog — Database Schema Designer
## v1.0.0 — 2026-06-30
- Initial release from Skill Foundry
- Domain modeling canvas for schema-first design
- SQL normalization checklist (1NF to BCNF)
- Indexing strategy with selection algorithm and anti-patterns
- Safe migration design with rollback patterns (8 safe-migration rules)
- Query optimization workflow using EXPLAIN ANALYZE
- Multi-tenant architecture patterns (DB/schema/row-level/hybrid)
- NoSQL design patterns (MongoDB embedding vs. referencing, Redis)
- Source: PlanetScale Database Skills, Supabase Agent Skills, softaworks/agent-toolkit
## Published 2026-07-02
- Published to JPeetz/agent-skills repository (Run 005)
## v1.0.1 — 2026-10-28
### Changed
- Description rewritten to trigger form ("Use this skill when...")
- Added evals/evals.json with 6 cases (5 positive, 1 near-miss negative)
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |