Skip to main content
Back to the field guide

A field guide to the /lens-report skill

AI Scheduled Reporting Pipeline

Reports get sent or they get forgotten. /lens-report builds scheduled SQL reports with Slack/email delivery, threshold alerts, and historical comparison.

Lens · Data Analytics & BI7 min readJanuary 20, 2026

Reports work when they arrive automatically; they fail when they require someone to remember. The team sets up the dashboard, intends to check it weekly, and forgets. The metric drifts unwatched. The report that arrives in Slack on Monday at 9am gets read; the dashboard the team has to navigate to does not.

The /lens-report skill builds scheduled reporting pipelines. SQL queries per metric. Schedule (daily, weekly, monthly). Delivery via Slack or email with proper formatting. Threshold alerts when metrics move beyond the expected band. Historical comparison so the recipient sees the trend, not just the current value.

What the pipeline includes

Five layers. SQL: queries that produce the metrics to report. Schedule: cadence per report (daily for ops, weekly for product, monthly for executive). Delivery: Slack message or HTML email with the right structure. Alerts: thresholds that fire when metrics move outside the band. History: 4-12 period comparison so trends are visible.

Tonone's /lens-report skill builds scheduled SQL reports with Slack/email delivery, threshold alerts, and historical comparison.

Install

/lens-report ships with the Lens agent in Tonone for Claude Code.

1. Add to marketplace

$ claude plugin marketplace add tonone-ai/tonone

2. Install Lens

$ claude plugin install lens@tonone-ai

Frequently asked questions

What does /lens-report do?
It builds a scheduled reporting pipeline with SQL queries, delivery via Slack or email, threshold alerts, and historical comparison.
How do I install /lens-report?
Install Tonone for Claude Code via tonone.ai/get-started.

Pairs well with