sq

sq is a versatile, open-source data wrangling tool designed for databases and documents, akin to jq but tailored for more complex data structures. It supports a wide range of functionalities including querying, joining, exporting, and importing data from various sources such as databases, Excel, and CSV files. Users can inspect and visualize metadata, perform diff operations on rows and tables, and seamlessly import data across different formats, such as transferring Excel data into a Postgres database.

The tool also includes commands for managing database tables, such as copying, truncating, and dropping tables. It features a plugin system to extend support for different data sources. However, sq currently lacks drivers for cloud or NoSQL databases like BigQuery, ClickHouse, MongoDB, and Redis.

sq's query language, SLQ, allows for powerful one-liners to manipulate data. It supports various input and output formats, including SQL databases (Postgres, SQLite, MySQL, MariaDB, SQL Server, Azure SQL Edge), and file formats like Excel, CSV, TSV, JSON, JSON Lines (JSONL), and JSON Arrays (JSONA). The output can be directed to multiple formats, including XML, HTML, Markdown, and raw bytes.

Despite its robust feature set, sq's current limitation is the absence of drivers for cloud and NoSQL databases, which might restrict its usability for some users.