xarray-sql

xarray-sql is a library that lets you run SQL queries against array datasets by treating them as tables. It registers Xarray Datasets as lazy tables on query engines like DataFusion, DuckDB, or Polars, then converts results back to labeled Datasets. The tool handles data translation rather than query translation, leaving dialects and optimizations to the underlying engine.

Designed for data scientists and climate researchers working with gridded data, xarray-sql enables common operations like climatology calculations and regridding through SQL syntax. The maker used Claude Code to develop benchmarks showing that geospatial and climate operations are fundamentally relational queries.