# Gluecron Master To-Do List Last updated: 2026-06-06 (rev 4 β€” full codebase audit complete, Bible is 35% of reality) **IMPORTANT:** The BUILD_BIBLE.md documents ~35% of the actual codebase. 34 migrations (0043–0076) and 87+ lib files exist beyond what the Bible tracks. This list is based on direct code scanning, not the Bible. Tick off items as they ship. Add `[x] YYYY-MM-DD commit:abc` when done. Work top-to-bottom within each priority. --- ## πŸ”΄ PRIORITY 1 β€” Configuration Blockers (Built, Just Not Configured) These are NOT build tasks β€” the code is complete. They need ops/config action. - [ ] **Verify SSH git push works end-to-end** β€” `src/lib/ssh-server.ts` is a full 545-line production implementation that starts at boot (`src/index.ts`). It handles `git-upload-pack` and `git-receive-pack`, does public-key auth against the `ssh_keys` table, and triggers post-receive hooks. Test from a clean machine: add an SSH key at `/settings`, then `git clone git@gluecron.com:user/repo.git`. If the SSH_PORT env var isn't set, default is 2222 β€” verify the port is open on the server. - [ ] **Enable AI Trio Review** β€” Three-model parallel PR review (security / correctness / style) is fully built in `src/lib/ai-review-trio.ts` and wired into `src/lib/ai-review.ts`. Set `AI_TRIO_REVIEW_ENABLED=1` to activate. This is a genuine differentiator β€” no other platform has this. - [x] 2026-06-06 **Fix duplicate migration number 0065** β€” Renamed `0065_auto_generate_tests.sql` to `0077_auto_generate_tests.sql` (was conflicting with `0065_ai_cost_events.sql`). Both migrations now have unique numbers. - [ ] **Set SERVER_TARGETS_KEY** β€” Server targets encrypt SSH private keys via AES. If `SERVER_TARGETS_KEY` env var isn't set, deploy target creation will fail silently. Set a 32-byte hex key in production. - [ ] **Set PREVIEW_DOMAIN** β€” Branch preview URLs are computed as `${branchSlug}-${repoSlug}.preview.gluecron.com` or `PREVIEW_DOMAIN` env var. Set this to match where previews will actually be served. --- ## 🟠 PRIORITY 2 β€” Genuine Code Gaps (Need Building) These are confirmed missing by direct code inspection. - [ ] **Container registry (Docker/OCI)** β€” No files exist for this anywhere in the codebase. npm package registry is complete (`src/lib/packages.ts`). The OCI push/pull protocol needs implementing: `GET /v2/`, `HEAD /v2/:name/blobs/:digest`, `POST /v2/:name/blobs/uploads/`, `PUT /v2/:name/manifests/:ref`. Without Docker support, teams with containerised apps can't fully leave GitHub. - [x] 2026-06-06 **Redis SSE fan-out** β€” `src/lib/sse.ts` rewritten. When `REDIS_URL` or `VALKEY_URL` is set, uses two `Bun.RedisClient` instances (pub + sub) with `autoReconnect`. Topic-scoped SUBSCRIBE/UNSUBSCRIBE. On disconnect, re-subscribes all channels. Falls back to local delivery if Redis unreachable. In-memory path unchanged when no URL set. Zero API changes to callers. - [x] 2026-06-06 **Workflow cache SAVE** β€” `saveCacheEntry()` implemented in `src/lib/actions/cache-action.ts`. DB-backed via `workflow_run_cache` Postgres table; tarballs paths, SHA-256 hashes, 100MB cap, upserts content. Wired in `src/lib/workflow-runner.ts` post-job. LOAD unchanged. - [x] 2026-06-06 **Pack-content ruleset enforcement** β€” `commit_message_pattern`, `blocked_file_paths`, `max_file_size` now blocking at push time via pre-receive hook (`GIT_CONFIG_COUNT` env injection). Git commands: `git log --format="%H %s"`, `git diff --name-only`, `git cat-file -s`. Wired in `src/routes/git.ts` (HTTP) and `src/lib/ssh-server.ts` (SSH). All 10 push-policy + 23 ruleset tests pass. - [x] 2026-06-06 commit:44ed968 **Branch preview expiry cleanup** β€” `expireOldPreviews()` wired as `preview-expiry` autopilot task in `src/lib/autopilot.ts`. Admin UI updated to show 10 tasks including `auto-merge-sweep`, `ai-build-from-issues`, and `preview-expiry`. - [x] 2026-06-06 **Server targets β†’ customer-facing** β€” `src/routes/deploy-targets.tsx` (414 lines). `GET/POST /settings/deploy-targets`, `POST /settings/deploy-targets/:id/delete`, `POST /settings/deploy-targets/:id/test`. AES-256-GCM encryption via `SERVER_TARGETS_KEY`. Ownership-gated. Added to settings subnav and registered in `src/app.tsx`. - [x] 2026-06-06 **Claude Web Sessions β†’ customer-facing** β€” `/:owner/:repo/claude` now open to all authenticated users with repo access. `listSessionsForUser()` scopes sessions to owner. Session list: colour-coded status badges, reverse-chron order. SSE stream via `GET /:owner/:repo/claude/:sessionId/stream?prompt=`. Spawns `claude --print --output-format stream-json`. "✨ Claude AI" sidebar card added to repo home (`src/routes/web.tsx`). - [x] 2026-06-06 **AI budget hard enforcement** β€” `assertAiQuota(userId)` added to `src/lib/billing.ts` with 60s in-memory cache. Wired into `ai-review.ts` (posts skip comment), `ai-review-trio.ts` (fail-closed trio result), `ai-ci-healer.ts` (returns skipped), `spec-to-pr.ts` (returns error to UI). Warn at 90%, throw `AiQuotaExceededError` at 100%. Fails open on DB error. - [x] 2026-06-06 **Spec-to-Live real-time progress UI** β€” `src/routes/specs.tsx` (+593 lines). POST redirects to `/:owner/:repo/spec/:jobId/progress`. Polling (2s, <20 lines JS) as primary; SSE endpoint as secondary. 8-stage timeline: analyzingβ†’writingβ†’opening_prβ†’ai_reviewingβ†’gates_runningβ†’mergingβ†’deployingβ†’done. In-memory `SpecJob` Map with 10-min eviction. No-JS server-render fallback. - [ ] **Agent marketplace β€” real listings** β€” Migration `0070_agent_marketplace.sql` is complete with full schema (listings, installs, reviews, 30% revenue cut built in). The route `src/routes/marketplace-agents.tsx` exists. But there are only seed listings. Write a "Publish an agent" guide, reach out to 10 developers, get 20+ real listings. --- ## 🟑 PRIORITY 3 β€” Messaging (Every Page Needs This) - [x] 2026-06-06 **Landing hero** (`src/views/landing.tsx`) β€” H1: "Write the spec. Gluecron ships it." Subhead: "Spec to PR in 90 seconds. Push to live in 25. AI review, auto-merge, deploy β€” automatic." Sleep Mode demoted to single closing clause. Rail label: "deploys shipped". - [x] 2026-06-06 **Landing "what's happening now" rail** β€” Rail label updated; "Three reasons" card 1 rewritten to lead with timing numbers. Sleep Mode demoted to one line. - [x] 2026-06-06 **vs-github AI rows** (`src/routes/vs-github.tsx`) β€” All 10 AI-native rows now have latency numbers: "AI review fires the moment PR opens (~8s)", "auto-merge triggers the instant gates pass", "ai:build β†’ draft PR in 90 seconds", etc. Sleep Mode renamed to "async batch digest" β€” framed as opt-in, not the headline. - [x] 2026-06-06 **Demo page** (`src/routes/demo.tsx`) β€” Tile headings: "being built right now" / "merged the instant gates passed". Steps updated with real-time language. Live feed subtitle: "Happening right now". Empty states rewritten. - [x] 2026-06-06 **Sleep Mode demoted** β€” Demoted across landing (one closing clause) and vs-github (async opt-in framing). Never leads anywhere. - [x] 2026-06-06 **OG/meta descriptions** β€” All pages audited. Landing title/desc: "AI-native git host. Spec to PR in 90 seconds." Pricing, vs-github, demo, explore, help: descriptions added. Per-repo pages: dynamic description. "wake up to", "overnight", "while you sleep" stripped everywhere including landing-2030.tsx body copy. Tests updated. - [x] 2026-06-06 **Pricing page** β€” Speed-first hero: monospace "Spec to PR in 90 seconds." accent stat, sub-copy with timing numbers. "Included in every plan" pill strip. All 4 plan card taglines mention AI review + auto-merge. OG/meta description added. --- ## πŸ”΅ PRIORITY 4 β€” Polish & Customer Experience ### Onboarding - [x] 2026-06-06 **Empty state for new repos** β€” 3-option panel in `src/routes/web.tsx`: git commands to push first commit, link to /import, link to /:owner/:repo/specs. Done in wave 1. - [x] 2026-06-06 **Onboarding email sequence** β€” `drizzle/0081_onboarding_emails.sql` adds `onboarding_emails_sent jsonb`. `src/lib/onboarding-drip.ts`: T+0 welcome (fire-and-forget in `auth.tsx` POST /register), T+1d "Try Spec-to-PR", T+3d "Your AI is watching" via `onboarding-drip` autopilot task. Idempotent via jsonb key tracking. Skips when RESEND_API_KEY unset. - [x] 2026-06-06 **Dashboard "AI just did this" widget** β€” `AiActivityWidget` added to `src/routes/dashboard.tsx`. Queries `audit_log` (auto_merge.merged, ai_build.dispatched) and `gate_runs` (status=repaired) for last 60 minutes. Shows per-category counts, item list with links, "All quiet β€” AI is watching." empty state. - [x] 2026-06-06 **Push Watch β†’ make it discoverable** β€” Pulsing "● Live" badge in `RepoHeader` (red + `pushWatchPulse` animation when <5min, muted "β—‹ Watch" when <24hr). Query on `activity_feed` WHERE action='push'. Eye-icon watch link on every commit row. `src/views/components.tsx`, `src/views/layout.tsx`, `src/routes/web.tsx`. - [x] 2026-06-06 **Repo overview AI stats strip** β€” `getRepoAiStats(repoId)` in `src/routes/web.tsx`. Shows "⚑ AI merged N PRs this week Β· Saved ~X hrs Β· N open security alerts" below file tree. Queries `activity_feed` (auto_merge), `pr_comments` (is_ai_review), `gate_runs` (security). Hidden when all zeros. ### Admin - [x] 2026-06-06 **Admin > AI cost breakdown** β€” `/admin/ai-costs`: monthly total, breakdown by `category`, top 10 spenders with CSS bar chart. `ai_cost_events` JOIN `users`. Added to admin dashboard nav. - [ ] **Admin > Stripe sync** β€” Stripe subscription status per user vs local plan. Flag mismatches. Link to Stripe dashboard. - [x] 2026-06-06 **Admin > Autopilot health** β€” `/admin/autopilot/health`: 10 tasks with last-tick status, duration, 24h success/error counts from `audit_log`. In-process `getLastTick()`/`getTickCount()` from autopilot.ts. - [x] 2026-06-06 **Admin > User growth chart** β€” `/admin/growth`: daily signups last 30 days (`date_trunc('day', created_at)`), activation rate (users with β‰₯1 repo), CSS bar chart table. - [x] 2026-06-06 commit:44ed968 **K3 tasks on `/admin/autopilot`** β€” `auto-merge-sweep` and `ai-build-from-issues` were already present; `preview-expiry` added. Badge updated to "10 tasks". ### Developer Experience - [x] 2026-06-06 **System/autopilot user** β€” `drizzle/0078_bot_user.sql` seeds `gluecron[bot]` (empty password_hash, non-loginable). `src/lib/bot-user.ts` lazy-caches the UUID. 10 comment call sites updated across `stale-sweep.ts`, `ai-review.ts`, `ai-review-trio.ts`, `autopilot.ts`. πŸ€– bot pill shown in PR/issue comment headers. - [x] 2026-06-06 **Notification preferences** β€” Restructured into 4 categories in `src/routes/settings.tsx`: AI activity, CI/CD, Code review, Mentions. All existing `name=` attrs preserved β€” POST handler unchanged. Email pill count updated to 5 events. - [x] 2026-06-06 **Repo health badge on repo overview** β€” Health score badge added to `RepoHeader` in `src/routes/web.tsx`. Grade colours: Elite=green, Strong=blue, Improving=yellow, Needs Attention=red. Links to /:owner/:repo/insights/health. Done in wave 1. - [x] 2026-06-06 **AI Trio Review UI indicator** β€” `TrioVerdictPills` component added to `src/routes/pulls.tsx`. Three pills (Security/Correctness/Style) in the PR header meta div. Feature-flagged on `AI_TRIO_REVIEW_ENABLED=1`. Pills link to `#trio-review-section`. No extra DB query β€” reads from already-fetched `prComments`. - [x] 2026-06-06 **L1 sleep-mode column split** β€” `drizzle/0079_sleep_digest_column.sql` adds `last_sleep_digest_sent_at`. Schema updated. `sleep-mode.ts` and `autopilot.ts` now write/read the dedicated column. Tests updated. (Renamed from 0077 to avoid collision with `0077_auto_generate_tests.sql`.) - [x] 2026-06-06 **GitHub unlink route** β€” `POST /settings/github/unlink` deletes `sso_user_links` rows with `subject` starting `"github:"`. "Disconnect GitHub" button shown on settings page when GitHub is linked. Audited via `auth.github.unlink`. - [ ] **Branch preview expiry UX** β€” previews.tsx shows status pills (building/ready/failed/expired). Once expiry cleanup is wired, test the "expired" state renders correctly. ### Documentation & Help - [ ] **Docs site** β€” `/help` exists as a migration cheatsheet. Need: Getting Started, API reference, MCP server setup, Workflow YAML syntax, Agent publishing guide. Could be `/docs` served from the self-hosted repo. - [x] 2026-06-06 **Changelog page** β€” `src/routes/changelog.tsx` at `/changelog`. June + May 2026 releases listed. "Subscribe to updates" CTA β†’ `/settings/notifications`. Changelog link added to footer in `layout.tsx`. - [ ] **Legal pages attorney review** β€” All four legal pages (`terms`, `privacy`, `dmca`, `acceptable-use`) are substantive drafts marked "DRAFT β€” requires attorney review." Get legal sign-off before any paid launch. - [x] 2026-06-06 **Status page β€” polish** β€” `drizzle/0080_incidents_and_status_subscribers.sql` adds `incidents` + `status_subscribers` tables. `src/routes/status.tsx` rewritten: overall status banner, 6 service uptime rows, last-10 incident history table, subscribe form with confirm/unsubscribe token flow. --- ## 🟣 PRIORITY 5 β€” Growth & Distribution - [ ] **60-second demo video** β€” Screen record: type a spec β†’ AI writes code β†’ PR opens β†’ trio review posts β†’ gates pass β†’ auto-merged. Show elapsed time counter. No voiceover. Embed everywhere. - [ ] **VS Code extension β†’ publish** β€” `vscode-extension/` is built. Run `vsce package`, publish to VS Code Marketplace. Free discovery. - [ ] **CLI β†’ publish to npm** β€” `cli/gluecron.ts` is built. Publish as `gluecron` npm package. `npx gluecron login` as zero-install entry. - [ ] **CLI β†’ Homebrew formula** β€” `brew install gluecron`. Mac developer standard. - [ ] **JetBrains plugin** β€” Same four commands as VS Code. Kotlin plugin. Covers IntelliJ, WebStorm, GoLand. - [x] 2026-06-06 **GitHub migration as primary CTA** β€” "Migrate from GitHub β†’" button added to landing hero and logged-out nav (accent pill). "Coming from GitHub?" callout card on explore page. Import page headline: "Migrate your GitHub org in 60 seconds." - [x] 2026-06-06 **Developer program page** β€” `src/routes/developer-program.tsx` at `/developer-program`. Hero: "Build on Gluecron. Earn revenue." Publish agent / 70% revenue share / partner badge sections. Partner application form (POST logs + redirects). Footer link added. - [x] 2026-06-06 **Shareable AI hours saved card** β€” `src/routes/share.tsx`: SVG OG image at `/share/hours-saved?user=:username` (1200Γ—630, dark bg, green glow number). HTML share page at `/share/:username` with og:image, Twitter pre-fill, copy-link button. "Share your AI stats" link added to billing usage page. Hours: PRsΓ—1.5 + reviewsΓ—0.5 + healsΓ—0.3. - [ ] **Blog / devlog** β€” Monthly shipping updates. Developers follow platforms that ship visibly. --- ## ⚫ PRIORITY 6 β€” Strategic / Long-Term - [ ] **SOC 2 Type II** β€” Engage auditor, scope controls. 6–9 months. No enterprise deals without it. - [ ] **EU data residency** β€” Neon postgres EU region + Fly.io EU region. "Data region" selector at org creation. - [ ] **GDPR account deletion verification** β€” Migration `0049_account_deletion.sql` adds `deleted_at` and `deletion_scheduled_for`. Verify the full cascade is implemented: bare git repo deletion, related rows purged, audit log anonymised. - [ ] **Audit log SIEM export** β€” `GET /api/v2/audit?since=&format=json`. Required by enterprise security teams (Splunk, Datadog, Elastic). - [ ] **Enterprise sales page** β€” `/enterprise`: custom pricing, SSO, dedicated support SLA, data residency. Contact form β†’ Calendly. - [ ] **Native iOS app** β€” Minimum viable: repo browser, notifications, PR approve/reject, AI chat. React Native. - [ ] **Native Android app** β€” Share React Native codebase with iOS. - [ ] **Multi-agent pipeline UI** β€” `agent-multiplayer.ts` and `agent_sessions`/`agent_leases` tables are complete. Wire a UI to define pipelines: Agent A writes, Agent B reviews, Agent C deploys. - [x] 2026-06-06 **AI pair programmer (browser)** β€” Covered by "Claude Web Sessions β†’ customer-facing" above. `/:owner/:repo/claude` open to all authenticated users. SSE streaming via `claude --print --output-format stream-json`. "✨ Claude AI" sidebar card on repo home. - [ ] **End-to-end test suite** β€” Playwright covering register β†’ push β†’ PR β†’ AI review β†’ merge. Catches flow regressions that unit tests miss. - [ ] **Load testing** β€” k6 or Artillery before any growth push. What happens at 1000 concurrent git pushes? - [ ] **Database connection pooling verification** β€” Confirm PgBouncer or Neon pooling is correctly configured for multi-instance load. --- ## βœ… CONFIRMED COMPLETE (Direct Code Verification) Verified by reading actual files β€” not just the Bible. **Revenue/Billing:** - Stripe Checkout + webhook + customer portal β€” complete, needs env vars only - Billing plans, quotas, usage tracking β€” complete - Billing UI with usage bars, plan cards, upgrade flow β€” complete - AI cost events + per-call tracking (`ai_cost_events` table) β€” complete - Budget cap warning system β€” complete (advisory; hard enforcement is a gap above) **Auth & Identity:** - SSH git push β€” complete (ssh-server.ts, 545 lines, wired at boot) - Password reset, email verification, magic link sign-in β€” complete - Google OAuth β€” complete - Playground anonymous accounts β€” complete - Account deletion with grace period β€” complete - Terms acceptance audit trail β€” complete **AI Features (all wired, not stubs):** - AI CI healer (auto-fixes failed workflow runs) β€” complete, runs every 5 min - AI proactive monitor (platform health surveillance) β€” complete, runs hourly - Stale PR/issue sweep (two-stage poke + auto-close) β€” complete, runs every 5 min - AI trio review (three-model parallel: security/correctness/style) β€” complete, opt-in - AI standup generation (daily/weekly briefs) β€” complete - Repair flywheel (learning cache for patches) β€” complete - Voice-to-PR β€” complete (1092 lines) - Multi-repo refactoring β€” complete - Migration assistant (AI-driven major dep upgrades) β€” complete **Developer Experience:** - Per-repo AI chat β€” complete (repo-chat.tsx, 967 lines) - Personal cross-repo AI chat β€” complete (personal-chat.tsx, 1137 lines) - Hosted Claude loops (deploy Claude agents as endpoints) β€” complete - Cloud dev environments (browser IDE) β€” complete (schema + routes, feature-flagged) - Branch preview URLs β€” complete (URL gen; expiry cleanup missing β€” see Priority 2) - PR sandboxes β€” complete (4h TTL, auto-provision on PR open) - PR live co-editing with cursor presence β€” complete - Comment moderation queue β€” complete - Import secrets from GitHub β€” complete - Agent multiplayer (sessions, leases, budgets) β€” complete **Integrations:** - Slack/Discord/Teams chat notifications β€” complete - Durable webhook delivery with exponential backoff retry β€” complete - Synthetic uptime monitoring β€” complete - Deploy timeline + step streaming β€” complete **Admin:** - /admin/diagnose β€” 14 system health checks β€” complete - /admin/self-host β€” self-hosting wizard β€” complete - /admin/servers β€” SSH deploy targets β€” complete (admin-only; customer rollout is a gap) **Everything in BUILD_BIBLE Β§2 marked βœ…** is confirmed present in the codebase. The Bible claims 100% accuracy for what it documents β€” no phantom features found. --- ## πŸ’³ LAST β€” Stripe/Billing Configuration (When Platform Is Ready) These are NOT build tasks β€” the code is 100% complete. Do these only after the platform is stable and ready for paying customers. - [ ] **Set STRIPE_SECRET_KEY + STRIPE_WEBHOOK_SECRET in production** β€” Stripe Checkout, customer portal, and webhook handler are 100% built (`src/lib/stripe.ts`, `src/routes/billing.tsx`, `src/routes/stripe-webhook.ts`). The billing UI even shows a warning when the key is missing. Run `scripts/stripe-bootstrap.ts` to create products/prices in Stripe with the right lookup keys (`gluecron_pro_monthly` etc), then set the secrets on Fly.io. Zero code changes needed. --- ## Notes - `- [ ]` = not started / not configured - `- [x] YYYY-MM-DD commit:abc` = done - Bible is accurate but covers only ~35% of the codebase by file count - 34 migrations beyond 0042 represent major post-Bible development - When in doubt: scan the code, don't trust the Bible