Explain this query: Free AI Prompt | SheCodes

Free AI prompt · The Code Book

Explain this query

A ready-to-use prompt from the chapter SQL & CRUD Basics. Paste it into Claude, ChatGPT, Lovable, Bolt or any AI coding tool.

The prompt

“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?”

How to use it

  1. Fill in the blanks with your own details, so the AI builds your project, not a generic one.
  2. Copy the prompt and paste it into your AI coding tool.
  3. Check the result in the preview, then ask for changes one at a time: "make the buttons bigger", "use my brand colours".
  4. Read the chapter to understand why it works and what to do next.

More prompts like this

All prompts

Write a query for me

“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.”

Optimize a slow query

“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 frontend project

“Set up a new Next.js project with TypeScript, Tailwind CSS, and App Router. Create a clean homepage with a [header/hero/features] layout.”

Add multi-page navigation

“Convert my single-page app into multiple pages with proper navigation. Add routes for [home, about, dashboard, settings].”

Make it responsive

“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 with supabase

“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.”