LockSmith
A deploy gate for PostgreSQL migrations: it flags lock-taking statements, proves the locks in embedded Postgres, estimates blocking time, and has IBM Bob rewrite them for zero downtime.
Case study · 2026 · Hackathon
An AI operations agent for agencies that turns conversations into typed, evidence-backed memory in CockroachDB, so decisions, instructions and tasks survive the session.
ClientOps Memory AI is a persistent organisational-memory console for agencies and service businesses. Talal Khawaja and Aqeela Urooj built it for the CockroachDB × AWS "Build with Agentic Memory" hackathon on Devpost. It was a new project for that event, and all its demo data is synthetic.
In agency work, the real state of a client lives in fragments: a kickoff call, a routing rule someone mentioned in passing, a task promised in a thread, an exception agreed last week. A chat transcript can replay those fragments, but it can't say which instruction is current, which one was replaced, or why. That's what an operator needs when they come back to a client after a week away.
The operator talks to an agent in a Next.js console. The memory orchestrator classifies what matters into typed records:
CockroachDB is the system of record, not a logging sidecar. It has 12 tables covering workspaces, clients, conversations, memories, embeddings, decisions, tasks, links, agent runs and retrieval events. Titan embeddings are stored as VECTOR(1024) with a vector index, and cosine distance ranks paraphrased queries. Nova Lite reasons over the ranked evidence. Each agent run is written with its retrieval trace in a short, retry-safe transaction, following Cockroach Labs' official Agent Skills guidance.
The demo shows the whole loop. The operator records a lead-routing rule for a synthetic roofing client, starts a fresh session, recalls it, adapts it with an exception, then asks why the behaviour changed. The agent cites both the current decision and the superseded one.
Client work fragments across meetings, notes, handoffs, tasks and approvals. Chat history can repeat text, but it can't reliably answer what is current, what was superseded, who committed to what, and what evidence supports the answer.
Conversations are turned into four kinds of typed memory (episodic, semantic, decision and commitment) and stored in CockroachDB alongside vector embeddings. Amazon Bedrock (Nova Lite) reasons over retrieved evidence, and every answer shows its sources, confidence and timestamps. Superseded decisions stay queryable instead of being silently overwritten.
Team member (teqprotech).
The detailed architecture for ClientOps Memory AI hasn’t been documented yet, so this sketch only lists the technologies on the project record. Nothing here is guessed.
Episodic, semantic, decision and commitment memory types
CockroachDB as system of record, with VECTOR(1024) and a vector index
Amazon Nova Lite reasoning and Titan Text Embeddings V2
Evidence drawer with source, confidence, timestamp and status
Explicit superseding links; conflicts surfaced, not merged
Edit, delete, mark-inaccurate and complete controls
Ten-scenario long-term-memory evaluation harness
Submitted to CockroachDB × AWS Hackathon — Build with Agentic Memory on Devpost, 15 Aug 2026.
Not among the listed winners.
Built with Teqprotech · AI Agents with Human Approval.