Best LLMs for SQL & Data Analysis
The best LLM for SQL and data analysis is GPT-5.6 Sol, with a 77.4 Coding Index and structured-output support for valid, parseable queries. GPT-5.6 Terra (76.7) and Claude Fable 5 (76.5) round out the top three.
The best AI models for writing SQL, analyzing data and powering analytics workflows — ranked by the Artificial Analysis Coding Index among models with structured-output support, so query generation comes back as valid, parseable SQL and JSON.
- 1
gpt-5.6-solReasoningToolsJSON+158.9 intel · $5.00/M · 74 t/s77.4Coding - 2gpt-5.6-terraReasoningToolsJSON+155.0 intel · $2.50/M · 96 t/s76.7Coding
- 3
claude-fable-5ReasoningToolsJSON+159.9 intel · $10.00/M · 1M ctx76.5Coding - 4
kimi-k3ReasoningToolsJSON+157.1 intel · $3.00/M · 1.0M ctx76.2Coding - 5gpt-5.5ReasoningToolsJSON+154.8 intel · $5.00/M · 100 t/s74.9Coding
- 6claude-opus-4.8ReasoningToolsJSON+155.7 intel · $5.00/M · 1M ctx74.3Coding
- 7claude-opus-4.7ReasoningToolsJSON+153.5 intel · $5.00/M · 1M ctx73.6Coding
- 8
grok-4.5ReasoningToolsJSON+153.8 intel · $2.00/M · 500K ctx72.4Coding - 9claude-sonnet-5ReasoningToolsJSON+153.4 intel · $2.00/M · 1M ctx71.5Coding
- 10gpt-5.6-lunaReasoningToolsJSON+151.2 intel · $1.00/M · 97 t/s71.4Coding
- 11Mmuse-spark-1.1ReasoningToolsJSON+250.6 intel · $1.25/M · 1.0M ctx71.3Coding
- 12gpt-5.4ReasoningToolsJSON+151.4 intel · $2.50/M · 79 t/s71.1Coding
- 13
gemini-3.5-flashReasoningToolsJSON+250.2 intel · $1.50/M · 189 t/s70.1Coding - 14gemini-3.6-flashReasoningToolsJSON+250.1 intel · $1.50/M · 111 t/s69.2Coding
- 15
glm-5.2ReasoningToolsJSON51.1 intel · $0.808/M · 1.0M ctx68.8Coding - 16gemini-3.1-pro-previewReasoningToolsJSON+246.5 intel · $2.00/M · 122 t/s68.8Coding
- 17
qwen3.7-maxReasoningToolsJSON46.0 intel · $1.48/M · 1M ctx66.0Coding - 18kimi-k2.6ReasoningToolsJSON+144.2 intel · $0.684/M · 262K ctx61.8Coding
- 19kimi-k2.7-codeReasoningToolsJSON+141.9 intel · $0.710/M · 262K ctx60.8Coding
- 20
mimo-v2.5-proReasoningToolsJSON42.2 intel · $0.435/M · 1.1M ctx60.2Coding - 21
kat-coder-pro-v2ToolsJSON33.7 intel · $0.300/M · 262K ctx59.5Coding - 22
deepseek-v4-proReasoningToolsJSON44.3 intel · $0.435/M · 1.0M ctx59.4Coding - 23
hy3ReasoningToolsJSON41.2 intel · $0.132/M · 262K ctx58.8Coding - 24
minimax-m3ReasoningToolsJSON+144.4 intel · $0.300/M · 1.0M ctx58.6Coding - 25mimo-v2.5ReasoningToolsJSON+237.2 intel · $0.140/M · 1.1M ctx56.8Coding
Frequently asked
Which LLM writes the best SQL?
The best LLM for SQL and data analysis is GPT-5.6 Sol, with a 77.4 Coding Index and structured-output support for valid, parseable queries. GPT-5.6 Terra (76.7) and Claude Fable 5 (76.5) round out the top three.
Which AI is best for data analysis?
The best AI model for SQL and data analysis is GPT-5.6 Sol, with a 77.4 Coding Index and structured-output support for valid, parseable queries. GPT-5.6 Terra (76.7) and Claude Fable 5 (76.5) round out the top three.
What's a good alternative to GPT-5.6 Sol?
GPT-5.6 Terra (76.7) is the closest alternative on this metric, followed by Claude Fable 5 (76.5). See the full ranking above for the tradeoffs.