If you want to run SQL queries on CSV files from the command line without installing/opening any DBMS software, use CSVKIT

• csvkit

  9 5,816 8.6 Python

  A suite of utilities for converting to and working with CSV, the king of tabular file formats.

  

• xquery-cli

  1 7 0.0 TypeScript

  A command-line tool for XQuery

Maybe off topic since it’s not SQL, but if you’re working with XML a lot I’d recommend checking out XQuery! There are a few command line implementations like CSVKIT if you google, this one doesn’t seem too awful

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• xsv

  64 10,089 0.0 Rust

  A fast CSV command line toolkit written in Rust.

I've also had success using this tool to do sql like operations on csv files! https://github.com/BurntSushi/xsv

• trdsql

  9 1,881 8.3 Go

  CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats.

The trdsql I made is feature-rich and fast (as a similar SQL tool).

Suggest a related project