SQL query generator prompt from plain English

متى تستخدم هذا البرومبت

• When you know what data you need but not the exact SQL syntax.
• When writing a report query against an unfamiliar schema.
• When teaching SQL by comparing intent to query.

نص البرومبت

Write a {{language}} SQL query for the following request against this schema: {{focus}}. Explain each clause briefly and flag any assumptions about table or column names.

{{CLIPBOARD}}

الكتلة {{CLIPBOARD}} تُستبدل تلقائياً بما نسخته قبل الضغط على «نسخ».

كيف تستخدمه

1. انسخ البرومبت بالزر أو املأ المتغيرات أولاً.
2. الصقه في ChatGPT أو Claude أو Gemini.
3. عدّل النتيجة أو أعد الطلب بتغيير المتغيرات.

مثال على النتيجة

SELECT c.name, SUM(o.total) AS lifetime_value
FROM customers c
JOIN orders o ON o.customer_id = c.id
WHERE o.status = 'completed'
GROUP BY c.name
ORDER BY lifetime_value DESC
LIMIT 10;

Assumption: 'orders.total' stores the order amount in the customer's currency.

نصائح للاستخدام

• Paste your actual table and column names, or a CREATE TABLE statement, for accurate results.
• Specify the SQL dialect (PostgreSQL, MySQL, SQLite) since functions differ.
• Always review generated queries against production data before running them.

النماذج الموصى بها

GPT

أسئلة شائعة

Do I need to share my full database schema?

Only the relevant table and column names; you never need to share actual data, just structure.

Can it write queries with joins and subqueries?

Yes, describe the relationships in plain English and it will structure joins, subqueries, or CTEs as needed.