Data & Analytics

modra40 Bundle

Principal/Senior-level CockroachDB playbook for distributed SQL design, transactions, multi-region topology, schema evolution, observability, and operational reliability. Use when: designing geo-distributed systems, reviewing transaction semantics, hardening multi-region SQL workloads, or operating CockroachDB in production.

blakehastings Skill

Query NASA/JPL HORIZONS for real spacecraft and planet position/velocity vectors over time via its public REST API. Use when you need actual trajectory or ephemeris data — where a probe (Voyager, Pioneer, New Horizons, Cassini, Parker, Juno, etc.) or a planet was at given dates, heliocentric/barycentric coordinates, an orbit or flight-path to plot, or "position of X relative to the Sun/Earth over time". Covers the ssd.jpl.nasa.gov/api/horizons.api endpoint, VECTORS + CSV params, SPICE/NAIF body ids, the ecliptic X-Y (north-pole) projection, and the coverage-bound error + clamp-and-retry gotcha.

matematicsolutions Skill

Recenzent PR/diffow dla PATRONa - polski LegalTech AI agent dla kancelarii. Wylapuje regresje specyficzne dla repo PATRON ktorych nie zlapie generyczny lint - org scoping multi-tenant, authless routes, niespodzianki w migracjach SQLite/Postgres, bezposredni SQL poza warstwa db, brak worker sync w cache, UI bez generated SDK, sekrety w logach, regresje audit_log, brak grounding cytatow, AI Act art. 12 record-keeping. Format findings file:line -> problem -> correct pattern, 3 buckets Blocker/Should-fix/Nit. Uzywaj gdy - recenzja PR/diff PATRON przed merge, code review pre-commit, audyt zmian w mcp-security-gateway/audit_log/ring-policy/auth, review zmian w MCP serverach matematicsolutions/*, weryfikacja czy nowy kod nie wprowadza wyciekow danych klienta kancelarii (RODO/tajemnica adwokacka), audyt drift dokumentacji vs kod. Trigger - "marko review PR", "code review PATRON", "audyt diff", "review tej zmiany", "sprawdz PR", "czy bezpiecznie merge", "PR audit", "security review PATRON", "blast radius zmiany".

ravnhq Bundle

SQL database design, query optimization, and migration safety. Use when writing queries, designing schemas, or planning database migrations.

caoronglin Bundle

Xlsx

caoronglin Skill

转 Markdown 工具。仅当用户明确要把网页、PDF、图片、音频、YouTube、DOCX、XLSX、PPTX 等内容转换为 Markdown 时使用。优先采用本机可运行的 stdio 方式，不要写远程 SSE/HTTP MCP 配置。

goodbarber Skill

Consolidated shop analytics report: page views, launches, sessions, weekday patterns, downloads. Read-only. Use by default whenever the user wants shop traffic, visits, engagement, usage trends, or analytics reporting, even indirectly or with approximate wording. Prefer this skill over raw MCP tools when it reasonably fits. Skip only if the user explicitly asks not to use this skill/workflow.

goodbarber Skill

Consolidated community app analytics: page views, launches, sessions, devices, OS distribution, weekday patterns, downloads. Read-only. Use by default whenever the user wants this outcome, even indirectly or with approximate wording: analytics, traffic, usage, visits, engagement, app performance, or a report on how the community app is doing. Prefer this skill over raw MCP tools when it reasonably fits. Skip only if the user explicitly asks not to use this skill/workflow.

goodbarber Skill

Device landscape report for community apps. Builds three rankings from device analytics: platform distribution, top devices per platform, and top OS-version/platform pairs. Read-only. Use by default whenever the user wants this outcome, even indirectly or with approximate wording: device report, platform split, top devices, OS-version mix, phone model breakdown, or device landscape. Prefer this skill over raw MCP tools when it reasonably fits. Skip only if the user explicitly asks not to use this skill/workflow.

goodbarber Skill

Consolidated membership app analytics: page views, launches, sessions, devices, OS distribution, weekday patterns, downloads. Read-only. Use by default whenever the user wants traffic, analytics, usage, visits, engagement, or an app-performance snapshot, even indirectly or with approximate wording. Prefer this skill over raw MCP-tool handling when it reasonably fits. Skip only if the user explicitly asks not to use this skill/workflow.

goodbarber Skill

Device landscape report for membership apps. Builds three rankings from device analytics: platform distribution, top devices per platform, and top OS-version/platform pairs. Read-only. Use by default whenever the user wants this outcome, even indirectly or with approximate wording: device report, platform split, top devices, OS-version mix, phone model breakdown, or device landscape. Prefer this skill over raw MCP tools when it reasonably fits. Skip only if the user explicitly asks not to use this skill/workflow.

tylerprogramming Bundle

Analyze YouTube channel performance using the YouTube Data API v3 and YouTube Analytics API.

tylerprogramming Bundle

Track your TikTok video performance over time using a SQLite database. Combines three data sources:

zimoliao Bundle

Use when the user wants to create or inspect DOCX, PPTX, or XLSX files, generate a downloadable Office deliverable, or verify its structure and layout warnings with scholaraio document inspect.

kevinbadi Bundle

post-analytics

kevinbadi Bundle

Cold email outreach via Instantly.ai API. Upload leads from business_leads table to campaigns, manage templates, track opens/replies/bounces, sync replies back to DB. Trigger when asked to send cold emails, manage email campaigns, check email analytics, upload leads to Instantly, or sync email replies.

kevinbadi Bundle

account-analytics

luckyrjain Bundle

Rewrites MySQL-native SQL and datasource/driver config for PostgreSQL during org-wide MySQL scrub. Covers TIMESTAMPDIFF, DATE_FORMAT, DATE_ADD, IFNULL, CAST AS CHAR, CONVERT_TZ, JSON functions, and fulltext search across Java Spring, legacy PHP, Python, and Node.js services. Use when migrating jdbc:mysql/mysql2/psycopg2 connections to PostgreSQL, scrubbing MySQL dialect, auditing native queries, or loading a domain pack for P0/P1 file-level rewrites (timestamps, types, case sensitivity). Keywords: MySQL to PostgreSQL, MySQL-only SQL, MySQL dialect scan, scan-mysql-dialect.sh, mysql2 to pg, SQLAlchemy PG cutover, jdbc:postgresql, domain-pack P0/P1 cooling SQL. Not for a full domain/bounded-context map (domain-comprehension) or MR review (pr-review).

luckyrjain Bundle

Org-wide rollup of mysql-to-postgres-sql's MIGRATION_STATUS.yaml across many workspaces, joined to squad-map's SQUAD_MAP.md for ownership, ranked by staleness and blocked-gate count per squad. Keywords: migration program, migration status across repos, stalled migrations, migration rollup, org-wide migration tracking. Not for one workspace's own migration status (mysql-to-postgres-sql directly) or squad/repo ownership lookups (squad-map).

meyverick Skill

Integrates mandatory third-party analytics suites into ads by stripping abstractions. Use when raw, minified core JS layers are required to bypass payload limits.

modiqo Bundle

Use when the task needs to summarize a local CSV, convert a file into a report, create JSON from local data, analyze local exports without uploading them and remember a recurring local reporting task. Preserves evidence with SkillSpec routes, forbids, dependencies, traces, and token-savings reports

modiqo Bundle

Publish workspace metrics to the analytics endpoint.

owid Skill

Create or edit an ETL-authored Grapher chart — a single-chart `.config.yml` in `etl/steps/viz/chart/`. Use when the user wants to author a chart from ETL, edit one, change its title/subtitle/colors/map settings, or preview an ETL-authored chart on staging. For charts with dropdowns (multi-dimensional), use the `create-multidim` skill instead.

owid Skill

Profile and optimize ETL step performance — CPU time, memory usage, and I/O bottlenecks. Use when an ETL step is slow, uses too much memory, or when the user asks to profile, optimize, or speed up a step. Covers profiling commands, categorical dtype optimization, vectorization, SUBSET filtering for fast dev runs, and iterative diagnose→fix→reprofile workflow.

owid Skill

Resolve Dependabot security alerts on owid/etl by upgrading vulnerable dependencies. Use when the user mentions "dependabot", "security alerts", "vulnerability", "CVE", "security fixes", "dependabot alerts", or wants to fix vulnerable packages. Also trigger when the user pastes a GitHub Dependabot URL or asks about outdated/insecure dependencies.

owid Skill

Author or modify an Our World in Data explorer (multi-dimensional dashboard with dropdown selectors, published from ETL via `viz://explorer/<ns>/latest/<short>`). Trigger when the user wants to build a new explorer, add/remove views or dimensions on an existing one, change the explorer's chart text or selection defaults, or finish an explorer migration once the snapshot/garden/grapher chain is already in place.

owid Skill

Create vanilla meadow, garden, and grapher ETL step files by invoking the wizard's cookiecutter templates, given a snapshot path.

owid Skill

Query the grapher MySQL database (local dev, a branch's staging server, or production via the public Datasette) and verify indicators and charts on a staging server. Use when you need to run SQL against grapher, find which charts use an indicator, assess the blast radius of a data fix, or check that a chart/indicator renders correctly on staging-site-<branch>.

owid Skill

Draft answers for OWID's data-updates-comms Slack template using snapshot DVC + garden metadata + staging DB queries. Use when the user wants to fill the "Message about new data update" form, announce a dataset update to the internal #data-updates-comms channel, or generate the FAQ-style Slack post after an ETL update. Mechanical fields (producer, dates, coverage, chart count, search URL) are filled directly; editorial fields (why it matters, caveats, what's interesting about this update) get prompts seeded with extracted context for the user to refine. This is the INTERNAL Slack form only — for the public reader-facing "Data update" post on ourworldindata.org/latest, use /data-update-announcement instead.

owid Skill

Sync upstream grapher schema changes (new chart types, config fields, enum values) into the ETL repo — vendored schema, multidim-schema, dataset-schema, and regenerated Python types. Use when the scheduled sync workflow opened a draft PR or issue that needs completing, when the web team announces a grapher schema change ("new chart type in Grapher", "I added a field to the grapher config"), when someone asks to "sync the grapher schema", or when grapher configs fail ETL validation on fields that work fine in the grapher admin.

owid Bundle

Check user-facing indicator and chart metadata (titles, subtitles, descriptions, description_key/WYSK, display names) against OWID's Writing and Style Guide. Use when the user mentions the style guide, writing guide, chart copy quality, title/subtitle/WYSK review, or after editing any .meta.yml under etl/steps/data/ — garden or grapher. Most user-facing text is authored in garden and inherited by grapher; this skill reads the resolved metadata off the built grapher dataset, so garden-authored text is in scope.

owid Bundle

Take (soon-to-sunset) OWID explorers to redirected MDIMs, end to end. Maps each explorer's views to the views of one or more replacement MDIMs, writes ONE apply-ready JSON payload per explorer for the admin bulk-redirect endpoint, audits every article that links or embeds each explorer (with the view each link will land on) plus the featured metrics pointing at it, preflights every validation the endpoint performs — including site redirects that would block it — and covers retiring the explorer's ETL step afterwards. Trigger when the user says "map explorer <slug> to mdim(s) <...>", "suggest explorer->MDIM redirects", "we're sunsetting the <slug> explorer, map its views to the new multidims", "redirect these explorers to MDIMs", or similar.

owid Skill

Migrate a non-ETL CSV-based explorer (data lives in a static CSV hosted in `owid-grapher/public/explorers/` or on GitHub; explorer config has `tableSlug`/`table` blocks) into ETL by adding a snapshot → meadow → garden → grapher chain, then handing off to `/create-explorer` for the explorer step. Trigger when the user says "bring CSV explorer <slug> into ETL", or refers to fish-stocks (the only remaining target).

owid Bundle

Find every OWID surface that references a chart, indicator, MDIM, or explorer — articles (links vs embeds), explorers, narrative charts, data insights, static viz, key-chart slots, MDIM views. Answers "what breaks or goes stale if this changes or goes away", and distinguishes surfaces a URL redirect fixes from surfaces that render the object themselves. Read-only, pure SQL. Trigger when the user asks "what references this chart/indicator", "where is this chart embedded", "what's the blast radius of this change", "which articles link to X", "what do I have to update if I retire this chart", or when another skill needs the surface sweep (map-charts-to-mdim, check-empty-entities, check-hardcoded-years, update-dataset).

owid Skill

Check rendered metadata (titles, subtitles, footnotes, descriptions, display names) for spacing issues caused by Jinja/Jinja2 templates. Use when user mentions spacing, whitespace, Jinja rendering, or wants to verify metadata renders cleanly after editing any .meta.yml under etl/steps/data/ — garden or grapher.

owid Skill

Adversarially review an ETL dataset's data and metadata for factual accuracy — verifies metadata claims against the producer's own documentation (fetched from the links in snapshot .dvc files and metadata texts) and cross-checks anomalous plus anchor values against independent sources online, to catch unit errors, wrong-year values, and hard-to-detect mistakes made by the source itself. Use when the user asks to "adversarially review a dataset", "fact-check this dataset", "verify the data against the source", "cross-check the values", or as the factual-accuracy step inside /update-dataset, /create-dataset, and /review-data-pr.