EasyEnv

How good is your SQL really? Prove it on the leaderboard.

One hour, a real database box, and a report query scanning the whole table. The best scores read the plan and add the right index. Get a score out of 100, a tier, and your rank.

Free to play. Runs in your browser. Sign in to save and share your rank.

SQL ScoreExample
0
out of 100
Advanced
Top 9%
percentile
Fast
challenge

Query indexed in 4m 40s. Read the EXPLAIN on sight.

The challenge

Make the report fast

A per-user report scans a 200,000-row table on every load, and EXPLAIN shows type ALL. This is the actual console you get. Add the right index and get it running fast.

SQL Challenge
59:14 left
schema.sqlreport.sql
1SELECT COUNT(*) FROM events
2WHERE user_id = 42
3 AND created_at > NOW() - INTERVAL 7 DAY;
4-- no index covers (user_id, created_at)← missing index
Terminal
$ EXPLAIN SELECT COUNT(*) FROM events WHERE ...
type: ALL rows: 200000
$ report runs in 3.4s
SQL / indexes60 minute windowSingle real fixFix it yourself

What we score

Outcome, root cause, restraint

Everyone gets the same broken project. The score is your judgement: did it come back to life, did you find the real cause, and was the fix clean.

1

Get it working

Outcome is graded first. A change that does not run is not a fix, however elegant it looks.

2

Find the real cause

We reward finding the actual root cause and fixing that, not patching the symptom and hoping.

3

Keep it clean

A minimal, correct change scores higher than a pile of guesses. Restraint counts.

The leaderboard

Where will you land?

Every run is judged on the same challenge, so the score is comparable. Climb from Learning to Elite, beat your friends, and share a link that shows exactly where you rank.

Claim your rank
90+
Expert
Fast, clean, every trap caught
90 - 100
75+
AdvancedExample run
Solid work, challenge shipped
75 - 89
55+
Proficient
Got there, a few detours
55 - 74
35+
Developing
Partly there, kept going
35 - 54
0+
Beginner
Made a start, room to grow
0 - 34

How it works

Three steps, one hour, one rank

01

Boot the broken stack

A real Linux machine spins up in your browser with the broken project, an editor, and a terminal. Nothing to install.

02

Fix it yourself

You have an hour. Read the logs, find the real root cause, and make the smallest change that brings it back to life.

03

Get scored and ranked

When it is live, the judge scores your run out of 100, hands you a tier, and drops you on the leaderboard.

Find out how good your SQL really is

One slow query, one hour, one shareable rank. No setup, no install. Start in your browser right now.

FAQ

Questions, answered

It is a hands-on challenge on a real Linux machine. You read a query plan and add the right index so a slow report runs fast. You have up to an hour, and we score the outcome, whether you found the real root cause, and how clean your change was.

No. The whole challenge runs in your browser on a real Linux box with an editor and a terminal already set up. Nothing to download, nothing to configure.

You have up to an hour, but the highest scores finish fast and clean. It is free to play. Sign in to save your result and share it.

A shareable score out of 100, a tier, and your rank against everyone else who has taken it. Send the link to a friend and challenge them to beat it.

SQL Challenge: Fix a slow query on a real box | EasyEnv