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
MCP Server Builder Guide
Step-by-step guide to build a Model Context Protocol server for any data source
Few-Shot Learning Prompt Builder
Create effective few-shot learning prompts with examples that teach AI models new tasks quickly.
Vibe Coding App Spec Writer
Turn a raw app idea into a precise, AI-ready specification document optimized for vibe coding tools like Bolt.new, Lovable, and NxCode.
Red Team Security Tester
Act as a red team attacker to identify vulnerabilities in systems, code, or proposals