octosql

SQL query tool for analyzing data across multiple file formats and databases

brewmacoslinux

Try with needOr install directly

About

SQL query tool to analyze data from different file formats and databases

octosql

Query a JSON file with SQL$ octosql "SELECT * FROM data.json WHERE age > 30"

Join data from CSV and JSON files$ octosql "SELECT a.id, a.name, b.value FROM users.csv a JOIN data.json b ON a.id = b.user_id"

Query a PostgreSQL database$ octosql "SELECT COUNT(*) FROM postgres://user:pass@localhost/db.table_name"