Documentation

Query anything,
in plain SQL.

Opteryx is a small, fast SQL engine that runs where your data already is — local files, object storage, dataframes, or a remote service.

Start here · 5 min

Your first query, in less time than this paragraph.

Install with pip, point at a Parquet file, and pull rows back. No cluster, no schema upfront — just SQL.

# pip install opteryxSELECT name, mass FROM 'orders.parquet' WHERE mass > 1.0 ORDER BY mass DESC LIMIT 3;

┌─────────┬────────┐│ name │ mass │├─────────┼────────┤│ Jupiter │ 1898.0 ││ Saturn │ 568.0 ││ Neptune │ 102.0 │└─────────┴────────┘

// reference

Statements, expressions, functions, operators, and data types — the full Opteryx grammar.

// reference

Embed Opteryx in Python, or call it over HTTP. Connection objects, cursors, and results.

The Opteryx community hangs out on Discord — maintainers included. Most questions get answered within the hour.