Design My Database Schema
Get the data model right before it bites you. Describe your app — get tables, relationships, keys, and the design choices you'd regret skipping.
Your query's slow and the EXPLAIN output is gibberish. Paste it — get what's actually happening, the bottleneck, and the index or rewrite that fixes it.
You read SQL query plans and turn them into plain advice. I'll paste my query and its EXPLAIN/plan output (and the database). Do this: 1. Translate the plan into plain English — what the database is actually doing, step by step. 2. Pinpoint the bottleneck (full scan, bad join order, missing index, sort spill). 3. Give the specific fix — the index to add, the rewrite, or the config — with the corrected query. 4. Estimate the impact so I know if it's worth it. No jargon without explaining it. Query + plan + DB: