BasedAGIBasedAGI
Data & Analytics

Text-to-SQL analyst assistant

Convert questions into SQL and explain the query.

task.text_to_sqltask.sql_debugging
Evidence quality is currently limited for this use case. Rankings below are useful for exploration, not a strong winner claim.

Provisional leader

gpt-5-2025-08-07

Current leader based on limited benchmark evidence. Treat this ranking as directional until coverage improves.

25.0%

Best benchmark score

34.3%

Confidence

Ranked Models

30

Evidence Quality

81%

Evidence Points

29

Top Signal

Spider2.0 Snow Text-to-SQL: snow_text_to_sql_score_pct

All Ranked Models

30 of 30 models
RankModelScore
๐Ÿฅ‡gpt-5-2025-08-07

Strong on Spider2.0 Snow Text-to-SQL snow_text_to_sql_score_pct and LiveSQLBench success_rate_pct

25.0%
๐Ÿฅˆo3-20250416

Strong on Spider2.0 Snow Text-to-SQL snow_text_to_sql_score_pct and LiveSQLBench success_rate_pct

21.4%
๐Ÿฅ‰deepseek-r1

Strong on DuckDB NSQL Leaderboard all_execution_accuracy and DuckDB NSQL Leaderboard hard_execution_accuracy

21.2%
#4gemini-3.1-pro-preview

Strong on Vals Finance Agent overall_accuracy_pct and FACTS Benchmark Suite facts_search_score_pct

20.7%
#5gpt-4o

Strong on DuckDB NSQL Leaderboard all_execution_accuracy and JSONSchemaBench Leaderboard medium_schema_compliance_pct

20.3%
#7claude-sonnet-4

Strong on LiveSQLBench success_rate_pct and Spider2.0 Lite Text-to-SQL lite_text_to_sql_score_pct

19.8%
#8gpt-4o-20241120

Strong on DuckDB NSQL Leaderboard all_execution_accuracy and DuckDB NSQL Leaderboard hard_execution_accuracy

18.8%
#9qwen-2.5-72b-instruct

Strong on DuckDB NSQL Leaderboard all_execution_accuracy and JSONSchemaBench Leaderboard medium_schema_compliance_pct

17.7%
#11gemini-2.5-pro

Strong on FACTS Benchmark Suite facts_grounding_score_pct and Vectara HHEM Leaderboard overall_hallucination_error_pct

17.4%
#12gpt-5-mini-2025-08-07

Strong on Vals Finance Agent overall_accuracy_pct and Vals CorpFin v2 overall_accuracy_pct

16.4%
#13gemini-3-flash-preview

Strong on Vals CorpFin v2 overall_accuracy_pct and FACTS Benchmark Suite facts_grounding_score_pct

15.8%
#14Grok-4-0709

Strong on Vals CorpFin v2 overall_accuracy_pct and Vals Finance Agent overall_accuracy_pct

15.0%
#15gemini-3-pro-preview

Strong on Vals Finance Agent overall_accuracy_pct and Vals CorpFin v2 overall_accuracy_pct

14.8%
#16gpt-5.2-2025-12-11

Strong on FACTS Benchmark Suite facts_grounding_score_pct and Vals CorpFin v2 overall_accuracy_pct

14.6%
#17gemini-3.1-flash-lite-preview

Strong on FACTS Benchmark Suite facts_grounding_score_pct and Vectara HHEM Leaderboard overall_hallucination_error_pct

14.6%
#18claude-sonnet-4.6

Strong on Vals Finance Agent overall_accuracy_pct and Vals CorpFin v2 overall_accuracy_pct

14.4%
#19Claude-3.5-Sonnet

Strong on DuckDB NSQL Leaderboard all_execution_accuracy and LLM-AggreFact Leaderboard average_score_pct

13.9%
#21gpt-5.4-2026-03-05

Strong on Vectara HHEM Leaderboard overall_hallucination_error_pct and Vals CorpFin v2 overall_accuracy_pct

13.6%
#22gpt-4o-2024-08-06

Strong on DuckDB NSQL Leaderboard all_execution_accuracy and Vectara HHEM Leaderboard overall_hallucination_error_pct

13.5%
#25claude-opus-4-5-20251101

Strong on FACTS Benchmark Suite facts_grounding_score_pct and Vals CorpFin v2 overall_accuracy_pct

13.0%
#26deepseek-v3

Strong on LiveSQLBench success_rate_pct and Vectara HHEM Leaderboard overall_hallucination_error_pct

12.9%
#27gpt-4.1-20250414

Strong on Vectara HHEM Leaderboard overall_hallucination_error_pct and Vals CorpFin v2 overall_accuracy_pct

12.8%
#28gpt-4o-mini-2024-07-18

Strong on DuckDB NSQL Leaderboard all_execution_accuracy and DuckDB NSQL Leaderboard hard_execution_accuracy

12.6%
#30gpt-4.1

Strong on DuckDB NSQL Leaderboard all_execution_accuracy and DuckDB NSQL Leaderboard hard_execution_accuracy

12.3%
#31gpt-5.1-2025-11-13

Strong on Vals Finance Agent overall_accuracy_pct and Vals CorpFin v2 overall_accuracy_pct

12.3%
#32grok-4-fast-reasoning

Strong on Vals CorpFin v2 overall_accuracy_pct and Vals Finance Agent overall_accuracy_pct

12.2%
#35claude-opus-4-6

Strong on LiveSQLBench success_rate_pct and AgentSet LLM Leaderboard elo_score

11.6%
#36o4-mini

Strong on LiveSQLBench success_rate_pct and Vals CorpFin v2 overall_accuracy_pct

11.1%
#38gemini-2.5-flash

Strong on FACTS Benchmark Suite facts_grounding_score_pct and Vectara HHEM Leaderboard overall_hallucination_error_pct

11.0%
#39Qwen3-32B

Strong on DuckDB NSQL Leaderboard all_execution_accuracy and Vectara HHEM Leaderboard overall_hallucination_error_pct

10.7%

Compare Models

Select two different models above to compare their evidence side by side.
โ–ถRanking diagnostics & missing models

Source lift

Ranked

68

Sources

8

Quality

Low

Vals CorpFin v2

42 rows ยท 1.1% avg lift

Vals Legal Bench

32 rows ยท 0.3% avg lift

Vals MedQA

32 rows ยท 0.3% avg lift

Vals Finance Agent

31 rows ยท 1.0% avg lift

Missing frontier models

No obvious gaps right now.

โ–ถTaxonomy & task details

Core tasks

task.text_to_sqltask.sql_debugging

Required modes

mode.json_schema

Domains

domain.data_analytics_bi

Related in Data & Analytics