Database Schema Design
Handles PostgreSQL and MySQL schema design with built-in templates for common patterns like one-to-many relationships, many-to-many junction tables, and soft deletes. The real value is in the error prevention: it catches missing primary keys, unindexed foreign keys, VARCHAR(MAX) abuse, and the EAV anti-pattern before they become production problems. Includes normalization rules up to 3NF with concrete examples, plus audit column patterns and constraint templates. If you're designing a new database or reviewing an existing schema that feels off, this gives you the checklist and SQL patterns to fix it properly. The critical errors section alone is worth having on hand during code review.
- skills.sh installs
- 437
- GitHub stars
- 248
- last updated
- Aug 21, 2026
Install
$ npx -y skills add secondsky/claude-skills --skill database-schema-design --agent claude-codeInstalls into .claude/skills of the current project.
Files
Handles PostgreSQL and MySQL schema design with built-in templates for common patterns like one-to-many relationships, many-to-many junction tables, and soft deletes. The real value is in the error prevention: it catches missing primary keys, unindexed foreign keys, VARCHAR(MAX) abuse, and the EAV anti-pattern before they become production problems. Includes normalization rules up to 3NF with concrete examples, plus audit column patterns and constraint templates. If you're designing a new database or reviewing an existing schema that feels off, this gives you the checklist and SQL patterns to fix it properly. The critical errors section alone is worth having on hand during code review.
Browse the repository on GitHubSponsors
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/secondsky/claude-skills
- Categories
- Backend & APIs, Code Review & Quality, Design & UI/UX, Databases
- First seen
- Jun 3, 2026
More from secondsky/claude-skills
All 146- Recommendation Engine437
- Seo Keyword Cluster Builder437
- Bun Sveltekit436
- Push Notification Setup436
- Drizzle Orm D1435
- Api Response Optimization434
- Api Pagination433
- Api Filtering Sorting432
- Defense In Depth Validation430
- Session Management427
- Ultracite426
- Nuxt Production425
- Api Gateway Configuration422
- Oauth Implementation422
- Nuxt Ui V4421
- Health Check Endpoints420
- Cloudflare D1416
- Api Changelog Versioning415
- Dependency Upgrade415
- Idempotency Handling415
- Nuxt Server415
- Turborepo414
- Mobile Offline Support412
- Recommendation System412
Recommended
More Backend & APIs
better-authjezweb/claude-skillsSelf-hosted auth for TypeScript/Cloudflare Workers with social auth, 2FA, passkeys, organizations, RBAC, and 15+ plugins. Requires Drizzle ORM or Kysely for D1 434skills.sh installs
nuxt-serversecondsky/claude-skills| Nuxt 4 server-side development with Nitro: API routes, server middleware, database integration, and backend patterns. Use when: creating server API routes, im415skills.sh installs
better-authmrgoonie/claudekit-skillsImplement authentication and authorization with Better Auth - a framework-agnostic TypeScript authentication framework. Features include email/password authenti396skills.sh installs
firebasedavila7/claude-code-templatesFirebase gives you a complete backend in minutes - auth, database, storage, functions, hosting. But the ease of setup hides real complexity. Security rules are 390skills.sh installsprisma-expertdavila7/claude-code-templatesPrisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations. Use PROACTIVELY for Prisma schema issues, migr386skills.sh installs
ln-113-backend-docs-creatorlevnikolaevich/claude-code-skillsCreates backend docs (api_spec.md, database_schema.md). Use when project has backend API or database.384skills.sh installs