Built for the H0: Hack the Zero Stack with Vercel v0 and AWS Databases Hackathon. #H0Hackathon
Live Demo: https://agently-ten.vercel.app
15 idempotent migrations showing:
- Matter, document, and firm data model
- Multi-tenant firm_id isolation (no RLS needed)
- OAuth token storage per firm
- Workflow runs and client intake tracking
- Custom schema design for DSQL constraints
See server/migrations/ for full schema.
Core Systems:
server/db.ts— Custom Aurora DSQL pool manager with IAM token rotation (13min TTL, 2min pre-refresh, connection deduplication)server/chat.ts— AI orchestration with AWS Bedrock, streaming responsesserver/action.ts— Tool-calling pipeline for file retrieval, legal research, browser controlserver/browser-router.ts— Browser agent orchestration with Steel.dev CDP and Playwright recordingserver/court-filing-router.ts— Court e-filing automation with S3-to-Steel file pipeline and Secrets Manager credential injection
Integrations:
server/middleware/auth.ts— Clerk JWT validation, firm_id extractionserver/file-repo.ts— S3 document management with presigned URLsserver/matter-router.ts— Matter lifecycle management
src/components/ChatView.tsx— Real-time AI chat with streamingsrc/components/BrowserView.tsx— Live browser agent control and Playwright recording UIsrc/components/MatterDashboard.tsx— Matter overview and navigationsrc/components/MatterWorkspace.tsx— Document and workflow management
Aurora DSQL Integration:
- IAM token rotation with deduplication to prevent connection storms
- Firm_id scoping on every query (replaces RLS which DSQL doesn't support)
- Custom DDL migration runner for DSQL's single-statement transaction requirement
Browser Automation:
- Steel.dev for remote Chrome (not Lambda — size/timeout limits)
- AWS ECS for Python browser-use agent (can't run on Lambda)
- S3 → Buffer → Steel Files API → VM path pipeline for secure file uploads
- Playwright recording via CDP action injection
Security:
- AWS Secrets Manager for per-firm court portal credentials
- Presigned S3 URLs with 5-minute expiry
- Clerk-signed org IDs as firm_id (never from request body)
- React 19, Vite, TailwindCSS
- Express 5, Node 24
- Aurora DSQL (PostgreSQL-compatible, serverless)
- AWS Bedrock (Claude inference)
- AWS S3, Secrets Manager, ECS
- Steel.dev, browser-use, Playwright
- Clerk auth, multi-tenant