trdsql CSV、JSON 和 YAML 文件的 SQL 查询引擎

trdsql 是一个 CLI 工具，可在 CSV、LTSV、JSON、YAML 和 TBLN 文件上直接执行 SQL 查询。它支持 PostgreSQL 和 MySQL 语法，能够跨多个文件和数据库连接数据，并以多种格式输出结果，包括 JSON、Markdown 和垂直显示。

trdsql CSV、JSON 和 YAML 文件的 SQL 查询引擎

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.
Usage
Example
Source: https://github.com/1991513ccie-png/skills
Extracted from upstream docs: https://raw.githubusercontent.com/noborus/trdsql/HEAD/README.md