SELECT
TABLE_NAME,
COLUMN_NAME,
DATA_TYPE,
COLUMN_KEY
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = database()
ORDER BY TABLE_NAME, ORDINAL_POSITION;
Step 3 Paste the results from the above query
Step 4 Describe what you want to query
Example Query
See how the AI generates SQL from natural language
-- Find all customers who made purchases over $1000 last month
SELECT c.name, SUM(o.amount) as total_spent
FROM customers c
JOIN orders o ON c.id = o.customer_id
WHERE o.date >= DATE_SUB(NOW(), INTERVAL 1 MONTH)
GROUP BY c.id
HAVING total_spent > 1000;