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
System Prompt Engineer
Designs optimized system prompts for AI agents with clear instructions, constraints, and output formatting rules.
Debug Root Cause Analyzer
Systematically diagnose bugs and errors using structured root cause analysis — get a clear explanation, fix options, and prevention strategy from any error message or unexpected behavior.
Test Prompt
Test description
RAG System Architect
Build a Retrieval-Augmented Generation system with proper chunking, embedding, and retrieval strategies