Skip to main content

// advent-of-postgres

December 1-24, 2026

Advent of Postgres 2026

24 SQL puzzles, one a day from 1 to 24 December. Each one is a small problem from the North Pole platform team: failed deploys, error budgets, on-call rotas, outages. You solve it on a real Postgres database that you get for free, right in the browser.

24 daysSQL puzzlesFree Postgres database
Days open0 / 24 days

// how it works

How It Works

  1. Step 1

    Open the day

    A new puzzle opens at 00:00 UTC each day. Read the story and the tables.

  2. Step 2

    Write SQL

    Create your free database with one click. The day’s data loads by itself, and you run queries on the page or with psql.

  3. Step 3

    Submit the answer

    One answer per day. The early days are short; the later ones need window functions, ranges and recursive queries.

// daily puzzles

Daily Puzzles

A new puzzle opens at 00:00 UTC each day. Your progress is saved in this browser.

Opens Dec 1
1

Day 1

Opens Dec 2
2

Day 2

Opens Dec 3
3

Day 3

Opens Dec 4
4

Day 4

Opens Dec 5
5

Day 5

Opens Dec 6
6

Day 6

Opens Dec 7
7

Day 7

Opens Dec 8
8

Day 8

Opens Dec 9
9

Day 9

Opens Dec 10
10

Day 10

Opens Dec 11
11

Day 11

Opens Dec 12
12

Day 12

Opens Dec 13
13

Day 13

Opens Dec 14
14

Day 14

Opens Dec 15
15

Day 15

Opens Dec 16
16

Day 16

Opens Dec 17
17

Day 17

Opens Dec 18
18

Day 18

Opens Dec 19
19

Day 19

Opens Dec 20
20

Day 20

Opens Dec 21
21

Day 21

Opens Dec 22
22

Day 22

Opens Dec 23
23

Day 23

Opens Dec 24
24

Day 24

// questions

Questions

What database do I get?
A real Postgres database on Neon, created for you when you press "Create my free database". It takes about five seconds and needs no account. Each day loads its data into its own schema, so you keep one database for the whole month.
How long does it last?
An unclaimed database lasts 72 hours. To keep it for the whole event, press "Keep it for the month" and claim it into a free Neon account. A few later puzzles use Neon branches, which need a claimed database.
Can I use my own tools?
Yes. "Connect with psql" shows the connection string, and every day also has a plain SQL file, so you can load the data into any Postgres 14 or later and solve it locally.
Does DevOps Daily see my queries?
No. Your browser sends queries straight to your own database on Neon. Our small API only asks Neon to create the database and the claim link, and it stores nothing.
How are answers checked?
In your browser, against a hash of the right answer. Your progress is saved in this browser only.

Prefer infrastructure? Try Advent of DevOps: 25 hands-on challenges with Docker, Kubernetes, CI/CD and Terraform, one a day through December.

Ready for December?

Day 1 opens on 1 December at 00:00 UTC. Share your answers with @thedevopsdaily