Skip to content
Back to search

duckdb-skills

MarketplaceWorks with Claude CodeGitHubIncomplete

Safety scan

A static text scan, not a guarantee. Select the badge to see what was scanned and every finding.

Checked today
Badge for your README
findsafeskills safety rating

Markdown

[![findsafeskills safety rating](/api/listings/duckdb-duckdb-skills/badge.svg)](/listings/duckdb-duckdb-skills)

HTML

<a href="/listings/duckdb-duckdb-skills"><img src="/api/listings/duckdb-duckdb-skills/badge.svg" alt="findsafeskills safety rating" /></a>

Install

Install instructions from the README

As written by the repo's author. findsafeskills has not verified these steps.

From the Discover tab (coming soon)

We are working on submitting this plugin to the official Anthropic marketplace. Once listed, it will appear in the **Discover** tab when you run `/plugin` inside Claude Code.

From GitHub (available now)

Add the repository as a plugin source and install:

/plugin marketplace add duckdb/duckdb-skills
/plugin install duckdb-skills@duckdb-skills

This registers the GitHub repo as a marketplace and installs the plugin. Skills will be available as `/duckdb-skills:<skill-name>` in all future sessions.

Updating

To pull the latest version, update the marketplace first and then the plugin:

/plugin marketplace update duckdb-skills
/plugin update duckdb-skills@duckdb-skills

What was scanned

The files the safety scan read, as written by the repository's author and shown as plain text. Lines with a finding are marked.

.claude-plugin/marketplace.json · Manifest · 19 lines
  1. {
  2. "name": "duckdb-skills",
  3. "owner": {
  4. "name": "duckdb",
  5. "url": "https://github.com/duckdb"
  6. },
  7. "plugins": [
  8. {
  9. "name": "duckdb-skills",
  10. "source": "./",
  11. "description": "DuckDB-powered skills for Claude Code: read any data file, attach and query DuckDB databases, search DuckDB/DuckLake docs, search past session logs, and install/update DuckDB extensions.",
  12. "version": "0.2.5",
  13. "homepage": "https://duckdb.org",
  14. "repository": "https://github.com/duckdb/duckdb-skills",
  15. "license": "MIT",
  16. "keywords": ["duckdb", "ducklake", "parquet", "csv", "json", "avro", "excel", "iceberg", "delta", "read-file", "read-memories", "duckdb-docs", "data-exploration", "session-logs", "query", "sql", "attach-db"]
  17. }
  18. ]
  19. }
README.md · README · 138 lines
  1. # duckdb-skills
  2. A [Claude Code](https://claude.ai/code) plugin that adds DuckDB-powered skills for data exploration and session memory.
  3. ## Installation
  4. ### From the Discover tab (coming soon)
  5. We are working on submitting this plugin to the official Anthropic marketplace. Once listed, it will appear in the **Discover** tab when you run `/plugin` inside Claude Code.
  6. ### From GitHub (available now)
  7. Add the repository as a plugin source and install:
  8. ```
  9. /plugin marketplace add duckdb/duckdb-skills
  10. ```
  11. ```
  12. /plugin install duckdb-skills@duckdb-skills
  13. ```
  14. This registers the GitHub repo as a marketplace and installs the plugin. Skills will be available as `/duckdb-skills:<skill-name>` in all future sessions.
  15. ### Updating
  16. To pull the latest version, update the marketplace first and then the plugin:
  17. ```
  18. /plugin marketplace update duckdb-skills
  19. /plugin update duckdb-skills@duckdb-skills
  20. ```
  21. ## Skills
  22. ### `attach-db`
  23. Attach a DuckDB database file for interactive querying. Explores the schema (tables, columns, row counts) and writes a SQL state file so all other skills can restore the session automatically. You can choose to store state in the project directory (`.duckdb-skills/state.sql`) or in your home directory (`~/.duckdb-skills/<project>/state.sql`).
  24. ```
  25. /duckdb-skills:attach-db my_analytics.duckdb
  26. ```
  27. Supports multiple databases — running `attach-db` again can append to the existing state file.
  28. ### `query`
  29. Run SQL queries against attached databases or ad-hoc against files. Accepts raw SQL or natural language questions. Uses DuckDB's Friendly SQL dialect. Automatically picks up session state from `attach-db`.
  30. ```
  31. /duckdb-skills:query FROM sales LIMIT 10
  32. /duckdb-skills:query "what are the top 5 customers by revenue?"
  33. /duckdb-skills:query FROM 'exports.csv' WHERE amount > 100
  34. ```
  35. ### `read-file`
  36. Read and explore any data file — CSV, JSON, Parquet, Avro, Excel, spatial, SQLite, Jupyter notebooks, and more — locally or from remote storage (S3, GCS, Azure, HTTPS). Auto-detects the format by file extension using a built-in `read_any` table macro. Suggests `query` for further exploration.
  37. ```
  38. /duckdb-skills:read-file variants.parquet what columns does it have?
  39. /duckdb-skills:read-file s3://my-bucket/data.parquet describe the schema
  40. /duckdb-skills:read-file https://example.com/data.csv how many rows?
  41. ```
  42. ### `duckdb-docs`
  43. Search DuckDB and DuckLake documentation and blog posts using full-text search against the hosted search indexes. No local setup required — queries run over HTTPS by default, with an option to cache the index locally for faster offline searches.
  44. ```
  45. /duckdb-skills:duckdb-docs window functions
  46. /duckdb-skills:duckdb-docs "how do I read a CSV with custom delimiters?"
  47. ```
  48. ### `read-memories`
  49. Search past Claude Code session logs to recover context from previous conversations — decisions made, patterns established, open TODOs. Offloads large result sets to a temporary DuckDB file for interactive drill-down.
  50. ```
  51. /duckdb-skills:read-memories duckdb --here
  52. ```
  53. ### `install-duckdb`
  54. Install or update DuckDB extensions. Supports `name@repo` syntax for community extensions and a `--update` flag that also checks whether your DuckDB CLI is on the latest stable version.
  55. ```
  56. /duckdb-skills:install-duckdb spatial httpfs
  57. /duckdb-skills:install-duckdb gcs@community
  58. /duckdb-skills:install-duckdb --update
  59. ```
  60. ## Session state
  61. All skills share a single `state.sql` file per project — a plain SQL file containing ATTACH/USE/LOAD statements, secrets, and macros. When state is first needed, you'll be asked where to store it:
  62. 1. **In the project directory** (`.duckdb-skills/state.sql`) — colocated with the project, optionally gitignored
  63. 2. **In your home directory** (`~/.duckdb-skills/<project>/state.sql`) — keeps the repo clean
  64. The file is append-only and idempotent. Any skill restores the session via `duckdb -init state.sql`.
  65. ## Local development
  66. To test skills locally from a clone of this repo:
  67. ```bash
  68. # 1. Clone the repo
  69. git clone https://github.com/duckdb/duckdb-skills.git
  70. cd duckdb-skills
  71. # 2. Launch Claude Code with the local plugin directory
  72. claude --plugin-dir .
  73. ```
  74. This loads the plugin from disk instead of the marketplace, so any edits to `skills/*/SKILL.md` take effect immediately — just start a new conversation (or re-run the slash command) to pick up changes.
  75. You can test individual skills directly:
  76. ```
  77. /duckdb-skills:read-file some_local_file.parquet
  78. /duckdb-skills:duckdb-docs pivot unpivot
  79. /duckdb-skills:query SELECT 42
  80. ```
  81. **Prerequisites:** DuckDB CLI must be installed. If it isn't, the skills will offer to install it via `/duckdb-skills:install-duckdb`.
  82. ## How the skills work together
  83. Skills reference each other where it makes sense:
  84. - `read-file` suggests `query` for follow-up exploration and `attach-db` for persisting large files
  85. - `query`, `read-file`, and `read-memories` all use `duckdb-docs` to troubleshoot DuckDB errors automatically
  86. - All skills share the same `state.sql` — secrets and macros set up by `read-file` are reused by `query`, and databases attached by `attach-db` are available everywhere
  87. ## Platform support
  88. These skills have been tested on **macOS** and **Linux**. Windows is not yet fully supported — some shell commands and path handling may not work as expected. We plan to improve Windows compatibility in a future release.
  89. ## Reporting issues & suggestions
  90. Found a bug or have an idea for improvement? Open an issue at:
  91. **https://github.com/duckdb/duckdb-skills/issues**
  92. For DuckDB-specific bugs (extension loading, SQL errors), please include the DuckDB version (`duckdb --version`) and the full error message.

Ratings and comments

Sign in to rate this skill.

Sign in

Free to use. If it’s helped, pass it on.