SQL 解释Explain SQL
输出语义解释、索引核对项与风险；不假装跑过 EXPLAIN。
Output semantic explanation, index checks and risks; do not pretend EXPLAIN was run.
提示词效果未实测。Prompt effect has not been tested.
提示词是可复跑的模板，不是效果承诺。换模型、换版本、换输入都可能改变结果；用本页的检查点自己核对，并把官方出处当作机制依据而不是效果保证。A prompt is a re-runnable template, not a promise of results. Changing the model, version or input can change the outcome. Use the checkpoints on this page to verify it yourself, and treat the official sources as evidence of mechanism rather than a guarantee of effect.
任务与输入Task and inputs
解释 SQL 并核对索引与边界。 输入：SQL、表结构、索引定义。
Output semantic explanation, index checks and risks; do not pretend EXPLAIN was run. Inputs: SQL, table schema, and index definitions.
提示词本体The prompt
解释 SQL。输出 meaning、joins[]、filters[]、index_checks[]、risks[]。index_checks 只依据给定索引定义判断可能使用/缺失；没有 EXPLAIN 输出就写未执行计划核对。不得编造行数或耗时。占位符用 {字段} 标注，运行前替换为本次输入。
Explain the SQL. Output meaning, joins[], filters[], index_checks[] and risks[]. index_checks judge possible use/absence only from given index definitions; if no EXPLAIN output exists, state that plan verification was not run. Do not invent row counts or timings.Replace {field} placeholders with the current inputs before running.
预期输出形态Expected output shape
meaning、 joins/filters、index_checks、risks。
meaning, joins/filters, index_checks, and risks.
检查点Checkpoints
- 索引判断有定义依据。
- 无编造统计数字。
- 风险含 NULL/重复键边界。
- Index judgments cite definitions.
- No invented statistics.
- Risks include NULL/duplicate-key boundaries.
失败分支Failure branches
- 表结构缺失：标 missing_schema。
- 解释过度：只保留 SQL 语义。
- Missing schema: mark missing_schema.
- Over-explanation: keep only SQL semantics.
出处与边界Sources and limits
提示词效果未实测。机制依据见出处；换模型、版本或输入会改变结果。
This site has not tested the effect of this prompt. See the sources for the mechanism; changing model, version or input can change the result.
出处Sources
| 来源Source | 链接URL |
|---|---|
| OpenAI Cookbook · Introduction to Structured Outputs（官方仓库 raw，2026-11-07 直抓 200）OpenAI Cookbook: Introduction to Structured Outputs (official repository raw, fetched 200 on 2026-11-07) | https://raw.githubusercontent.com/openai/openai-cookbook/main/examples/Structured_Outputs_Intro.ipynbhttps://raw.githubusercontent.com/openai/openai-cookbook/main/examples/Structured_Outputs_Intro.ipynb |
资料快照日期：2026-11-07；单项复核范围与日期见对应正文或来源记录。产品功能与条款可能变化，使用前请核对原始来源。Source snapshot: 2026-11-07; item-specific rechecks and their scope are recorded in the text or source notes. Features and terms may change; check the original sources before use.