Official agent skill

S3 Explore

by duckdb in duckdb/duckdb-skills

Explore and query data on S3, Cloudflare R2, GCS, MinIO, or any S3-compatible storage.

OfficialMITAuto-check: notesBackend & APIs

Install S3 Explore

skills CLI
$ npx skills add duckdb/duckdb-skills --skill s3-explore -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install duckdb/duckdb-skills s3-explore --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/duckdb/duckdb-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/s3-explore .claude/skills/s3-explore && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
s3-explore
GitHub stars
599
Used in
1 other repo
Token cost
~848 tokens
SKILL.md length
313 words
Files
1
Skills in repo
8
Repo updated
First seen
Licence
MIT

At a glance

Explore and query data on S3, Cloudflare R2, GCS, MinIO, or any S3-compatible storage.

  • Works in 3 steps: Detect provider and set up credentials → Determine what the URL points to → Answer the question
  • The user mentions an s3://
  • SKILL.md covers Step 1 — Detect provider and…, Step 2 — Determine what the…, Step 3 — Answer the question and Error handling
  • Calls duckdb and aws

What it does

S3 Explore is an agent skill from duckdb/duckdb-skills, published by the product's own GitHub organization. Explore and query data on S3, Cloudflare R2, GCS, MinIO, or any S3-compatible storage. Use when the user mentions an s3://, r2://, gs://, or gcs:// URL, asks "what's in this bucket", wants to list remote files, preview remote Parquet/CSV/JSON, or query data on object storage without downloading it. Also triggers when the user wants to know the size, schema, or row count of remote datasets.

Its SKILL.md is about 850 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Backend & APIs, covering File uploads and storage. It works with Cloudflare R2 and DuckDB. The licence is MIT.

When your agent uses it

  • The user mentions an s3://
  • Asks whats in this bucket
  • Wants to list remote files
  • Preview remote Parquet/CSV/JSON

Example prompts

  • “s in this bucket”
  • “/s3-explore”

Requirements

  • Pre-approved tools (allowed-tools): Bash

Workflow steps

3 steps, taken from the step headings in SKILL.md.

  1. Detect provider and set up credentials
  2. Determine what the URL points to
  3. Answer the question

What it can do on your machine

Read from SKILL.md and the folder at commit 7feda8e. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves these tools, so the agent can use them without asking each time:

    • Bash

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • duckdb
    • aws

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md. Its commands use aws, which can reach the network depending on how they are called.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

S3 Explore loads about 848 tokens when it runs. Until then it costs about 101 tokens; SKILL.md has 313 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~101
When it runs · the whole SKILL.md, loaded when a task matches
~848

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check: notes

The automated check noted patterns worth knowing about, such as sudo or a known installer.

  • NotePre-approves every shell command (allowed-tools: Bash)SKILL.md
    allowed-tools: Bash

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from duckdb/duckdb-skills at commit 7feda8e, republished under its MIT licence (© duckdb). 313 words, ~848 tokens.

Download SKILL.mdSave it as .claude/skills/s3-explore/SKILL.md (or your agent's skills folder).
name
s3-explore
description
Explore and query data on S3, Cloudflare R2, GCS, MinIO, or any S3-compatible storage. Use when the user mentions an s3://, r2://, gs://, or gcs:// URL, asks "what's in this bucket", wants to list remote files, preview remote Parquet/CSV/JSON, or query data on object storage without downloading it. Also triggers when the user wants to know the size, schema, or row count of remote datasets.
allowed-tools
Bash
argument-hint
<s3-url> [question about the data]

You are helping the user explore data on remote object storage using DuckDB.

URL: $0 Question: ${1:-list and describe what's there}

Step 1 — Detect provider and set up credentials

Based on the URL or user context, prepend the appropriate secret configuration:

ProviderURL patternsSecret setup
AWS S3s3://CREATE SECRET (TYPE S3, PROVIDER credential_chain);
Cloudflare R2r2://, s3:// with R2 endpointCREATE SECRET (TYPE R2, PROVIDER credential_chain);
GCSgs://, gcs://CREATE SECRET (TYPE GCS, PROVIDER credential_chain);
MinIO / customs3:// with custom endpointCREATE SECRET (TYPE S3, KEY_ID '...', SECRET '...', ENDPOINT '...', USE_SSL true);

For R2, if the user provides an account ID, the endpoint is <account_id>.r2.cloudflarestorage.com. R2 URLs like r2://bucket/path should be rewritten to s3://bucket/path with the R2 secret.

For public buckets (e.g., Overture Maps, AWS open data), no secret is needed — skip this step.

Always prepend:

sql
LOAD httpfs;

Step 2 — Determine what the URL points to

If the URL looks like a directory or bucket (no file extension, or ends with /), list its contents with sizes:

bash
duckdb -c "
LOAD httpfs;
<SECRET_SETUP>
SELECT filename, (size / 1024 / 1024)::DECIMAL(10,1) AS size_mb, last_modified
FROM read_blob('<URL>/*')
ORDER BY filename
LIMIT 50;
"

Note: only select filename, size, last_modified — never select content, which would download the actual files.

If the URL points to a specific file or glob pattern (has a file extension or contains *), preview it:

bash
duckdb -c "
LOAD httpfs;
<SECRET_SETUP>
DESCRIBE FROM '<URL>';
SELECT count(*) AS row_count FROM '<URL>';
FROM '<URL>' LIMIT 20;
"

For Parquet files, get row counts and sizes from metadata (no data download):

bash
duckdb -c "
LOAD httpfs;
<SECRET_SETUP>
SELECT file_name,
       sum(row_group_num_rows) AS total_rows,
       (sum(row_group_compressed_bytes) / 1024 / 1024)::DECIMAL(10,1) AS compressed_mb
FROM parquet_metadata('<URL>')
GROUP BY file_name;
"

Step 3 — Answer the question

Using the listing, schema, or sample data, answer:

${1:-list and describe what's there}

If the user asks an analytical question (e.g., "how many rows match X"), write and run the appropriate SQL query. DuckDB pushes predicates down into Parquet on S3, so filtering is efficient even on large remote datasets.

Error handling

  • duckdb: command not found → delegate to /duckdb-skills:install-duckdb
  • Access denied / 403 → suggest the user check credentials: aws configure, environment variables, or provide explicit key/secret
  • Bucket not found / 404 → check the URL and region
  • Timeout on large listing → suggest narrowing the glob pattern or adding a prefix

© duckdb, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in skills/s3-explore of duckdb/duckdb-skills.

Open the folder on GitHubat commit 7feda8e

Used in 1 other repository

We found 1 copy of this SKILL.md (exact, near-identical or edited) in other folders, from 1 other GitHub owner. This page covers the copy in duckdb/duckdb-skills, which our catalogue first saw on October 7, 2026.

Compare with similar skills

S3 Explore next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

S3 Explore compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
S3 Explore this skillduckdb/duckdb-skills5991 repos~848Automated safety check: NotesMIT
Arcgis To Portaljsdatopian/portaljs2.4k—~2kAutomated safety check: PassMIT
R2 Uploadzebbern/claude-code-guide4.6k1 repos~886Automated safety check: PassMIT
Cloudflare R2einverne/dotfiles121—~2.8kAutomated safety check: PassGPL-3.0
Cloudflare R2sickn33/agentic-awesome-skills47k2 repos~2.5kAutomated safety check: PassMIT
File Uploadsdavila7/claude-code-templates32k3 repos~238Automated safety check: PassMIT

Similar skills

  • Arcgis To Portaljs

    datopian/portaljs

    Migrate a whole ArcGIS Hub site into a PortalJS Arc portal end-to-end.

    2.4k GitHub stars~2k tokensUpdated 1 mo ago
    Backend & APIsAuto-check passed
  • R2 Upload

    zebbern/claude-code-guide

    Upload files to Cloudflare R2, AWS S3, or any S3-compatible storage (like MinIO) and generate secure, time-limited presigned download links with configurable expiration, typically set to 5 minutes.

    4.6k GitHub starsUsed in 1 repo~886 tokens
    Backend & APIsAuto-check passed
  • Cloudflare R2

    einverne/dotfiles

    Guide for implementing Cloudflare R2 - S3-compatible object storage with zero egress fees.

    121 GitHub stars~2.8k tokensUpdated 28 days ago
    Backend & APIsAuto-check passed
  • Cloudflare R2

    sickn33/agentic-awesome-skills

    Manage Cloudflare R2 buckets, lifecycle, and signed URLs. An agent skill from sickn33/agentic-awesome-skills.

    47k GitHub starsUsed in 2 repos~2.5k tokens
    Backend & APIsAuto-check passed
  • File Uploads

    davila7/claude-code-templates

    Expert at handling file uploads and cloud storage. An agent skill from davila7/claude-code-templates.

    32k GitHub starsUsed in 3 repos~238 tokens
    Backend & APIsAuto-check passed
  • Lunora Setup Storage

    anolilab/lunora

    Adds R2-backed file storage to a Lunora app. An agent skill from anolilab/lunora.

    283 GitHub stars~4.2k tokensUpdated today
    Backend & APIsAuto-check passed

More from duckdb/duckdb-skills

All 8 skills in this repo
  • Spatial

    duckdb/duckdb-skills

    Official

    Answer questions about spatial data using DuckDB. An agent skill from duckdb/duckdb-skills.

    599 GitHub starsUsed in 1 repo~1k tokens
    Auto-check: notes
  • Convert File

    duckdb/duckdb-skills

    Official

    Convert any data file to another format: CSV, Parquet, JSON, Excel, GeoJSON, and more.

    599 GitHub starsUsed in 1 repo~720 tokens
    Auto-check: notes
  • Read File

    duckdb/duckdb-skills

    Official

    Read any data file (CSV, JSON, Parquet, Avro, Excel, spatial, SQLite) or remote URL (S3, HTTPS).

    599 GitHub starsUsed in 1 repo~917 tokens
    Auto-check: notes
  • Attach DB

    duckdb/duckdb-skills

    Official

    Attach a DuckDB database file for use with /duckdb-skills:query.

    599 GitHub starsUsed in 1 repo~1.2k tokens
    Auto-check: notes
  • Duckdb Docs

    duckdb/duckdb-skills

    Official

    Search DuckDB and DuckLake documentation and blog posts. An agent skill from duckdb/duckdb-skills.

    599 GitHub starsUsed in 1 repo~1.4k tokens
    Auto-check: notes
  • Query

    duckdb/duckdb-skills

    Official

    Run SQL queries against the attached DuckDB database or ad-hoc against files.

    599 GitHub starsUsed in 1 repo~2k tokens
    Auto-check: notes

Categories

Questions about S3 Explore

What does S3 Explore do?

Explore and query data on S3, Cloudflare R2, GCS, MinIO, or any S3-compatible storage. S3 Explore is an agent skill from duckdb/duckdb-skills, published by the product's own GitHub organization. Explore and query data on S3, Cloudflare R2, GCS, MinIO, or any S3-compatible storage.

When should I use S3 Explore?

S3 Explore fits situations like: the user mentions an s3://; asks whats in this bucket; wants to list remote files; preview remote Parquet/CSV/JSON.

How do I install S3 Explore in Claude Code?

Run `npx skills add duckdb/duckdb-skills --skill s3-explore -a claude-code`. Or copy the skill folder (skills/s3-explore in duckdb/duckdb-skills) into .claude/skills/s3-explore in your project. Claude Code loads it when a task matches its description.

How do I install S3 Explore in Codex?

Run `npx skills add duckdb/duckdb-skills --skill s3-explore -a codex`. Or copy the skill folder (skills/s3-explore in duckdb/duckdb-skills) into .agents/skills/s3-explore in your project. Codex loads it when a task matches its description.

Can I use S3 Explore in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add duckdb/duckdb-skills --skill s3-explore -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/s3-explore, .gemini/skills/s3-explore, .github/skills/s3-explore and .opencode/skills/s3-explore in your project.

What does S3 Explore need to run?

Going by SKILL.md and its folder, S3 Explore needs the command-line tools its instructions call (duckdb and aws). Its frontmatter pre-approves these tools: Bash.

Does S3 Explore access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is S3 Explore safe to install?

Our automated static check of SKILL.md found notes only (pre-approves every shell command (allowed-tools: bash)), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.

What licence does S3 Explore use?

S3 Explore is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does S3 Explore use?

About 848 tokens (SKILL.md is roughly 3.4k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to S3 Explore?

Skills that share tags, products or a category with S3 Explore: Arcgis To Portaljs (datopian/portaljs, 2.4k stars), R2 Upload (zebbern/claude-code-guide, 4.6k stars), Cloudflare R2 (einverne/dotfiles, 121 stars) and Cloudflare R2 (sickn33/agentic-awesome-skills, 47k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains S3 Explore?

duckdb (a GitHub organization, an official publisher) maintains it in duckdb/duckdb-skills, which has 599 GitHub stars. The repository holds 8 skills in this directory. The repository was last updated on April 23, 2026.

Source: duckdb/duckdb-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.