M
markatdataandbeyond/dbu-waste-finder
A free, read-only Databricks notebook that shows where your DBUs go and which resources look wasteful, using only
updated 2026-10-30
View on GitHub ↗Direct link · no redirect page
We have neither an install command nor a public remote endpoint from this repository, so we do not print a config. A made-up one is worse than none. How each client wires MCP up →
- Star count
- 0 ★ · markatdataandbeyond/dbu-waste-finder · read from the GitHub search API · (checked 2026-11-19 20:00:48)
- Source
- collected from the punkpeye/awesome-mcp-servers list · type: MCP server
- Harvest history
- first seen 2026-11-18 · last seen 2026-11-20 · seen 3× · listed by 3 sources
- Score
- score 300 · 3 sources · mcp
FAQ (answers come from our records)
Who is it for?
We filed it under these tags: MCP servers. The tags come from the entry itself, not a taxonomy we imposed.
Who maintains it?
repository
markatdataandbeyond/dbu-waste-finder;first catalogued 2026-11-18;last seen 2026-11-20。There is no official certification or quality rating here — we record sources and dates only.README excerpt (English, untranslated) · Read the full README on GitHub →
# DBU Waste Finder
Excerpted from the repository README (abridged)
A free, read-only Databricks notebook that shows where your DBUs go and which resources look wasteful, using only
Databricks system tables. One notebook, no install; the notebook sends nothing out of your workspace.
This repo contains two things:
notebook/ – the free notebook (below).
mcp/ – an MCP server so Claude/Cursor can answer "why did our bill jump?" from your system tables and propose fixes as a diff to your Asset Bundle (read-only, never applied). See mcp/README.md.
Landing page: https://markatdataandbeyond.github.io/dbu-waste-finder/
## What it checks
| Check | Source tables |
| Cost by product and top 20 cost drivers (jobs, warehouses, clusters) at list price | system.billing.usage + system.billing.list_prices |
| Jobs running on all-purpose compute, with the list-price difference to job compute (ratio from the cluster's own billed SKU and cloud in list_prices; on a shared cluster only the share of billed time used by job runs counts, the full figure is shown as est_saving_upper_bound_usd) | system.lakeflow.job_task_run_timeline (compute_ids), system.compute.clusters |
| All-purpose clusters with auto-termination off (0/NULL) or above 60 min, incl. clusters deleted inside the window | system.compute.clusters (latest SCD row) |
| Idle or oversized clusters (avg CPU =3 days, have 0.23".
low_confidence: true (plus a note) when observation_days < 7 (3–7 days: projection shown but flagged). Exactly 7 is not flagged.
This is an extrapolation of past waste at list price, not a promise of what you will get back.
## Demo output (example data)
The snippet below is example / fixture data, not a live workspace. It was produced by running the MCP tools
(cost_summary, top_cost_drivers, find_waste, propose_fix) against the same mock system-table rows the
unit tests use.
text
cost_summary(days=15)
total_list_cost_usd: 1000.00 (JOBS 700 + ALL_PURPOSE 300; usd_complete=false, GENIE_FREE_USAGE unpriced)
daily: 2026-10-01 → $33.30
top_cost_drivers(days=15)
job etl-nightly $500.00
cluster c-shared-01 $300.00
warehouse wh-sql-01 $120.00
find_waste(days=15)
measured_saving_usd: 203.15 measured_waste_dbu: 4.5
observation_days: 15.0 projected_30d_usd: 406.30
jobs_on_all_purpose: c-shared-01 (2 jobs, est. $165 if moved to job compute)
missing_autotermination: c-adhoc-02 (auto_termination_minutes=0)
idle_or_oversized: c-idle-03 (CPU 4 %, mem 12 %, est. $35)
idle_warehouse: wh-sql-01 (98.4 % idle, 4.0 DBU → $2.80)
delta_needs_optimize: main.bronze.events (500 files, ~4 MiB avg)
delta_needs_vacuum: main.bronze.events (40 days since vacuum, ~3 GiB reclaimable)
delta_overfrequent_optimize: main.silver.orders (14 OPTIMIZE runs / 7 days)
propose_fix(issue="delta_optimize", resource_key="main.bronze.events")
-- Proposal only; review before running. DBU Waste Finder never executes this.
OPTIMIZE main.bronze.events;
## Live trial run (real workspace, 2026-10-29)
Not fixture data. Same tools (cost_summary, top_cost_drivers, find_waste, cost_review_report) against a Databricks trial workspace over serverless SQL (Statement API + system tables only).
| Field | Value |
| Observed days | 2.84 (30-day lookback requested) |
| Total list-price cost | $18.17 (usd_complete: false — GENIE_FREE_USAGE 0.326 DBU unpriced) |
Databricks system tables. One notebook, no install; the notebook sends nothing out of your workspace.
This repo contains two things:
notebook/ – the free notebook (below).
mcp/ – an MCP server so Claude/Cursor can answer "why did our bill jump?" from your system tables and propose fixes as a diff to your Asset Bundle (read-only, never applied). See mcp/README.md.
Landing page: https://markatdataandbeyond.github.io/dbu-waste-finder/
## What it checks
| Check | Source tables |
| Cost by product and top 20 cost drivers (jobs, warehouses, clusters) at list price | system.billing.usage + system.billing.list_prices |
| Jobs running on all-purpose compute, with the list-price difference to job compute (ratio from the cluster's own billed SKU and cloud in list_prices; on a shared cluster only the share of billed time used by job runs counts, the full figure is shown as est_saving_upper_bound_usd) | system.lakeflow.job_task_run_timeline (compute_ids), system.compute.clusters |
| All-purpose clusters with auto-termination off (0/NULL) or above 60 min, incl. clusters deleted inside the window | system.compute.clusters (latest SCD row) |
| Idle or oversized clusters (avg CPU =3 days, have 0.23".
low_confidence: true (plus a note) when observation_days < 7 (3–7 days: projection shown but flagged). Exactly 7 is not flagged.
This is an extrapolation of past waste at list price, not a promise of what you will get back.
## Demo output (example data)
The snippet below is example / fixture data, not a live workspace. It was produced by running the MCP tools
(cost_summary, top_cost_drivers, find_waste, propose_fix) against the same mock system-table rows the
unit tests use.
text
cost_summary(days=15)
total_list_cost_usd: 1000.00 (JOBS 700 + ALL_PURPOSE 300; usd_complete=false, GENIE_FREE_USAGE unpriced)
daily: 2026-10-01 → $33.30
top_cost_drivers(days=15)
job etl-nightly $500.00
cluster c-shared-01 $300.00
warehouse wh-sql-01 $120.00
find_waste(days=15)
measured_saving_usd: 203.15 measured_waste_dbu: 4.5
observation_days: 15.0 projected_30d_usd: 406.30
jobs_on_all_purpose: c-shared-01 (2 jobs, est. $165 if moved to job compute)
missing_autotermination: c-adhoc-02 (auto_termination_minutes=0)
idle_or_oversized: c-idle-03 (CPU 4 %, mem 12 %, est. $35)
idle_warehouse: wh-sql-01 (98.4 % idle, 4.0 DBU → $2.80)
delta_needs_optimize: main.bronze.events (500 files, ~4 MiB avg)
delta_needs_vacuum: main.bronze.events (40 days since vacuum, ~3 GiB reclaimable)
delta_overfrequent_optimize: main.silver.orders (14 OPTIMIZE runs / 7 days)
propose_fix(issue="delta_optimize", resource_key="main.bronze.events")
-- Proposal only; review before running. DBU Waste Finder never executes this.
OPTIMIZE main.bronze.events;
## Live trial run (real workspace, 2026-10-29)
Not fixture data. Same tools (cost_summary, top_cost_drivers, find_waste, cost_review_report) against a Databricks trial workspace over serverless SQL (Statement API + system tables only).
| Field | Value |
| Observed days | 2.84 (30-day lookback requested) |
| Total list-price cost | $18.17 (usd_complete: false — GENIE_FREE_USAGE 0.326 DBU unpriced) |
Listed badge (optional)
Copy this line into the README if you want the listing mark. Optional, and it does not affect being listed.
[](https://anclum.com/en/s/markatdataandbeyond-dbu-waste-finder/)
- Source
- awesome · https://github.com/markatdataandbeyond/dbu-waste-finder
- Browse by field
- MCP servers
- Listed by
- 3 independent sources
- added
- today
More MCP servers
Filed under
Every tag opens the full list for that filter. Counts are the live catalogue figures.