Dashboard Design Brief
Write a complete brief for a data dashboard — what to show, how to organize it, and what decisions it should drive.
Write complex SQL queries from a plain English description of what you need — with explanations.
Write a SQL query based on my plain English description. **What I need the query to do:** [Describe what you want to retrieve, calculate, or update in plain English] **My database schema:** [Paste your table definitions, or describe the tables and their columns. e.g.: - users (id, name, email, created_at, plan_type) - orders (id, user_id, amount, status, created_at) - products (id, name, category, price)] **Database type:** [PostgreSQL / MySQL / SQLite / BigQuery / Snowflake / SQL Server / other] **Any filters, conditions, or constraints:** [e.g. only last 30 days, only paying customers, exclude cancelled orders, group by month] **Output format I need:** [e.g. one row per user, aggregated totals, ranked list, percentage breakdown] Write the SQL query with: 1. The complete, runnable query 2. A plain English walkthrough of what each clause does 3. Any indexes or columns that should exist for this query to perform well 4. Edge cases to watch for (e.g. NULLs, duplicates, empty joins) 5. An alternative approach if there's a simpler or faster way to get the same result
Writing SQL queries from plain English descriptions for data extraction, reporting, analytics, and database operations.
A complete, runnable SQL query with a clause-by-clause explanation, performance notes, edge case warnings, and an alternative approach if one exists.
Sign in to leave a comment.
No comments yet.
Be the first to share your thoughts.
Works best with
Claude Sonnet 4
Write a complete brief for a data dashboard — what to show, how to organize it, and what decisions it should drive.
Design a structured analysis plan — what to measure, how to measure it, and how to avoid common analytical mistakes.
Define the right metrics and KPIs for a goal — including how to measure them, what good looks like, and what to avoid tracking.