Database Metrics Digest Agent with OpenCode
One run a morning, six queries, one message, and no reasoning needed beyond reading a number and putting it under the right heading. That is the strongest case in this catalogue for choosing a smaller model, and OpenCode is the harness that lets you. The saving compounds because it fires every day of the year.
Watch it work before it's live
Run a staged conversation — no account needed. The agent handles it for real while a simulated world answers its tool calls; nothing touches real accounts, and nothing is actually sent.
08:30 daily metrics tick
It is 08:30 in Melbourne and all six queries return in under two seconds for the meal kit database. Signups came back at 148 against 131 yesterday, active subscriptions are flat at 9,204, and the failed payment count is the same three as the day before.
Set up in minutes
Using this template drops you into a guided setup. It asks exactly this, nothing else:
Connect PostgreSQL
One sign-in. The agent acts through your account, scoped to what this template uses.
Connect Slack
One sign-in. The agent acts through your account, scoped to what this template uses.
Metrics queries
The exact read only SELECT statements you want run each morning, each with the name it should carry in the digest. This list is the only SQL the agent will ever run.
Digest style
How the digest should read, which movements are worth flagging (for example signups down more than 20 percent), and who to tag when a query fails.
Runs on OpenCode
Preselected for this page — connect your OpenCode account during setup, or switch to NoClick's built-in models with one click.
Watch it handle a test run
A staged conversation against a simulated world — then it’s live.
Why OpenCode for this agent
Least demanding job here
Copying returned values into four sections asks very little of a model. Paying reasoning prices for it is optional.
Threshold rules stay simple
The WATCH section fires on thresholds you write down, so the model applies a rule instead of forming an opinion.
Before you fork
How small can the model go?
Further than most jobs here, though the line to watch is the ban on explaining movement. Weak models like to supply a reason for a number that halved overnight, and Numbers Look Wrong stages exactly that with a backfill inflating order rows from 2,140 to 96,300. If the digest theorises about the backfill instead of reporting both figures, step back up.
Run it with a different agent
Put Database Metrics Digest Agent to work on OpenCode
Free to start. Guided setup, a test run against staged conversations, and it's live.