Data & Analytics

majiayu000 Bundle

Use when user asks for Claude Code usage stats, weekly analytics, project activity summary, or wants to see what projects were worked on. Triggers on "аналитика", "статистика claude", "cc stats", "weekly report", "что делал"

majiayu000 Bundle

Handle messy CSVs with encoding detection, delimiter inference, and malformed row recovery.

majiayu000 Bundle

Use when working with data transformations, scales, color schemes, formatting, or CSV/TSV parsing. Invoke for data processing pipelines, scale creation, color interpolation, number/date formatting, or data loading/parsing operations.

majiayu000 Bundle

This skill should be used when analyzing business sales and revenue data from CSV files to identify weak areas, generate statistical insights, and provide strategic improvement recommendations. Use when the user requests a business performance report, asks to analyze sales data, wants to identify areas of weakness, or needs recommendations on business improvement strategies.

majiayu000 Bundle

Use when writing SQL queries, optimizing database performance, or analyzing data

majiayu000 Bundle

Data science and analytics expertise for statistical analysis, machine learning pipelines, data governance, business intelligence, predictive modeling, and analytics strategy. Use when building ML models, analyzing data, creating dashboards, or designing data architectures.

majiayu000 Bundle

Export table data as SQL INSERT statements from 30+ databases using DbCli. Essential for creating backups before dangerous modifications (UPDATE/DELETE/DROP). Use when user needs to backup data, migrate tables, or create portable SQL dumps.

majiayu000 Bundle

Writing dbt models with proper CTE patterns, SQL structure, and layer-specific templates. Use this skill when writing or refactoring dbt models, implementing CTE patterns, creating staging/intermediate/mart models, or ensuring proper SQL structure and dependencies.

majiayu000 Bundle

I/O platform functions for the East language on Node.js. Use when writing East programs that need SQL databases (SQLite, PostgreSQL, MySQL), NoSQL databases (Redis, MongoDB), S3 storage, file transfer

majiayu000 Bundle

Comprehensive guide to ELT (Extract, Load, Transform) modeling patterns, dimensional modeling, fact and dimension tables, and data warehouse design

majiayu000 Bundle

Production ETL patterns orchestrator. Routes to core reliability patterns and incremental load strategies.

majiayu000 Bundle

Push Excel data back to BIM models. Update parameters, properties, and attributes from structured spreadsheets.

majiayu000 Bundle

Import Excel data into RVT projects. Update element parameters, create schedules, and sync external data sources.

majiayu000 Bundle

Test game mechanics via SQL. Use game_* tools for gameplay flow.

majiayu000 Bundle

Work with GNU recutils for plain-text record databases. Use when creating, querying, or validating .rec files, defining record schemas with %rec descriptors, converting between rec/CSV formats, or when the user mentions recutils, recsel, recins, recfmt, or record-oriented data files.

majiayu000 Bundle

Information gathering utilities (analytics, research, content analysis) (general)

majiayu000 Bundle

LMS feature implementations including Browse Gradebook, Course Kanban, Communications, Statistics Module, MAP Analytics, Teacher Schedule, and Attendance System. Use this skill when implementing or modifying these features, understanding their data structures, or debugging feature-specific issues.

majiayu000 Bundle

DataFrame manipulation with chunked processing, memory optimization, and vectorized operations.

majiayu000 Bundle

Use this skill when writing or updating SQL queries (query.sql) or Python ETL scripts (query.py) following Mozilla BigQuery ETL conventions. ALWAYS checks for and updates existing tests when modifying queries. Coordinates downstream updates to schemas and tests. Works with bigquery-etl-core, metadata-manager, and sql-test-generator skills.

majiayu000 Bundle

R&D Ops Autonomous Agent system for vendor management, contract staffing pipelines, CV processing, interview orchestration, legal document drafting (SoW/MSA), and finance evidence compilation. Use when working with vendors, candidates, hiring pipelines, CV screening, deduplication, interview scheduling, SoW drafting, PO readiness, audit reports, or Excel exports for R&D operations.

majiayu000 Bundle

This skill provides guidance for tasks involving MobileSAM or Segment Anything Model (SAM) for cell segmentation, mask refinement, and polygon extraction from images. Use when working with SAM-based image segmentation pipelines, converting masks to polygons, processing CSV-based coordinate data, or integrating deep learning segmentation models into processing scripts.

majiayu000 Bundle

Bun runtime security audit patterns. Load when reviewing Bun apps (bun.lockb, bunfig.toml, or bun:* imports present). Covers Bun shell injection, bun:sqlite SQL injection, Bun.serve, Bun.spawn, file operations, and Bun-specific footguns.

majiayu000 Bundle

Logs and scores skill usage quality, tracking output effectiveness, user satisfaction signals, and improvement opportunities. Expert in skill analytics, quality metrics, feedback loops, and continuous improvement. Activate on "skill logging", "skill quality", "skill analytics", "skill scoring", "skill performance", "skill metrics", "track skill usage", "skill improvement". NOT for creating skills (use agent-creator), skill documentation (use skill-coach), or runtime debugging (use debugger skills).

majiayu000 Bundle

Use to design measurement, alerting, and reporting for MQL→SQL SLAs.

majiayu000 Bundle

Master SQL for data analysis with complex queries, joins, aggregations, window functions, and query optimization.

majiayu000 Bundle

Prevent D1 "too many SQL variables" errors when using Drizzle ORM. Use this skill whenever writing database queries with `inArray()`, bulk inserts/updates, or any query with dynamic arrays. Critical for queries where array size is unbounded (user teams, registrations, IDs from prior queries).

majiayu000 Bundle

对SQLite、PostgreSQL、MySQL数据库执行SQL查询，支持结果格式化和导出。

majiayu000 Bundle

Guide for researching SQL syntax and behavior for database backends. Use when you need to research how a SQL function, command, or feature works in a specific database before implementing it in dbplyr.

majiayu000 Bundle

High-performance CLI for working with SQL dump files: split/merge by table, analyze contents, validate integrity, convert between MySQL/PostgreSQL/SQLite/MSSQL, create FK-safe samples, shard multi-tenant dumps, generate ERD diagrams, reorder for safe imports, and run SQL analytics with embedded DuckDB. Use when working with .sql dump files for migrations, dev seeding, CI validation, schema visualization, data extraction, or ad-hoc analytics.

majiayu000 Bundle

SQL workflow guidelines. Activate when working with SQL files (.sql), database queries, migrations, or SQLFluff.

majiayu000 Bundle

Transform data into compelling narratives using visualization, context, and persuasive structure. Use when presenting analytics to stakeholders, creating data reports, or building executive presentations.

majiayu000 Bundle

Expert guidance for TM1py Python package for IBM Planning Analytics (TM1). Master connection management, data operations (MDX, views, DataFrames), metadata CRUD, performance optimization, and best practices. Use when working with TM1py, IBM Planning Analytics API, or when user mentions TM1, Planning Analytics, TM1 REST API, MDX queries, cube operations, dimension management, or Python TM1 development.

majiayu000 Bundle

Fetch and analyze weather data for specified locations. Use when you need current weather conditions, forecasts, or weather-related analytics for decision-making or integration with Chainlit chat responses.

majiayu000 Bundle

Comprehensive word counting and tracking system for authors - track word counts across documents, monitor writing progress, and generate detailed analytics for markdown-based writing projects.

majiayu000 Bundle

Классифицирует пользовательский фидбек (Excel/CSV/текст) по 6 категориям, делает sentiment-анализ, кластеризацию тем, анализ трендов, триангуляцию по источникам, расчёт NPS и извлечение персон. На выходе — Top-10 болей с рекомендациями к действию. User-invoked only — do NOT auto-trigger. Triggers on /pm-feedback, "анализ обратной связи", "разбор отзывов", "анализ NPS", "analyze user feedback", "VOC analysis", "NPS analysis", "review analysis".

majiayu000 Bundle

Mine usage history (session archaeology, rtk analytics, shell history) for repeated toil, score frequency x pain, and emit ranked automation candidates.