Data & Analytics
Data agent skills make AI agents useful for data work: writing SQL, cleaning datasets, building pipelines, working with spreadsheets, and producing analyses. Each skill is a reviewed SKILL.md file that teaches the agent one workflow well, ready to install in seconds.
-
kirkruglov Bundle Generate Comparison TableGenerates a prototype comparison table (comparison-table.xlsx) for Phase 3 — Prototyping. PM describes 2–4 prototypes in chat; the agent structures evaluation criteria (standard set: technical feasibility, UX quality, cost, timeline, risk), proposes weights (customisable by PM), scores each prototype on a 1–5 scale, calculates weighted totals and provides a recommendation. Output: two-sheet xlsx file with a summary and a detailed scoring matrix. PM reviews the draft and makes the final selection decision. Covers task #14 of the project management agent. Mode B: agent prepares draft, PM decides. Triggers EN: 'compare prototypes', 'prototype comparison table', 'evaluate prototype options'.
-
kong Bundle Konnect AI GatewayOperate Konnect AI Gateway request flow, provider/model routing, AI Proxy behavior, prompt/response controls, and LLM analytics. Use when the issue is inside AI Gateway, not generic prompt engineering, provider SDK debugging, or non-AI Gateway rollout.
-
kong Bundle Konnect MonetizationModel and validate Konnect usage-based billing across meters, features, plans, rate cards, and invoices. Use when turning a pricing model into billing entities or checking allowance and overage math. Not for AI Gateway cost analytics or API Catalog packaging.
-
kong Bundle Konnect Observability TriageDiagnose missing, partial, delayed, or mis-scoped Konnect observability data across analytics, Explorer, and Debugger. Use when the question is dataset, scope, or telemetry visibility, not pure gateway health or operator-access troubleshooting.
-
asimons81 Bundle X Analytics ImportUse when X Analytics CSV exports must be inspected, validated, normalized, imported, or compared through a repeatable private-by-default workflow.
-
buildmoonshot Bundle Postgis Query PatternsUse when writing PostGIS or spatial SQL — distance, proximity, intersection, or geometry storage queries. Makes the agent use correct SRIDs, spatial indexes, and the right ST_ functions, so spatial SQL is both correct and fast instead of silently slow or wrong.
-
buyoung Bundle Kysely ConverterConvert raw SQL into type-safe Kysely TypeScript, write Kysely queries from requirements without source SQL, modify or refactor existing Kysely code, and diagnose Kysely type errors. Use for SELECT, INSERT, UPDATE, DELETE, joins, CTEs, expressions, and window functions with version-aware SQL dialect handling. Excludes migration operations and work on other query builders.
-
indranilbanerjee Skill Cf AuditAudit an existing content library for freshness decay and coverage gaps — scores every piece 0-100 on age, statistic currency, link health, and citation recency, maps covered topics against target keywords, and produces a prioritized report: top refresh candidates, gap topics, retire candidates, and the exact follow-up commands. Triggers on "/contentforge:cf-audit", "which content needs refreshing", "content health check", "what topics are we missing", "audit our blog library". Reads inventory from a Google Drive folder, WordPress REST API, or CSV; pulls performance data only if Google Analytics/Search Console MCPs are connected. Audit only — refreshing happens via /contentforge:content-refresh and new pieces start at /contentforge:cf-brief.
-
indranilbanerjee Skill Cf Add IntegrationConnect any external API or service to ContentForge as a custom MCP connector — walks non-technical users from finding a verified MCP package or HTTP endpoint to a ready-to-paste .mcp.json entry, credential setup instructions, and a post-restart verification check. Triggers on "/contentforge:cf-add-integration", "connect our internal CMS", "add a custom integration", "hook up Google Analytics to ContentForge", "there is no connector for this service". Reads .mcp.json.connectors-reference for verified endpoints and checks the registry via scripts/connector-status.py first; for connectors already in the registry, /contentforge:cf-connect is the shorter path. Configuration guidance only — never asks for secrets in chat and does not call the connected service itself.
-
jgamaraalv Bundle Drizzle PgDrizzle ORM reference for PostgreSQL — schema definition, typesafe queries, relations, and migrations with drizzle-kit. Use when: (1) defining pgTable schemas with column types, indexes, constraints, or enums, (2) writing select/insert/update/delete queries or joins, (3) defining relations and using the relational query API (db.query.*), (4) running drizzle-kit generate/migrate/push/pull, (5) configuring drizzle.config.ts, (6) using the sql`` template operator, or (7) working with PostGIS/pg_vector extensions.
-
jgamaraalv Bundle PostgresqlPostgreSQL 16+ reference for writing queries, designing schemas, managing indexes, and optimizing performance. Use when: (1) writing SQL queries (SELECT, INSERT, UPDATE, DELETE, CTEs, window functions, subqueries), (2) designing or altering table schemas (CREATE TABLE, constraints, sequences, data types), (3) choosing or creating indexes (B-tree, GIN, GiST, BRIN, partial, expression), (4) managing transactions and isolation levels (BEGIN/COMMIT, savepoints, MVCC), (5) working with JSONB data and jsonpath, (6) analyzing query performance with EXPLAIN ANALYZE, or (7) using the psql CLI.
-
shishiv Bundle WhyUse for 'why does X work this way', 'why we picked Y', design rationale, regressions, postmortems, or data-backed thresholds. Discovers available read-only source tools and queries each evidence category (source control, issue tracker, long-form docs, real-time chat, infrastructure observability, error tracking, product analytics warehouse) in parallel, then returns a cited read on decisions and tradeoffs. Use how for runtime behavior.
-
theoklitosbam7 Bundle WhyUse for 'why does X work this way', 'why we picked Y', design rationale, regressions, postmortems, or data-backed thresholds. Discovers available MCPs and queries each evidence category (source control, issue tracker, long-form docs, real-time chat, infrastructure observability, error tracking, product analytics warehouse) in parallel, then returns a cited read on decisions and tradeoffs. Use how for runtime behavior.
-
arthjean Bundle Neon CLIOperate Neon Postgres from the terminal with neonctl, psql, and bundled SQL helpers. Use when asked to query a Neon database, manage Neon projects or branches, or run or preview a migration on Neon.
-
profpowell Skill LoggingStructured client-side logging and error reporting. Use when implementing console logging, error tracking, user session tracking, or analytics event patterns.
-
0xranx Skill SQL Query BuilderWhen the user needs help writing SQL queries, analyzing data, building reports, or says 'write a query,' 'SQL help,' 'pull this data,' 'how many users,' 'funnel analysis,' 'cohort analysis,' 'retention query,' or needs to extract insights from a database.
Audited -
ivklgn Bundle Code ReviewerAnalyzes code diffs and files to identify bugs, security vulnerabilities (SQL injection, XSS, insecure deserialization), code smells, N+1 queries, naming issues, and architectural concerns, then produces a structured review report with prioritized, actionable feedback. Use when reviewing pull requests, conducting code quality audits, identifying refactoring opportunities, or checking for security issues.
-
sid-surange Skill Security HardeningApply security-first practices when building or reviewing code — input validation, secrets management, auth checks, OWASP Top 10 coverage. Triggered by "security review", "harden this", "is this secure", "security-hardening", "check for vulnerabilities", "audit my code", "run a security check", "is there anything unsafe here", "check for SQL injection", "check for XSS", "are there any security issues".
-
yasuakiomokawa Skill Model DataUse when business requirements must be modeled against available schema or SQL to produce a consistent data model, optional DBML, and evidence-backed findings on data design, entity relationships, schema consistency, or SQL anti-patterns.
-
adrigm06 Bundle Flutter ObservabilityLead authority for Flutter observability. Use when implementing crash reporting, structured logging, performance monitoring, distributed tracing, analytics governance, feature flags, or privacy-safe telemetry.
-
csfuwwc Bundle Xiaohongshu ScraperUse when a user provides Xiaohongshu/XHS/xhslink URLs, asks to fetch 小红书 note or video content, likes, saves/collections, comments, publish metadata, or wants to fill a spreadsheet/Base from 小红书 links.
-
dojocodinglabs Skill Course RetroIngiere xAPI + feedback CSV de una cohorte y produce retro report Kirkpatrick L1-L4 con iteration candidates priorizados (impact × ease). Use when user asks to "course retrospective", "retro", "post-mortem cohort", "Kirkpatrick analysis", "analizar cohort", "retro del curso", "/course-retro".
-
extruct-ai Bundle Email SearchGet verified emails and phones for contacts found by people-search. Takes LinkedIn profiles from the Extruct people table and enriches them via contact enrichment providers like Prospeo or Fullenrich. Supports single-provider and waterfall modes. Outputs a contact CSV ready for email-generation. Triggers on: "get emails", "find emails", "enrich contacts", "email finder", "get phone numbers", "enrich people", "contact enrichment", "verify emails", "email enrichment".
-
karozi Bundle Pivot Or PersevereForce a written pivot-or-persevere verdict backed by cohort evidence instead of hope. Prepares the decision meeting, runs it against Ries's failure conditions, and blocks the let's-give-it-another-quarter flake without a falsifiable threshold. Use when deciding whether to keep going or change direction, before a strategy review, when a product is stuck in the trough of sorrow, or when the user says pivot or persevere, should we pivot, pivot decision, or time to kill this. Not for choosing which pivot type to execute (that is a separate catalog decision) or for performance reviews.
-
karozi Bundle Vanity Metric AuditSeparate actionable metrics from vanity metrics in any dashboard, metrics review, or investor update, then rebuild reporting around cohort behavior. Use when reviewing a dashboard or KPI slide, when numbers go up but decisions do not get easier, or when the user says vanity metric audit, vanity metrics check, are my metrics actionable, or rebuild my dashboard. Not for choosing analytics tools or implementing tracking.
-
krishamaze Bundle Vyapar MigrationAuthoritative Vyapar schema knowledge. Use when the user mentions Vyapar, .vyb files, .vyp SQLite databases, reading Vyapar data, or any task that requires understanding Vyapar's internal structure. Triggers on: "vyapar", "vyb file", "vyp file", "vyapar backup", "vyapar schema", "vyapar sqlite", "vyapar data". This skill contains only verified facts about Vyapar's internals -- zero assumptions, zero hallucination. Use it regardless of the target system (Odoo, Tally, custom ERP, CSV export, or anything else).
-
oakoss Bundle DatabaseDrizzle ORM + PostgreSQL database layer. Use for db, database, query, schema, table, migrate, sql, postgres, drizzle, model, relation
-
skillist-io Skill SQL ReviewReview SQL queries and schema changes for performance, safety, and migration correctness.
Audited -
snowflake-labs Skill Emergency ResponseRegion-generic Emergency Response evacuation-planning demo: a multi-step wizard in the FLEET_SA_APP that, for whatever region/dataset is active, colors the map by procedural hazard-zone risk (flood/wildfire), seeds participants inside the drive-time isochrone union of the region's health-anchor care centers, and solves a capacitated multi-depot evacuation VRP. Data is produced by Data Studio (generates_hazard + generates_anchors + generates_participants); the wizard binds to the FLEET_APP.EMERGENCY_RESPONSE contract + evac_seed/evac_solve verbs. Use when: setting up emergency response demo, evacuation planning, hazard risk, flood or wildfire exposure, paratransit evacuation routing, participant pickup optimization. Do NOT use for: standard fleet tracking (use fleet-intelligence-car), retail trade area analysis (use retail-catchment), route deviation analytics (use route-deviation), generic dispatch (use route-optimization). Triggers: emergency response, evacuation planning, hazard risk, wildfire risk, flood r
-
snowflake-labs Bundle Sap Fleet ConnectorBind landed SAP (EAM/SD/TM) plus fleet telematics into the existing FLEET_APP neutral contract and SV_FLEET_OPS semantic view, so the fleet dashboards, Cortex agent, and Cortex Analyst run on a customer's real SAP data with no edits above the contract. The connector maps SAP equipment/delivery/maintenance + telematics to the neutral entities via a mandatory configurable ASSET_CROSSWALK, dedupes CDC-landed SAP tables to current rows, and repoints the UNIFIED_FLEET source seam. Use when: onboarding an SAP fleet customer, swapping synthetic demo data for SAP+telematics, joining EQUI/IFLOT/IMRG/AUFK/QMEL/LIKP to GPS telemetry, building an SAP fleet POC. Do NOT use for: ingesting SAP into Snowflake (that is Fivetran/SLT/Datasphere); generating synthetic data (use install-fleet-apps + Data Studio); non-SAP fleet demos (use fleet-intelligence-car/ebike). Triggers: SAP connector, SAP fleet, EQUI telematics join, asset crosswalk, bind SAP to FLEET_APP, SAP semantic layer, SAP EAM analytics.
-
soapboxbuild Bundle Egc Compliance V2Generate a Green Communities EGC 5.1a ASHRAE 90.1-2016 performance-path compliance analysis. Produces a 4-page print-quality PDF report AND a filled BPS Excel template. Runs 3 EnergyPlus simulations (As-Built calibrated to Audette actuals, Code Minimum per 90.1-2016, Retrofit with Audette plan ECMs). Solar PV shown supplementally — it does NOT affect the compliance verdict. Use for EGC 5.1a submissions or pre-application compliance checks. Triggers on: "EGC compliance", "Green Communities compliance", "90.1 compliance", "run energy code analysis", "compliance report for [building]", "BPS template".
-
soapboxbuild Bundle Audette Energy DataExtracts utility bill data from PDF or Excel files in the project folder, validates 12-month concurrent and continuous coverage across all meters, and submits the records to Audette — triggering a re-model. Use this skill when the user wants to compile energy data for a building, extract utility bills, or upload consumption data to Audette. Triggers on: "compile energy data", "extract utility bills", "process energy files", "prepare energy data for [building]", "upload utility data", or "get consumption from bills".
-
stealth-factory Skill Meaningful Linear IssuesCreate complete, analytics-ready Linear issues in ONE pass — resolve the right project (never guess it), and proactively fill the metadata that's technically optional but matters for planning/analytics: priority, estimate, labels (a Type + an Area from the team's existing taxonomy), milestone, assignee, cycle, and relations. Use when asked to 'create/file/open a Linear issue', 'log a ticket', 'add this to Linear', 'make an issue for X', or before any Linear `save_issue` that **creates** an issue or **backfills** missing metadata on a bare one — so the user doesn't have to come back and ask for the labels/estimate/project a second time, and so an issue doesn't land in the wrong project. NOT for routine field edits (status changes, reassignments) — those are also `save_issue` but don't need this.
-
gxgeek-n Bundle Thesis AnalyzeZJU MEM学位论文数据分析入口。涵盖数据生成机制审计、数据处理(采集→清洗→统计→建模)和专业图表生成 (Mermaid/PlantUML/Python matplotlib),输出可直接嵌入论文的代码和图表。 【改道声明】画图/图表/可视化/出成品图/改图/重渲图类请求,一律路由到 thesis-figures (本项目画图统一入口);本skill只管数据处理、统计分析与探索性草图,不产出论文成品图。 含 t检验、ANOVA、回归、聚类、卡方、相关性、信度效度、描述性统计等具体统计方法(读 CSV→出结果)。 触发词:数据生成机制、数据如何产生、数据分析、数据处理、数据清洗、统计分析、建模、data analysis、 t检验、方差分析、ANOVA、回归分析、相关分析、聚类分析、卡方检验、显著性检验、 描述性统计、信度效度、Cronbach、KMO、Cohen's d、假设检验。
-
legioncodeinc Bundle Audit Scoring StingerN/A-aware weighted rollup engine (leaf to sub-audit to category to final), critical-security-override, populates the branded named-range-driven XLSX scorecard.
-
legioncodeinc Bundle Analytics Stack StingerFoundational, industry-specific, and lawful-only de-anonymization analytics audit, built on the vendor census. Flags jurisdiction questions rather than a compliance verdict. Wave W5.
Frequently asked questions
What are Data & Analytics agent skills?
Data agent skills make AI agents useful for data work: writing SQL, cleaning datasets, building pipelines, working with spreadsheets, and producing analyses. Each skill is a reviewed SKILL.md file that teaches the agent one workflow well, ready to install in seconds.
Which Data & Analytics skills are most installed?
Popular Data & Analytics skills on SkillMD right now include why, vanity-metric-audit, sql-review. Rankings shift as installs change; sort this page by "Most installs" for the live list.
Do Data & Analytics skills work with Claude Code and Cursor?
Yes. Every skill here ships as a SKILL.md file, an open format that works in Claude Code, Claude.ai, Cursor, Codex, Windsurf, and 60+ other agents. Install one with npx skillmds@latest add <owner>/<name>, or copy the file into your agent's skills directory.