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
On-Device AI App Feature Planner
Plans a mobile app feature set that runs entirely on-device using small AI models like Gemma 4 or Llama, with offline-first architecture and privacy-by-design principles.
Code Migration Planner
Creates a detailed migration plan for moving codebases between frameworks, languages, or architectures — with risk assessment, phased steps, and rollback strategy.
API Documentation Generator
Generate comprehensive API documentation including endpoints, parameters, responses, and examples.
Database Migration Plan
Create a comprehensive plan for migrating between databases