Spider

A large-scale, complex and cross-domain semantic parsing and text-to-SQL dataset annotated by 11 college students. Contains 10,181 questions and 5,693 unique complex SQL queries on 200 databases with multiple tables, covering 138 different domains. Requires models to generalize to both new SQL queries and new database schemas, making it distinct from previous semantic parsing tasks that use single databases.

Codestral-22B from Mistral AI currently leads the Spider leaderboard with a score of 0.635 across 2 evaluated AI models.

Paper
About this benchmark

What Spider measures

Spider is a text benchmark that evaluates large language models on language and reasoning tasks. LLM Stats tracks 2 models on this benchmark, with a maximum possible score of 1. Current average across reported models is 0.5, with the leader reaching 0.6.

Compare leaders on the best AI for language and best AI for reasoning leaderboards.

Publication

Paper
Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Task
Authors
Tao Yu, Rui Zhang, Kai Yang, Michihiro Yasunaga, and 8 others
Published

Abstract

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

Mistral AICodestral-22B leads with 63.5%, followed by Alibaba Cloud / Qwen TeamQwen3-Coder 480B A35B Instruct at 31.1%.

Progress Over Time

Interactive timeline showing model performance evolution on Spider

State-of-the-art frontier
Open
Proprietary

Spider Leaderboard

2 models
ContextCostLicense
1
Mistral AI
Mistral AI
22B
2
Alibaba Cloud / Qwen Team
Alibaba Cloud / Qwen Team
480B
Notice missing or incorrect data?

FAQ

Common questions about Spider.

What is the Spider benchmark?

A large-scale, complex and cross-domain semantic parsing and text-to-SQL dataset annotated by 11 college students. Contains 10,181 questions and 5,693 unique complex SQL queries on 200 databases with multiple tables, covering 138 different domains. Requires models to generalize to both new SQL queries and new database schemas, making it distinct from previous semantic parsing tasks that use single databases.

What is the Spider leaderboard?

The Spider leaderboard ranks 2 AI models based on their performance on this benchmark. Currently, Codestral-22B by Mistral AI leads with a score of 0.635. The average score across all models is 0.473.

What is the highest Spider score?

The highest Spider score is 0.635, achieved by Codestral-22B from Mistral AI.

How many models are evaluated on Spider?

2 models have been evaluated on the Spider benchmark, with 0 verified results and 2 self-reported results.

Where can I find the Spider paper?

The Spider paper is available at https://arxiv.org/abs/1809.08887. The paper details the methodology, dataset construction, and evaluation criteria.

What categories does Spider cover?

Spider is categorized under language and reasoning. The benchmark evaluates text models.

What is the best open-source model on Spider?

Codestral-22B by Mistral AI is the top-ranked open-source model on Spider, with a score of 0.635 (rank #1).

How recent are the Spider leaderboard results?

The Spider leaderboard was last updated in June 2026 and currently includes 2 evaluated models.

More evaluations to explore

Related benchmarks in the same category

View all language
GPQA

A challenging dataset of 448 multiple-choice questions written by domain experts in biology, physics, and chemistry. Questions are Google-proof and extremely difficult, with PhD experts reaching 65% accuracy.

reasoning
224 models
MMLU-Pro

A more robust and challenging multi-task language understanding benchmark that extends MMLU by expanding multiple-choice options from 4 to 10, eliminating trivial questions, and focusing on reasoning-intensive tasks. Features over 12,000 curated questions across 14 domains and causes a 16-33% accuracy drop compared to original MMLU.

language
127 models
AIME 2025

All 30 problems from the 2025 American Invitational Mathematics Examination (AIME I and AIME II), testing olympiad-level mathematical reasoning with integer answers from 000-999. Used as an AI benchmark to evaluate large language models' ability to solve complex mathematical problems requiring multi-step logical deductions and structured symbolic reasoning.

reasoning
114 models
MMLU

Massive Multitask Language Understanding benchmark testing knowledge across 57 diverse subjects including STEM, humanities, social sciences, and professional domains

language
100 models
SWE-Bench Verified

A verified subset of 500 software engineering problems from real GitHub issues, validated by human annotators for evaluating language models' ability to resolve real-world coding issues by generating patches for Python codebases.

reasoning
100 models
Humanity's Last Exam

Humanity's Last Exam (HLE) is a multi-modal academic benchmark with 2,500 questions across mathematics, humanities, and natural sciences, designed to test LLM capabilities at the frontier of human knowledge with unambiguous, verifiable solutions

reasoningmultimodal
82 models