lens-report

Automate data reporting pipelines from SQL queries to scheduled Slack or email deliveries.

69|8|Updated Mar 16, 2026
One-click install
npx skills add https://github.com/tonone-ai/tonone --skill lens-report
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: lens-report
Source: https://github.com/tonone-ai/tonone/tree/main/team/lens/skills/lens-report
Command: npx skills add https://github.com/tonone-ai/tonone --skill lens-report

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Build and automate recurring data reports by collecting data from multiple sources, executing SQL queries, and delivering insights to Slack or email with historical comparisons and threshold-based alerts.

Core Features & Use Cases

  • Detect data sources, scheduling mechanisms, and delivery channels to enable automated report delivery.
  • Build SQL queries to compute current vs previous period, changes, and trend insights.
  • Schedule Reports and deliver them via Slack or email with threshold alerts and historical context.
  • Integrate with common orchestrators (Airflow, Prefect, Dagster, GitHub Actions) to ensure reliable timing and retries.

Quick Start

Configure a weekly Slack delivery of a revenue report using the provided SQL templates.

Frequently Asked Questions about lens-report

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate recurring SQL data reports and deliver them via Slack or email?

Automate recurring SQL data reports by configuring pipelines that connect data sources, execute current vs previous period queries, and deliver insights with historical comparisons via Slack or email channels.

Can I schedule data report deliveries using Airflow or GitHub Actions?

Yes, you can schedule data report deliveries by integrating with common orchestrators like Airflow, Prefect, Dagster, or GitHub Actions to ensure reliable timing and automated retries for recurring metrics delivery.

How do I set up threshold alerts for breached metrics in automated reporting?

Set up threshold alerts by defining specific metric limits within your reporting pipeline, which then triggers automated alerting via Slack or email notifications when computed query values breach those configured thresholds.

What is the best way to compare current versus previous period data in scheduled reports?

The best way to compare current versus previous period data is by building SQL queries that compute changes and trend insights, then scheduling these reports for automated delivery with historical context.

Does automated reporting work for delivering weekly revenue metrics to a Slack channel?

Yes, automated reporting supports configuring weekly deliveries of revenue metrics to Slack channels by using SQL templates to compute the data and scheduling the recurring delivery with threshold alerts.

Do I need an orchestrator to send threshold-based alerts to email?

While you can send threshold-based alerts via email, integrating a common orchestrator like Dagster or Prefect ensures reliable timing, handles scheduling, and provides automated retries for recurring report deliveries.