Database Schema Designer
Design optimized database schemas from business requirements
Content
Design a database schema for the following application: Application: {{app_description}} Database type: {{db_type}} Key entities: {{entities}} Expected scale: {{scale}} Provide: 1. Entity-Relationship diagram (text representation) 2. Complete table/collection definitions with: - Column names, types, constraints - Primary and foreign keys - Indexes for common query patterns 3. Sample queries for the 5 most common operations 4. Migration script (CREATE TABLE statements or equivalent) 5. Performance considerations and optimization notes 6. Suggested partitioning strategy if applicable Follow {{db_type}} best practices and naming conventions.
Related Prompts
SQL Query Optimizer
Optimize SQL queries for performance and best practices
Code Review Security Auditor
Perform a security-focused code review identifying vulnerabilities
Legacy Code Refactoring Plan
Creates a step-by-step refactoring plan for legacy code with risk assessment
Security Threat Model Generator
Generates a structured security threat model for an application or system using the STRIDE framework, identifying attack surfaces, threats, and mitigations.