sq

sq is a powerful command-line data wrangler that combines the flexibility of jq with SQL database capabilities. It lets you query diverse data sources—including SQL databases, CSV files, Excel spreadsheets, and JSON documents—using a unified jq-style query language.

Key capabilities include:

• Cross-source queries: Join data across different sources like CSV files, Excel sheets, and databases in a single operation
• Multiple output formats: Export results as JSON, Excel, CSV, HTML, Markdown, or XML
• Database operations: Copy, truncate, drop tables, and insert query results directly into SQL databases
• Data inspection: View metadata about source structure, tables, and columns
• Comparison tools: Use sq diff to compare tables or entire databases
• Flexible drivers: Support for SQLite, PostgreSQL, MySQL, SQL Server, ClickHouse, and document formats

Whether you're performing quick data exploration, building ETL pipelines, or bridging gaps between different data formats, sq eliminates the need to switch between multiple tools. Execute native SQL queries or use jq-style syntax—whatever fits your workflow. Perfect for developers and data analysts who want powerful data manipulation capabilities without leaving the terminal.