Data & Analytics

charlieviettq Bundle

Optimize SQL query performance using EXPLAIN analysis, indexing strategies, and common anti-pattern fixes. Use this skill when the user needs to speed up slow queries, design indexes, fix N+1 problems, or optimize database performance — even if they say 'this query is slow', 'optimize our database', 'which indexes do we need', or 'our dashboard takes 30 seconds to load'.

charlieviettq Skill

Implement GA4 for Taiwan e-commerce — Enhanced Ecommerce events (view_item, add_to_cart, begin_checkout, purchase), TW-specific parameter conventions (含稅 revenue, NT$ currency, 統編 as user property), Looker Studio reporting, and Big Query export. Use when instrumenting a TW store with GA4 or auditing existing GA4 setup. Do NOT use for generic analytics (use `ecom-analytics`). STATUS: SKELETON — body pending.

charlieviettq Skill

> Generate or improve a company-specific data analysis skill by extracting tribal knowledge from analysts. BOOTSTRAP MODE - Triggers: "Create a data context skill", "Set up data analysis for our warehouse", "Help me create a skill for our database", "Generate a data skill for [company]" → Discovers schemas, asks key questions, generates initial skill with reference files ITERATION MODE - Triggers: "Add context about [domain]", "The skill needs more info about [topic]", "Update the data skill with [metrics/tables/terminology]", "Improve the [domain] reference" → Loads existing skill, asks targeted questions, appends/updates reference files Use when data analysts want Claude to understand their company's specific data warehouse, terminology, metrics definitions, and common query patterns.

charlieviettq Skill

Taiwan e-commerce benchmark ranges for CVR, ROAS, LTV, AOV, repeat rate, cart-abandon — segmented by vertical (3C, 美妝, 服飾, 母嬰, 生鮮) and channel (DTC, Shopee, momo). Use when a TW merchant asks 'is my CVR / ROAS good?' or when sizing a business case. Source discipline: cite industry report or vendor data; mark undocumented ranges as estimates. STATUS: SKELETON — body pending.

charlieviettq Skill

Convert laboratory instrument output files (PDF, CSV, Excel, TXT) to Allotrope Simple Model (ASM) JSON format or flattened 2D CSV. Use this skill when scientists need to standardize instrument data for LIMS systems, data lakes, or downstream analysis. Supports auto-detection of instrument types. Outputs include full ASM JSON, flattened CSV for easy import, and exportable Python code for data engineers. Common triggers include converting instrument files, standardizing lab data, preparing data for upload to LIMS/ELN systems, or generating parser code for production pipelines.

williamcorrea23 Skill

SAP HANA CLI and Database Explorer — hdbsql command-line tool, HANA Database Explorer in BAS, SQL console, catalog browser, security manager, trace configuration, backup management. Use when accessing HANA via command line, running SQL queries against HANA, or managing HANA database artifacts.

williamcorrea23 Skill

Help with modern ABAP SQL features and AMDP (ABAP Managed Database Procedures) including inline declarations, window functions, GROUP BY, HAVING, PRIVILEGED ACCESS, string functions, aggregate expressions, common table expressions (CTE), AMDP classes, AMDP procedures, AMDP table functions, CDS table functions, and AMDP scalar functions. Use when users ask about ABAP SQL, modern SQL, SELECT, window functions, CTE, common table expression, AMDP, SQLScript, AMDP table function, CDS table function, aggregate, GROUP BY, HAVING, UNION, INTERSECT, EXCEPT, PRIVILEGED ACCESS, ABAP SQL expressions, built-in SQL functions, or database procedures. Triggers include "ABAP SQL query", "window function", "CTE", "AMDP", "table function", "GROUP BY", "aggregate", "PRIVILEGED ACCESS", "inline SELECT", or "SQLScript".

clowlove Bundle

Automate Twitter/X posting, engagement, and analytics. Supports scheduling, threading, and trending话题 analysis.

clowlove Bundle

Business analytics dashboard with real-time metrics, custom reports, and data visualization. Supports multiple data sources.

dingxingdi Bundle

Skill: set operations and union reasoning

dingxingdi Bundle

Skill: nested aggregation and filter reasoning

dingxingdi Bundle

Use this skill when an analytics or data transformation task requires combining structured data (CSVs, databases) with unstructured domain logic found in manuals, project handbooks, regulatory guidelines, or business documentation. It is triggered by plain-language requests such as 'calculate our fraud rates using the risk manual', 'harmonize clinical lab data across our medical centers using the conversion guide', 'check if these transactions follow the scheme fee rules', or 'perform a multi-step financial audit'. It is specifically meant for cases where the agent cannot write the code until it first understands complex, implicit rules or industry standard operating procedures (SOPs) buried in text files.

dingxingdi Bundle

Use this skill when the user wants SQL-generation data where the agent must read schema information, consult dialect docs, and produce correct queries for real databases. Trigger it for requests like 'generate enterprise SQL tasks', 'make BigQuery or Snowflake coding questions', 'create SQL problems that need schema lookup and docs', or 'give me text-to-SQL data for code agents'. Do not use it for broader multi-step analytics pipelines with many intermediate artifacts; use the orchestration skill for those.

dingxingdi Bundle

Use this when the user needs a plan that chains together multiple interactive steps where later stages depend purely on earlier outputs, such as passing API parameters, moving text between apps, inserting linked SQL records, or chaining network recon into an executable exploit. Trigger it for requests like 'find information and then process it into a file', 'extract these details and add them to my SQL tables linked by ID', 'forward a code from an SMS to a banking app', or 'scan the server, look up the vulnerability, and execute the payload.'

dingxingdi Bundle

Use this skill when the user wants to autonomously gather datasets from open web sources by writing and executing scrapers or API harvesters. It is triggered by natural language requests such as 'collect all papers from this year's top AI conference', 'give me a CSV of NBA player stats for 2023', 'download daily stock prices for S&P 500 companies', or 'create a dataset of children's book abstracts from the web'. Use this when the agent needs to plan a data acquisition strategy, identify stable web anchors or API endpoints, and generate executable Python scripts to build a curated dataset from scratch.

williamcorrea23 Bundle

Help with ABAP Unit testing including test class setup, assertions, test doubles, mocking frameworks, dependency injection, CDS test environments, SQL test environments, RAP BO test doubles, and test fixtures. Use when users ask about ABAP unit tests, test classes, test methods, CL_ABAP_UNIT_ASSERT, test doubles, mocking, CDS test environment, SQL test environment, RAP testing, ABAP test injection, test seams, behavior-driven testing, TDD in ABAP, test isolation, or writing automated tests for ABAP code. Triggers include "write a unit test", "create test class", "mock a dependency", "test a CDS view", "test a RAP BO", "test double", "assertion", "test fixture", "test isolation", or "ABAP unit".

williamcorrea23 Bundle

Back up and (critically) recover the database under a SAP system — backup types (full/incremental/log), recovery types (most-recent / point-in-time / specific backup), log/recovery-mode prerequisites, and the per-DB restore commands for SAP HANA, Oracle, SAP ASE, IBM Db2, SAP MaxDB and MS SQL Server, on Linux/Windows/AIX. Use for "restore the database", "recover to point in time", "backup strategy", "test restore", "brrecover", "RECOVER DATA", "db2 rollforward", "RESTORE DATABASE". Cited to help.sap.com.

williamcorrea23 Bundle

Run, smoke-test, and drive the SAP Router Skill CLI (sap_router.py, memory_manager.py, xls_to_bapi.py, template_repo.py, abap_serializer.py, cpi_iflow_packager.py). Use when asked to run, start, build, test, verify, or smoke-test the sap-router-skill, its routing engine, MEMORY.md compaction, or the XLS/CSV-to-BAPI converter.

williamcorrea23 Skill

SAP Datasphere plugin for Codex Co-Work (MarioDeFelipe/sap-datasphere-plugin-for-Codex-cowork). Reference for Datasphere spaces, views, and data federation — the MCP/plugin usage layer: connecting via datasphere-mcp, @sap/datasphere-cli operations, consuming views via OData/Open SQL, and monitoring task chains.

williamcorrea23 Bundle

Database-specific operational commands for SAP systems — start, stop, connect, status and basic backup for the SAP-supported databases (SAP HANA, Oracle, SAP ASE/Sybase, IBM Db2, SAP MaxDB/liveCache, Microsoft SQL Server), with Linux / Windows / AIX variants. Use whenever a Basis/operations task needs the DB layer: "stop the database", "connect to HANA/ASE/Oracle", "is the DB up", "restart the database before/after the SAP instances", or when sap-system-lifecycle hands off DB start/stop. Every command is cited to help.sap.com / the official Administration Guide.

dingxingdi Bundle

Use this skill when the user wants to populate or enrich an existing relational database using information extracted from raw text documents. Trigger it for requests like 'extract information from these news reports into my SQL database', 'add new rows to the movies table based on this biography', 'fill in missing data in my table using the provided text', or 'create new columns from the attached articles'. This skill is specifically for tasks that require the agent to understand a database schema and ensure that data extracted from unstructured sources follows formatting, granularity, and integrity constraints.

biotender-max Skill

NCBI GEO access via GEOparse and E-utilities. Search by keyword/organism/platform, download GSE series matrices, parse GPL annotations, extract GSM metadata, load expression matrices into pandas. For single-cell use cellxgene-census; for multi-DB access use gget-genomic-databases.

biotender-max Skill

CHARLS (China Health and Retirement Longitudinal Study) database-specific knowledge for reproducing published papers. Use when reproducing or analyzing papers that use CHARLS data, including variable mapping from harmonized to raw questionnaire items, cognitive function scoring (episodic memory, mental status, TICS), CESD-10 depression screening, social isolation index construction, and chronic disease coding. Also use for any CHARLS data cleaning, variable construction, or cohort selection task.

biotender-max Bundle

Core Python library for astronomy/astrophysics: units with dimensional analysis, celestial coordinate transforms (ICRS/Galactic/AltAz/FK5), FITS I/O, tables (FITS/HDF5/VOTable/CSV), cosmology (Planck18, distance/age), precise time (UTC/TAI/TT/TDB, Julian, barycentric), WCS pixel-world mapping, model fitting. For general tables use pandas/polars; for radio interferometry use CASA.

clowlove Bundle

专注于构建可靠数据管线、湖仓架构和可扩展数据基础设施的数据工程专家。精通 ETL/ELT、Apache Spark、dbt、流处理系统和云数据平台，将原始数据转化为可信赖的分析就绪资产。

clowlove Bundle

核对畜禽养殖档案 Excel 与生产日报，按子表独立审计兽药、饲料、诊疗、免疫、生产记录等错填漏填，FIFO 复核批号，输出可直接整改的中文问题表述。

clowlove Bundle

专业数据分析师，擅长将原始数据转化为可操作的业务洞察。创建仪表盘、执行统计分析、跟踪 KPI，并通过数据可视化和报告提供战略决策支持。

clowlove Bundle

监控 Excel 文件并提取关键销售指标（月累计、年累计、年末预测），服务于内部实时报告系统。

clowlove Bundle

专业文档创建专家，通过代码化方式生成专业的 PDF、PPTX、DOCX 和 XLSX 文件，支持格式化、图表和数据可视化。

dingxingdi Bundle

Skill: source retrieval

dingxingdi Bundle

Skill: schema item grounding

dingxingdi Bundle

Skill: sql dialect adaptation

dingxingdi Bundle

Skill: multi-hop join reasoning

dingxingdi Bundle

Trigger this skill when the user provides broken or logically incorrect SQL requiring clause-level diagnosis and repair. It is essential when a query results in a syntax crash, row inflation (unwanted duplicates), or semantic nulls (correct syntax but no data returned). Layman triggers include requests like 'fix this query', 'why is my code returning nothing?', 'this script has an error on line 5', or 'adjust the WHERE clause to match the question better'. Use this to target specific parts of a query like the SELECT, WHERE, or JOIN clauses for fine-grained localized correction.

dingxingdi Bundle

Skill: geospatial rule grounding

dingxingdi Bundle

Use this skill when the user wants SQL tasks where time is the main source of difficulty, including colloquial shift-based time references. Trigger it for requests like “make it about first vs last”, “events that happened before the night shift”, “test recency and ordering”, or “during the lunch hour bounds.”