DuckDB/read-file — Agent Skills | officialskills.sh
Back to skills

read-file

communitydata

Reads and explores data files in CSV, JSON, Parquet, Avro, Excel, spatial, and other formats using DuckDB.

Setup & Installation

npx skills add https://github.com/duckdb/duckdb-skills --skill read-file
or paste the link and ask your coding assistant to install it
https://github.com/duckdb/duckdb-skills/tree/main/skills/read-file
View on GitHub

What This Skill Does

Reads and explores data files in CSV, JSON, Parquet, Avro, Excel, spatial, and other formats using DuckDB. Works with local paths and remote sources like S3, GCS, Azure, and HTTPS URLs. Resolves file paths automatically and detects format by extension.

Instead of installing format-specific tools or writing boilerplate reader code for each file type, this skill dispatches to the right DuckDB reader automatically and handles remote credential setup in one step.

When to use it

  • Reading a Parquet file from S3 without writing any Python or SQL setup
  • Checking row counts and column types in a CSV before importing it into a database
  • Exploring a GeoJSON or Shapefile without loading it into a GIS tool
  • Previewing an Excel spreadsheet's structure from the command line
  • Querying a Jupyter notebook's cell contents as structured data