Portable, powerful, colorful.

An easy, fast, and beautiful database client for the terminal.

Get Started
A screenshot of Harlequin Harlequin╭─ Data Catalog ─────────────╮╭─ Query Editor ─────────────────────────────────────────────────────────────────────────╮ │▼ f1 db││ 1  select│ │└─ ▼ main sch││ 2  drivers.surname,                                         │ │├─ ▶ circuits t││ 3  drivers.forename,                                        │ │├─ ▶ constructor_result││ 4  drivers.nationality,                                     │ │├─ ▶ constructor_standi││ 5  avg(driver_standings.position)asavg_standing,          │ │├─ ▶ constructors t││ 6  avg(driver_standings.points)asavg_points│ │├─ ▶ driver_standings t││ 7  fromdriver_standings│ │├─ ▼ drivers t││ 8  joindriversondriver_standings.driverid=drivers.driverid│ ││  ├─ code s││ 9  joinracesondriver_standings.raceid=races.raceid│ ││  ├─ dob d││10  groupby1, 2, 3│ ││  ├─ driverId ##││11  orderbyavg_standing asc                                    │ ││  ├─ driverRef s│││ ││  ├─ forename s│││ ││  ├─ nationality s│││ ││  ├─ number s│││ ││  ├─ surname s│╰────────────────────────────────────────────────────────────────────────────────────────╯ ││  └─ url s│▐X▌ Limit 500Run Query │├─ ▶ lap_times t│╭─ Query Results (850 Records) ──────────────────────────────────────────────────────────╮ │├─ ▶ pit_stops t││ surname s forename s nationality s avg_standing #.# av│ │├─ ▶ qualifying t││ Hamilton                 Lewis              British            2.66                14│ │├─ ▶ races t││ Prost                    Alain              French             3.51                33│ │├─ ▶ results t││ Stewart                  Jackie             British            3.78                24│ │├─ ▶ seasons t││ Schumacher               Michael            German             4.33                46│ │├─ ▶ sprint_results t││ Verstappen               Max                Dutch              5.09                12│ │├─ ▶ status t││ Fangio                   Juan               Argentine          5.22                16│ │└─ ▶ tbl1 t││ Pablo Montoya            Juan               Colombian          5.25                27│ │││ Farina                   Nino               Italian            5.27                11│ │││ Hulme                    Denny              New Zealander      5.34                14│ │││ Fagioli                  Luigi              Italian            5.67                9.│ │││ Clark                    Jim                British            5.81                17│ │││ Vettel                   Sebastian          German             5.84                10│ │││ Senna                    Ayrton             Brazilian          5.92                31│ │▌││▌│ ╰────────────────────────────╯╰────────────────────────────────────────────────────────────────────────────────────────╯  CTRL+Q  Quit  F1  Help 

Runs Anywhere.

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

Works with Your Database.

Whether in-process, local, or in the cloud, Harlequin makes it easy to explore your data.

More coming soon. Don't see your database here? Open an issue or create your own adapter.

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. Optionally view local files or S3 objects.

  • Query Editor

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

  • Results Viewer

    View 1M+ results in an interactive table. Multiple queries loaded into separate tabs.

  • 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.

  • Query History

    View a list of executed queries and a summary of results. Select to insert into a new buffer.

Looks nice.

Choose from dozens of styles.

  •

Join the Flock.

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