Database Schema Design
This one helps you design schemas that won't embarrass you six months later. It walks you through choosing relational versus document storage with actual reasons, modeling ownership boundaries and lifecycle rules, justifying every index, and planning migrations that account for backfills and compatibility windows. The intake checklist keeps you from designing storage on vibes alone, and the route-outs send API contracts to api-design and auth modeling to authentication-setup so you stay focused on the data layer. Best for backend and fullstack work where schema choices ripple through integrity, query performance, and rollout safety across Postgres, MySQL, MongoDB, or similar stacks.
- skills.sh installs
- 172
- GitHub stars
- 22
- last updated
- Jun 3, 2026
Install
$ npx -y skills add akillness/oh-my-skills --skill database-schema-design --agent claude-codeInstalls into .claude/skills of the current project.
Files
Database Schema Design
Use this skill when the main job is choosing and evolving the storage model, not dumping generic SQL or ORM snippets.
database-schema-design is the backend storage-design anchor for:
- choosing between relational-first, document-heavy, and hybrid models
- turning domain entities into tables, collections, ownership boundaries, and lifecycle rules
- justifying constraints, indexes, tenant scope, history/audit structures, and deletion/retention behavior
- planning staged schema evolution so migrations, backfills, and cleanup are believable
- handing downstream teams one compact storage-design packet before implementation, verification, reporting, or observability work branches out
Read these support docs before handling larger or riskier work:
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/akillness/oh-my-skills
- Categories
- Backend & APIs, Design & UI/UX, Databases
- First seen
- Jun 3, 2026
More from akillness/oh-my-skills
All 81- React Best Practices172
- Agentation171
- Bmad Idea171
- Code Review171
- Marketing Automation171
- Obsidian Plugin171
- Opencontext171
- Standup Meeting171
- Task Estimation171
- Ui Component Patterns171
- Changelog Maintenance170
- Monitoring Observability170
- Sprint Retrospective170
- Deployment Automation169
- Ohmg169
- Security Best Practices169
- Authentication Setup168
- Fabric168
- Firebase Ai Logic168
- Debugging167
- Environment Setup167
- Git Submodule167
- Git Workflow167
- Marketing Skills Collection167
Recommended
More Backend & APIs
postgresql-best-practiceswimolivier/postgresql-best-practicespostgresql best practices172skills.sh installs
microsoft-azure-sql-databasemembranedev/application-skillsMicrosoft Azure SQL Database integration. Manage data, records, and automate workflows. Use when the user wants to interact with Microsoft Azure SQL Database da161skills.sh installs