{"repo":"neilotoole/sq","free":true,"listed":false,"github":"https://github.com/neilotoole/sq","clone":"git clone https://github.com/neilotoole/sq.git","description":"sq data wrangler","language":"Go","stars":2551,"topics":["sql","golang","go","excel","csv","tsv","json","jsona","jsonl","markdown"],"license":"MIT","category":"databases-storage","readme_excerpt":"sq data wrangler sq is a command line tool that provides jq-style access to structured data sources: SQL databases, or document formats like CSV or Excel. It is the lovechild of SQL+jq. sq executes jq-like queries, or database-native SQL. It can join across sources: join a CSV file to a Postgres table, or MySQL with Excel. sq outputs to a multitude of formats including JSON, Excel, CSV, HTML, Markdown and XML, and can insert query results directly to a SQL database. sq can also inspect sources to view metadata about the source structure (tables, columns, size). You can use sq diff to compare tables, or entire databases. sq has commands for common database operations to copy, truncate, and drop tables. Find out more at sq.io. [!TIP] The rest of this doc is mainly for sq end users and first-timers. Contributors (bug reports, feature requests, pull requests), see CONTRIBUTING.md. Drivers sq knows how to deal with a data source type via a driver implementation. To view the installed/supported drivers: Install macOS [!IMPORTANT] sq is now a core brew formula. Previously, sq was available via brew install neilotoole/sq/sq . If you have installed sq this way, you should uninstall it ( brew uninstall neilotoole/sq/sq ) before installing the new formula via brew install sq . Linux Windows Go Docker The ghcr.io/neilotoole/sq image is preloaded with sq and a handful of related tools like jq . Local Kubernetes Running sq in a Kubernetes environment is useful for DB migrations, as well as","default_branch":null,"files":null,"tree":[],"storefront":"/r/neilotoole","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/neilotoole/sq/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}