https://harlequin.sh/

Harlequin
The DuckDB IDE for Your Terminal.
A line drawing of a duck, in lieu of a hamburger.

  * Get Started
  * Docs
  * About
  * GitHub

Portable, powerful, colorful.

A drop-in replacement for the DuckDB CLI.

Get Started
A screenshot showing the interface and features of Harlequin.

Runs Anywhere.

Any shell, any terminal, any machine. Fish in tmux on Alpine over
SSH? Sure. Windows cmd? Yep.

  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 

Does SQL IDE Stuff.

The features you'd expect from an IDE, delightfully running right in
your terminal.

  * Data Catalog

    View tables, columns, and their types across one or more attached
    databases.

  * Query Editor

    A full-featured editor: open, save, format, cut, copy, paste, and
    more. Supports multiple tabbed buffers!

  * Results Viewer

    View up to 10k results in an interactive table. Multiple queries
    loaded into separate tabs.

  * MotherDuck Support

    Connect to any MotherDuck database in local or SaaS mode.

  * Full Screen

    Need more room? Press F10 to view the Editor or Results in
    full-screen mode.

  * Results Export

    Export query results and configure the export using a helpful UI.

Looks nice.

Choose from dozens of styles.

  *  
  *  
  *  
  *  
  *  
  *  
  *  
  *  
  *  
  *  
  *  
  *  
  *  
  *  
  *  
  *  
  *  
  *  
  *  
  *  
  *  
  *  

Join the Flock.

Thousands are using Harlequin. Join them with pipx install harlequin.

  * 
    Alex C. Viana @AlexVianaPro
     

    If you like @duckdb and retro/efficient text interfaces Harlequin
    is pretty cool! https://t.co/4tNKmt1yT4 pic.twitter.com/
    5Upic8iPXv

    6:24 AM * May 29, 2023
  * 
    pedram @pdrmnvd
     

    pretty sweet terminal-based duckdb sql editor! just what i've
    been looking for https://t.co/DWWY68tQcs pic.twitter.com/
    Ol2JwcxXE8

    9:46 PM * Jul 5, 2023
  * 
    Jacob Matson @matsonj
     

    its beautiful @tedconbeer pic.twitter.com/LRNHkPUnGt

    7:09 PM * Sep 9, 2023
  * 
    Tyler Hillery @_TylerHillery
     

    @tedconbeer crushed it with Harelquin, a DuckDB IDE for your
    terminal.

    I highly recommend trying it out https://t.co/vZOCzpQZ6Y
    pic.twitter.com/iBcbTDFKxr

    5:52 PM * Sep 19, 2023
  * 
    nedned @nletcher
     

    Harlequin is a super snazzy terminal-based IDE for @duckdb that
    has a whole bunch of useful features. Think of it like the DuckDB
    CLI dialled up to 11. Go check it out! https://t.co/HKVreF6xEv

    (It's also one of them funky TUIs built with Textual,
    @textualizeio ) https://t.co/7hkCWrWl8f

    8:24 AM * Sep 20, 2023
  * 
    Will McGugan @willmcgugan
     

    So much awesome!  https://t.co/D5eBrRGDK9
    11:27 AM * Sep 20, 2023

Shandy Data LLC (c)2023. Icons by Icons8.