tdx-basic

Execute Treasure Data tdx CLI operations for databases, tables, and queries.

21|24|Updated Oct 21, 2025
One-click install
npx skills add https://github.com/treasure-data/td-skills --skill tdx-basic
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: tdx-basic
Source: https://github.com/treasure-data/td-skills/tree/main/tdx-skills/tdx-basic
Command: npx skills add https://github.com/treasure-data/td-skills --skill tdx-basic

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill guides users through setting up and using the Treasure Data CLI, including authentication, context management, and common commands for databases, tables, and queries.

Core Features & Use Cases

  • CLI setup and authentication
  • Context switching and profile management
  • CRUD-like commands for databases, tables, and queries
  • Output formats and helpful hints

Quick Start

Install the tdx CLI and run tdx auth setup to begin.

Frequently Asked Questions about tdx-basic

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I set up authentication for the Treasure Data CLI?

Authentication for the Treasure Data CLI starts with running `tdx auth setup`, which initializes your credentials and configures access to your Treasure Data account. This step is required before executing any database, table, or query operations.

Can I execute SQL queries directly from the command line with tdx?

Yes, the tdx CLI supports SQL query execution from multiple sources: inline queries, files, or stdin. You can execute queries and format output as JSON, JSONL, TSV, or table format depending on your workflow needs.

How do I manage multiple Treasure Data profiles and sites with tdx?

Profile and site context management in tdx follows a precedence hierarchy: flags override session settings, which override project defaults, which override profile configuration, which overrides global settings. Switch contexts seamlessly across different profiles and sites.

What output formats does the tdx CLI support for query results?

The tdx CLI supports four output formats for query results: JSON for structured objects, JSONL for line-delimited JSON, TSV for tab-separated values, and table format for human-readable display.

Can I list databases and tables using patterns with tdx?

Yes, tdx supports pattern-driven listing of databases and tables, allowing you to filter and discover resources by name patterns without listing everything in your account.

Do I need prior CLI experience to use the Treasure Data tdx tool?

No; the tdx CLI is designed for users new to command-line interfaces. Start with `tdx auth setup` and basic commands like database and table operations. The guided authentication process and straightforward syntax make it accessible for beginners.