Overview

csvq is a command line tool to operate CSV files. You can read, update, delete CSV records with SQL-like query.

You can also execute multiple operations sequentially in managed transactions by passing a procedure or using the interactive shell. In the multiple operations, you can use variables, cursors, temporary tables, and other features.

Latest Release

Version 1.11.1

Released on May 19, 2019

file_downloaddownload

Features

• CSV File Operation
  • Select Query
  • Insert Query
  • Update Query
  • Replace Query
  • Delete Query
  • Create Table Query
  • Alter Table Query
• Cursor
• Temporary Table
• Transaction Management
• Support loading data from Standard Input
• Support following file formats
  • CSV
  • TSV
  • LTSV
  • Fixed-Length Format
  • JSON
• Support following file encodings
  • UTF-8
  • UTF-16
  • Shift_JIS

  JSON Format supports only UTF-8.

Install

Install - Reference Manual - csvq

Command Usage

Command Usage - Reference Manual - csvq

Reference Manual

Reference Manual - csvq

Execute csvq statements in Go

csvq-driver

Example of cooperation with other applications

• csvq emacs extension

License

csvq is released under the MIT License