Data & Analytics

majiayu000 Bundle

Use when the user needs to interact with X (Twitter) — searching tweets, looking up users/followers, posting tweets/replies, liking, retweeting, following/unfollowing, sending DMs, downloading media, monitoring accounts in real time, or extracting bulk data. Provides 122 REST API endpoints, 2 MCP tools, and HMAC webhooks. Use even if the user says 'Twitter' instead of 'X', or asks about social media automation, tweet analytics, or follower analysis.

majiayu000 Bundle

Use when the user needs to interact with X (Twitter) — searching tweets, looking up users/followers, posting tweets/replies, liking, retweeting, following/unfollowing, sending DMs, downloading media, monitoring accounts in real time, or extracting bulk data. Provides 111 REST API endpoints, 2 MCP tools, and HMAC webhooks. Use even if the user says 'Twitter' instead of 'X', or asks about social media automation, tweet analytics, or follower analysis.

majiayu000 Bundle

Enforce Elixir/Phoenix security — auth, OAuth, sessions, CSRF, XSS, SQL injection, input validation, secrets. Use when editing auth files, login flows, RBAC, or API keys.

majiayu000 Bundle

Data-driven business analysis with modern analytics, BI tools, and strategic insights. Use when analyzing business data, creating dashboards, running experiments, or generating data-driven recommendations.

majiayu000 Bundle

Guide for optimizing SQL queries with EXPLAIN ANALYZE, index tuning, N+1 detection, covering indexes, and query plan analysis. Use when the user has slow database queries, asks about query performance, needs to interpret EXPLAIN output, or wants to eliminate N+1 queries. Trigger whenever query performance, slow queries, or database optimization is discussed.

majiayu000 Bundle

Use when the user needs to interact with X (Twitter) - searching tweets, looking up users/followers, posting tweets/replies, liking, retweeting, following/unfollowing, sending DMs, downloading media, monitoring accounts in real time, or extracting bulk data. Provides 111 REST API endpoints, 2 MCP tools, and HMAC webhooks. The skill authenticates only with a Xquik API key (xq_...) and NEVER asks for, transmits, stores, or logs X account passwords, TOTP secrets, session cookies, or any login credentials - X account connection is done by the user in the Xquik dashboard. Use even if the user says 'Twitter' instead of 'X', or asks about social media automation, tweet analytics, or follower analysis.

majiayu000 Bundle

Use when the user needs to interact with X (Twitter) - searching tweets, looking up users/followers, posting tweets/replies, liking, retweeting, following/unfollowing, sending DMs, downloading media, monitoring accounts in real time, or extracting bulk data. Provides 111 REST API endpoints, 2 MCP tools, and HMAC webhooks. The skill authenticates only with a Xquik API key (xq_...) and NEVER asks for, transmits, stores, or logs any X account login material - X account connection is done by the user in the Xquik dashboard. Use even if the user says 'Twitter' instead of 'X', or asks about social media automation, tweet analytics, or follower analysis.

majiayu000 Bundle

Use when the user needs to interact with X (Twitter) - searching tweets, looking up users/followers, posting tweets/replies, liking, retweeting, following/unfollowing, sending DMs, downloading media, monitoring accounts in real time, or extracting bulk data. Provides 111 REST API endpoints, 2 MCP tools, and HMAC webhooks. The skill authenticates only with a Xquik API key (xq_...) and NEVER asks for, transmits, stores, or logs any X account login material - X account connection is done by the user in the Xquik dashboard. Use even if the user says 'Twitter' instead of 'X', or asks about social media automation, tweet analytics, or follower analysis.

majiayu000 Bundle

Use when the user needs to interact with X (Twitter) - searching tweets, looking up users/followers, posting tweets/replies, liking, retweeting, following/unfollowing, removing followers, sending DMs, downloading media, monitoring accounts in real time, or extracting bulk data. Provides 112 REST API endpoints, 2 MCP tools, and HMAC webhooks. The skill authenticates only with a Xquik API key (xq_...) and NEVER asks for, transmits, stores, or logs any X account login material - X account connection is done by the user in the Xquik dashboard. Use even if the user says 'Twitter' instead of 'X', or asks about social media automation, tweet analytics, or follower analysis.

majiayu000 Bundle

Use when the user needs to interact with X (Twitter) - searching tweets, looking up users/followers, posting tweets/replies, liking, retweeting, following/unfollowing, removing followers, sending DMs, downloading media, monitoring accounts in real time, or extracting bulk data. Provides 113 REST API endpoints, 2 MCP tools, and HMAC webhooks. The skill authenticates only with a Xquik API key (xq_...) and NEVER asks for, transmits, stores, or logs any X account login material - X account connection is done by the user in the Xquik dashboard. Use even if the user says 'Twitter' instead of 'X', or asks about social media automation, tweet analytics, or follower analysis.

majiayu000 Bundle

This skill should be used when the user asks to "create a PR", "open a pull request", "ship it", "submit for review", "push and create PR", or wants to finalize changes into a pull request with Linear integration, Copilot review, and Slack notification.

majiayu000 Bundle

Use this skill when performing exploratory data analysis, statistical testing, data visualization, or building predictive models. Triggers on EDA, pandas, matplotlib, seaborn, hypothesis testing, A/B test analysis, correlation, regression, feature engineering, and any task requiring data analysis or statistical inference.

majiayu000 Bundle

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.

majiayu000 Bundle

AI-assisted pair programming with multiple modes (driver/navigator/switch), real-time verification, quality monitoring, and comprehensive testing. Supports TDD, debugging, refactoring, and learning sessions. Features automatic role switching, continuous code review, security scanning, and performance optimization with truth-score verification.

majiayu000 Bundle

Hybrid team skill for issue resolution. CSV wave primary for exploration, planning, integration, and implementation. Interactive agents for review gates with fix cycles. Supports Quick, Full, and Batch pipelines.

majiayu000 Bundle

Enforce Elixir/Phoenix security — auth, OAuth, sessions, CSRF, XSS, SQL injection, input validation, secrets. Use when editing auth files, login flows, RBAC, or API keys.

majiayu000 Bundle

Structure a cohort analysis for retention, LTV, or behavioural patterns. Use when asked to run a cohort analysis, analyse retention by cohort, segment users by behaviour over time, or calculate lifetime value by acquisition period. Produces a complete cohort analysis framework with methodology, cohort definitions, retention curves, and prioritised interventions.

majiayu000 Bundle

Database design patterns, SQL best practices, ORM usage (Prisma/Drizzle), and migration strategies. Use when designing schemas, writing queries, or optimizing database operations.

majiayu000 Bundle

Database schema design patterns for SQL and NoSQL databases

majiayu000 Bundle

SPARC (Specification, Pseudocode, Architecture, Refinement, Completion) comprehensive development methodology with multi-agent orchestration

majiayu000 Bundle

CLI automation for Supabase development workflows. Provides scripts for migrations, Edge Functions, secrets management, type generation, and SQL execution with safety checks.

majiayu000 Bundle

Use when implementing input validation and output encoding to prevent injection attacks. Covers validation strategies, context-specific output encoding, parameterized queries, and defense-in-depth approaches across all languages and frameworks. USE FOR: input validation, output encoding, XSS prevention, SQL injection prevention, command injection prevention, parameterized queries, sanitization, allowlisting, content security policy DO NOT USE FOR: authentication validation (use authentication), API rate limiting (use api-security), cryptographic validation (use cryptography)

majiayu000 Bundle

Data exploration and analysis partner for Product Managers. Use when the user needs to query databases, analyze metrics, create dashboards, or extract insights from data. Triggers include "query", "analyze data", "metrics", "BigQuery", "SQL", "dashboard", "what does the data say", or when working with quantitative information.

majiayu000 Bundle

Automatically applies when optimizing database queries. Ensures EXPLAIN analysis, proper indexing, N+1 prevention, query performance monitoring, and efficient SQL patterns.

majiayu000 Bundle

Technical stack overview for stock_picker_bot. Python 3.13, FastAPI, SQLAlchemy with Alembic, aiosqlite, pandas, numpy, yfinance, pytest, Ruff, httpx, and LLM APIs.

majiayu000 Bundle

AGGRESSIVELY use TOON v2.0 format for biggish regular data (≥5 items, ≥60% uniform). Auto-applies to tables, logs, events, transactions, analytics, API responses, database results. Supports 3 array types (inline, tabular, expanded), 3 delimiters (comma, tab, pipe), key folding for nested objects. Triggers on structured data, arrays, repeated patterns. Use TOON by default when tokens matter - RAG pipelines, tool calls, agents, benchmarks. Keywords "data", "array", "list", "table", "log", "transaction", "metric", "analytics", "API", "database", "query", "TOON".

majiayu000 Bundle

Meta-skill for generating team skills. Analyzes requirements, scaffolds directory structure, generates role definitions and specs, validates completeness. Produces complete Codex team skill packages with SKILL.md orchestrator, CSV schemas, agent instructions, and interactive agents.

majiayu000 Bundle

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database...

majiayu000 Bundle

Umbrella skill for document workflows (PDF/DOCX/XLSX/PPTX). Dispatches to the most specific document skill to reduce noise and improve routing precision.

majiayu000 Bundle

WordPress plugin development with hooks, security, REST API, custom post types. Use for plugin creation, $wpdb queries, Settings API, or encountering SQL injection, XSS, CSRF, nonce errors.

majiayu000 Bundle

Analytics engineering for reliable metrics and BI readiness. Build transformation layers, dimensional models, semantic metrics, data quality tests, and documentation. Use when you need dbt or SQL transformation strategy, metrics definition, or analytics data modeling.

majiayu000 Bundle

Drizzle ORM schema management and SQLite migrations — adding tables, modifying columns, creating indexes, generating and running migrations, Drizzle query patterns. NOT for Prisma, TypeORM, Sequelize, or raw SQL migration tools.

majiayu000 Bundle

Expert guidance on creating Content Elements, Record Types, and Page Types using TYPO3 Content Blocks extension - the single source of truth for content modeling. Includes bidirectional migration between classic TCA/SQL and Content Blocks.

knownasnaffy Bundle

基于东方财富专业数据库，支持自然语言查询金融数据，覆盖A股、ETF、债券、港美股、基金等全品类资产，含实时行情、公司信息、估值、财务报表等，数据实时、权威、全面，可用于投资研究、交易复盘、行业分析、信用研究、财报审计、资产配置、报告撰写等场景，一站式满足机构与个人投资分析、市场监控、数据检索等需求。返回结果包含数据说明及 xlsx 文件。

knownasnaffy Bundle

Perform bank reconciliation between bank statements and general ledger files. Supports bank statement PDF ingestion, conversion of PDF statements into structured Excel data, custom amount thresholds, ID/key matching, and semantic description matching. Use when the user wants to read a bank statement PDF or Excel file, convert statement activity into a workbook, reconcile bank activity to GL transactions, identify matched and unmatched items, and generate an Excel workbook with reconciliation results, a summary tab, and separate unreconciled-bank and unreconciled-GL tabs.

knownasnaffy Bundle

Perform bank reconciliation between bank statements and general ledger files. Supports bank statement PDF ingestion, conversion of PDF statements into structured Excel data, custom amount thresholds, ID/key matching, and semantic description matching. Use when the user wants to read a bank statement PDF or Excel file, convert statement activity into a workbook, reconcile bank activity to GL transactions, identify matched and unmatched items, and generate an Excel workbook with reconciliation results, a summary tab, and separate unreconciled-bank and unreconciled-GL tabs.