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

Project Samples

sq data wrangler Screenshot 1

Project Activity

See All Activity >

Categories

JSON, Command Line Tools

License

MIT License

Follow sq data wrangler

sq data wrangler Web Site

Other Useful Business Software
MongoDB Atlas runs apps anywhere Icon
MongoDB Atlas runs apps anywhere

Deploy in 115+ regions with the modern database for every enterprise.

MongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
Start Free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of sq data wrangler!

Additional Project Details

Programming Language

Go

Related Categories

Go JSON Software, Go Command Line Tools

Registered

2023-10-27
Report inappropriate content