ChatGPT prompt to write an SQL query
Coding and ITFree prompt
Describe your tables and ask your question in plain English: the AI writes the SQL query for your database, explains it and flags the pitfalls.
Your prompt
The fields stay in your browser. The prompt is only sent to the AI service you choose to open.
How do I write an SQL query with ChatGPT?
Ask your question in plain English, state your database (MySQL, PostgreSQL…) and paste the structure of the relevant tables. Ask for a readable query explained clause by clause, with no invented columns. The Lunyce prompt prepares this request; test the query on a copy before changing any data.
How to use it
- Ask your question in plain English and state your database (MySQL, PostgreSQL, SQL Server, SQLite…).
- Paste the table structure: names and columns are enough, no need for the data.
- Copy or open the prompt, then test the query on a copy or with a row limit.
Tips for better results
- Paste only the table structure, never real customer data.
- To get the structure, use SHOW CREATE TABLE (MySQL) or \d table_name (PostgreSQL).
- Test any UPDATE or DELETE query on a copy of the database, after a backup.
Do I need to know SQL to use this prompt?
No: ask your question in plain English and describe your tables. The AI writes and explains the query. Still check the result on a few rows you know.