# 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.

- Skill: `agentskillexchange/trdsql-sql-query-engine-for-csv-json-and-yaml-files` (Agent Skill)
- Install (CLI): `npx skillmds@latest add agentskillexchange/trdsql-sql-query-engine-for-csv-json-and-yaml-files`
- Raw SKILL.md: https://api.skillmd.com/api/skills/agentskillexchange/trdsql-sql-query-engine-for-csv-json-and-yaml-files/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: agentskillexchange (https://skillmd.com/u/agentskillexchange)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/agentskillexchange/trdsql-sql-query-engine-for-csv-json-and-yaml-files

---


# 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/)