Spider
Models turn natural language questions into SQL over 200 multi-table databases from 138 domains. Test databases are unseen in training, and answers are scored by exact match or execution.
10,181 questions and 5,693 unique SQL queries annotated by 11 Yale students. The Spider site announced Spider 2.0 as its successor in 2024.
- Released
- September 2018
- Kind
- Data science and SQL
- Level
- University
- Scored
- Checked automatically
- Answers
- Code
- Tasks
- Public, plus a private test set
- Last in a launch post
- January 2025, dropped for a newer version
- Last model added
- February 2026
- Scores refreshed
- November 12th, 2026
In the authors’ words
We present Spider, a large-scale, complex and cross-domain semantic parsing and text-to-SQL dataset annotated by 11 college students. It consists of 10,181 questions and 5,693 unique complex SQL queries on 200 databases with multiple tables, covering 138 different domains. We define a new complex and cross-domain semantic parsing and text-to-SQL task where different complex SQL queries and databases appear in train and test sets. In this way, the task requires the model to generalize well to both new SQL queries and new database schemas. Spider is distinct from most of the previous semantic parsing tasks because they all use a single database and the exact same programs in the train set and the test set. We experiment with various state-of-the-art models and the best model achieves only 12.4% exact matching accuracy on a database split setting. This shows that Spider presents a strong challenge for future research. Our dataset and task are publicly available at https://yale-lily.github.io/spider
Qwen3-Coder-Next leads with 83.7% among models released by February 2026
Best score per model as labs report them in their own cards. Labs pick their own settings, so these compare less cleanly than independent runs.
T5-3B leads with 78% across all independent runs
Best score per model across the official leaderboard, Epoch AI’s own runs and any board Epoch AI copied. Each bar and row names its source.
Qwen3-Coder-Next leads with 83.7%, claims included
Best score per model from every source, including labs’ own numbers and claims Epoch AI collected from reports and papers. Labs pick their own settings, so a claim can beat an independent run of the same model.
The newest model with a score here came out in February 2026, and nobody has reported a newer one. Among the 20 highest-ranked models on the capability index, these have no score yet:
- Claude Fable 5.2
-
Gemini 4 Carbon
- GPT-6 Astra
- Claude Opus 5.5
- and 16 more
- 1
Qwen3-Coder-Next 83.7%
- 2
Cohere Command A 80.2%
- 3
Codestral 66.5%
- 4
Phi-4 Mini 42.2%
Source: Labs’ model cards
Source: Official Spider leaderboard
- 1
Qwen3-Coder-Next 83.7%
- 2
Cohere Command A 80.2%
- 3
T5-3B 78%
- 4 T5-Base 71.1%
- 5
Codestral 66.5%
- 6
Phi-4 Mini 42.2%
Sources: Labs’ model cards and official Spider leaderboard
| # | Model | Score | Setting | Date | Source |
|---|---|---|---|---|---|
| 1 | | 83.7% | Feb 2026 | Lab model card | |
| 2 | | 80.2% | Apr 2025 | Lab model card | |
| 3 | | 66.5% | Jan 2025 | Lab model card | |
| 4 | | 42.2% | Mar 2025 | Lab model card |
| # | Model | Score | Setting | Date | Source |
|---|---|---|---|---|---|
| 1 | | 78% | T5-3B+NatSQL+Token Preprocessing | Oct 2019 | Official leaderboard |
| 2 | T5-Base | 71.1% | T5-Base+NatSQL+Token Preprocessing | Aug 2021 | Official leaderboard |
| # | Model | Score | Setting | Date | Source |
|---|---|---|---|---|---|
| 1 | | 83.7% | Feb 2026 | Lab model card | |
| 2 | | 80.2% | Apr 2025 | Lab model card | |
| 3 | | 78% | T5-3B+NatSQL+Token Preprocessing | Oct 2019 | Official leaderboard |
| 4 | T5-Base | 71.1% | T5-Base+NatSQL+Token Preprocessing | Aug 2021 | Official leaderboard |
| 5 | | 66.5% | Jan 2025 | Lab model card | |
| 6 | | 42.2% | Mar 2025 | Lab model card |
The benchmark's own leaderboard has 29 entries, 2 of them models we track. Switch the scores above to rank them together.
3 models have held number one in labs’ own numbers since 2023 Number one over time 3 models have held number one with claims included since 2023
Lab claims count from the day the card came out, independent runs from the model’s release. We draw one row each for the benchmark’s own leaderboard and what labs claim in their cards.
Sources: Official Spider leaderboard and labs’ model cards
Scores over time
All the scores we have, one dot each, so a model tested at several settings appears more than once.
Sources: Official Spider leaderboard and labs’ model cards
Labs moved on to Spider 2.0
Launch posts from every lab that has listed it, one tick per post. Tall colored ticks include it, and short gray ones leave it out.
| Date | Launch post | Score | As the post writes it |
|---|---|---|---|
| Jan 13, 2025 | 66.5 | Spider (SQL) |
3 system cards report it, from 3 labs
Besides launch posts, we read the system cards, model cards and technical reports labs publish with a release. They report far more, including safety and frontier-risk tests.
| Date | Document | Score | As the document writes it | Section |
|---|---|---|---|---|
| Feb 28, 2026 | | 83.7 | Spider (Table 7) | Capabilities |
| Apr 1, 2025 | | 80.2 | Spider Test execution accuracy (Table 14). Dev 79.5 | Capabilities |
| Mar 3, 2025 | | 42.2 | Spider (4-Shot) (Table 8) | Capabilities |
Versions
We switch the top row to each new version when it comes out. Open it for one row per version. An old version stays in play while people still test it, so whoever first takes it past 85% gets credit for closing it out.
Sources: Official leaderboards and labs’ model cards
More in Coding
- SWE-bench Verified In use 500 human-validated GitHub issues from 12 Python repos. Agent writes a patch that must pass hidden tests. Claude Opus 4.7 83.5%
- LiveCodeBench v6 In use Competitive programming problems collected after model cutoffs from LeetCode, AtCoder, Codeforces. Scored pass@1 on hidden tests.
DeepSeek-V4-Pro 93.5%
- SWE-bench Multilingual In use 300 GitHub-issue tasks across nine programming languages in SWE-bench format. Patch graded by repository tests. Claude Fable 5.2 96.6%
- DeepSWE In use 113 original long-horizon engineering tasks across 91 repos and five languages, written from scratch. Hand-written verifiers accept alternative solutions. GPT-6 Astra 74.1%
- SciCode In use Scientist-curated research coding problems split into subproblems across natural sciences. Code checked against test cases.
Seed2.1 Pro 59.8%
- Codeforces rating In use Model solves recent Codeforces contest problems. An Elo-style rating is computed from simulated contest performance.
DeepSeek V4.1 Flash 3,471