skills.rest
akiotanaka847
akiotanaka847COMMUNITY
Explore all skills by this author →
GitHub

set-up-tracking

Create read-only SQL metric definitions or BI dashboard specifications.

2|Updated May 8, 2026
Search Tags:#dashboards#metrics#sql#operations#tracking#warehouse#bi spec
One-click install
npx skills add https://github.com/akiotanaka847/qaio-desktop --skill set-up-tracking
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: set-up-tracking
Source: https://github.com/akiotanaka847/qaio-desktop/tree/main/store/agents/operations/.agents/skills/set-up-tracking
Command: npx skills add https://github.com/akiotanaka847/qaio-desktop --skill set-up-tracking

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Set up operational tracking so teams can measure performance consistently instead of operating without visibility.

Core Features & Use Cases

  • Metric setup: Define a single metric, write read-only SQL for it, snapshot daily values, and generate the reusable query assets for later analysis.
  • Dashboard spec: Propose a dashboard with 2–4 sections, visualizations, cadence, and read-only SQL snippets behind every chart for a BI tool to render.
  • Operational guardrails: Enforce that SQL is SELECT-only, require missing operational context, and block metric snapshot creation without a connected warehouse.

Quick Start

Run set-up-tracking with scope=metric to define your daily snapshot metric, or with scope=dashboard to draft a full read-only dashboard spec for your chosen KPIs.

Frequently Asked Questions about set-up-tracking

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

FAQPage Schema
How do I set up daily metric snapshots using SQL for operational tracking?▼

Creating a BI-ready dashboard spec involves proposing 2–4 sections with defined visualizations and cadence. The specification includes read-only SQL snippets behind every chart for a BI tool to render against a warehouse-backed operating context.

Do I need a connected data warehouse before defining tracking metrics?▼

Yes, the setup process requires SELECT-only SQL. It validates queries to enforce operational guardrails, ensuring that metric definitions and dashboard chart snippets are strictly read-only and cannot modify warehouse data.

What is the difference between setting up a single tracking metric versus a full dashboard spec?▼

You run the setup with scope=metric to define a single daily snapshot metric, or use scope=dashboard to draft a full read-only dashboard specification with sections, visualizations, and query-backed charts for your chosen KPIs.

Can I generate a BI dashboard specification without writing SQL for every chart?▼

No, a BI dashboard specification requires read-only SQL snippets behind every chart. The setup process validates SELECT-only SQL queries and generates query-backed charts to ensure visualizations render directly from your warehouse data sources.

Related Skills

Explore More Data & Analytics Skills→
AradotsoAradotso
7

ktx-data-agent-context-layer

Build a semantic context layer for AI agents querying data warehouses.

Official
Advanced
davekim917davekim917
1

analytics

Analyze dashboards, metrics, and BI artifacts for clarity and accuracy.

Community
Advanced
borgheiborghei
467

data-analyst

Query SQL databases, create visualizations, and generate insights reports.

Community
Intermediate
mtsatryanmtsatryan
1

data-analyst

Analyze business data with SQL and Python to generate dashboard-ready visualizations and insights.

Community
Advanced