Home / fmind / dot · skills/duckdb/SKILL.md · GitHub

duckdb skillA

duckdb is agent-read markdown (skill) from fmind/dot: Query, transform, and export files or databases with DuckDB and SQLite..

Indexed from public GitHub and served as immutable, content-addressed versions. Install it pinned to an exact SHA-256 with the mdr CLI, and every file is verified against the hash recorded here before it reaches your agent. The deterministic audit below grades the latest version, and the same file always earns the same grade.

What the file says

# DuckDB and SQLite

DuckDB is the default engine for local analysis: it reads CSV, Parquet, and JSON directly, attaches SQLite files, and writes any of them back. SQLite stays the embedded store for applications; DuckDB is the tool you point at data.

## Commands

```bash
duckdb -c "SELECT name, score FROM 'people.csv' WHERE score > 80 ORDER BY score DESC"   # files are tables
duckdb -json -c "SELECT * FROM 'events/*.json'"                                          # JSON output for agents and jq
duckdb lab.duckdb -c "CREATE OR REPLACE TABLE people AS FROM 'people.csv'"               # persist into a database file
duckdb -c "COPY (FROM 'people.csv') TO 'people.parquet'"                                 # convert; Parquet is the durable format
duckdb -c "ATTACH 'app.sqlite' AS s (TYPE sqlite, READ_ONLY); SELECT count(*) FROM s.users"         # read an application database
duckdb -c "SUMMARIZE FROM 'people.parquet'"                                              # column stats in one call
sqlite3 -readonly app.sqlite ".schema" && sqlite3 -readonly app.sqlite "PRAGMA integrity_check"              # inspect the app store itself
```
…

Read the whole file at its exact version.

How to install

Latest version
mdr add fmind/dot/duckdb@git:20260919.4491844
Exact content
mdr add fmind/dot/duckdb@sha256:b2afa2a83ea7c066

Pin to a label to follow the author's releases, or to a sha256 to freeze the exact bytes forever. Either way the resolved hash is written to mdr.lock, and mdr install reproduces it on any machine.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_srktlagokfdp3y4l.svg)](https://markdownregistry.com/a/art_srktlagokfdp3y4l)

1 badge views in 30 days

Versions

versioncommittedcommitsizeaudit
git:20260919.4491844 latest2026-09-19 4491844 4,119 BA view · diff
git:20260916.50d68102026-09-16 50d6810 4,095 BA view · diff
git:20260912.0ce18c02026-09-12 0ce18c0 4,166 BA view · diff
git:20260909.892d8592026-09-09 892d859 4,049 BA view · diff
git:20260909.17296ea2026-09-09 17296ea 3,869 BA view

Audit of the latest version

A  17 of 17 checks passed. Deterministic, no model, same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (4119 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

fmind/dot · 9 stars · license MIT · pushed 2026-09-24 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_srktlagokfdp3y4l
GET https://markdownregistry.com/api/v1/resolve?ref=fmind/dot/duckdb
GET https://markdownregistry.com/api/v1/blob/b2afa2a83ea7c066c469caf7d687f4af536c9c2241d6862b21940acac3180256

Your agent does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

More from fmind/dot

chezmoi skill
fmind/dot · .agents/skills/chezmoi/SKILL.md · Manage chezmoi source names, templates, secrets, diffs, and deployment in fmind/dot.
git:20260920.d5fedf5 · audit A · 9 stars
dot-development skill
fmind/dot · .agents/skills/dot-development/SKILL.md · Develop fmind/dot CLI commands, session parsers, storage, configuration, and installation.
git:20260920.d5fedf5 · audit A · 9 stars
dot-release skill
fmind/dot · .agents/skills/dot-release/SKILL.md · Prepare, publish, recover, and verify fmind/dot releases through the repository task.
git:20260920.d5fedf5 · audit A · 9 stars
dot-skills skill
fmind/dot · .agents/skills/dot-skills/SKILL.md · Maintain fmind/dot skill packages, catalog budgets, routing contracts, and installed links.
git:20260920.d5fedf5 · audit A · 9 stars
dot-verify skill
fmind/dot · .agents/skills/dot-verify/SKILL.md · Qualify the fmind/dot working tree before a release: review changes, sync docs, run every gate, and smoke-test the dot…
git:20260924.4be3d0c · audit A · 9 stars
AGENTS.md agents
fmind/dot · AGENTS.md
git:20260920.d5fedf5 · audit A · 9 stars
CLAUDE.md claude
fmind/dot · CLAUDE.md
git:20260903.fa1d8bb · audit B · 9 stars
AGENTS.md@dot_agents agents
fmind/dot · dot_agents/AGENTS.md
git:20260920.d5fedf5 · audit A · 9 stars
acli skill
fmind/dot · skills/acli/SKILL.md · Search, plan, and update Atlassian Jira and Confluence with acli.
git:20260920.d5fedf5 · audit A · 9 stars
agent-evaluation skill
fmind/dot · skills/agent-evaluation/SKILL.md · Evaluate prompt, model, retrieval, and agent changes through repeated trials and outcome grading.
git:20260916.50d6810 · audit A · 9 stars
agent-frameworks skill
fmind/dot · skills/agent-frameworks/SKILL.md · Build Python agents with Google ADK, LangChain, LangGraph, and agents-cli: tools, state, and retrieval.
git:20260916.50d6810 · audit A · 9 stars
agent-harnesses skill
fmind/dot · skills/agent-harnesses/SKILL.md · Operate and configure Claude Code, Codex, Copilot, Grok, and OpenCode.
git:20260919.afe8ee0 · audit A · 9 stars

Every file in fmind/dot

Browse by kind, by grade A, or by owner.