Data & Analytics

impertio-studio Bundle

Use when importing large datasets, choosing COPY vs INSERT, querying CSV files as tables, or setting up cross-database queries. Prevents row-by-row INSERT loops that are orders of magnitude slower than COPY, stale planner stats from skipping ANALYZE after load, and "permission denied" from server-side COPY on a client file (use \copy). Covers COPY FROM/TO/STDIN, CSV/TEXT/BINARY formats, COPY FREEZE, v17 ON_ERROR ignore + HEADER MATCH, v16 COPY DEFAULT, file_fdw for CSV-as-table, postgres_fdw cross-database queries, load optimization (drop indexes, UNLOGGED staging), prepared statements. Keywords: COPY, bulk load, COPY FROM STDIN, \copy, CSV import, COPY FREEZE, ON_ERROR, file_fdw, postgres_fdw, foreign data wrapper, IMPORT FOREIGN SCHEMA, import is slow, fastest way to load data, query csv as table, cross database query, insert loop slow

impertio-studio Bundle

Use when storing list-valued columns, modelling time/number intervals, or preventing overlapping bookings with exclusion constraints. Prevents seqscan on range-overlap queries from missing GiST index, CSV-in-text instead of native array, and off-by-one errors from inclusive vs exclusive range bounds. Covers array literals + operators (= ANY, @>, &&, ||), unnest WITH ORDINALITY, array_agg, range types (int4range, tstzrange, daterange), range operators (@>, &&, -|-), multirange (v14+), GiST exclusion constraints for non-overlap. Keywords: array, ARRAY, ANY, unnest, array_agg, range type, int4range, tstzrange, daterange, multirange, range overlap, exclusion constraint, GiST, EXCLUDE USING gist, overlapping bookings, how to store a list, prevent double booking, range query is slow

impertio-studio Bundle

Use when reviewing SQL queries for correctness and performance before they ship, or auditing existing queries in a codebase. Prevents rubber-stamping queries without checking index usage, missing a WHERE-less UPDATE/DELETE, and overlooking implicit casts or un-indexed JSONB and LIKE patterns that force seqscans. Covers a deterministic SQL review checklist (SELECT *, missing WHERE, implicit casts, JSONB GIN gaps, leading-wildcard LIKE, N+1, OFFSET pagination, NOT IN with NULLs, fan-out), severity grading, and which sibling skill to cite per finding. Keywords: SQL review, query review, code review, query reviewer, SELECT star, missing WHERE, N+1 query, implicit cast, seqscan, slow query review, review my SQL, is this query good, audit queries, query checklist

impertio-studio Bundle

Use when reviewing a PostgreSQL schema or DDL design before it ships, or auditing an existing schema for structural problems. Prevents shipping tables with no primary key, un-indexed foreign keys, multi-tenant tables with no RLS strategy, SERIAL where IDENTITY belongs, and timestamp instead of timestamptz for event times. Covers a deterministic schema review checklist (snake_case naming, IDENTITY vs SERIAL, missing PK, FK indexing, redundant indexes, RLS coverage, jsonb vs CSV-in-text, timestamptz, normalization), severity grading, cite-sibling-skill per finding, GOOD / NEEDS-WORK / POOR verdict. Keywords: schema review, DDL review, database design review, table design, naming convention, missing primary key, foreign key index, RLS coverage, normalization, IDENTITY vs serial, review my schema, is this schema good, audit database design, schema checklist

unknown-333 Skill

Build batch and incremental data ingestion (extract-load) pipelines — full vs incremental extraction, change data capture (CDC), watermarks and high-water marks, API pagination and rate limits, and choosing managed EL tools (Fivetran, Airbyte) vs custom code. Use when ingesting data from databases, APIs, files, or SaaS into a warehouse/lake, or designing incremental extraction and CDC.

unknown-333 Skill

Capture database changes with Debezium change data capture — connector setup for Postgres/MySQL/SQL Server, snapshot vs streaming phases, handling inserts/updates/deletes and tombstones, schema changes, and applying the change stream idempotently to a warehouse/lake. Use when setting up CDC, replicating an OLTP database, capturing deletes, or consuming a Debezium change stream.

unknown-333 Bundle

Reduce Snowflake cost and latency — right-size and auto-suspend warehouses, use multi-cluster for concurrency, apply clustering keys, read the Query Profile, exploit result/warehouse caching, and control credit spend. Use when Snowflake queries are slow or expensive, warehouses spill or queue, credits are high, or you need to size a warehouse.

archive-dot-com Skill

Parse raw text from an Instagram or TikTok Story insights screenshot and format it into a clean, spreadsheet-ready row with labeled fields. This skill should be used when parsing Story metrics from a screenshot, formatting Story insights for a spreadsheet, extracting metrics from a pasted Story screenshot, cleaning up Story analytics data, converting Story insights text into structured data, turning a Story performance screenshot into a row for the tracker, logging Story metrics into a spreadsheet, normalizing Story screenshot data, pulling numbers from a Story insights paste, organizing Story metrics from creator screenshots, processing a batch of Story screenshots into rows, building a Story metrics tracker from screenshots, or entering Story data from a screenshot into a sheet. For normalizing metrics from multiple sources into a unified table, see metrics-normalization-formatter. For calculating engagement rates and comparing to benchmarks, see engagement-rate-calculator-benchmarker.

estuary Skill

Foundation for writing Estuary derivations — what they are, language choice (SQL/TypeScript/Python), project layout, flowctl workflow, stateless vs stateful shuffling, and universal gotchas. Read this before any other derivation-* skill. Use when user says "write a derivation", "how do derivations work", "create a derivation", "derivation setup", or before starting any transformation work.

lensetek Skill

Spreadsheet Operations Capability

lensetek Skill

Defines KPIs, measurement plans, attribution, funnel analysis, reporting, and optimization priorities.

lightpointventures Skill

当用户想转换数据格式、CSV 转 JSON、迁移数据库、导入导出数据时使用 -- 在不同格式和系统之间迁移数据

schroneko Bundle

SMBC 三井住友カード Vpass の Web 明細ページから、ログイン済み Chrome タブを使ってカード別ディレクトリへ直接ダウンロード可能な CSV 明細を保存する。クレジットカード明細、SMBC カード明細、Vpass 明細、三井住友カードの利用明細を取得・整理したい場合に使用する。

scottwater Bundle

Run a multi-agent security review of Rails application code. Use when the user asks for a Rails security review or audit, or raises a specific concern — authorization/IDOR/tenant isolation, XSS/SQL injection/SSRF, vulnerable gems/Brakeman/bundle audit, or prompt injection in AI features.

thiennc-tesoglobal Bundle

Design, implement, or repair production observability in Flutter using operational logs, error and crash capture, breadcrumbs, traces, release context, privacy controls, and verification. Use for diagnosability and incident signals; not product analytics, profiling-only optimization, or a general code review.

thiennc-tesoglobal Bundle

Build or review provider-neutral AI features in Flutter, including streaming responses, conversation state, structured output, tool calls, attachments, cancellation, and safe service boundaries. Use when model behavior is part of the product; do not use for ordinary APIs, product analytics, or generic chat between people.

thiennc-tesoglobal Bundle

Design, implement, repair, or review product analytics in Flutter using event contracts, identity, consent, funnels, attribution, experiment exposure, delivery semantics, and backend verification. Use for measuring user behavior and business outcomes; not operational logs, crash reporting, profiling, or general UI tracking.

trycomp-io Bundle

Brazilian CLT vs PJ (Pessoa Jurídica) salary equivalence calculator. Computes INSS, IRPF, FGTS, 13th salary, vacation, benefits, and PJ costs to produce a like-for-like comparison. Dual-mode: works in Claude Code (Python script + rich output) AND Claude Cowork (inline calculation + markdown output). Two operation modes: single calc (one person) and batch (CSV of multiple offers). Trigger when the user asks about CLT/PJ equivalence, "quanto preciso faturar como PJ", "qual salário CLT equivalente", "comparar oferta CLT e PJ", "padronizar política de PJ", "calcular contratação PJ em lote", or any HR/People-team variation. Maintained by Comp, free skill for HR & People leaders.

trycomp-io Bundle

Simulador de custo total de folha de pagamento (Brasil). Inclui encargos patronais (INSS 20%, FGTS 8%, SAT 2%, Sistema S 5.8%), provisões (13º, férias+1/3, multa FGTS rescisória) e benefícios. Dois modos: detalhado (CSV de roster) ou estimativa (headcount + salário médio). NÃO substitui sistema de folha real; é simulação rápida pra orçamento, projeção, cenários. Trigger em "custo de folha", "simulador de folha", "custo total empregador", "quanto custa folha de X colaboradores", "encargos sobre folha", "onerated factor". Mantida pela Comp.

trycomp-io Bundle

Calculadora do custo real (oculto) de turnover. Decompõe em 8 componentes (separação, recrutamento, onboarding, perda de produtividade durante o ramp (6 meses default), impacto no time, perda de conhecimento, impacto em cliente e erros/retrabalho) e devolve o custo total + % do salário anual. Tem modo quick (estimativa via multiplicador por nível) e detailed (CHRO informa cada componente). Modo batch via CSV. Metodologia baseada no artigo Cajuína "O custo oculto do turnover". Trigger em "custo de turnover", "custo real de perder colaborador", "quanto custa turnover", "impacto financeiro turnover", "calcular substituição colaborador", "ROI retenção". Mantida pela Comp.

trycomp-io Bundle

Calculadora de impacto financeiro de reajuste salarial (dissídio, mérito, ajuste pontual). Lê CSV/XLSX de roster + regra de reajuste (flat %, por nível ou por área) e devolve aumento total mensal/anual com encargos (~55.5%), % impacto na folha, breakdown por grupo. Trigger em "impacto de reajuste", "custo de dissídio", "simular mérito", "quanto custa aumento de X%", "impacto na folha", "ciclo de mérito". Mantida pela Comp.

vchirrav-eng Skill

Run gosec SAST scans on Go code. Detects SQL injection, hardcoded credentials, insecure TLS, command injection, and other Go security issues.

vchirrav-eng Skill

Run Psalm with taint analysis on PHP code. Detects SQL injection, XSS, command injection, path traversal, and other taint-flow vulnerabilities in PHP applications.

vchirrav-eng Skill

Run Bandit SAST scans on Python code. Detects common security issues like SQL injection, hardcoded passwords, exec usage, and insecure crypto.

vchirrav-eng Skill

Run Brakeman SAST scans on Ruby on Rails applications. Detects SQL injection, XSS, mass assignment, CSRF, command injection, and other Rails-specific vulnerabilities.

syncfusion Bundle

Guide for implementing Syncfusion WinUI DataGrid (SfDataGrid) for tabular data display in desktop applications. Use this skill when working with data grids, sorting, filtering, grouping, or CRUD operations. Covers data binding, column configuration, master-details views, Excel export, and performance optimization including data virtualization and custom templates.

wei18 Skill

Default analytics stack for solo / small Apple-platform Apps — App Store Connect Analytics + MetricKit + Game Center (for games), no third-party tracking SDK by default, PrivacyInfo.xcprivacy mandatory. Invoke when deciding analytics SDK (vs Firebase / TelemetryDeck / Amplitude), writing PrivacyInfo, or when asked "should I integrate Firebase / Mixpanel / TelemetryDeck".

kehwar Bundle

SAP Business One 10.0 table schema reference for writing HANA SQL queries. Use when working with SAP B1 tables, looking up column names, understanding header/lines document structure, writing or reviewing HANA SQL that joins SAP B1 tables, or mapping a business concept to the correct SAP table name.

woocommerce Skill

Use when the merchant asks to triage refunds, returns, refund spikes, high refund rates, refund leakage, refunded products, refunded countries, refund timing, or what is driving refunds. Produces a merchant-friendly WooCommerce refund diagnostic using existing analytics tools, with aggregated data only, no customer PII, and no suggestions to build new tools.

woocommerce Skill

Use when the merchant asks about tax collected, VAT or sales-tax totals, tax returns, tax reconciliation, shipping tax, refunded tax, pending tax, tax by rate or jurisdiction, or why tax figures differ from WooCommerce admin. Produces a merchant-friendly WooCommerce tax collection and reconciliation readout using existing analytics tools, with aggregated data only, no customer PII, and no suggestions to build new tools.

woocommerce Skill

Use when the merchant asks why revenue is down, why sales dropped, what changed in a soft period, whether a revenue dip is serious, or what is driving a month-over-month/week-over-week decline. Produces a merchant-friendly WooCommerce revenue-drop diagnostic using existing analytics tools, with aggregated data only, no customer PII, and no suggestions to build new tools.

woocommerce Skill

Use when the merchant asks for a weekly store review, asks "Give me my weekly store review", asks how the store did this week, or wants a last-7-days WooCommerce performance summary. Produces a merchant-friendly review using WooCommerce for Claude analytics tools, with revenue, orders, customers, products, attribution, refunds, and prioritised next actions.

woocommerce Skill

Use when the merchant asks about customer lifetime value, best customers over time, repeat buyers, one-time versus repeat purchasing, cohort retention, reorder cadence, loyalty opportunities, or whether recent customers are becoming more valuable. Produces a merchant-friendly WooCommerce customer value review using existing analytics tools, with aggregated and pseudonymised data only, no customer PII, and no suggestions to build new tools.

woocommerce Skill

Use when the merchant asks about stock risk, inventory risk, out-of-stock or low-stock products, products to restock or watch, slow-moving stocked products, or sale-priced products with stock issues. Produces a merchant-friendly WooCommerce inventory risk review using existing catalogue and analytics tools, with aggregated data only, no customer PII, no forecasts, and no suggestions to build new tools.

woocommerce Skill

Use when the merchant asks how payment methods are performing, which gateways drive paid revenue, whether on-hold orders are concentrated by method, how failed orders look alongside payment mix, whether payment labels are blank, or which payment settings need checking. Produces a merchant-friendly WooCommerce payment-method review using existing analytics tools, with aggregated data only, no customer PII, no processor-reversal claims, and no suggestions to build new tools.

woocommerce Skill

Use when the merchant asks whether coupons are working, which coupon codes are performing, whether discounting is eating margin, what a promotion cost, which coupons drive new customers, or which codes need attention. Produces a merchant-friendly WooCommerce coupon performance triage using existing analytics tools, with aggregated data only, no customer PII, and no suggestions to build new tools.