SQL Database Support for pREST
prest/prest
Guides classifying, gap-analyzing and scaffolding support for a new SQL database in pREST, from Postgres-compatible variants to entirely new dialects.
Build a reporting pipeline — scheduled reports with SQL queries, delivery via Slack or email, threshold alerts, and historical comparison.
Install Lens Report
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill lens-report -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install jeremylongshore/tons-of-skills-marketplace lens-report --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .claude/skills && cp -r skills-src/plugins/ai-agency/tonone/skills/lens-report .claude/skills/lens-report && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "lens-report" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/plugins/ai-agency/tonone/skills/lens-report into .claude/skills/lens-report/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "lens-report", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/plugins/ai-agency/tonone/skills/lens-reportType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill lens-report -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install jeremylongshore/tons-of-skills-marketplace lens-report --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .agents/skills && cp -r skills-src/plugins/ai-agency/tonone/skills/lens-report .agents/skills/lens-report && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "lens-report" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/plugins/ai-agency/tonone/skills/lens-report into .agents/skills/lens-report/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "lens-report", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill lens-report -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install jeremylongshore/tons-of-skills-marketplace lens-report --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/plugins/ai-agency/tonone/skills/lens-report .cursor/skills/lens-report && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "lens-report" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/plugins/ai-agency/tonone/skills/lens-report into .cursor/skills/lens-report/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "lens-report", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/jeremylongshore/tons-of-skills-marketplace.git --path plugins/ai-agency/tonone/skills/lens-report--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill lens-report -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install jeremylongshore/tons-of-skills-marketplace lens-report --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/plugins/ai-agency/tonone/skills/lens-report .gemini/skills/lens-report && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "lens-report" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/plugins/ai-agency/tonone/skills/lens-report into .gemini/skills/lens-report/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "lens-report", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install jeremylongshore/tons-of-skills-marketplace lens-reportInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill lens-report -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .github/skills && cp -r skills-src/plugins/ai-agency/tonone/skills/lens-report .github/skills/lens-report && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "lens-report" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/plugins/ai-agency/tonone/skills/lens-report into .github/skills/lens-report/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "lens-report", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill lens-report -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install jeremylongshore/tons-of-skills-marketplace lens-report --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/plugins/ai-agency/tonone/skills/lens-report .opencode/skills/lens-report && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "lens-report" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/plugins/ai-agency/tonone/skills/lens-report into .opencode/skills/lens-report/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "lens-report", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
lens-report- GitHub stars
- 2.8k
- Token cost
- ~1.3k tokens
- SKILL.md length
- 413 words
- Files
- 2
- Skills in repo
- 3,342
- Repo updated
- First seen
- Licence
- MIT
At a glance
Build a reporting pipeline — scheduled reports with SQL queries, delivery via Slack or email, threshold alerts, and historical comparison.
- Works in 7 steps: Detect Environment → Understand the Report Requirements → Build SQL Queries → …
- Asked for automated reports
- SKILL.md covers Steps and Delivery
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Lens Report is an agent skill from jeremylongshore/tons-of-skills-marketplace. Build a reporting pipeline — scheduled reports with SQL queries, delivery via Slack or email, threshold alerts, and historical comparison. Use when asked for "automated reports", "scheduled report", "email digest", or "Slack alerts for metrics".
Its SKILL.md is about 1.3k tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files (for example `.claude-plugin/plugin.json`).
It sits in Databases, covering SQL and Newsletters. It works with SQL, Slack, GitHub Actions and dbt. The repository describes itself as: Model-agnostic agent-skills platform with a harness-free canonical layer, verified adapters, and the ccpi package manager. Explore at tonsofskills.com. The licence is MIT.
When your agent uses it
- Asked for automated reports
- Scheduled report
- Slack alerts for metrics
Example prompts
- “automated reports”
- “scheduled report”
- “email digest”
- “/lens-report”
Requirements
- Python 3
- Docker
- Pre-approved tools (allowed-tools): Read, Write, Edit, Bash, Glob, Grep, WebFetch, WebSearch, Task, TodoWrite, AskUserQuestion
Workflow steps
7 steps, taken from the step headings in SKILL.md.
What it can do on your machine
Read from SKILL.md and the folder at commit cfae287. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves these tools, so the agent can use them without asking each time:
ReadWriteEditBashGlobGrepWebFetchWebSearchTaskTodoWrite
…and 1 more on the same allowed-tools line.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md (its code samples are sql).
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Lens Report loads about 1.3k tokens when it runs. Until then it costs about 64 tokens; SKILL.md has 413 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check: notes
The automated check noted patterns worth knowing about, such as sudo or a known installer.
- NotePre-approves every shell command (allowed-tools: Bash)SKILL.md
allowed-tools: Read, Write, Edit, Bash, Glob, Grep, WebFetch, WebSearch, Task, TodoWrite, AskUserQuestion
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from jeremylongshore/tons-of-skills-marketplace at commit cfae287, republished under its MIT licence (© jeremylongshore). 413 words, ~1,307 tokens.
Download SKILL.mdSave it as
.claude/skills/lens-report/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.- name
- lens-report
- description
- Build a reporting pipeline — scheduled reports with SQL queries, delivery via Slack or email, threshold alerts, and historical comparison. Use when asked for "automated reports", "scheduled report", "email digest", or "Slack alerts for metrics".
- allowed-tools
- Read, Write, Edit, Bash, Glob, Grep, WebFetch, WebSearch, Task, TodoWrite, AskUserQuestion
- version
- 0.6.4
- author
- tonone-ai <hello@tonone.ai>
- license
- MIT
Build Reporting Pipeline
You are Lens — the data analytics and BI engineer from the Engineering Team.
Steps
Step 0: Detect Environment
Scan workspace for data and scheduling infrastructure:
- Database configs — connection strings, ORM configs (what data source)
docker-compose.yml— check for Airflow, Prefect, Dagster, or cron-based scheduling.github/workflows/— GitHub Actions (can schedule reports)crontab, systemd timers — simple scheduling- Slack webhook URLs or bot tokens in config/env
- Email/SMTP configuration
- Existing report scripts or SQL queries
dbt_project.yml— dbt for transformation before reporting
Identify: data source, scheduling mechanism, delivery channel.
Step 1: Understand the Report Requirements
Determine (from context or by asking):
- What metrics? — which numbers matter for this report
- Who receives it? — stakeholders, team, leadership
- What frequency? — daily, weekly, monthly (weekly is usually the sweet spot)
- What triggers action? — what should make someone stop and investigate
- What format? — Slack message, email, PDF, dashboard link
Step 2: Build SQL Queries
For each metric in the report, create SQL returning:
- Current value — metric for this reporting period
- Previous period — same metric for last period (week-over-week, month-over-month)
- Change — absolute and percentage change
- Threshold status — above/below target
-- Example: Weekly active users with comparison
WITH current_week AS (
SELECT COUNT(DISTINCT user_id) AS active_users
FROM events
WHERE event_date >= current_date - interval '7 days'
),
previous_week AS (
SELECT COUNT(DISTINCT user_id) AS active_users
FROM events
WHERE event_date >= current_date - interval '14 days'
AND event_date < current_date - interval '7 days'
)
SELECT
c.active_users AS current,
p.active_users AS previous,
c.active_users - p.active_users AS change,
ROUND((c.active_users - p.active_users)::numeric / NULLIF(p.active_users, 0) * 100, 1) AS pct_change
FROM current_week c, previous_week p;Step 3: Build the Scheduling Mechanism
Choose based on detected infrastructure:
- GitHub Actions — cron-triggered workflow that runs the report script
- Airflow/Prefect/Dagster — DAG or flow with schedule
- Simple cron — bash or Python script on a schedule
- dbt + scheduler — dbt run then report
Create scheduling config with:
- Schedule expression (cron syntax)
- Retry logic on failure
- Timeout to prevent hung jobs
- Logging for debugging
Show full SKILL.md (172 more words)Show less
Step 4: Build the Delivery
Format and send the report:
Slack webhook:
Weekly Report — [Date Range]
Active Users: 1,234 (+12% vs last week)
Revenue: $45,678 (-3% vs last week) [BELOW TARGET]
Conversion: 4.2% (stable)
[Link to full dashboard]Email: HTML table with metrics, sparklines optional, link to dashboard.
Include:
- Historical comparison — this week vs last week, this month vs last month
- Threshold alerts — highlight metrics that crossed boundaries (above/below target)
- Trend indicator — up/down/stable arrows or text
- Link to detail — always link to full dashboard for drill-down
Step 5: Add Threshold Alerts
For critical metrics, add separate alerts (not just in the report):
- Threshold definition — what value triggers an alert
- Alert channel — Slack DM, channel mention, PagerDuty for critical
- Cooldown — don't alert again for N hours after firing
- Context — include enough data in alert to understand the issue
Step 6: Present Summary
Follow the output format defined in docs/output-kit.md — 40-line CLI max, box-drawing skeleton, unified severity indicators, compressed prose.
## Reporting Pipeline Built
**Metrics:** [N] | **Schedule:** [frequency] | **Delivery:** [Slack/email/both]
### Report Contents
| Metric | Comparison | Threshold |
|--------|-----------|-----------|
| [name] | vs last [period] | [target] |
| ... | ... | ... |
### Pipeline
- Query: [SQL files location]
- Schedule: [cron expression / scheduler config]
- Delivery: [Slack webhook / email / both]
- Alerts: [N] threshold alerts configured
### Files Created
- [path to report script]
- [path to SQL queries]
- [path to schedule config]
### Next Steps
- [ ] Set up [Slack webhook / email credentials]
- [ ] Test with current data
- [ ] Confirm report recipients
- [ ] Adjust thresholds after first week of dataDelivery
If output exceeds the 40-line CLI budget, invoke /atlas-report with the full findings. The HTML report is the output. CLI is the receipt — box header, one-line verdict, top 3 findings, and the report path. Never dump analysis to CLI.
© jeremylongshore, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
SKILL.md and 1 other file in plugins/ai-agency/tonone/skills/lens-report of jeremylongshore/tons-of-skills-marketplace.
- SKILL.md
- .claude-plugin/plugin.json
Open the folder on GitHubat commit cfae287
Compare with similar skills
Lens Report next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Lens Report this skilljeremylongshore/tons-of-skills-marketplace | 2.8k | — | ~1.3k | Automated safety check: Notes | MIT | |
| SQL Database Support for pRESTprest/prest | 4.6k | — | ~1.6k | Automated safety check: Pass | MIT | |
| Modelersidequery/sidemantic | 129 | — | ~4.2k | Automated safety check: Pass | Apache-2.0 | |
| Slacrawlopenclaw/openclaw | 392k | — | ~315 | Automated safety check: Pass | MIT | |
| Snowflake Developmentsickn33/agentic-awesome-skills | 47k | 2 repos | ~2.1k | Automated safety check: Pass | MIT | |
| Snowflake Developmentalirezarezvani/claude-skills | 28k | — | ~3.2k | Automated safety check: Pass | MIT |
Similar skills
Modeler
sidequery/sidemantic
Build, validate, and manage semantic models using Sidemantic.
Slacrawl
openclaw/openclaw
Slack archive: search, sync freshness, threads/DMs, SQL counts, and Slacrawl repo work.
Snowflake Development
sickn33/agentic-awesome-skills
Comprehensive Snowflake development assistant covering SQL best practices, data pipeline design (Dynamic Tables, Streams, Tasks, Snowpipe), Cortex AI functions, Cortex Agents, Snowpark Python, dbt…
Snowflake Development
alirezarezvani/claude-skills
A skill your agent uses when writing Snowflake SQL, building data pipelines with Dynamic Tables or Streams/Tasks, using Cortex AI functions, creating Cortex Agents, writing Snowpark Python…
Uipath Process Mining
UiPath/skills
UiPath Process Mining via uip pm — build and operate a process app end-to-end from a CSV / event log: templates, data mapping, upload, ingest, the dbt (Snowflake) transformation layer, publish, and…
More from jeremylongshore/tons-of-skills-marketplace
All 3,342 skills in this repoPerforming Security Code Review
jeremylongshore/tons-of-skills-marketplace
Execute this skill enables AI assistant to conduct a security-focused code review using the security-agent plugin.
Adapting Transfer Learning Models
jeremylongshore/tons-of-skills-marketplace
Build this skill automates the adaptation of pre-trained machine learning models using transfer learning techniques.
Agent Context Loader
jeremylongshore/tons-of-skills-marketplace
Execute proactive auto-loading: automatically detects and loads agents.md files.
Aggregating Performance Metrics
jeremylongshore/tons-of-skills-marketplace
Aggregate and centralize performance metrics from applications, systems, databases, caches, and services.
Analyzing Capacity Planning
jeremylongshore/tons-of-skills-marketplace
Execute this skill enables AI assistant to analyze capacity requirements and plan for future growth.
Analyzing Database Indexes
jeremylongshore/tons-of-skills-marketplace
Process use when you need to work with database indexing. An agent skill from jeremylongshore/tons-of-skills-marketplace.
Related
Works with
Categories
Questions about Lens Report
What does Lens Report do?
Build a reporting pipeline — scheduled reports with SQL queries, delivery via Slack or email, threshold alerts, and historical comparison. Lens Report is an agent skill from jeremylongshore/tons-of-skills-marketplace. Build a reporting pipeline — scheduled reports with SQL queries, delivery via Slack or email, threshold alerts, and historical comparison.
When should I use Lens Report?
Lens Report fits situations like: asked for automated reports; scheduled report; slack alerts for metrics.
How do I install Lens Report in Claude Code?
Run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill lens-report -a claude-code`. Or copy the skill folder (plugins/ai-agency/tonone/skills/lens-report in jeremylongshore/tons-of-skills-marketplace) into .claude/skills/lens-report in your project. Claude Code loads it when a task matches its description.
How do I install Lens Report in Codex?
Run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill lens-report -a codex`. Or copy the skill folder (plugins/ai-agency/tonone/skills/lens-report in jeremylongshore/tons-of-skills-marketplace) into .agents/skills/lens-report in your project. Codex loads it when a task matches its description.
Can I use Lens Report in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill lens-report -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/lens-report, .gemini/skills/lens-report, .github/skills/lens-report and .opencode/skills/lens-report in your project.
What does Lens Report need to run?
SKILL.md names no scripts, command-line tools or credentials: Lens Report is instructions for the agent only. Our summary lists: Python 3; Docker. Its frontmatter pre-approves these tools: Read, Write, Edit, Bash, Glob, Grep, WebFetch, WebSearch, Task, TodoWrite, AskUserQuestion.
Does Lens Report access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Lens Report safe to install?
Our automated static check of SKILL.md found notes only (pre-approves every shell command (allowed-tools: bash)), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.
What licence does Lens Report use?
Lens Report is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Lens Report use?
About 1.3k tokens (SKILL.md is roughly 5.2k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Lens Report?
Skills that share tags, products or a category with Lens Report: SQL Database Support for pREST (prest/prest, 4.6k stars), Modeler (sidequery/sidemantic, 129 stars), Slacrawl (openclaw/openclaw, 392k stars) and Snowflake Development (sickn33/agentic-awesome-skills, 47k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Lens Report?
jeremylongshore (a GitHub user) maintains it in jeremylongshore/tons-of-skills-marketplace, which has 2,827 GitHub stars. The repository holds 3,342 skills in this directory. The repository was last updated on October 10, 2026.
Source: jeremylongshore/tons-of-skills-marketplace on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.