Data & Analytics

paulasilvatech Skill

Analyze COBOL programs, copybooks, PERFORM and CALL structure, file and VSAM access, embedded EXEC SQL and EXEC CICS, DB2 DDL, DCLGEN structures, cursors, and JCL job steps with source citations. Use when reading or inventorying a COBOL/DB2 legacy system before modernization.

paulasilvatech Skill

Review existing PostgreSQL SQL, schema, migrations, functions, triggers, indexes, JSONB, arrays, custom types, domains, extensions, privileges, and Row Level Security for PostgreSQL-specific anti-patterns. Use when asked to audit or critique PostgreSQL code, database migrations, PL/pgSQL, RLS policies, or schema design.

paulasilvatech Bundle

Compare SQL Server tables across source and target instances for migration validation, ETL verification, production versus staging checks, schema drift, missing rows, extra rows, and column mismatches. Use this skill when the user asks for SQL Server reconciliation reports, and use mssql-python with Apache Arrow for fast extraction.

paulasilvatech Skill

Design, tune, and modernize PostgreSQL SQL, schemas, indexes, functions, and maintenance workflows using PostgreSQL-specific capabilities. Use this skill when the user asks for PostgreSQL optimization, query tuning, JSONB or array design, EXPLAIN ANALYZE interpretation, index strategy, full-text search, custom types, range/geometric types, pg_stat_statements, VACUUM, ANALYZE, partitioning, or secure parameterized database development.

tryboy869 Bundle

[Applies to: **/*] Comprehensive guidelines for writing high-performance, secure, and maintainable Supabase applications, covering SQL style, data modeling, security, and testing.

tryboy869 Bundle

[Applies to: **/*] This guide defines the definitive best practices for writing clean, performant, and maintainable PostgreSQL SQL, focusing on modern conventions and avoiding common pitfalls.

tryboy869 Bundle

Apply for PostgreSQL schema design, queries, migrations, and performance. Covers: indexes, constraints, JSONB, migrations with Alembic, connection pooling, query optimization. Trigger for: database, PostgreSQL, SQL, schema, migration, query, index.

jantoniofc Skill

Django security best practices, authentication, authorization, CSRF protection, SQL injection prevention, XSS prevention, and secure deployment configurations.

peteedoo Bundle

Automate GoPhish phishing simulation campaigns using the Python gophish library. Creates email templates with tracking pixels, configures SMTP sending profiles, builds target groups from CSV, launches campaigns, and analyzes results including open rates, click rates, and credential submission statistics for security awareness assessment.

peteedoo Bundle

Hunt AADGraphActivityLogs and MicrosoftGraphActivityLogs in Microsoft Sentinel/Log Analytics for fingerprints of offensive Entra ID tools such as ROADtools, AADInternals, and AzureHound.

solizardking Bundle

NVIDIA DeepStream SDK 9.0 development with Python pyservicemaker API. Use when building video analytics pipelines, GStreamer-based video processing, TensorRT inference integration, object detection/tracking, or Kafka/message broker integration.

solizardking Bundle

Runs the DEFT embed-then-mine workflow for VCN AOI iterations — embeds the gap-analysis target parquet, embeds a source pool, and mines nearest-neighbour source images for downstream augmentation. Use as the immediate next step after `tao-route-visual-changenet-samples` when expanding a real-image augmentation queue from the mining subset.

tryboy869 Bundle

Apply for pandas-scikit-learn-guide-cursorrules-prompt-file. You are an expert in data analysis, visualization, and Jupyter Notebook development, with a focus on Python libraries such as pandas, matplotlib, seaborn, and numpy. Key Principles: - Write concise, t

zhizhunbao-ai-dev-config Bundle

Work with Weka data files (.arff format). Use when (1) user needs to convert ARFF to CSV, (2) mentions Weka data files, (3) needs to extract column names from ARFF files.

solizardking Bundle

Load a sharded, on-disk dataset (sharded .npy, Parquet/Arrow, raw binary, sharded HDF5, custom layouts) into a distributed cuPyNumeric ndarray via a manual partition + leaf @task launch with CPU/OMP/GPU variants. Use when no single-call loader fits, including when per-shard row counts differ across files. Prefer cupynumeric.load or legate.io.hdf5.from_file when they apply.

solizardking Bundle

Guides developers through implementing event and conversion ingestion to Google products using the Data Manager API /v1/events/ingest endpoint and its associated client libraries. Use this skill when the user wants to upload offline conversions, enhanced conversions for leads, click conversions, Google Analytics web or app events, or any other event ingestion use case supported by the Data Manager API. Don't use for uploading audience members (use the data-manager-api-audience-ingestion skill).

dirnbauer Bundle

When the user wants to plan, design, or implement an A/B test or experiment. Also use when the user mentions "A/B test," "split test," "experiment," "test this change," "variant copy," "multivariate test," or "hypothesis." For tracking implementation, see analytics-tracking.

dirnbauer Bundle

When the user wants to create, plan, or optimize a lead magnet for email capture or lead generation. Also use when the user mentions "lead magnet," "gated content," "content upgrade," "downloadable," "ebook," "cheat sheet," "checklist," "template download," "opt-in," "freebie," "PDF download," "resource library," "content offer," "email capture content," "Notion template," "spreadsheet template," or "what should I give away for emails." Use this for planning what to create and how to distribute it. For interactive tools as lead magnets, see free-tools. For writing the actual content, see copywriting. For the email sequence after capture, see emails.

dirnbauer Bundle

Hardens TYPO3 v14 installations and extensions with secure configuration, trusted hosts, file permissions, Install Tool protection, backend user security, MFA, CSP, QueryBuilder usage, XSS defenses, and CSRF checks. Use when the user asks about TYPO3 security, hardening, permissions, authentication, CSP, SQL injection, XSS, CSRF, or go-live security readiness.

dirnbauer Skill

Create, edit, and analyze office documents (PDF, DOCX, PPTX, XLSX). Use when working with PDFs, Word documents, PowerPoint presentations, or Excel spreadsheets. Covers text extraction, form filling, document creation, and data analysis.

infrasity-labs Skill

Cluster a list of keywords into topical groups with search intent labels, validated search volume, KD, and CPC data. Use this skill whenever a user provides a list of keywords (pasted, uploaded as CSV/Excel, or via Google Sheet URL) and asks to cluster, group, map, organize, or categorize them. Also trigger when a user says "keyword cluster", "cluster my keywords", "group these keywords", "keyword map", "keyword strategy from this list", "organize keywords by topic", or pastes or uploads a list of keywords and wants structure from it. Always use this skill — do not attempt keyword clustering manually without following this workflow.

sahit-sai Skill

SQL 查询助手。帮用户写 SQL 查询、优化慢查询、设计表结构，支持 MySQL/PostgreSQL/SQLite。当用户说「帮我写个 SQL」「SQL 怎么写」「查询优化」「建表语句」「慢查询」「SQL 报错」「数据库查询」「写个查询」「join 怎么用」「索引优化」「sql query」时触发。关键词：SQL、查询、MySQL、PostgreSQL、SQLite、建表、索引、JOIN、慢查询、查询优化、SELECT、INSERT、UPDATE、DELETE、GROUP BY、子查询、存储过程、视图、触发器、事务、EXPLAIN、数据库、表设计、ER 图、范式、sql query、database

sahit-sai Skill

数据分析助手。帮用户分析数据、生成统计摘要和可视化建议。当用户说「分析这个数据」「帮我看看这些数据」「做个数据分析」「统计一下」「数据可视化」「画个图表」「CSV 分析」「data analysis」「analyze this data」「数据趋势」「数据报告」时触发。关键词：数据分析、统计、可视化、图表、CSV、JSON、Excel、趋势分析、数据报告、data analysis、visualization、chart、statistics、pandas、数据清洗、数据处理、聚合、分组、透视表、pivot table、histogram、scatter plot

sahit-sai Bundle

Query Fabric lakehouse and warehouse data using DuckDB, either locally or inside a Fabric notebook. Automatically invoke when the user mentions "DuckDB", "query Delta tables locally", or asks to "attach DuckDB to a lakehouse", "query OneLake data", "explore lakehouse data", "data freshness check", "validate data quality", "use DuckDB in Fabric".

sahit-sai Skill

Excel公式助手。帮用户写Excel和Google Sheets公式，VLOOKUP/SUMIF/数组公式/透视表。当用户说「帮我写公式」「Excel公式」「VLOOKUP怎么用」「SUMIF」「数组公式」「表格公式」「Google Sheets公式」「条件求和」「数据透视表」「excel formula」「spreadsheet」「lookup」时触发。关键词：Excel、公式、formula、VLOOKUP、HLOOKUP、XLOOKUP、SUMIF、SUMIFS、COUNTIF、INDEX、MATCH、IF、嵌套函数、数组公式、透视表、pivot table、条件格式、数据验证、Google Sheets、WPS表格、SUMPRODUCT、OFFSET、INDIRECT、power query、宏、VBA

sahit-sai Skill

Python 脚本助手。帮用户写 Python 脚本，数据处理、自动化任务、爬虫、文件操作。当用户说「帮我写个 Python 脚本」「Python 怎么写」「写个爬虫」「数据处理脚本」「自动化脚本」「Python 报错」「pandas 怎么用」「正则匹配」「文件批量处理」「Excel 处理」「CSV 读取」「JSON 解析」「python script」「web scraping」「automation」时触发。关键词：Python、脚本、爬虫、数据处理、自动化、pandas、numpy、requests、BeautifulSoup、Selenium、正则、文件操作、CSV、Excel、JSON、API调用、定时任务、批量处理、数据清洗、ETL、subprocess、os、pathlib、asyncio、multiprocessing

sahit-sai Skill

SQL 生成器。从自然语言描述自动生成 SQL 查询语句，支持复杂查询和多数据库方言。当用户说「帮我写个SQL」「查询怎么写」「自然语言转SQL」「text to SQL」「SQL查询」「数据库查询」「generate SQL」「NL2SQL」「表怎么联」「子查询」「窗口函数」时触发。关键词：SQL生成、自然语言转SQL、NL2SQL、text to SQL、查询生成、SELECT、JOIN、子查询、窗口函数、聚合函数、GROUP BY、HAVING、CTE、WITH、MySQL、PostgreSQL、SQLite、Oracle、SQL Server、数据查询、表关联、索引建议

sahit-sai Bundle

Author, validate, publish, and test Power BI paginated reports in the RDL format. Automatically invoke when the user mentions "paginated report", "RDL", ".rdl", "Report Builder", "Power BI Report Builder", "SSRS report", "PBIRS", "Power BI Report Server", or asks to "create a paginated report", "build an invoice/statement report", "make a print-perfect report", "connect a paginated report to a semantic model", "edit an RDL file", "publish an .rdl", or "render a paginated report to PDF/Excel".

sahit-sai Skill

小红书数据分析与运营策略助手。帮用户分析小红书账号数据、爆文规律、标签策略、发布时间优化、涨粉策略。当用户说「小红书数据分析」「分析一下我的小红书」「小红书运营」「为什么我的笔记没流量」「小红书涨粉」「爆文分析」「小红书算法」「redbook analytics」「RED analytics」「小红书复盘」「笔记数据」时触发。关键词：小红书数据、小红书分析、小红书运营、爆文、流量、涨粉、标签策略、发布时间、互动率、完播率、收藏率、点赞率、笔记复盘、账号诊断、小红书算法、内容策略、对标账号、数据看板

junmystery Skill

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads. Use when writing ClickHouse schemas or queries, or when an analytical query is too slow.

junmystery Skill

Django security best practices, authentication, authorization, CSRF protection, SQL injection prevention, XSS prevention, and secure deployment configurations. Use when reviewing Django authentication, authorization, input handling, or deployment settings.

handsomeboy990 Bundle

Analytics Instrumentation

serejaris Bundle

Specialized utility for advanced manipulation, analysis, and creation of spreadsheet files, including (but not limited to) XLSX, XLSM, CSV formats. Core functionalities include formula deployment, complex formatting (including automatic currency formatting for financial tasks), data visualization, mandatory post-processing recalculation, and finance-focused Excel modeling workflows such as three-statement models, DCF valuation, and public comps analysis.

serejaris Bundle

CSV数据异常检测工具，使用Z-score、IQR（四分位距）、移动平均偏离三种方法进行扫描，并自动将检测到的异常点分类为「可解释」或「需关注」，输出详细的JSON报告。当用户需要异常检测、离群值排查或数据质量巡检，提及outlier detection、Z-score、IQR、移动平均偏离等关键词或直接上传CSV文件时触发。

vishuwa2004 Skill

Translate a streaming subagent run into task progress, analytics, and notifications while keeping partial results and cleanup tidy.

serejaris Bundle

从学习材料（文本、Markdown、笔记）中提取核心知识点，生成符合间隔重复记忆原理的正面问题+反面答案闪卡，输出可直接导入Anki的CSV文件。当用户提到闪卡、Anki、记忆卡片、知识点提取、复习卡片、间隔重复，或需要将学习内容转换成问答对进行复习时触发。