CockroachDB x AWS Hackathon * Agentic Memory

Confident.
Wrong.
Forgotten.

What happens when your dispatch AI sends crews into a 47 degC corridor - and forgets it happened every single week?

One-line identity

The dispatch agent that recalls every hot corridor before it acts.

Recall
Hybrid
Act
Override
Persist
CockroachDB
Deploy
AWS Lambda

The failure mode

Stateless dispatch is an occupational hazard.

01

Confident

Fastest route wins. The agent scores 0.92 confidence. Operations approves.

02

Wrong

I-10 Express peaks at 47 degC at 14:00. City weather says 42 degC for the whole metro.

03

Forgotten

Three heat incidents last month. Zero memory. Same dispatch tomorrow.

Live demo * centerpiece

Same dispatch.
Different outcome.

Agent loop

Think ? Recall ? Act ? Remember

01

Observe

New dispatch: crew, corridor candidates, departure window.

02

Recall

Hybrid search in CockroachDB - vector + keyword + outcome filters.

03

Act

Bedrock agent overrides fastest route when incidents ? threshold.

04

Persist

Transactional write: memory record + embedding + audit event.

CockroachDB memory layer

Without this table, the agent sends crews into the same heat trap.

Source: Seed fallback (set DATABASE_URL)

Loading dispatch_memories ...

Schema: dispatch_memories + VECTOR(512) + cosine vector index. Setup: pnpm db:setup

Real-world impact

Field ops managers lose sleep over repeat heat exposure.

Phoenix last-mile fleets dispatch hundreds of crews daily. City weather APIs report one number for the whole metro - blind to corridor-level heat gaps that injure workers.

47 degC

Arterial peak

I-10 Express @ 14:00

39 degC

Recalled route

Surface @ 06:00

3 x

Past incidents

Same corridor, no memory

?8 degC

Exposure delta

When recall overrides

Stack

One database. No separate vector store.

Memory

  • CockroachDB Cloud - dispatch_memories + VECTOR(512)
  • Distributed vector index (cosine)
  • Managed MCP Server (read-only ops queries)
  • ccloud CLI + Agent Skills

Agent

  • Amazon Bedrock - Nova Pro reasoning
  • Titan Embeddings V2 - corridor vectors
  • Observe ? Recall ? Act ? Persist loop

AWS

  • Lambda + API Gateway
  • S3 + CloudFront (static demo)
  • CloudWatch + X-Ray audit trail
UI (S3) ? API Gateway ? Lambda (dispatch-agent)
                              ? recall / persist
                    CockroachDB Cloud
                    ??? dispatch_memories (structured)
                    ??? VECTOR(512) embeddings
                    ??? memory_audit (observability)
                    ??? MCP Server ? Cursor / Claude