Data & Analytics

majiayu000 Bundle

Load data from files (CSV, JSON, JSONL, Parquet) or stdin for analysis and visualization with ggterm. Use when reading datasets, importing data, opening files, or when the user mentions loading, reading, or opening data.

majiayu000 Bundle

RDBMS access patterns for DuckDB, MySQL (keycloak), PostgreSQL (dw, x3rocs), SQL Server (sage1000, x3), and DBISAM (Exportmaster) using ODBC and native drivers

majiayu000 Bundle

提供通用的数据库查询工作流程、SQL 模板和结果分析方法。使用 exec_sql 工具执行查询。

majiayu000 Bundle

ALWAYS USE when working with dbt models, SQL transformations, tests, snapshots, or macros. Use IMMEDIATELY when editing dbt_project.yml, profiles.yml, or creating SQL models. MUST be loaded before any transform-layer work. Enforces dbt owns SQL principle - never parse, validate, or transform SQL in Python.

majiayu000 Bundle

Query DeFiLlama for TVL, protocol analytics, yield pools, and stablecoin data.

majiayu000 Bundle

Drill down on a cell in the Datarails Excel Add-in to see underlying detail. Resolves DR.GET formulas (direct or through formula chains), reads hidden "dr control" sheet filters, queries Datarails for breakdown data, and validates totals before presenting results.

majiayu000 Bundle

Execute SQL queries on Danmarks Statistik data stored in DuckDB. Use when user needs specific data analysis, filtering, aggregation, or joins. Also includes table summary functionality.

majiayu000 Bundle

Excel VBA開発の専門スキル。VBAマクロ作成、Excel操作自動化、ワークブック処理時に使用。

majiayu000 Bundle

使用game-meta进行策划表相关的操作，包括导出csv文件、更新game-meta工具

majiayu000 Bundle

Local environment management - run SQL queries, set up fake payments, reset test data. Use when the user needs help with local database operations or test data setup.

majiayu000 Bundle

Expert-level supply chain management, logistics optimization, warehouse systems, and fleet management

majiayu000 Bundle

Expert guidance for SQL Server database operations using natural language via the MssqlMcp server. Execute queries, manage schemas, perform CRUD operations, and inspect database structures through conversational interface. Use when working with SQL Server, T-SQL, database queries, data manipulation, or schema management.

majiayu000 Bundle

Implements privacy-friendly web analytics with Plausible as a Google Analytics alternative. Use when adding lightweight, cookie-free analytics that are GDPR compliant without consent banners.

majiayu000 Bundle

SQL language guardrails, patterns, and best practices for AI-assisted development. Use when working with SQL files (.sql), database migrations, or when the user mentions SQL/databases. Provides query optimization patterns, indexing guidelines, transaction management, and migration standards specific to this project's coding standards.

majiayu000 Bundle

Generate and optimize SQL queries for data retrieval and analysis

majiayu000 Bundle

TSH stock and warehouse logic for Main WareHouse. Use when: (1) Displaying stock levels on product pages (2) Understanding warehouse configuration (3) Debugging stock display issues (showing 0 when shouldn't) (4) Working with "In Stock" / "Out of Stock" badges (5) Implementing stock-based filtering (6) Understanding stock sync architecture (webhooks, cron, manual) (7) Understanding the difference between list and detail page stock

majiayu000 Bundle

Query Danish real estate data from Boliga.dk as pandas DataFrames. Use when the user asks about Danish property prices, real estate searches, market statistics, or housing analysis in Denmark.

majiayu000 Bundle

Export RFP data, evaluations, and pursuits in CSV and other formats. Use when implementing data export features, building reports, or extracting data for analysis.

majiayu000 Bundle

Parse and analyze CSV files with data validation

majiayu000 Bundle

Convert a CSV or Excel FF&E product list to SIF (Standard Interchange Format) for dealer and procurement systems.

majiayu000 Bundle

Plan Linear cycles using velocity analytics. Suggests scope based on historical capacity, identifies dependency risks, balances workload.

majiayu000 Bundle

Google Docs/Sheets management via ACSet condensation. Transforms documents into GF(3)-typed Interactions, tracks comments/cells, detects saturation when all comments resolved. Use for document workflows, spreadsheet automation, or applying ANIMA principles to Workspace documents.

majiayu000 Bundle

Layer 4: IES Interactome Analytics with GF(3) Momentum Tracking

majiayu000 Bundle

积木报表生成器 — 自然语言描述报表需求或提供截图，自动生成积木报表（支持数据报表、打印报表、分组报表、循环报表、数据填报等全类型）。Use when user says "积木报表", "jmreport", "Excel报表", "数据填报", "可视化报表", "打印报表", "分组报表", "循环报表", "按照截图生成报表", "创建积木报表", "做一个可视化报表", "积木设计器", "create jimureport", "visual report". Also triggers when user describes report requirements involving Excel-like layouts, data binding with

majiayu000 Bundle

Type-safe SQL query building with Kysely in LivestockAI

majiayu000 Bundle

Generate comprehensive lab member rosters in both markdown and CSV formats. Analyzes member profiles, git history, and alumni information to create detailed rosters with role transitions, team assignments, and career tracking. Use when user mentions roster, team list, lab members, or updating member information.

majiayu000 Bundle

Prisma/SQL 마이그레이션 관리. Use when: (1) 스키마 변경, (2) 마이그레이션 생성/적용, (3) DB 동기화, (4) 마이그레이션 상태 확인, (5) 롤백 필요 시.

majiayu000 Bundle

Design and build database schemas and data models in MotherDuck. Produces a file-based project scaffold. Use when creating tables, choosing data types, defining relationships, or restructuring data for analytics workloads.

majiayu000 Bundle

Oracle DBA and DevOps expertise for Autonomous Database (ADB) on OCI. This skill should be used when managing Oracle Autonomous Databases, writing optimized SQL/PLSQL, configuring security (TDE, Database Vault, Data Safe), implementing HA/DR (Data Guard, PITR), using OCI CLI for database operations, or integrating with Oracle MCP servers for AI-assisted database management. Covers Oracle Database versions 19c, 21c, 23ai, and 26ai.

majiayu000 Bundle

Convert a SIF (Standard Interchange Format) file to a clean, readable CSV or Google Sheet.

majiayu000 Bundle

Database expert - query optimization, schema design

majiayu000 Bundle

Query production PostgreSQL database with read-only credentials. Use for investigating data, debugging issues, or analyzing application state.

majiayu000 Bundle

Database Architect skill. Use this when you need to modify the database schema, add tables, or seed data. This project uses RAW SQL SCRIPTS orchestrated by .NET Aspire, NOT Entity Framework Migrations.

majiayu000 Bundle

Google Suite via uni CLI. Use when user mentions: calendar, events, schedule, meetings, Gmail, email, Drive, files, Sheets, spreadsheet, Docs, documents, Slides, presentations, Forms, surveys, Meet, video call, Tasks, todos, Contacts. Trigger words: calendar, gcal, gmail, email, drive, sheets, docs, slides, forms, meet, tasks, contacts, google. Services: gcal, gmail, gdrive, gsheets, gdocs, gslides, gforms, gmeet, gtasks, gcontacts.

majiayu000 Bundle

Use when solving spreadsheet workbook problems with the `univer` or `unv` CLI as a terminal-native spreadsheet engine: Excel-compatible `.xlsx` handoff, `.univer` or `.unv` packages, workbook inspection, range search, formulas, formatting, charts, shapes, floating images, rich spreadsheet edits, live preview and viewer review comments, versioning, shell-native `pipe out`/`pipe in` roundtrips, or bounded `run` scripts.

majiayu000 Bundle

Expert in automating Excel workflows using Node.js (ExcelJS, SheetJS) and Python (pandas, openpyxl).