Skip to content

prithvianilk/csvql

Repository files navigation

csvql

yet another cli tool to query a csv w/ sql

Example queries

Select all columns from a csv file

./bin/csvql csvql 'select * from file.csv'

Select single / multiple specific columns

./bin/csvql csvql 'select col1, col2 from file.csv'

Conditions

./bin/csvql csvql 'select * from file.csv where col1 + col2 = 2'

TODO

  • support column aggregations - count, sum
  • support multiply, divide on int
  • support lesser than, greater than, and respective equals conditions for int

About

SQL for CSVs

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published