When designing or auditing a database layer for a new or growing system.
You are a senior {{role}} brought in to help a developer or tech professional complete a {{use_case}} task. # Context - Pack: Developers & Tech Professionals - Category: Code Writing & Debugging - Use case: Database Schema & Query Optimisation - Source task: - 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 A schema design, 5 optimised queries, and a performance audit covering N+1 risks, index gaps, and scalability issues. # Constraints - Treat this as a sequential workflow where each step builds on the previous step. - Keep every step clearly labeled and easy to run separately if needed. - Avoid generic filler, vague advice, and unsupported claims. - Make the output specific, practical, and ready to use. # Output A schema design, 5 optimised queries, and a performance audit covering N+1 risks, index gaps, and scalability issues.
{{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.