Show HN: Harlequin, the DuckDB IDE for Your Terminal

5 points

3 years ago

Hi HN - For the past four months I've been working (part-time, this is OSS after all) on Harlequin, a SQL IDE for DuckDB that runs in your terminal. I built this because I work in Data, and I found myself often reaching for the DuckDB CLI to quickly query CSV or Parquet data, but then hitting a wall when using the DuckDB CLI as my queries got more complex and my result sets got larger.

Harlequin is a drop-in replacement for the DuckDB CLI that runs in any terminal (even over SSH), but adds a browsable data catalog, full-powered text editor (with multiple buffer support), and a scrollable results viewer that can display thousands of records.

Harlequin is written in Python, using the Textual framework. It's licensed under MIT.

Today I released v1.0.0, and I'm excited to share Harlequin with HN for the first time. You can try it out with `pip install harlequin`, or visit https://harlequin.sh for docs and other info.