trdsql SQL Query Engine for CSV JSON and YAML Files
trdsql is a CLI tool that executes SQL queries directly on CSV, LTSV, JSON, YAML, and TBLN files. It supports PostgreSQL and MySQL syntax, can join data across multiple files and databases, and outputs results in various formats including JSON, Markdown, and vertical display.
Installation
Use the upstream install or setup path that matches your environment:
- make
- make install
- brew install trdsql
- docker pull noborus/trdsql
Requirements and caveats from upstream:
- Docker
- 2.1. Docker pull
- 2.3. Docker Run
Basic usage or getting-started notes:
For usage as a library, please refer to the godoc and the provided examples.
Extracted from upstream docs: https://raw.githubusercontent.com/noborus/trdsql/HEAD/README.md