sq

Like jq but for databases and documents.

Visit website ↗

Profile updated

Console’s review

· Reviewed by David Mytton

What we like

Query, join, export, import data from databases, Excel, CSV. Inspect and visualize metadata e.g. table structure. Diff rows and tables within databases. Import across formats e.g. Excel into Postgres. Copy, truncate, drop tables. Plugin system for sources. Open source.

Tradeoffs

No drivers yet for cloud or NoSQL databases e.g. BigQuery, ClickHouse, MongoDB, Redis.

Is sq a fit?

Based on Console’s review published on 2024-07-25. Summary updated .

Who it’s for

Developers working with various data formats and databases

Why consider it

It allows users to query, join, export, and import data from different sources

Keep in mind

It lacks support for cloud or NoSQL databases

Console is a free weekly newsletter with short reviews of developer tools, covering strengths and tradeoffs. This review reflects Console’s assessment at publication on 2024-07-25. Features and limitations may have changed since the review date. Read our selection criteria and learn about Console.

Tech stack

Runs on
  • Linux
  • Windows
  • macOS
Integrates with
  • Docker
  • MySQL
  • PostgreSQL
  • SQLite
Written in
  • Go

Checked

Source and notes

Go data-query CLI supports PostgreSQL, MySQL and SQLite with macOS/Linux/Windows and Docker installation.

View research source ↗

Coverage may be incomplete. “Written in” describes implementation, not supported project languages.

Discover your next favorite tool

Independent devtool reviews and the latest betas, in your inbox every Thursday. Free.