Prove a research idea on vacation with Claude Code

An open-source maintainer used Claude Code on a beach to show common geo and climate operations can be written as SQL, and even built a neural network in SQL.

Difficulty
AdvancedOur rating
Time to build
Not reportedOur estimate
Monthly cost
Not reported
Revenue
Not reportedWe only show revenue the source states
Engagement
121 HN points20 comments · fetched Oct 15, 2026

What they did

He and Claude Code wrote a benchmark of geo and climate queries on his Xarray-SQL library.

How it went

They published the benchmark and the SQL neural network demo.

Worth knowing

Benchmarks need independent checks.

Builder recipe

Our own starting point, written from the source. Adapt it to your setup.

Stack

  • Claude Code
  • Xarray-SQL

Steps

  1. Define the question and success criteria.
  2. Let agents search, run or summarize in parallel.
  3. Verify key results yourself.
  4. Write up findings with sources.

Starter prompt

Tags

Read the original

Related use cases

The Daily 5.

Five real AI agent use cases each morning, each with a recipe and a source. Plus a Sunday roundup. Free.