Duckdb

Checked

silvainfm·vlatest·database

DuckDB enables fast in-process SQL querying of data files like CSV and Parquet – ideal for quick data exploration & analysis without a database server.

Repository

Install on your platform

Showing Claude Code. One command installs this skill into any of the agents below.

Run this in your project

terminal

$ npx skills add silvainfm/claude-skills --skill duckdb -a claude-code

Uses the open-source skills CLI and needs Node.js. Add -g to install it for your user instead of this project.

What we know about this skill

Publisher

silvainfm

Taken from the source listing. We haven't verified who controls this account.

Install target

Live repository

Not pinned. Installing fetches whatever the repository holds at the time you run the command.

No human has reviewed this code. The checks below are a static scan of the files at one commit — nobody has run this skill or judged whether it works. A skill runs with whatever access you give your agent, so read the source before you install it.

Automated safety checks

scanned 27 Sept 2026

This skill passed all 6 checks. We read its files at one commit and looked for the things that make a skill dangerous to run — not for whether it works.

Declares what it does: passed
SKILL.md parses and declares a name and a description.
SKILL.md exists, its frontmatter parses, and it declares a name and a description.
No undeclared network calls: passed
Makes no network calls.
Every host the skill dials — from its scripts, its config endpoints or the commands it tells the agent to run — is either well-known package and API infrastructure or declared in its own frontmatter. Links in documentation are not counted.
No obfuscated payloads: passed
No encoded or obfuscated payloads.
No base64, hex or compressed blob is decoded and then executed, and no encoded shell commands.
No credential access: passed
Reads no keys, tokens, keychains or credential files.
Neither the code nor the SKILL.md instructions read SSH keys, cloud credentials, keychains, token stores, browser cookie databases or dotfiles that hold secrets.
No pipe-to-shell installers: passed
No pipe-to-shell or download-and-run installers.
No `curl … | sh` pattern, in the code or in the instructions, that runs code fetched at run time.
Pinned to a commit: passed
Scanned silvainfm/claude-skills at 0af9d5be25.
The exact upstream commit SHA that was scanned is recorded, so the result refers to specific bytes.

Commit: 0af9d5be25
Manifest: duckdb/SKILL.md
Scanned: 2 files, 881 lines

This is a static scan, not a review. It reads the skill's files; it does not run them, and it cannot tell you whether the skill is any good or whether the code does what its description says. A skill runs with whatever access you give your agent.

What each check looks for →

About this skill

The DuckDB skill enables AI agents to execute SQL queries directly against local data files, allowing for instant analysis of CSVs, JSON, Parquet, and other formats without requiring a separate database server. It acts as an in-process analytical database that handles complex joins, aggregations, and time-series calculations efficiently within the agent's execution environment.

When to use it

Analyzing large datasets locally where setting up a persistent database cluster is impractical or too slow.
Performing ad-hoc exploratory data analysis on CSV or JSON files uploaded during a session.
Generating dynamic reports by joining multiple local data sources in real-time.
Validating data quality and performing aggregations before feeding results into downstream AI workflows.

Key capabilities

Reads diverse file formats including CSV, JSON, Parquet, SQLite, and Avro directly from the filesystem.
Executes full SQL dialects supporting complex joins, window functions, and recursive queries.
Operates as a zero-configuration, in-process engine requiring no external server installation.
Handles both single-threaded and parallel execution modes for varying data sizes.

Example prompts

"Load the sales_2023.csv file from my project directory and calculate the total revenue by region."
"Join the customers.json and orders.parquet files to find the top 5 customers by purchase frequency."
"Analyze the time-series data in events.log to identify any spikes in error rates over the last week."

Tips & gotchas

Ensure the AI agent has read permissions for the local file paths you specify, as DuckDB operates strictly on the local filesystem. While highly efficient for analytical workloads, avoid using this skill for high-concurrency transactional systems designed for persistent storage.