Design Database Schema
Design optimized database schemas with proper relationships, constraints, and performance considerations
npx claude-code-templates@latest --command setup/design-database-schema Scanned by NVIDIA SkillSpector
Automated static analysis (no LLM) · v2.12.0 · 2026-10-23
Partial analysis: some checks could not run on this component.
SkillSpector looks for patterns such as shell commands, credential access, network calls or unpinned dependencies. An observation is something worth reading in the files before you install, not a confirmed vulnerability. Components that run code locally, like hooks, MCP servers and security tooling, naturally show more of them.
No observations.
Learn more about NVIDIA SkillSpector.
Content
Design Database Schema
Design optimized database schemas with comprehensive data modeling: $ARGUMENTS
Current Project Context
- Application type: Based on $ARGUMENTS or codebase analysis
- Data requirements: @requirements/ or project documentation
- Existing schema: @prisma/schema.prisma or @migrations/ or database dumps
- Performance needs: Expected scale, query patterns, and data volume
Task
Design comprehensive database schema with optimal structure and performance:
Schema Type: Use $ARGUMENTS to specify relational, NoSQL, hybrid approach, or normalization level
Design Framework:
- Requirements Analysis - Business entities, relationships, data flow, and access patterns
- Entity Modeling - Tables/collections, attributes, primary/foreign keys, constraints
- Relationship Design - One-to-one, one-to-many, many-to-many associations
- Normalization Strategy - Data consistency vs performance trade-offs
- Performance Optimization - Indexing strategy, query optimization, partitioning
- Security Design - Access control, data encryption, audit trails
Advanced Patterns: Implement temporal data, soft deletes, JSONB fields, full-text search, audit logging, and scalability patterns.
Validation: Ensure referential integrity, data consistency, query performance, and future extensibility.
Output: Complete schema design with DDL scripts, ER diagrams, performance analysis, and migration strategy.