Alternative Risk Transfer & Group Captive Engine
Scaffolding the foundation of CaptiveStack: replacing legacy stateful Blazor Server with a serverless edge architecture powered by Cloudflare D1 (SQLite), Drizzle ORM, and SvelteKit 2.
Pilot Group Captives
Association-backed alternative risk programs targeting letters-of-credit replacement.
Eagle1 Hole-in-One Prize Indemnity Captive
ID: prj_eagle1_pilot • Entity: Risk Retention Group Sponsor
GlassCo Replacement Warranty Group Captive
ID: prj_glassco_pool • Entity: 501(c)(6) Trade Association
Alternative Risk Transfer (ART) Formation Roadmap
Deterministic gating milestones for association members from risk data intake to final reinsurance binding.
Feasibility Assessments & Fit Scores
Actuarial intake algorithms evaluating loss ratios, volatility premiums, and captive suitability.
Sports & Entertainment Trade Group
Contact: pilot@eagle1coverage.com
Primary Risk Concern: Volatile Prize Insurance Premiums & High Reinsurer Margins
Mid-Market Automotive Glass Contractors
Contact: admin@glassco.org
Primary Risk Concern: OEM Windshield Part Spikes & Commercial Auto Retention
Production Deployed Captive Test
Contact: deployed@captivestack.pages.dev
Primary Risk Concern: Cloudflare Edge Verification
Role-Based Access Control (RBAC) Test Identities
Edge-compatible session authentication schemas with strictly defined permission scopes.
| Role | Representative Identity | Email Address | Scope & Authority |
|---|---|---|---|
| Admin | CaptiveStack System Admin | admin@captivestack.com | Full platform infrastructure, migrations, and tenant onboarding. |
| CaptiveStackAdministrator | Sarah Underwriter (Platform CSA) | csa@captivestack.com | Cross-program underwriting review, actuarial oversight, and capital reserves gating. |
| AssociationAdministrator | David Vance (GlassCo Exec Director) | admin@glassco.org | Manages trade group members, launches campaigns, and tracks survey progress. |
| AssociationMember | Marcus Miller (GlassCo Dealer) | marcus@autoglasspro.com | Submits loss runs, completes 11-step exposure survey, and certifies risk profile. |
| AdviserReviewer | Dr. Elena Rostova (Adviser Reviewer) | elena@actuarialrisk.com | Third-party actuary, legal counsel, and captive manager auditing milestones. |
Cloudflare Wrangler & D1 Local Verification Commands
Terminal commands used to run and verify D1 migrations, inspect tables, and preview on Cloudflare Pages.
npx wrangler d1 execute DB --local --file=./drizzle/0000_bitter_kid_colt.sql
npx wrangler d1 execute DB --local --file=./src/lib/server/db/seed.sql
npx wrangler d1 execute DB --local --command="SELECT name, stage FROM projects;"
npm run db:generate