data_analytics
Data quality assistant
Propose validation checks and likely data issues from schema and symptoms.
#1 Recommendation
gpt-4o
Strong on DuckDB NSQL Leaderboard all_execution_accuracy (77%) and JSONSchemaBench Leaderboard medium_schema_compliance_pct (100%)
external/openai/gpt-4o
21.1%
Score
35.9%
Confidence
Limited benchmark evidence for this use case.
59 ranked models with average evidence of 11.4 points. Rankings may shift as more benchmark data is ingested.
Ranked Models
30
Evidence Quality
79%
Scoring
Benchmark-backed
Top Signal
DuckDB NSQL Leaderboard: all_execution_accuracy
All Ranked Models
| Rank | Model | Score |
|---|---|---|
| #1 | gpt-4o Strong on DuckDB NSQL Leaderboard all_execution_accuracy (77%) and JSONSchemaBench Leaderboard medium_schema_compliance_pct (100%) | 21.1% |
| #2 | qwen-2.5-72b-instruct Strong on DuckDB NSQL Leaderboard all_execution_accuracy (83%) and JSONSchemaBench Leaderboard medium_schema_compliance_pct (90%) | 20.9% |
| #3 | gpt-4o-20241120 Strong on DuckDB NSQL Leaderboard all_execution_accuracy (96%) and DuckDB NSQL Leaderboard hard_execution_accuracy (75%) | 20.3% |
| #5 | deepseek/deepseek-r1 | 18.4% |
| #7 | openai/gpt-4o-mini-2024-07-18 | 15.9% |
| #10 | gpt-4o-2024-08-06 | 15.0% |
| #14 | gemini-3-pro-preview | 13.0% |
| #15 | google/gemini-2.0-flash-001 | 12.8% |
| #16 | gpt-4.1-20250414 | 12.6% |
| #19 | gemini-2.5-pro | 12.3% |
| #20 | Grok-4-0709 | 12.3% |
| #23 | google/gemini-3.1-pro-preview | 11.9% |
| #24 | claude-sonnet-4-20250514 | 11.9% |
| #27 | Llama-3.3-70B-Instruct | 11.5% |
| #30 | gpt-5-2025-08-07 | 10.9% |
| #32 | openai/gpt-5.4-2026-03-05 | 10.7% |
| #34 | gemma-2-27b-it | 10.6% |
| #35 | gpt-5.1-2025-11-13 | 10.4% |
| #38 | gemini-2.5-flash | 10.4% |
| #40 | anthropic/claude-sonnet-4.6 | 10.3% |
| #41 | phi-4 | 10.3% |
| #42 | claude-opus-4-5-20251101 | 10.3% |
| #43 | gpt-5-mini-2025-08-07 | 10.0% |
| #44 | Qwen3-30B-A3B | 9.9% |
| #45 | anthropic/claude-opus-4-6-thinking | 9.8% |
| #46 | gemini-3-flash-preview | 9.8% |
| #47 | Qwen2.5-Coder-7B | 9.7% |
| #48 | gpt-5.2-2025-12-11 | 9.6% |
| #49 | anthropic/claude-opus-4-5-20251101-thinking | 9.5% |
| #53 | Qwen3-32B | 9.4% |
Compare Models
Model A leads by +0.3%
Shareable Link →Model A
gpt-4o
external/openai/gpt-4o
Rank #1
DuckDB NSQL Leaderboard: all_execution_accuracy
Value 76.9% · Conf 100.0% · Weight 6.2%
duckdb_nsql_leaderboard.all_execution_accuracy (Mar 12, 2026)
JSONSchemaBench Leaderboard: medium_schema_compliance_pct
Value 100.0% · Conf 100.0% · Weight 3.0%
jsonschemabench_leaderboard.medium_schema_compliance_pct (Mar 12, 2026)
JSONSchemaBench Leaderboard: hard_schema_compliance_pct
Value 100.0% · Conf 100.0% · Weight 2.1%
jsonschemabench_leaderboard.hard_schema_compliance_pct (Mar 12, 2026)
DuckDB NSQL Leaderboard: hard_execution_accuracy
Value 50.0% · Conf 100.0% · Weight 1.5%
duckdb_nsql_leaderboard.hard_execution_accuracy (Mar 12, 2026)
Model B
qwen-2.5-72b-instruct
external/qwen/qwen-2-5-72b-instruct
Rank #2
DuckDB NSQL Leaderboard: all_execution_accuracy
Value 82.7% · Conf 100.0% · Weight 6.6%
duckdb_nsql_leaderboard.all_execution_accuracy (Mar 12, 2026)
JSONSchemaBench Leaderboard: medium_schema_compliance_pct
Value 90.1% · Conf 100.0% · Weight 2.7%
jsonschemabench_leaderboard.medium_schema_compliance_pct (Mar 12, 2026)
Galileo Agent Leaderboard v2: Avg AC
Value 76.1% · Conf 100.0% · Weight 1.6%
galileo_agent_v2.avg_ac (Mar 12, 2026)
JSONSchemaBench Leaderboard: hard_schema_compliance_pct
Value 74.4% · Conf 100.0% · Weight 1.6%
jsonschemabench_leaderboard.hard_schema_compliance_pct (Mar 12, 2026)
▶Ranking Diagnostics & Missing Models
Source Lift
Ranked
59
Sources
8
Quality
Insufficient
Vals Legal Bench
vals_legal_bench
37 rows
0.6% avg lift
Vals Tax Eval v2
vals_tax_eval_v2
37 rows
0.5% avg lift
Vals LiveCodeBench
vals_lcb
36 rows
0.5% avg lift
Vals CorpFin v2
vals_corp_fin_v2
36 rows
0.5% avg lift
Missing Strong Models
zai/glm-5-thinking
external/zai/glm-5-thinking
Rank #32
13.0%
x-ai/grok-3
external/x-ai/grok-3
Rank #35
12.1%
gpt-4o-2024-05-13
external/openai/gpt-4o-2024-05-13
Rank #51
10.5%
qwen/qwen3-max
external/qwen/qwen3-max
Rank #55
10.3%
▶Taxonomy Details
Core Tasks
Required Modes
Domains
Related Use Cases
data_analytics
SQL debugging
Diagnose and fix SQL queries for correctness and performance.
Top: gpt-4o-20241120
data_analytics
Metric definition workshop
Turn ambiguous KPI definitions into precise, measurable specs.
Top: gpt-4o
data_analytics
Dashboard narratives
Generate weekly KPI narratives and investigation suggestions.
Top: gemini-3-pro-preview
data_analytics
Text-to-SQL analyst assistant
Convert questions into SQL and explain the query.
Top: gemini-3-pro-preview