Data & Analytics

majiayu000 Bundle

This skill should be used when completing LBO (Leveraged Buyout) model templates in Excel for private equity transactions, deal materials, or investment committee presentations. The skill fills in formulas, validates calculations, and ensures professional formatting standards that adapt to any template structure.

majiayu000 Bundle

This skill should be used when the user wants to open or preview a file that already exists on disk using the operating system's default application. Triggers on requests like "open this file", "show me the PDF", "preview the image", "view the document", or "display the spreadsheet". Works with all file types including PDFs, images, documents, emails, and spreadsheets.

majiayu000 Bundle

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

majiayu000 Bundle

COO 产品运营数据分析技能，使用 Playwright MCP 从 App Store Connect、小程序后台、小红书创作者中心等平台获取运营数据

majiayu000 Bundle

When the user wants to implement cross-docking operations, optimize transshipment, or reduce warehouse storage. Also use when the user mentions "crossdock," "transshipment," "flow-through distribution," "dock-to-dock," "consolidation center," or "break-bulk operations." For general warehouse design, see warehouse-design. For dock scheduling, see dock-door-assignment.

majiayu000 Bundle

Profile datasets to understand schema, quality, and characteristics. Use when analyzing data files (CSV, JSON, Parquet), discovering dataset properties, assessing data quality, or when user mentions data profiling, schema detection, data analysis, or quality metrics. Provides basic and intermediate profiling including distributions, uniqueness, and pattern detection.

majiayu000 Bundle

Write and verify SQL queries with BigQuery. Use when executing bq commands, writing SQL queries, or including query results in documents.

majiayu000 Bundle

Transform and export data using DuckDB SQL. Read CSV/Parquet/JSON/Excel/databases, apply SQL transformations (joins, aggregations, PIVOT/UNPIVOT, sampling), and optionally write results to files. Use when the user wants to: (1) Clean, filter, or transform data, (2) Join multiple data sources, (3) Convert between formats (CSV→Parquet, etc.), (4) Create partitioned datasets, (5) Sample large datasets, (6) Export query results. Prefer this over in-context reasoning for datasets with thousands of rows or complex transformations.

majiayu000 Bundle

SQL database querying, optimization, and data management for analytics

majiayu000 Bundle

- You are integrating a SQL client (Drizzle, Kysely, Prisma, mysql2/pg) with Effect

majiayu000 Bundle

Expert-level energy systems, smart grids, renewable energy, power management, and energy analytics

majiayu000 Bundle

Analyze unknown or inherited Excel files to understand what they do, document their purpose, audit formulas for errors, and assess maintainability risk. Use when: (1) User uploads an Excel file asking 'what does this do?', (2) User needs to understand an inherited/legacy spreadsheet, (3) User wants formula auditing or error detection, (4) User asks about spreadsheet risk, complexity, or documentation, (5) User mentions 'inherited', 'legacy', 'undocumented', or 'someone left' regarding Excel files.

majiayu000 Bundle

读取、写入和操作Excel文件（.xlsx、.xls）。创建电子表格、读取数据并导出为各种格式。

majiayu000 Bundle

description: Excel 数据处理工具包，针对 BTC ShopFlow 的库存、盘点、报表等 Excel 导入导出场景

majiayu000 Bundle

JOOQ type-safe SQL patterns - use for database queries, repositories, complex SQL operations, and PostgreSQL-specific features

majiayu000 Bundle

Generate and execute Python code to analyze large log datasets, detect patterns, and extract actionable insights

majiayu000 Bundle

Analyzes long straddle volatility plays with ATM call and put at same strike. Requires numpy>=1.24.0, pandas>=2.0.0, matplotlib>=3.7.0, scipy>=1.10.0. Use when expecting large price movement in either direction, analyzing earnings plays, evaluating volatility opportunities, or assessing binary event outcomes on high IV stocks.

majiayu000 Bundle

Analyzes long strangle volatility plays with OTM call and put at different strikes. Requires numpy>=1.24.0, pandas>=2.0.0, matplotlib>=3.7.0, scipy>=1.10.0. Use when expecting very large price movement, want lower-cost alternative to straddle, analyzing high-volatility events, or evaluating wide-range breakout opportunities on stocks with elevated IV.

majiayu000 Bundle

Analyze Mixpanel analytics data using the mixpanel_data Python library or mp CLI. Use when working with Mixpanel event data, user profiles, funnels, retention, cohorts, segmentation queries, JQL scripts, or SQL analysis on local DuckDB. Triggers on mentions of Mixpanel, event analytics, funnel analysis, retention curves, user behavior tracking, JQL queries, filter expressions, 'fetch data from Mixpanel', 'query Mixpanel with SQL', 'run DuckDB queries on events', 'analyze user behavior', 'export Mixpanel data', 'mp command', or requests to work with analytics pipelines. Supports filter expressions for WHERE/ON clauses, JQL (JavaScript Query Language) for complex transformations, Python scripts with pandas integration, and CLI pipelines with jq/Unix tools.

majiayu000 Bundle

Log experiment metrics, parameters, and artifacts using MLflow Python API. Query and analyze runs with DataFrame operations. Use when user mentions "log backtest", "MLflow metrics", "experiment tracking", "log parameters", "search runs", "MLflow query", or needs to record strategy performance.

majiayu000 Bundle

SQL best practices with pgTAP, sqlfluff 3.2, query optimization, and migration management.

majiayu000 Bundle

Test Nuxt 3 / Nitro API handlers with real PostgreSQL, transaction rollback isolation, and typed factories. No mocks, real SQL.

majiayu000 Bundle

Columnar file patterns including partitioning, predicate pushdown, and schema evolution.

majiayu000 Bundle

PostGIS-focused SQL tips, tricks and gotchas. Use when in need of dealing with geospatial data in Postgres.

majiayu000 Bundle

This skill should be used when the user asks to "work with polars", "create a dataframe", "use lazy evaluation", "migrate from pandas", "optimize data pipelines", "read parquet files", "group by operations", or needs guidance on Polars DataFrame operations, expression API, performance optimization, or data transformation workflows.

majiayu000 Bundle

Role-based access control (RBAC) patterns, authentication wrappers, authorization checks, input validation with Zod schemas, security boundaries, server action security, real-time message validation, preventing common vulnerabilities like XSS and SQL injection, and security best practices for ree-board project

majiayu000 Bundle

Expert-level retail systems, POS, inventory management, e-commerce, customer analytics, and omnichannel retail

majiayu000 Bundle

Expert-level SmartAssembly scripting for SIGMAXIM's Creo Parametric automation. Use for: .tab script writing/review/debug, CREATE_UDF/ASSEMBLE commands, BEGIN_GUI_DESCR/BEGIN_TAB_DESCR configuration, INCLUDE modular design, BEGIN_CATCH_ERROR error handling, feature/reference manipulation, Excel integration (EXCEL_* commands), drawing automation (CREATE_DRW_*), PDF export (EXPORT_DRW_PDF), XML manipulation (READ/MODIFY_FEATURE_XML), JSON commands (JSON_LOAD_DOCUMENT, JSON_GET_VALUE, JSON_SET_VALUE for REST API/data exchange), PowerShell-Creo COM API integration, manufacturing workflows (Model→Drawing→Export→PDF), path system (SA_Paths.txt, lib: prefix), product patterns (Counters, WorkTables, Tops, DishTables, Wall_Panels, Curbs, Channels), vector geometry analysis, map operations, multi-stage GUI, auto-generation logic, field joints, material selection, or any PTC Creo automation scripting.

majiayu000 Bundle

Master analytical SQL including window functions, CTEs, aggregations, and query optimization for BI workloads

majiayu000 Bundle

This skill should be used when the user asks to format SQL code, polish SQL queries, improve SQL readability, or work with .sql files. Use when queries mention SQL formatting, code beautification, Oracle SQL, or database query polishing.

majiayu000 Bundle

WHEN: SQL query review, query optimization, index usage, N+1 detection, performance analysis WHAT: Query plan analysis + Index recommendations + N+1 detection + Join optimization + Performance tuning WHEN NOT: Schema design → schema-reviewer, ORM code → orm-reviewer

majiayu000 Bundle

Use when user needs SQL development, database design, query optimization, performance tuning, or database administration across PostgreSQL, MySQL, SQL Server, and Oracle platforms.

majiayu000 Bundle

Time tracking integration patterns with RescueTime and Toggl APIs for automated time entry, reporting, analytics, and project/task attribution

majiayu000 Bundle

当需要修改项目（增删改文件）并希望将 update_plan 与 CSV 有机同步时使用此技能：在项目根目录创建“{任务名} TO DO list.csv”，用 TODO/IN_PROGRESS/DONE 驱动 plan 的 pending/in_progress/completed，同步推进，全部完成后删除该文件。

majiayu000 Bundle

Extract VBA/macro code from Microsoft Office files (.xlsm, .xlsb, .docm, .pptm). This skill should be used when users want to read, view, or extract VBA macros from Excel workbooks or other Office documents containing embedded VBA projects.

majiayu000 Bundle

Google Suite integration for Sheets, Docs, Slides, Gmail, Calendar, Tasks with multi-account support. Orchestrates operations via CLI tools. Triggers on keywords: google sheets, google docs, google slides, gsuite, gdrive, spreadsheet, document, gmail, google calendar, google tasks