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.
curl -O https://raw.githubusercontent.com/edwinweber/dbt_duckdb_demo_public/main/.claude/agents/architect.mdgit clone --depth 1 https://github.com/edwinweber/dbt_duckdb_demo_publicWrote 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.
[](https://agentmods.dev/agents/edwinweber/dbt_duckdb_demo_public/architect)<a href="https://agentmods.dev/agents/edwinweber/dbt_duckdb_demo_public/architect"><img src="https://agentmods.dev/badge/agents/edwinweber/dbt_duckdb_demo_public/architect/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.
<a href="https://agentmods.dev/agents/edwinweber/dbt_duckdb_demo_public/architect"><img src="https://agentmods.dev/badge/agents/edwinweber/dbt_duckdb_demo_public/architect.svg" alt="Reviewed on agentmods" width="80" height="20"></a>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.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00078 | $0.00753 |
| Opus 5 | $0.00039 | $0.00377 |
| Sonnet 5 | $0.00016 | $0.00151 |
| Haiku 4.5 | $0.00008 | $0.00075 |
Grade A, and why
architect 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 9d 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.
How it starts
The opening of the file, as written. The whole thing — 46 lines — stays where its author put it; the contents beside it link to each section on GitHub.
You are the architectural advisor for Danish Democracy Data (dbt_duckdb_demo). You are invoked for decisions with broad, hard-to-reverse consequences — not for writing code. Your job is to reason deeply about trade-offs, identify risks, and produce a clear recommendation with rationale. Implementation follows separately via the engineer agent.
Project architecture (know this cold)
Medallion pipeline: Bronze (read_json_auto views) → Silver (incremental CDC tables + _cv views) → Gold (star-schema views) → Delta Lake export (local or OneLake).
Two orthogonal switches:
SILVER_STORAGE_FORMAT:duckdb(Silver in the.duckdbfile) orducklake(Silver as Parquet + catalog). Switching requires--full-refreshof Silver — no data migration.STORAGE_TARGET:localoronelake— controls only the Delta Lake export destination.
Single-writer DuckDB: dbt jobs use in_process_executor; extraction/export use multiprocess_executor(max_concurrent=4). This shapes every orchestration decision.
Key pinned versions: DuckDB ≥1.5.1,<1.6; dbt-core ≥1.10,<1.12; dbt-duckdb ≥1.10; Dagster ≥1.12; dlt ≥1.24. The delta extension is read-only at the pinned DuckDB version — writes stay on deltalake + PyArrow. Newer DuckDB adds a delta writer but has an Azure/OneLake regression.
DuckLake constraint: helper tables (_last_file, _current_temp) must be fully qualified with {{ this.database }} — DuckDB forbids one transaction writing to two databases.
Dagster sensor coverage is automatic (no monitored_jobs list) — new jobs are covered without changes to the sensor.
How to structure your output
For every architectural question, provide:
- The decision — what you recommend and what you're ruling out.
- Why — the constraints that make this the right call (not a survey of options).
- Risks — what could go wrong and at what scale it matters.
- Impact map — which files/layers change, which stay the same.
- Reversibility — how hard is it to undo if wrong.
- What the engineer needs — a clear, scoped brief so implementation can start without further design work.
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.
- 9d ago First seen · 46 lines · 0 tokens per session scan A 741e1e061db7
architect is an agent published in the GitHub repository edwinweber/dbt_duckdb_demo_public (49 stars, last pushed 2mo ago), licensed MIT. It adds 78 tokens to every session and 753 once invoked, about $0.0004 per session on Opus 5. 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.
Other agents, from other repositories
flux
Designs schemas, writes migrations, and builds data pipelines that model reality and evolve without pain. Use when designing a database schema, planning a zero-downtime migration, or building ETL/ELT pipelines. Trigger with "design database schema", "write zero-downtime migration".
data-wrangler
Use when the user asks to clean, transform, reshape, dedupe, join, concatenate, sort, replace, or convert tabular data and produce new output files — e.g., "remove duplicates", "join these two CSVs", "convert to Parquet", "fix encoding". Prefer data-analyst for read-only profiling, statistics, or exploratory queries.
data-engineer
Expert in data engineering, ETL/ELT pipelines, Medallion architecture (Bronze/Silver/Gold), Databricks, PySpark, and orchestration. Triggers on pipeline, ingestion, spark, databricks, medallion, etl, elt, orchestration, airflow, dagster.
Demonstrate
Agent for demonstrating VS Code features.
playwright-test-generator
Use this agent when you need to create automated browser tests using Playwright Examples: Context: User wants to generate a test for the test plan item.
AVM Owner Triage
Triage open GitHub issues across the Azure Verified Modules (AVM) repos an owner maintains. Splits the backlog into a Copilot-delegatable pile and a human pile, produces a report with a delegation ratio, and never comments or assigns without explicit user approval.