Explain this query
“Here's a SQL query I don't understand: [paste query]. Explain what it does step by step in plain English. What table does it touch, what does it filter, what does it return?”
Free AI prompt · The Code Book
A ready-to-use prompt from the chapter SQL & CRUD Basics. Paste it into Claude, ChatGPT, Lovable, Bolt or any AI coding tool.
“Write a SQL query that does the following: [describe what you want, e.g., 'show all orders from the last 30 days with the customer name, sorted by order total descending']. Use my Supabase / Postgres database. Explain what the query does in plain English so I understand it.”
“Here's a SQL query I don't understand: [paste query]. Explain what it does step by step in plain English. What table does it touch, what does it filter, what does it return?”
“This query is slow: [paste query]. Tell me what's making it slow and how to fix it. If I need to add an index, write the CREATE INDEX statement and explain what it does.”
“Set up a new Next.js project with TypeScript, Tailwind CSS, and App Router. Create a clean homepage with a [header/hero/features] layout.”
“Convert my single-page app into multiple pages with proper navigation. Add routes for [home, about, dashboard, settings].”
“Make my website fully responsive so it looks great on phones, tablets, and desktops. Use Tailwind CSS breakpoints and make sure the navigation works on mobile with a hamburger menu.”
“Set up a backend for my app using Supabase. I need tables for [users, posts, comments]. Include row-level security policies so users can only edit their own data.”