← Explore all skills

DATABASES / DuckDB

DuckDB read file

DuckDB's read-file skill: one DuckDB CLI command that picks a reader by file extension and returns a file's schema, row count and first 20 rows, for local paths or HTTPS, S3, GCS and Azure URLs.

“Read any data file (CSV, JSON, Parquet, Avro, Excel, spatial, SQLite) or remote URL (S3, HTTPS). Use when user references a data file, asks "what's in this file", or wants to preview/profile a dataset. Not for source code.”

01 / THE REASONING

Why this made the selection.

  • DuckDB publishes it in duckdb/duckdb-skills as one skill of the duckdb-skills Claude Code plugin (plugin.json version 0.2.4, license MIT); LICENSE is the MIT text with "Copyright 2018-2025 Stichting DuckDB Foundation".
  • A single `duckdb -csv -c` command defines a read_any table macro that chooses a reader by file extension (.json, .jsonl, .ndjson, .geojson, .geojsonl and .har; .csv, .tsv, .tab and .txt; .parquet and .pq; .avro; .xlsx and .xls; .shp, .gpkg, .fgb and .kml; .ipynb; .db, .sqlite and .sqlite3; read_blob otherwise), then runs DESCRIBE, a row count and a 20-row sample.
  • It gives a prefix table for remote paths (https/http, s3, gs/gcs, az/azure/abfss) and three named failure branches: DuckDB CLI not found, missing extension, and wrong reader or parse error.

02 / THE REVIEW RECORD

What we actually inspected.

Source review has boundaries.
A clear record is more useful than a “safe” badge.

Material inspected

  • skills/read-file/SKILL.md: frontmatter, the read_any command, the remote prefix table and the failure branches
  • README.md: installation, the read-file entry, prerequisites, how the skills work together, platform support
  • LICENSE
  • .claude-plugin/plugin.json
  • skills/install-duckdb/SKILL.md: frontmatter and Step 1 (locate DuckDB)
  • Repository tree at 7feda8e0: nine skills/*/SKILL.md files

Our findings

  • The frontmatter declares `allowed-tools: Bash` and the argument hint `<filename or URL> [question about the data]`.
  • A bare filename (no /) is resolved to a full path with `find` before the duckdb command runs.
  • The README says secrets and macros set up by read-file are reused by query through the shared state.sql, and that read-file uses duckdb-docs to troubleshoot errors. The read-file SKILL.md at this revision defines read_any inside each command, does not mention state.sql, and names install-duckdb, not duckdb-docs, in its failure branches.
  • The README says the skills offer to install the DuckDB CLI via /duckdb-skills:install-duckdb; that skill's Step 1 only tells the user how to install it and stops if DuckDB is not found.
  • The plugin install brings nine skills at this revision (attach-db, convert-file, duckdb-docs, install-duckdb, query, read-file, read-memories, s3-explore, spatial); the README describes six of them.

Not established by this review

  • Not executed: it was not installed or run.
  • No DuckDB command was run and no local or remote file was read.
  • No extension was installed and no cloud secret was created.
  • Behaviour on Windows was not checked.

The review applies to the material and revision named here. A newer upstream release can change its behavior.

03 / PUT IT TO WORK

Add a skill to your workflow.

Upstream setup instructions ↗
  1. The README's "From GitHub (available now)" section prints `/plugin marketplace add duckdb/duckdb-skills` and `/plugin install duckdb-skills@duckdb-skills` for Claude Code. They install the whole duckdb-skills plugin, which has nine skills/*/SKILL.md files at this revision, not read-file alone.
  2. Skills are then available as `/duckdb-skills:<skill-name>`; this one runs as `/duckdb-skills:read-file` with a filename or URL and an optional question about the data.
  3. For local testing, the README prints `claude --plugin-dir .` from a clone of the repository; that also loads the whole plugin from disk.

Before you start

  • The DuckDB CLI, installed beforehand. The README says the skills offer to install it via `/duckdb-skills:install-duckdb`; that skill prints `brew install duckdb`, `curl -fsSL https://install.duckdb.org | sh` or `winget install DuckDB.cli` and stops if DuckDB is not found.
  • macOS or Linux, the platforms the README says were tested.
  • For s3, gs/gcs or az/azure/abfss paths only: cloud credentials for the credential_chain secret the skill creates.

04 / FOLLOW THE EVIDENCE

The source trail.

Our notes are separate from the original resource.
Check upstream before adopting a new version.

  1. https://github.com/duckdb/duckdb-skills/blob/7feda8e01e22bc0886c86123f3884947e36d8c69/skills/read-file/SKILL.md

    Supports: upstreamDescription, whySelected[1], whySelected[2], bestFor, language, access.permissions, install.steps[1], limitations[2], limitations[3], limitations[4], limitations[5], review.findings

  2. README.md at 7feda8e0 ↗Checked

    https://github.com/duckdb/duckdb-skills/blob/7feda8e01e22bc0886c86123f3884947e36d8c69/README.md

    Supports: install, compatibility, whySelected[0], limitations[1], limitations[6], review.findings

  3. MIT LICENSE at 7feda8e0 ↗Checked

    https://github.com/duckdb/duckdb-skills/blob/7feda8e01e22bc0886c86123f3884947e36d8c69/LICENSE

    Supports: license, whySelected[0], limitations[7]

  4. https://github.com/duckdb/duckdb-skills/blob/7feda8e01e22bc0886c86123f3884947e36d8c69/.claude-plugin/plugin.json

    Supports: homepage, license, whySelected[0], limitations[7]

  5. https://github.com/duckdb/duckdb-skills/blob/7feda8e01e22bc0886c86123f3884947e36d8c69/skills/install-duckdb/SKILL.md

    Supports: install.prerequisites, access.permissions, limitations[2], review.findings

Evidence & Ask