Skip to content

Open Loops

Open Loops is a small desk buddy that finds the work people forgot to close: a laptop request still "awaiting approval" 92 days after the laptop arrived, a launch brief where you are the last approver, a customer waiting

Core trick

Mines stale Snowflake records into cards, then runs a read-only Claude job only after an explicit Accept, with the exact brief shown first.

Tags

Description

Open Loops is a small desk buddy that finds the work people forgot to close: a laptop request still "awaiting approval" 92 days after the laptop arrived, a launch brief where you are the last approver, a customer waiting on a date nobody gave, an invoice about to pick up a late fee, a contractor whose warehouse access outlived the contract. It reads those loops from a Snowflake table, has Claude turn each into one decision card (what it is, why it matters, a verbatim quote from the record), and offers two or three read/draft next steps. Swipe left to snooze, right to choose. You see the exact brief before anything leaves, and only an explicit Accept runs the Claude job. The result is a cited draft or summary. Nothing is sent, approved, paid or closed for you, and every card, snooze and accepted job is written back to Snowflake as memory.
i098/open-loops★ 00 forksJavaScriptGPL-3.0Created Oct 23, 2026 · last push Oct 23, 2026

README excerpt

# Open Loops

A desk buddy that finds the work you forgot to close. It reads stale requests, pending approvals and unanswered threads from Snowflake, has Claude turn each one into a single decision card with a verbatim citation, and only runs a read/draft job after you explicitly accept it. Nothing gets sent, approved or closed on your behalf.

[![Quality](https://github.com/i098/open-loops/actions/workflows/quality.yml/badge.svg)](https://github.com/i098/open-loops/actions/workflows/quality.yml)
[![License: GPL v3](https://img.shields.io/badge/License-GPLv3-blue.svg)](LICENSE)
![Snowflake SQL API](https://img.shields.io/badge/Snowflake-SQL%20API%20v2-29B5E8)
![Claude](https://img.shields.io/badge/Claude-Messages%20API-D97757)

[![Open Loops demo: problem, live Snowflake + Cortex run, architecture](docs/media/open-loops-preview.gif)](https://open-loops-demo.vercel.app)

**[Watch the 60-second demo with captions](https://open-loops-demo.vercel.app).** Recorded from a real run on the hackathon Snowflake account: the companion on the left, every Snowflake statement and the `LOOP_JOURNAL` table on the right.

Built at the [Intelligence at Work Hackathon](https://cerebralvalley.ai/e/intelligence-at-work-hackathon) (Snowflake + Anthropic, Menlo Park, Oct 23 2026). Submission write-up: [SUBMISSION.md](SUBMISSION.md).

## Claude runs inside Snowflake

With Snowflake connected, every Claude call is a Cortex [`AI_COMPLETE`](https://docs.snowflake.com/en/sql-reference/functions/ai_compl

Team