Trdsql Sql Query Engine Csv Json Yaml Files

---
name: "trdsql SQL Query Engine for CSV JSON and YAML Files"
slug: "trdsql-sql-query-engine-csv-json-yaml-files"
description: "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."
github_stars: 2154
verification: "security_reviewed"
source: "https://github.com/noborus/trdsql"
category: "Data Extraction & Transformation"
framework: "Custom Agents"
tool_ecosystem:
  github_repo: "noborus/trdsql"
  github_stars: 2154
---

# 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](#docker)
- 2.1. [Docker pull](#docker-pull)
- 2.3. [Docker Run](#docker-run)

Basic usage or getting-started notes:
- For usage as a library, please refer to the [godoc](https://pkg.go.dev/github.com/noborus/trdsql) and the provided examples.
- [Usage](#usage)
- [Example](#example)

- Source: https://github.com/noborus/trdsql
- Extracted from upstream docs: https://raw.githubusercontent.com/noborus/trdsql/HEAD/README.md

## Source

- [Agent Skill Exchange](https://agentskillexchange.com/skills/trdsql-sql-query-engine-csv-json-yaml-files/)