sq data wrangler

We have hosted the application sq data wrangler in order to run this application in our online workstations with Wine or directly.

Quick description about 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. 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.

Features:

• Use sq help to see command help
• The sq ping command simply pings the source to verify that it's available
• Fundamentally, sq is for querying data
• Combine sq inspect with jq for some useful capabilities
• You can also inspect an individual table
• Use sq diff to compare metadata, or row data, for sources, or individual tables

Programming Language: Go.
Categories: