Add a dbt-optimizer agent: scan dbt projects for fixable issues with cost/impact reporting
Nobody has claimed this yet.
Assessment
- Difficulty
- 5/5
- Estimated time
- Over a week
- Newbie friendliness
- 32/100
- Issue type
- Feature
- Clarity
- Mostly clear
- Activity status
- Quiet
- Tech stack
- sql, typescript
- Domain
- ai, data-engineering
Research direction
Start with docs/internal/2026-08-12-dbt-optimization-taxonomy-research.md and map its detection areas to the planned dbt-optimizer agent behind the Optimize workflow. Define the read-only scan, candidate selection, fix application, cost/impact reporting, and PR outputs, while preserving the stated warehouse-write, equivalence, and query-history safety gates. Done means the named agent covers the agreed scope without weakening those requirements.
Written by the indexing model from the issue text.
Description
Feature
Add a new native primary agent, dbt-optimizer, that scans an existing dbt project for concrete, fixable issues and proposes targeted fixes with cost and impact reporting. This is the agent behind the planned Optimize workflow.
Input: an existing dbt project (connected repository and environment).
Output: candidates (detected issues), fixes for user-selected candidates, impact reports (batch effect incl. estimated cost change), and PRs for applied fixes.
Detection scope (from the dbt-optimization taxonomy research, docs/internal/2026-08-12-dbt-optimization-taxonomy-research.md):
- materialization & incremental processing (strategy-aware: merge / delete+insert / insert_overwrite / microbatch, precondition-gated)
- warehouse physical design (clustering / partitioning / sort keys, query-history gated)
- SQL anti-patterns, DAG economics (fan-out, duplicate scans, dead models), run-level orchestration (Slim CI, threads, full-refresh overuse), tests/docs/storage
Safety requirements: scan phase is read-only; warehouse writes denied non-overridably; SQL rewrites gated on decidable equivalence; cost claims only from attributed query-history evidence.
Named dbt-optimizer (not optimizer) because more optimizer agents are planned later.
- Dominant language
- TypeScript
- Stars
- 813
- Forks
- 134
- Avg merge
- 2d 3h
- Merged PRs (30d)
- 65
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from AltimateAI/altimate-code
-
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
AltimateAI/altimate-code#1359 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
AltimateAI/altimate-code#1323 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 86/100
AltimateAI/altimate-code#1288 ·
-
Difficulty 1/5 Under an hour Newbie friendliness 92/100
AltimateAI/altimate-code#1285 ·
-
privacy: Altimate Base consent dialog no longer discloses persistent per-installation identifier Open
Difficulty 1/5 Under an hour Newbie friendliness 88/100
AltimateAI/altimate-code#1284 ·
All issues in AltimateAI/altimate-code
Similar issues
-
bug(cli): hapi doctor inline-media prints a fabricated B:\ helper-script path in packaged installs Open
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
-
Crush Open
Difficulty 1/5 Under an hour Newbie friendliness 85/100
catppuccin/catppuccin#3125 ·
-
Add a SECURITY.md Open
Difficulty 1/5 Under an hour Newbie friendliness 90/100
ElementsProject/cln-application#167 · 1 comment · 1 reaction ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
Quantco/pnpm-licenses#17 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100