"q" is a nifty command line tool if you would like to do some text file processing and lookups. So what is it? Basically SQL for csv/tsv (and other tabelated) files. It supports most of the basic queries and also allows to perform them over multiple files (supports joining). How does it work? You can imagine a file with tabelated data as a single table of a database. Just type in the command prompt: