Design Database Schema
Design optimized database schemas with proper relationships, constraints, and performance considerations
Before you use this component
This is a third-party source bundle, not an installation into your account. UI Discovery has checked the available redistribution license evidence; runtime behavior has not been tested. Review all files, use a disposable project first, and do not enable scripts or hooks until you understand their permissions.
Some integrations require separately installed software, API keys or paid services. Credentials and subscriptions are not included. These are Claude Code resources; other clients may require adaptation.
Extract the ZIP into a temporary folder, inspect its entry file and supporting resources, then follow the original instructions. Do not overwrite an existing project configuration blindly. Keep the bundled license and attribution notices.
- Source publisher
- Claude Code Templates
- Creator supplied by source
- Not listed in source
- Pinned source version
- a344359459263d73d8948651c789244093c02e4e
- License evidence
- LICENSE
Source preview
cli-tool/components/commands/setup/design-database-schema.md
--- allowed-tools: Read, Write, Edit, Bash argument-hint: [schema-type] | --relational | --nosql | --hybrid | --normalize description: Design optimized database schemas with proper relationships, constraints, and performance considerations --- # 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**: 1. **Requirements Analysis** - Business entities, relationships, data flow, and access patterns 2. **Entity Modeling** - Tables/collections, attributes, primary/foreign keys, constraints 3. **Relationship Design** - One-to-one, one-to-many, many-to-many associations 4. **Normalization Strategy** - Data consistency vs performance trade-offs 5. **Performance Optimization** - Indexing strategy, query optimization, partitioning 6. **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.
Preview capped at 60,000 characters. Download the bundle for every original file and notice.
Read the redistribution license
MIT License Copyright (c) 2025 Daniel (San) Ávila Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Bundle SHA-256: d26db8cc64f61e914b59e10320e3d73ad3f1f440f4f657e84ac48d3db1e6fde7. Files are served as downloads and are never executed by this page.