AlpacApps Updates — Sync New Features

Instructions for Claude

When a user pastes a prompt generated by this page, follow these steps:

Read the user's current project state — check what's already installed by looking at their package.json, cloudflare/ directory, shared/ directory, and .claude/settings.json.
For each requested feature, follow the detailed adoption steps in the feature card below. Each card has a "What Claude Does" section with exact commands and file changes.
Don't duplicate work — if the user already has a feature partially or fully set up, skip to the missing parts.
Ask for credentials only when needed — some features (like D1 session logging) require the user to provide a Cloudflare auth token. Prompt once with all needed values.
Commit and push after each feature — one feature per commit so changes are easy to review or revert.
Update docs — after each feature, update the relevant docs/*.md files (KEY-FILES.md, CHANGELOG.md, INTEGRATIONS.md, etc.).

How this works Check the features you want below, then click "Generate Prompt for Claude." Copy and paste it into Claude Code in your project directory. Claude will pull the new code from the template repo and configure everything for you.

New Session Logging to Cloudflare D1

Added Mar 2026

Automatically save every Claude Code session transcript to a Cloudflare D1 (SQLite) database. Search past conversations, track token usage and costs, and never lose context from previous sessions.

What you get

Cloudflare Worker API with endpoints: save sessions, list/search/filter, get full transcript, aggregate stats
D1 SQLite database with indexed sessions table
Auto-save hook that fires on every Claude Code stop event (rate-limited to once per 5 minutes per session)
Bearer token authentication
Bulk timestamp repair endpoint for imported sessions

Prerequisites

Cloudflare account (free) Node.js 18+

What Claude does

Check if cloudflare/claude-sessions/ already exists in the project. If not, pull it from the template repo.
Install Wrangler CLI globally if not present: npm install -g wrangler
Run wrangler login (opens browser for Cloudflare auth)
Create D1 database: npx wrangler d1 create claude-sessions
Update cloudflare/claude-sessions/wrangler.jsonc with the returned database_id
Ask the user to choose a secure auth token (or generate one)
Set the auth token in src/index.js — replace CHANGE_ME_TO_A_SECRET with the chosen token
Apply the schema: cd cloudflare/claude-sessions && npx wrangler d1 execute claude-sessions --file=schema.sql --remote
Deploy the worker: cd cloudflare/claude-sessions && npx wrangler deploy
Note the worker URL from the deploy output (e.g., https://claude-sessions.USERNAME.workers.dev)

Copy the hook script to the user's home directory:

mkdir -p ~/.claude/hooks
cp cloudflare/claude-sessions/hooks/save-session.sh ~/.claude/hooks/save-session.sh
chmod +x ~/.claude/hooks/save-session.sh

Update the hook script with the Worker URL and auth token (replace the placeholder values)

Add the Stop hook to ~/.claude/settings.json:

{
  "hooks": {
    "Stop": [{
      "hooks": [{
        "type": "command",
        "command": "$HOME/.claude/hooks/save-session.sh",
        "timeout": 15
      }]
    }]
  }
}

Validate by running: curl -H "Authorization: Bearer TOKEN" https://WORKER_URL/stats
Update docs/KEY-FILES.md, docs/INTEGRATIONS.md, and docs/CHANGELOG.md

Files added/modified cloudflare/claude-sessions/ (new directory with worker, schema, hook script, wrangler config) • ~/.claude/hooks/save-session.sh • ~/.claude/settings.json (hooks block)

New On-Demand Context System

Added Mar 2026

Reduce Claude Code token usage by splitting heavy documentation into on-demand files. Instead of loading everything into CLAUDE.md, Claude only loads the specific docs/*.md file it needs for a given task.

What you get

Slim CLAUDE.md (~30 lines, always loaded) with an on-demand doc index
Separate doc files: CREDENTIALS.md, SCHEMA.md, PATTERNS.md, KEY-FILES.md, DEPLOY.md, INTEGRATIONS.md, CHANGELOG.md
Thousands of tokens saved per conversation
CREDENTIALS.md automatically gitignored

Prerequisites

None

What Claude does

Check if docs/ directory already exists with the expected files. If so, skip or merge.

Pull the latest docs/ directory structure from the template repo:

docs/CREDENTIALS.md  (gitignored — API keys, tokens)
docs/SCHEMA.md       (database table definitions)
docs/PATTERNS.md     (code patterns, Tailwind tokens)
docs/KEY-FILES.md    (project file structure)
docs/DEPLOY.md       (deployment workflow, URLs)
docs/INTEGRATIONS.md (external service configs)
docs/CHANGELOG.md    (recent changes log)

Update CLAUDE.md to the slim version with on-demand doc index header (preserve any custom directives the user has added)
Add docs/CREDENTIALS.md to .gitignore if not already present
Migrate any credentials, schema info, or patterns currently in CLAUDE.md to the appropriate docs/*.md file
Populate docs/KEY-FILES.md with the user's actual project structure

Files added/modified CLAUDE.md (slimmed down) • docs/*.md (7 new files) • .gitignore (add CREDENTIALS.md)

New Open Brain — Session Transparency Dashboard

Added Mar 2026

A public-facing (or admin-only) page that displays your Claude Code session history from D1. Shows what Claude worked on, when, token counts, and costs. Full radical transparency for how AI is being used in your project.

What you get

HTML dashboard page that queries the D1 session API
Session list with search, date filters, and project filters
Expandable full transcript view for each session
Aggregate stats: total sessions, tokens, cost, average duration
Configurable: public or auth-gated access

Prerequisites

D1 Session Logging (above)

What Claude does

Verify D1 session logging is set up and the Worker is responding
Create open-brain/index.html — a standalone dashboard page with:
- Stats summary bar (total sessions, tokens, cost)
- Filterable session list (search, date range, project)
- Click-to-expand transcript viewer with markdown rendering
- Styled to match the project's design system
Ask the user: should this be public or require authentication?
- Public — accessible to anyone at /open-brain/
- Auth-gated — wrap in the existing auth system, admin-only
Configure the Worker URL and auth in the dashboard's JavaScript
Update docs/KEY-FILES.md and docs/CHANGELOG.md

Files added open-brain/index.html (standalone dashboard)

New Smart Polling with Circuit Breaker

Added Mar 2026

Intelligent data refresh that pauses when the tab is hidden, backs off exponentially on failures, and auto-recovers when Supabase comes back online. Prevents hammering your API during outages.

What you get

PollManager class with configurable intervals (default: 30s)
Visibility API integration — pauses when tab is hidden
Exponential backoff after 3 consecutive failures
Auto-pause after 6 consecutive failures (circuit breaker open)
Automatic recovery when Supabase health check passes
Supabase health check utility (shared/supabase-health.js)

Prerequisites

Supabase configured

What Claude does

Pull shared/services/poll-manager.js from the template repo
Pull shared/supabase-health.js from the template repo
Wire the PollManager into existing pages that fetch data periodically
Replace any existing setInterval polling with PollManager
Update docs/KEY-FILES.md and docs/PATTERNS.md

Files added shared/services/poll-manager.js • shared/supabase-health.js

New Intranet Tab Visibility Config

Added Mar 2026

Database-driven configuration for which intranet sections and tabs are visible. Toggle tabs on/off per section without code changes — just update a Supabase table.

What you get

page_display_config Supabase table with RLS
Authenticated users can read and update visibility settings
Seed data for all default sections (admin, devices, residents, associates, staff)
UI automatically hides/shows tabs based on config

Prerequisites

Supabase configured

What Claude does

Run the migration: supabase/migrations/001_page_display_config.sql against the user's Supabase project via psql or the Supabase SQL editor
Pull the updated intranet components from the template repo if they've changed:
- src/components/intranet/section-tabs.tsx
- src/components/intranet/sub-tabs.tsx
- src/components/intranet/tab-content.tsx
Customize the seed data for the user's specific sections/tabs
Update docs/SCHEMA.md and docs/CHANGELOG.md

Files added/modified supabase/migrations/001_page_display_config.sql • Intranet tab components (3 files)

New Centralized Error Logger

Added Mar 2026

A lightweight error logging utility that standardizes error handling across the app. Captures, formats, and optionally reports errors to a central location.

What you get

shared/error-logger.js — consistent error capture and formatting
Integrates with the rest of your shared utilities

Prerequisites

None

What Claude does

Pull shared/error-logger.js from the template repo
Wire it into existing error handling patterns (try/catch blocks, fetch error handlers)
Update docs/KEY-FILES.md and docs/PATTERNS.md

Files added shared/error-logger.js

New Stop Hook Upgrade (replaces SessionEnd)

Added Mar 2026

If you previously set up session logging with the SessionEnd hook, this upgrade switches to the Stop hook which also captures worktree and subagent sessions. Includes rate-limiting to avoid excessive API calls.

What you get

Session capture for worktree and subagent sessions (previously missed)
Rate limiting: only saves once per 5 minutes per session
Lock file mechanism to prevent duplicate saves

Prerequisites

D1 Session Logging already set up

What Claude does

Check ~/.claude/settings.json for an existing SessionEnd hook
Replace it with the Stop hook configuration
Update ~/.claude/hooks/save-session.sh with the latest version (includes rate-limiting)
Verify the hook fires correctly by checking for the lock directory

Files modified ~/.claude/settings.json (hook event type) • ~/.claude/hooks/save-session.sh (rate-limiting)

New DevControl — AI Development Dashboard

Added Mar 2026

A comprehensive admin dashboard for monitoring your AI-assisted development workflow. Six sub-tabs covering releases, sessions, token usage, context window analysis, and backup status — all in one place.

What you get

Overview — card grid linking to each sub-tab with quick descriptions
Releases — GitHub PR changelog grouped by date, with version tags, line counts, and category badges
Sessions — view Claude Code session history from D1 (single-project filtered), expandable transcripts, copy support
Tokens & Cost — token usage analytics, daily breakdown bar chart, per-model usage table
Context Window — file-by-file token breakdown, stacked usage bar, 90-day history chart with daily snapshots to Supabase
Backups — backup status cards (DB → R2, R2 → external drive) with activity log from Supabase

Prerequisites

Supabase configured GitHub repo (for Releases tab)

Optional: D1 Session Logging (for Sessions tab), backup_logs table (for Backups tab)

What Claude does

Pull the DevControl files from the template repo:

spaces/admin/devcontrol.html   (admin page shell)
spaces/admin/devcontrol.js     (all 6 sub-tab logic)
spaces/admin/devcontrol.css    (complete styling)

Configure the project-specific values at the top of devcontrol.js:
- GH_OWNER / GH_REPO — for Releases and Context tabs (GitHub API)
- SESSIONS_API / SESSIONS_TOKEN / PROJECT_FILTER — for Sessions and Tokens tabs (D1 Worker)

Add the DevControl tab to the admin navigation in shared/admin-shell.js:

{ id: 'devcontrol', label: 'DevControl', href: 'devcontrol.html',
  permission: 'view_settings', section: 'admin' }

Add the DevControl icon to admin-shell.js icon map

Create the context_snapshots Supabase table for 90-day history tracking:

CREATE TABLE context_snapshots (
  snapshot_date DATE PRIMARY KEY,
  always_loaded_tokens INTEGER NOT NULL,
  total_tokens INTEGER NOT NULL,
  breakdown JSONB DEFAULT '{}'
);

If the user already has a backup_logs table, the Backups tab will work immediately. Otherwise, create it:

CREATE TABLE backup_logs (
  id SERIAL PRIMARY KEY,
  created_at TIMESTAMPTZ DEFAULT NOW(),
  source TEXT NOT NULL,
  backup_type TEXT NOT NULL,
  status TEXT NOT NULL,
  duration_seconds INTEGER,
  details JSONB,
  r2_key TEXT
);

Update docs/KEY-FILES.md, docs/CHANGELOG.md, and docs/PATTERNS.md

Files added/modified spaces/admin/devcontrol.html • spaces/admin/devcontrol.js • spaces/admin/devcontrol.css • shared/admin-shell.js (nav entry + icon)

Generated Prompt

Select features above, then click the button to generate a prompt you can paste into Claude Code.