All loops
RAGEasy 8 min· claude-sonnet-4-5
pgvector quickstart
From plain Postgres to a working RAG endpoint in 10 minutes.
NOT DEPLOYEDNOT DEPLOYED
0142ms
Trigger
cron(0 7 * * *) fired · every day · 07:00
021162ms
Agent
claude-sonnet-4-5 · in 1662 tok · out 725 tok
03152ms
Tools
postgres-mcp/lovable cloud:invoke → 200 OK · 422ms
0432ms
Verify
schema check · zod v3 passed
0562ms
Output
eval passed · faithfulness 0.94
0622ms
Notify
audit log written · runbook link attached
SUCCESS
0%
0 runs
P50
0ms
median
P95
0ms
tail
AVG COST
—
per run
LAST OK
never
—
LAST FAIL
never
none
Latency · last 30 runs0 samples
no runs yet
Latest output · what your users see
RAG index · helpdesk-2026
chunks
10
faithfulness
0.9
recall
0.9
Q: How do I rotate a secret without restarting the loop? A: Call `locker rotate <name>` — running loops pick up the new value on their next tick via the signed refresh channel.
// press Test to run once · Watch live to keep streaming · Deploy to make it real
The problem
Naive RAG embarrasses you in front of users — irrelevant chunks, no citations, drift.
The outcome
A measurable, evaluable RAG pipeline with cited answers and a quality dashboard.
Ingredients & skills
Secrets
- ANTHROPIC_API_KEY
- DATABASE_URL
Providers
- Anthropic
- Lovable Cloud
MCP servers
- postgres-mcp
- fetch-mcp
#rag#embeddings#pgvector
How it works
From plain Postgres to a working RAG endpoint in 10 minutes.
Step 1
1 — Index
Chunk → embed → upsert into pgvector with a metadata JSON column.
Step 2
2 — Retrieve
Top-k vector + filter on metadata. Optional rerank pass.
Step 3
3 — Answer
Claude answers using only retrieved chunks. Empty retrieval ⇒ 'I don't know'.
One-line deploy
The button above runs the same command with your saved config. This is the raw CLI form.
bash
npx claudeloops deploy pgvector-quickstart