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.

agentskillexchange Updated 28 repo stars

File contents

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:

Basic usage or getting-started notes:

Source

agentskillexchange/skills/tree/main/skills/trdsql-sql-query-engine-csv-json-yaml-files commit 3d5f0a1bdc

Frequently asked questions

npx skillmds@latest add agentskillexchange/trdsql-sql-query-engine-for-csv-json-and-yaml-files