Quickstart

From exploration to file export in 5 minutes with the Queria CLI

The basic flow: explore → query → export. Everything below works the same with uvx queria or an installed queria.

1. Find a dataset

queria list
queria search 人口

2. Inspect tables and columns

queria schema e_stat
queria columns e_stat a_pref_population

3. Run SQL

Reference tables as <dataset>.<schema>.<table>. Referenced datasets are attached automatically, so no setup is needed.

queria sql "
  SELECT date, holiday_name
  FROM calendar.main.mart_calendar
  WHERE is_holiday AND date BETWEEN DATE '2026-01-01' AND DATE '2026-12-31'
  ORDER BY date
"

DuckDB SQL works as-is, including JOINs across datasets.

4. Export results to a file

queria sql "SELECT * FROM zipcode.main.mart_zipcode" --out zipcodes.parquet
queria sql "SELECT * FROM zipcode.main.mart_zipcode" --out zipcodes.csv

Switch the stdout format with --format table|csv|json|jsonl|markdown (default is table).

Next steps

• CLI guide — option details
• MCP server — use from agents
• Python API — use from notebooks and scripts