Data & Analytics

majiayu000 Bundle

This skill should be used when users need to work with the DuckDB CLI for querying, analyzing, or transforming data. Use this skill for executing SQL queries, importing/exporting data, configuring DuckDB settings, or performing database operations at the command line.

majiayu000 Bundle

Interact with 80+ websites and desktop apps from the CLI via Chrome session reuse — zero LLM cost, deterministic JSON/YAML/CSV output. Covers Twitter/X, Reddit, YouTube, HN, Instagram, Spotify, Amazon, LinkedIn, and more; also automates browser actions and registers local CLI tools. Triggers on 'opencli', 'CLI for website', 'scrape without API', 'browser automation', 'operate command'.

majiayu000 Bundle

Creates and manages Linear issues for analytics work. Also posts weekly status reports to Slack. Use when someone asks to create an issue, track a task in Linear, link work to Linear, or send a status update.

majiayu000 Bundle

Pre-landing PR review. Analyzes diff against the base branch for SQL safety, LLM trust boundary violations, conditional side effects, and other structural issues. Use when asked to "review this PR", "code review", "pre-landing review", or "check my diff". Proactively suggest when the user is about to merge or land code changes.

majiayu000 Bundle

Create new Claude Code Skills with proper YAML frontmatter, progressive disclosure structure, and complete directory organization. Use when you need to build custom skills for specific workflows, generate skill templates, or understand the Claude Skills specification.

majiayu000 Bundle

Executive-grade data analysis with pandas/polars and McKinsey-quality visualizations. Use when: analyze data, build dashboard, create charts, investor presentation, SaaS metrics, cohort analysis, visualize, pandas, streamlit, executive summary.

majiayu000 Bundle

PostgreSQL migration patterns with RLS, Better Auth integration, and TIMESTAMPTZ. Covers main tables, meta tables, child entities, and sample data. Use this skill when creating migrations, validating SQL, or generating sample data.

majiayu000 Bundle

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for creating new spreadsheets, reading/analyzing data, modifying existing spreadsheets, or recalculating formulas.

majiayu000 Bundle

Advanced analytics and machine learning for data-driven insights. Use when performing statistical analysis, building predictive models, designing experiments, or creating data visualizations.

majiayu000 Bundle

Cohort analysis and retention optimization framework. Identifies retention drivers and churn factors.

majiayu000 Bundle

SQLAlchemy query optimization and data retrieval for stock_picker_bot. Covers efficient querying of historical stock data, portfolio lookups, and stock market analytics.

majiayu000 Bundle

Use this skill when working with PostHog - product analytics, web analytics, feature flags, A/B testing, experiments, session replay, error tracking, surveys, LLM observability, or data warehouse. Triggers on any PostHog-related task including capturing events, identifying users, evaluating feature flags, creating experiments, setting up surveys, tracking errors, and querying analytics data via the PostHog API or SDKs (posthog-js, posthog-node, posthog-python).

majiayu000 Bundle

Nuxt Content v3 Git-based CMS for Markdown/MDC content sites. Use for blogs, docs, content-driven apps with type-safe queries, schema validation (Zod/Valibot), full-text search, navigation utilities. Supports Nuxt Studio production editing, Cloudflare D1/Pages deployment, Vercel deployment, SQL storage, MDC components, content collections.

majiayu000 Bundle

Automated weekly CEO Briefing generation with AI-powered business insights, task analytics, proactive suggestions, and cost tracking. Runs every Sunday at 23:00, analyzes completed tasks from previous week, calculates Claude API costs, generates actionable suggestions via AI, and creates comprehensive briefing in vault/Briefings/. Includes graceful degradation when AI unavailable (data-only mode) and manual trigger for testing. Use when: (1) building executive reporting for autonomous agents, (2) implementing scheduled analytics with AI insights, (3) creating weekly business summaries, (4) tracking API costs and agent activity, (5) generating proactive recommendations from historical data.

majiayu000 Bundle

Write secure, performant database queries using parameterized statements, proper indexing, eager loading, and transaction management to prevent SQL injection and N+1 query problems. Use this skill when writing database queries, constructing SQL statements, using ORM query builders, optimizing database performance, or working with repositories, services, or DAO files that interact with databases. Applies to SELECT, INSERT, UPDATE, DELETE operations, joins, aggregations, and any code that retrieves or manipulates data from databases.

majiayu000 Bundle

Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis.

majiayu000 Bundle

Backend developer for your project. MUST BE USED for building APIs, database schemas, and backend services. Prioritize speed and simplicity over complex architecture. Use when building API endpoints, designing database schemas, implementing business logic, server-side integrations, backend service architecture, or data model implementation. Invoke when user mentions REST API, GraphQL, database models, SQL queries, ORM, migrations, authentication backend, or server architecture.

majiayu000 Bundle

Python后端工程师技能。当需要实现Python后端功能、异步REST API、数据处理管道、AI/ML推理服务或Web爬虫工作流时使用。关键词：Python、FastAPI、Pydantic、SQLAlchemy、asyncpg、Pandas、Polars、Celery、LangChain、Playwright、Scrapy、数据管道、异步、后端开发。

majiayu000 Bundle

Monitors key metrics and sends alerts for revenue, usage, enterprise accounts, backend costs, and API runtime. Routes requests to specialized monitoring sub-agents.

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

Apply security guardrails (authentication, authorization, input validation, SQL/XSS/command injection prevention, secrets management, SSRF protection, secure logging, dependency auditing). Use when adding/changing endpoints, auth flows, data access, file/network I/O, or handling user input and sensitive data. NOT for resilience/fault-tolerance patterns (use resilience); NOT for observability instrumentation (use observability).

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 present...

majiayu000 Bundle

Show GKE cluster health dashboard — nodes, agents, app pods, ingress, certs, analytics. Use when user asks about cluster status, pod health, node count, or infrastructure state.

majiayu000 Bundle

Comprehensive CSV data analysis and visualization tool. Use this skill when analyzing CSV files, generating data summaries, creating visualizations from data, detecting outliers, finding correlations, assessing data quality, or creating data reports. Triggers on CSV analysis, data exploration, data visualization, data profiling, statistical analysis, or data quality assessment requests.

majiayu000 Bundle

Master data engineering, ETL/ELT, data warehousing, SQL optimization, and analytics. Use when building data pipelines, designing data systems, or working with large datasets.

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

SQL query optimization for PostgreSQL/MySQL with indexing, EXPLAIN analysis. Use for slow queries, N+1 problems, missing indexes, or encountering sequential scans, OFFSET pagination, temp table spills, inefficient JOINs.

majiayu000 Bundle

Download YouTube transcripts for videos tracked in a CSV file. Use when you need to download transcripts in bulk with progress tracking, fetching transcripts overnight, processing video libraries, or when the user mentions "get transcripts", "download captions", or "bulk transcript download".

majiayu000 Bundle

Implement comprehensive input validation on server-side with complementary client-side validation for user experience, using allowlists, type checking, and sanitization to prevent injection attacks. Use this skill when validating user inputs, form data, API requests, file uploads, query parameters, or any external data entering the application. Apply this skill when implementing server-side validation as the primary security layer, adding client-side validation for immediate user feedback, validating data types and formats, checking ranges and required fields, sanitizing inputs to prevent SQL injection and XSS attacks, using allowlists over blocklists, providing field-specific error messages, or enforcing business rules at appropriate application layers. This skill ensures validation happens at all entry points consistently, security is never dependent on client-side checks alone, users receive helpful immediate feedback, and data integrity is maintained through multiple layers of validation.

majiayu000 Bundle

Extract text, tables, and images from PDFs. Use when: extracting data from reports; converting PDF tables to CSV; pulling images from presentations; processing research papers; batch converting PDFs to text

majiayu000 Bundle

YouTube: video management, transcript extraction, channel analytics, comments, playlists, upload

majiayu000 Bundle

Run the Python code review protocol on scripts in code/py/. Checks code quality, reproducibility, pandas idioms, figure standards, and output conventions. Produces a report without editing files.

majiayu000 Bundle

Automated coordination, formatting, and learning from Claude Code operations using intelligent hooks with MCP integration. Includes pre/post task hooks, session management, Git integration, memory coordination, and neural pattern training for enhanced development workflows.

majiayu000 Bundle

Design effective dashboards with clear layouts, KPI displays, data grids, and real-time updates. Covers dashboard patterns, information hierarchy, responsive grids, widget design, and admin panel layouts. Use for building analytics dashboards, admin interfaces, and monitoring displays.

majiayu000 Bundle

This skill should be used when analyzing CSV datasets, handling missing values through intelligent imputation, and creating interactive dashboards to visualize data trends. Use this skill for tasks involving data quality assessment, automated missing value detection and filling, statistical analysis, and generating Plotly Dash dashboards for exploratory data analysis.

majiayu000 Bundle

Convert database DDL from any source platform to dbt models compatible with Snowflake. This skill should be used when converting views, tables, or stored procedures from Snowflake, Teradata, Oracle, SQL Server, Redshift, BigQuery, PostgreSQL, DB2, Hive, Vertica, or Sybase to dbt code, generating schema.yml files with tests and documentation, or migrating existing SQL to follow dbt best practices.