agentmods.dev

dbt_duckdb_demo_public: Agent for Claude Code

.claude/agents/investigator.md

investigator is an agent for Claude Code from edwinweber/dbt_duckdb_demo_public. It costs 0 tokens per session (1,133 once invoked), scanned A, original, MIT.

A read-only troubleshooting assistant for data pipelines, databases, dashboards, and automated builds. It examines evidence such as logs, error traces, files, schemas, and settings to identify likely causes.

In plain words
What is it for?
Use it to investigate failed Dagster runs, incomplete data extractions, dbt or DuckDB problems, Metabase connection issues, CI failures, and confusing test results.
Why use it?
It helps when a system fails or behaves unexpectedly and the cause is unclear. It separates diagnosis from making changes, so an engineer can review the findings before fixing anything.

Agent for Claude Code

Written for Claude Code: installed under .claude/. Also seen: model in frontmatter.

This is edwinweber/dbt_duckdb_demo_public's own configuration. It tells Claude Code how to work on dbt_duckdb_demo_public itself, so it is not a mod to install elsewhere. Copy it as a starting point and replace the rules that are about this project. Everything dbt_duckdb_demo_public configures →

not rated 58repo +1 changed 13d ago A scan 0 tokens original MIT
View source ↗ edwinweber/dbt_duckdb_demo_public
Reuse

Borrowing it

Nothing to install: this file belongs to edwinweber/dbt_duckdb_demo_public. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file
curl -O https://raw.githubusercontent.com/edwinweber/dbt_duckdb_demo_public/main/.claude/agents/investigator.md
Clone the repo
git clone --depth 1 https://github.com/edwinweber/dbt_duckdb_demo_public

Made for: Claude Code.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for investigator

README.md
[![agentmods](https://agentmods.dev/badge/agents/edwinweber/dbt_duckdb_demo_public/investigator/github.svg)](https://agentmods.dev/agents/edwinweber/dbt_duckdb_demo_public/investigator)
Your own site
<a href="https://agentmods.dev/agents/edwinweber/dbt_duckdb_demo_public/investigator"><img src="https://agentmods.dev/badge/agents/edwinweber/dbt_duckdb_demo_public/investigator/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for investigator

Your own site · 80×15
<a href="https://agentmods.dev/agents/edwinweber/dbt_duckdb_demo_public/investigator"><img src="https://agentmods.dev/badge/agents/edwinweber/dbt_duckdb_demo_public/investigator.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 0 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 1,133 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00000 $0.01133
Opus 5.5 $0.00000 $0.00453
Sonnet 5.5 $0.00000 $0.00227
Haiku 4.5 $0.00000 $0.00113

Measured 13d ago against content hash 19be0af1d299, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

investigator scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 13d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

.claude/agents/investigator.md · 43 lines

How it starts

The opening of the file, as written. The whole thing — 43 lines — stays where its author put it; the contents beside it link to each section on GitHub.

You are a diagnostic agent for Danish Democracy Data (dbt_duckdb_demo). When something is broken, your job is to find out why — not to fix it (that's the engineer's job). Reason from evidence: logs, stack traces, file state, DuckDB schema, environment variables.

Project context for diagnosis

Pipeline stages and their failure modes:

  • dlt extraction (ddd_dlt/): silently partial extracts (network timeout mid-page), MySQL connection hangs (use connect_timeout=30), extraction gaps longer than the lookback window (changes in the gap are missed until a full extraction).
  • dbt build (dbt/): outside Docker, DuckDB lock conflicts (another process holds the .duckdb file — check DBeaver, a DuckDB shell); in Docker, duckdb_server down or a token mismatch. Silver runs stop on purpose on a missing bookmark, a late Bronze file, a probable mass delete (delete guard) or a _full file new together with other files — the message says which (runbook §7). Also macro expansion errors (Jinja) and type conversion errors (a real source type change).
  • Dagster (ddd_dagster/): asset materialisation failures, sensor tick errors (ntfy.sh POST failure is non-blocking — warn only), schedule timezone issues (Europe/Copenhagen), executor configuration (in_process vs multiprocess).
  • Delta Lake export (ddd_dlt/export_*.py): delta_scan anti-join dedup returning wrong rows, PyArrow schema mismatch on write_deltalake, Azure credential errors (AZURE_TENANT_ID/CLIENT_ID/SECRET), OneLake path construction.
  • DuckLake mode (SILVER_STORAGE_FORMAT=ducklake): catalog file corruption, leftover _current_temp directories from earlier Silver macro versions (run ducklake_cleanup_job manually), Silver tables missing from ducklake_catalog.main_silver after a failed run.
  • Metabase (docker/Dockerfile.metabase): cannot connect to the quack server (check QUACK_SERVER_TOKEN matches and duckdb_server is up; the rendered init SQL is $METABASE_DATA_DIR/duckdb-init.sql, default /data/metabase/data/duckdb-init.sql); it uses DuckDB JDBC 2.0 with ATTACH + USE, and DuckLake Silver tables are not listed in its schema browser (query them as danish_democracy_data.ducklake_catalog.main_silver.<table>).
  • quack server (ddd_dlt/duckdb_quack_server.py): token too short (must be ≥4 chars), DUCKLAKE_CATALOG_LOCATION missing in ducklake mode, DuckDB extension not installed server-side.
  • CI (pyproject.toml): ruff check/format failures, mypy errors, pytest failures from entity list count mismatches in test_configuration_variables.py.

Read the full file on GitHub · 43 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 13d ago Changed 19be0af1d299
  2. 14d ago Changed · +1 lines 3ce5194e88a1
  3. 23d ago Changed 0c30e7ec7494
  4. 2mo ago First seen · 42 lines · 0 tokens per session scan A c85b5918a257

Subscribe to this mod's changes

investigator is an agent published in the GitHub repository edwinweber/dbt_duckdb_demo_public (58 stars, last pushed 9d ago), licensed MIT. It costs nothing until one of its globs matches a file; then it loads 1,133 tokens. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Debuggingdata-engineeringdbtdelta-lakedltduckdbmedallion-architecture
Related

investigator compared with agents from other repositories

investigator next to 6 agents from other repositories
ModTypeStarsLast pushLicenceScanTokensWorks with
investigatoredwinweber/dbt_duckdb_demo_publicAgent589d agoMITA0Claude Code
perf-reviewerdathere/qsvAgent3.8kyesterdaynoneA76Claude Code
databricks-notebook-analyzeroracle-samples/oracle-aidp-samplesAgent582d agoUPL-1.0A108Claude Code
debuggerTT-Wang/forgeAgent353d agoMITA17Claude Code
loom-advisorcosmix/loomAgent655d agoMITA53Claude Code
scramjet:instruction-semantics-analyzerLeanAndMean/scramjetAgent84d agoApache-2.0A35Claude Code
wizardskeggsguy/adventure-partyAgent624d agoMITA60Claude Code