Data & Analytics

majiayu000 Bundle

Use when handling any workbook or spreadsheet task with Univer CLI, including ordinary workbook operations, SaC source authoring, Facade Migration Packs, assertions.ts, or complex workbook behavior.

majiayu000 Bundle

Install Excel MCP server via uvx. Use when user needs Excel file manipulation capabilities.

majiayu000 Bundle

i-AUD 서버 스크립트 개발 가이드. Rhino 엔진에서 실행되는 TypeScript 서버 스크립트 작성법을 안내합니다. "서버 스크립트", "데이터베이스 조회", "SQL 실행", "파일 처리", "FTP", "서비스 개발" 등을 물어볼 때 사용하세요.

majiayu000 Bundle

AelfScan explorer data retrieval and analytics skill for agents.

majiayu000 Bundle

Integration with hosted documentation platforms GitBook and Notion. Manage spaces, synchronize content with Git, export/import between formats, configure webhooks, and retrieve analytics.

majiayu000 Bundle

Use when planning complex SaC spreadsheet or workbook behavior, Facade Migration Packs, workbook range roles, migration boundaries, assertion gates, or Excel-domain decisions before implementation.

majiayu000 Bundle

Complete Google Workspace integration (Gmail, Docs, Sheets, Calendar, Drive, Tasks, Slides). Load when user mentions 'google', 'gmail', 'email', 'google docs', 'google sheets', 'spreadsheet', 'google calendar', 'schedule meeting', 'calendar', 'google drive', 'upload file', 'download file', 'google tasks', 'todo', 'google slides', 'presentation', or any Google service operation.

majiayu000 Bundle

Comprehensive Claude Code telemetry via 10 hooks capturing sessions, conversations, tools, subagents, context, permissions, and repository analytics. Use when analyzing detailed usage patterns beyond default OTEL.

majiayu000 Bundle

On-chain data analysis framework — covers active addresses, whale behaviour, TVL (total value locked), DEX liquidity, and on-chain valuation metrics: MVRV (market cap / realised value), NVT (network value / transaction volume), SOPR. Longbridge provides spot crypto quotes (.HAS); raw on-chain data requires external sources (Glassnode / Dune Analytics). Triggers: "链上数据", "链上分析", "MVRV", "NVT", "活跃地址", "鲸鱼地址", "TVL", "SOPR", "链上指标", "链上估值", "鏈上數據", "鏈上分析", "活躍地址", "鯨魚地址", "鏈上指標", "鏈上估值", "on-chain data", "on-chain analysis", "MVRV ratio", "NVT ratio", "active addresses", "whale activity", "TVL", "SOPR", "on-chain valuation", "DeFi TVL", "crypto on-chain".

majiayu000 Bundle

Use when building API endpoints with @frappe.whitelist() in Frappe. Covers endpoint design, permission patterns, error handling, client integration, file uploads, background jobs, rate limiting, REST API testing, and migration from Server Scripts to whitelisted methods. Prevents permission bypasses, SQL injection, and data exposure. Keywords: how to create API, build REST endpoint, frappe.call, frappe.whitelist, API permission, guest API, secure endpoint, rate limiting, curl testing, frm.call.

majiayu000 Bundle

Use this skill when a Deepline Play needs human review, evaluation against golden labels, or bounded iterative improvement. Triggers on “put this run in a Sheet,” “review these results,” “read my feedback,” “compare this run to the golden set,” “evaluate this play,” “optimize this play,” or “add the revised run to the same spreadsheet.” It covers fresh Google Sheets feedback reads, durable Play Dataset exports, golden-set discipline, and safe iteration through `deepline tools execute`. Skip ordinary CSV export with no review or evaluation loop.

majiayu000 Bundle

Process vehicle insurance Excel data using Pandas - file handling, data cleaning, merging, validation. Use when processing Excel/CSV files, handling data imports, implementing business rules (negative

majiayu000 Bundle

Unified document generation system producing professionally styled PDF, DOCX, PPTX, and XLSX files with consistent branding through a single configuration.

majiayu000 Bundle

Quick reference cheatsheet for libpython-clj Python interop. Includes initialization, module imports, function calls, data conversions, NumPy/Pandas/Transformers patterns, and troubleshooting. Use when calling Python from Clojure, using Python libraries, or debugging interop issues.

majiayu000 Bundle

This skill should be used when reading any tabular data file (Excel, CSV, Parquet, ODS). It automatically detects and fixes common data issues including multi-level headers, encoding problems, empty rows/columns, and data type mismatches. Returns a clean DataFrame ready for analysis with zero user intervention.

majiayu000 Bundle

Convert Google BigQuery DDL to dbt models compatible with Snowflake. This skill should be used when converting views, tables, or stored procedures from BigQuery to dbt code, generating schema.yml files with tests and documentation, or migrating BigQuery SQL to follow dbt best practices.

majiayu000 Bundle

Convert PostgreSQL/Greenplum/Netezza DDL to dbt models compatible with Snowflake. This skill should be used when converting views, tables, or stored procedures from PostgreSQL, Greenplum, or Netezza to dbt code, generating schema.yml files with tests and documentation, or migrating PostgreSQL SQL to follow dbt best practices.

majiayu000 Bundle

Convert Amazon Redshift DDL to dbt models compatible with Snowflake. This skill should be used when converting views, tables, or stored procedures from Redshift to dbt code, generating schema.yml files with tests and documentation, or migrating Redshift SQL to follow dbt best practices.

majiayu000 Bundle

Convert Teradata DDL to dbt models compatible with Snowflake. This skill should be used when converting views, tables, or stored procedures from Teradata to dbt code, generating schema.yml files with tests and documentation, or migrating Teradata SQL to follow dbt best practices.

majiayu000 Bundle

Use when planning channel distribution and measuring video performance.

majiayu000 Bundle

Process CSV data files by cleaning, transforming, and analyzing them. Use this when users need to work with CSV files, clean data, or perform basic data analysis tasks.

majiayu000 Bundle

Validates Customer Feedback Analyzer Excel exports with 7 view sheets, 36 columns, and professional formatting. Use when checking Excel files, verifying export quality, debugging Excel generation issues, before releasing new versions, or when modifying Excel export code. Ensures zero errors in customer-facing deliverables.

majiayu000 Bundle

Analyze Excel spreadsheet formulas to build dependency DAGs (Directed Acyclic Graphs) and understand calculation chains. This skill should be used when the user wants to reverse-engineer Excel formula dependencies, trace how values are calculated from inputs to outputs, validate formula logic, or create reusable calculators from spreadsheet logic.

majiayu000 Bundle

Guidance for identifying and fixing security vulnerabilities in code. This skill should be used when asked to fix security issues, address CVEs or CWEs, remediate vulnerabilities like injection attacks (SQL, command, CRLF, XSS), or when working with failing security-related tests.

majiayu000 Bundle

When the user wants to optimize inventory levels, calculate safety stock, determine reorder points, or minimize inventory costs. Also use when the user mentions "inventory management," "safety stock," "EOQ," "reorder point," "service level," "stockout prevention," "ABC analysis," "inventory turns," or "working capital reduction." For warehouse slotting, see warehouse-slotting-optimization. For multi-echelon systems, see multi-echelon-inventory.

majiayu000 Bundle

Use this when instrumenting analytics, reviewing event taxonomy, or handling privacy/redaction rules for markdowntown.

majiayu000 Bundle

Modern Python coaching covering language foundations through advanced production patterns. Use when asked to "write Python code", "explain Python concepts", "set up a Python project", "configure Poetry or PDM", "write pytest tests", "create a FastAPI endpoint", "run uvicorn server", "configure alembic migrations", "set up logging", "process data with pandas", or "debug Python errors". Triggers on "Python best practices", "type hints", "async Python", "packaging", "virtual environments", "Pydantic validation", "dependency injection", "SQLAlchemy models".

majiayu000 Bundle

Optimizes Snowflake query performance using query ID from history. Use when optimizing Snowflake queries for: (1) User provides a Snowflake query_id (UUID format) to analyze or optimize (2) Task mentions "slow query", "optimize", "query history", or "query profile" with a query ID (3) Analyzing query performance metrics - bytes scanned, spillage, partition pruning (4) User references a previously run query that needs optimization Fetches query profile, identifies bottlenecks, returns optimized SQL with expected improvements.

majiayu000 Bundle

Pandas for time series analysis, OrcaFlex results processing, and marine engineering data workflows

majiayu000 Bundle

Extract structured data from multiple web pages using Playwright with built-in ethical crawling practices including rate limiting, robots.txt compliance, and error monitoring. Use when asked to "scrape data from", "extract information from pages", "collect data from site", "crawl multiple pages", or when gathering structured data from websites. Supports pagination, multi-page extraction, data aggregation, and export to CSV/JSON/Markdown. Works with browser_navigate, browser_evaluate, browser_wait_for, and browser_snapshot tools.

majiayu000 Bundle

Builds production-ready, beautiful Plotly Dash dashboards with consistent theming, intuitive layouts, performant callbacks, and thorough documentation. Use when the user asks for a dashboard/data app, interactive analytics, Plotly charts, Dash UI, or a well-formatted shareable web dashboard.

majiayu000 Bundle

When the user wants decision support systems, recommendation engines, or prescriptive analytics. Also use when the user mentions "decision optimization," "recommendation system," "what should we do," "action recommendations," "decision support," "intelligent recommendations," "automated decisions," or "prescriptive models." For pure optimization, see optimization-modeling. For forecasting, see demand-forecasting.

majiayu000 Bundle

When the user needs to monitor SLA compliance for support tickets or service requests, this skill identifies overdue items by querying databases, analyzing SLA documentation from PDFs, and generating automated notifications. It handles 1) Database exploration to find relevant tables (support tickets, users), 2) PDF analysis to extract SLA rules and email templates, 3) SQL queries to identify tickets exceeding response times based on user service levels, and 4) Automated email generation for manager reminders and customer apologies using extracted templates. Triggers include 'SLA compliance', 'overdue tickets', 'response time monitoring', 'send reminder emails', 'apology emails', 'ticket monitoring', and 'service level agreement'.

majiayu000 Bundle

Implement or refactor SQL assets behavior while keeping docs and tests aligned (src/vibe_piper/sql_assets.py, tests/test_sql_assets.py, docs/sql_assets.md).

majiayu000 Bundle

A skill for optimizing SQL queries, focusing on PostgreSQL. It provides a checklist for query analysis, guidance on reading EXPLAIN plans, and patterns for common optimization problems like N+1 queries, JOINs, and pagination. Includes templates for benchmarking and recommending indexes. Use this skill when a user wants to improve the performance of a SQL query.

majiayu000 Bundle

Expert in SQLite embedded database development for Tauri/desktop applications with focus on SQL injection prevention, migrations, FTS search, and secure data handling