Home › Prompts › DeepSeek › SQL query from a plain-English question

SQL query from a plain-English question

Write a correct SQL query from your schema and question, with an explanation and edge cases.

DeepSeek Data analysisRuleStack original

Written for DeepSeek Chat (DeepThink reasoning mode) · Updated 2026-10-17

Note: Review and test before use. Provided as is, without warranty. See Terms.

Prompt

Database: [PostgreSQL/MySQL/SQLite]. Tables:
[table definitions or columns]
Question: [e.g. monthly revenue by country for the last 12 months, excluding refunds].
Write the query, explain each part briefly, and list edge cases (nulls, time zones, duplicates) and how the query handles them.

Replace everything in [square brackets] with your own details.

Settings & parameters

DeepThink on for complex joins

Variations

Optimize an existing slow query: paste it with EXPLAIN output.
Convert to a dbt model.

Tips

Paste real column names; guessing causes errors.
Run on a sample before production.

More: all DeepSeek prompts · all data analysis prompts · prompt library

Related prompts

Analyze a CSV and explain the findings

Upload a spreadsheet and get cleaning notes, key metrics, charts and plain-English findings with caveats.

ChatGPTData analysis

A/B test readout with statistical rigor

Interpret experiment results correctly: significance, effect size, power and practical recommendation.

ClaudeData analysis

Spreadsheet formula builder

Get the exact Google Sheets or Excel formula for a task, explained, with an example.

GeminiData analysis

KPI dashboard design

Define the right metrics, formulas and chart types for a business dashboard.

GrokData analysis

Excel formula and fix explainer

Get the right Excel formula for a task, with an explanation and a version for older Excel.

Microsoft CopilotData analysis

Code open-ended survey responses

Turn hundreds of free-text survey answers into themes with counts, quotes and recommendations.

Any chat AIData analysis

Get the best new AI prompts every week

One short email a week: the best new prompts and rules for ChatGPT, Claude, Gemini, Midjourney, Cursor and more, plus what changed in the tools. Free, unsubscribe anytime.

Finishes on our newsletter page at beehiiv (opens in a new tab). Or subscribe directly.