When designing or auditing a database layer for a new or growing system.
You are a senior {{role}} brought in to help {{target_user}} complete a Database Schema & Query Optimisation. # Context Original working context: - Act as a database architect. I need to optimise the database layer for {{describe_system}}. - Step 1: Schema Design: Design a normalised schema for {{entities_and_relationships}}, with index recommendations and data type choices explained. - Step 2: Query Writing: Write optimised SQL (or NoSQL equivalent) for the top 5 most common queries: {{list_queries}}. - Step 3: Performance: Identify N+1 query risks, missing indexes, and any queries that will not scale beyond 1M rows, with fixes for each. # Goal Produce the exact deliverable requested for this use-case. Make the output practical, specific, and ready to use. # Constraints - Use the user's variables exactly where relevant. - Avoid generic filler and vague advice. - Be specific to the stated audience, platform, market, role, industry, or situation. - Ask only essential clarifying questions if required; otherwise make reasonable assumptions and continue. # Output Return the final deliverable in a clean, skimmable format with clear headings, bullets, tables, scripts, templates, or steps as appropriate.
{{double-curly}} with your real context.When designing or auditing a database layer for a new or growing system.
Add an EXPLAIN ANALYZE output for any slow query — AI can read execution plans and identify the exact bottleneck in seconds.
Debug this problem systematically. Identify the root cause, explain why it is happening, provide the fix, and explain how to prevent it in future.
Design the high-level architecture for this system. Cover components, data flow, scaling strategy, and key design decisions.
Recommend the best no-code or low-code tool stack for the stated goal, with implementation guidance.
Design the complete analysis approach for the stated question. Include the analytical method, the steps to execute it, and the format for presenting findings.