Ledger
Government budget tracking
Ledger is a public, read-only explorer for the U.S. DoD FY2026–FY2027 budget. Browse RDT&E and Procurement programs through a drill-down hierarchy or Sankey flow diagram, with full justification-book narratives behind every program.
JavaScriptSupabaseClaudeNetlify
https://ledger-demo.netlify.appOpen ↗
Live demo
Try Ledger with seed data
What it does
- Budget hierarchy (tier) view — Service → Account → Budget Activity → program tree across the full FY2026–FY2027 DoW budget
- Sankey diagram of funding flows, from service toplines down to individual program elements
- Program drawers with J-Book narratives, budget-year detail, and source references
- Search and filtering: program/title/mission text, Budget Activity, active vs terminated programs, service and appropriation facets
- Zero-input read-only posture — no login, no API keys; writes blocked at the SDK layer and by server-side RLS
What you get
- Pre-seeded entire FY26 and FY27 DoW budget — schema migration plus a 94-file SQL seed (~12,500 rows: appropriations, orgs, program elements, projects, narratives)
- Single-page JavaScript app — no build step; deploys as static files plus one Netlify function
- Supabase Postgres schema with read-only RLS policies and anon-safe RPCs
- Claude-driven installer (.claude/skills/setup-ledger) that stands up Supabase + Netlify end to end
- Documented manual setup path (docs/SETUP.md) and Netlify deployment config
- MIT license
Run it locally
# Two paths to install. Both end at the same working app.
#
# 1. Claude-driven (~15 min, recommended)
# With Claude + the Supabase and Netlify MCPs connected, the bundled
# .claude/skills/setup-ledger skill drives the whole install.
#
# 2. Manual — full walkthrough in docs/SETUP.md.
#
# Manual quick start:
git clone https://github.com/reesemozer/ledger-public.git
cd ledger-public
# Apply schema (substitute your Supabase DB_URL)
psql "$DB_URL" -f supabase/migrations/000_ledger_schema.sql
# Load the budget seed (~30 s over the pooler)
for f in supabase/seed/budget/*.sql; do psql "$DB_URL" -f "$f"; done
# Deploy to Netlify with env vars set:
# WAYPOINT_ENV=demo
# SUPABASE_URL, SUPABASE_ANON_KEY