Catch conflicting metric definitions before they reach a meeting
Scans your SQL queries, dbt models, and dashboard definitions to find every place a key metric is calculated. Flags inconsistencies — like marketing counting revenue with refunds and finance counting without — before they cause a trust-destroying meeting.
Create a skill called "Metric Watchdog". I'll give you the names of key business metrics (like "revenue", "churn rate", "active users", "conversion rate"). Search through my SQL files, dbt models, dashboard definitions, and any other code to find every place each metric is calculated. For each metric, show: (1) Every distinct definition found, with the source file and exact SQL/DAX/LookML. (2) A side-by-side comparison highlighting where definitions differ (filters, joins, date ranges, inclusion/exclusion criteria). (3) The likely root cause of each discrepancy. (4) A recommended canonical definition. Store canonical definitions in a registry. On subsequent runs, alert me when any new query or dashboard defines a tracked metric differently from the registry.
Nothing erodes data trust faster than two dashboards showing different
revenue numbers. The root cause is almost always inconsistent metric
definitions scattered across dozens of queries and dashboards. This skill
finds them all and shows you the differences.
Stop KPI arguments by defining metrics once and reusing everywhere
Many reporting conflicts come from undefined or inconsistent KPIs (what counts as a lead, which revenue number, what window, etc.). This recipe builds a KPI dictionary and maps each KPI to source systems and owners, including "confidence levels" and known limitations.
Get alerted when upstream schemas change before your pipelines break
Monitors your source databases, APIs, and third-party integrations for schema changes — new columns, removed columns, type changes, enum value additions — and alerts you before the downstream breakage happens.
Local-first AI assistant that automates small daily tasks safely on your device
A personal, local-first AI assistant that automates small daily tasks—organizing files, setting reminders, and monitoring system events—without touching sensitive data or taking risky actions without your approval.
Real sources, named experts, actual quotes
Deep research that finds primary sources with named individuals, community sentiment from Reddit/HN/X, and news coverage. No summaries of summaries — actual quotes with URLs.