Data & Analytics

majiayu000 Bundle

Optimize slow queries, analyze SQL performance, and collect evidence for expensive workloads.

majiayu000 Bundle

Test automate security vulnerability testing covering OWASP Top 10, SQL injection, XSS, CSRF, and authentication issues. Use when performing security assessments, penetration tests, or vulnerability scans. Trigger with phrases like "scan for vulnerabilities", "test security", or "run penetration test".

majiayu000 Bundle

Validation for XIRR and fee calculations. Use when working on server/analytics/xirr.ts, server/analytics/fees.ts, or their truth cases.

majiayu000 Bundle

Polars fast DataFrame library. Use for fast data processing.

majiayu000 Bundle

Consult PostgreSQL's parser and grammar (gram.y) to understand SQL syntax, DDL statement structure, and parsing rules when implementing pgschema features

majiayu000 Bundle

Python SQL toolkit and ORM for defining schemas and issuing SQL/ORM queries with explicit transaction control.

majiayu000 Bundle

WordPress security best practices and vulnerability prevention patterns. Use when reviewing WordPress code for security issues, writing secure WordPress code, or checking for common vulnerabilities like SQL injection, XSS, CSRF, and authentication issues.

majiayu000 Bundle

Use when you need framework-agnostic SQL guidance — schema naming, relational table design, query readability, indexes, transactions, database security, migrations, testing, and monitoring — without choosing Spring Boot, Quarkus, or Micronaut. This should trigger for requests such as Review SQL schema or migrations; Improve SQL query performance and readability; Design relational tables and indexes; Review database transaction, security, or monitoring practices. Part of cursor-rules-java project

majiayu000 Bundle

Comprehensive ColdFusion (CFML) syntax validation and best practices verification. Use when validating ColdFusion code, checking for security vulnerabilities (SQL injection, proper cfqueryparam usage), ensuring proper variable scoping, verifying code quality standards, or reviewing ColdFusion applications for senior developer best practices.

majiayu000 Bundle

Migrate raw kubernetes_ingress_v1 resources to the centralized ingress_factory module. Use when: (1) a service defines a raw kubernetes_ingress_v1 with hand-rolled Traefik middleware annotations, (2) adding a new service that needs standard ingress with rate limiting, CrowdSec, CSP headers, rybbit analytics, or authentik auth, (3) refactoring existing ingresses for consistency. Covers single-path, multi-path, split UI/API, full_host overrides, custom rate limits, and extra middleware injection.

majiayu000 Bundle

Emit Postgres.sql and SQLite.sql from a single schema spec so tools work across both drivers without duplicating DDL by hand. Use when designing a schema that needs to support both shared Postgres deployments and zero-config SQLite. Reduces two-file sync burden to a single source edit.

majiayu000 Bundle

Integrate PostHog for product analytics, feature flags, and session replay. Use when setting up the SDK, configuring feature flags, tracking events, or identifying users across sessions.

majiayu000 Bundle

Use when integrating PostHog for product analytics, feature flags, and session replay. Covers SDK setup, feature flag patterns, event tracking conventions, Doppler credential management, and both greenfield and brownfield integration approaches.

majiayu000 Bundle

Use when implementing translations/i18n in Frappe v14-v16 apps. Covers _() in Python, __() in JavaScript, CSV translation files, bench commands, string extraction rules, lazy translation _lt(), PO/MO files [v15+], RTL support, and custom app translations. Prevents common mistakes with f-strings, concatenation, and template literals that break string extraction. Keywords: translation, i18n, _(), __(), _lt(), CSV, PO, gettext, bench get-untranslated, RTL, localization.

majiayu000 Bundle

Pull the people who liked or commented on any LinkedIn post and segment them by ICP fit (peer / aspirational / prospect / other). Produces an engager roster, tier breakdown, and outbound action lists (follow back, comment-drop, DM-able with one-line openers). Powered by Apify, no LinkedIn login. Triggers on "who liked my post", "who engaged", "engagers report", "audience analytics". Not for tracking author replies to your comments (use linkedin-thread-monitor).

majiayu000 Bundle

Operational expert tools — used by domain specialists for hours every day — require a different design approach than consumer or occasional-use software. Information density, workflow linearity, and at-a-glance status take priority over whitespace and discoverability. Use when designing dispatch tools, warehouse management, logistics, scheduling, or any B2B tool whose primary users are trained specialists.

majiayu000 Bundle

Creates short employee pulse surveys (5–15 questions) and eNPS surveys. Pulse themes include morale, manager trust, workload, remote/hybrid, DEI, onboarding, change management, team cohesion, leadership communication, psychological safety, learning & development, and all-hands/event feedback. Use this skill when asked to run a pulse check, create a quick employee sentiment survey, check in on how the team is feeling, run an eNPS, measure employee net promoter score, or build an HR survey on a specific topic. Works for open-ended requests ("create a pulse survey", "run an eNPS") and goal-directed briefs ("check morale after the reorg", "how do people feel about the new leadership?"). Creates surveys directly in FeedbackPulse via MCP tool when available, or produces a CSV ready to import into FeedbackPulse (Surveys → Templates → Import Questions) or other survey tools.

majiayu000 Bundle

Checks hardcoded secrets, SQL injection, XSS, insecure deps, input validation. Use when auditing security.

majiayu000 Bundle

Generate a `@DataJpaTest` slice test for a JPA persistence adapter using H2 in-memory database and `TestEntityManager`. Use when the user asks to "write tests for a persistence adapter", "generate JPA tests", or "test the repository adapter". Covers all CRUD operations; uses `@Sql` fixtures for read/delete tests; calls `flush()` and `clear()` after writes to bypass the JPA cache; asserts with `usingRecursiveComparison()`.

majiayu000 Bundle

Update data-cleaning-implementation skill with critical pandas patterns and testing learnings from vp-e62a

majiayu000 Bundle

Design schemas, write queries for MongoDB and PostgreSQL. Use for database design, SQL/NoSQL queries, aggregation pipelines, indexes, migrations, replication, performance optimization, psql CLI.

majiayu000 Bundle

Troubleshoot and optimize pandas performance in Microsoft Fabric Spark notebooks. Use when diagnosing slow pandas operations, toPandas() out-of-memory errors, pandas API on Spark (pyspark.pandas) bottlenecks, DataFrame conversion failures, collect() memory issues, driver memory exhaustion, notebook cell timeouts, or when optimizing pandas workloads for Fabric capacity. Covers pandas vs Spark DataFrame conversion, memory profiling, broadcast joins, shuffle tuning, resource profiles, and Native Execution Engine integration.

majiayu000 Bundle

Generate SQL validation notebooks for dbt changes. Pass a GitHub PR URL or local dbt repo path.

majiayu000 Bundle

Execute use when you need to work with stored procedure generation. This skill provides stored procedure code generation with comprehensive guidance and automation. Trigger with phrases like "generate stored procedures", "create database functions", or "write SQL procedures".

majiayu000 Bundle

Analyze construction labor productivity using data analytics. Track worker performance, identify inefficiencies, predict resource needs, and optimize crew allocation for maximum efficiency.

majiayu000 Bundle

Expert guidance for designing event tracking systems, implementing analytics SDKs (PostHog, Mixpanel, GA4, Amplitude), creating semantic event taxonomies, validating instrumentation, building dashboards, and interpreting user behavior metrics. Use when setting up product analytics, designing event tracking, analyzing retention/engagement data, or improving analytics infrastructure.

majiayu000 Bundle

Guide to analyze multiple documents (PDF, DOCX) against user-defined columns and produce a structured Excel output with citations. Use when the user wants to: (1) Extract specific information from multiple documents into a table, (2) Compare clauses or provisions across contracts, (3) Create a document review matrix with source citations. Triggers on: 'tabular review', 'document matrix', 'extract from documents', 'compare across documents', 'review multiple contracts'.

majiayu000 Bundle

Automatically detect and prevent common Wheels framework errors before code is generated. This skill activates during ANY Wheels code generation (models, controllers, views, migrations) to validate patterns and prevent known issues. Scans for mixed arguments, query/array confusion, non-existent helpers, and database-specific SQL.

majiayu000 Bundle

Strategic guide for data privacy in Fullstory implementations. Teaches developers how to decide what data to send, mask, exclude, hash, or replace with joinable keys. Covers regulatory compliance (GDPR, HIPAA, PCI, CCPA), privacy-by-design principles, and balancing analytics value with privacy protection. Acts as a decision framework that references core privacy skills.

majiayu000 Bundle

Use this skill when a human needs to review a Deepline Play result and hand feedback, labels, or approval back to the agent for revision, evaluation, comparison, or bounded iteration. Triggers on “put this run in a Sheet,” “review these results,” “read my feedback,” “make this a standing rule,” “never regress on this case,” “compare these runs,” “keep improving,” or “add the revised run to the same spreadsheet.” Skip ordinary Play authoring or execution with no human review loop, generic spreadsheet work, and one-off CSV export.

majiayu000 Bundle

Excel 가져오기 모달의 보일러플레이트를 자동 생성합니다. useExcelImport 훅 기반. 새 가져오기 기능 추가 시 사용.

majiayu000 Bundle

Collect and analyze on-device performance metrics and crash diagnostics using MetricKit. Use when setting up MXMetricManager, handling MXMetricPayload or MXDiagnosticPayload, processing crash/hang/disk-write diagnostics via MXCallStackTree, adding custom signpost metrics, or uploading telemetry to an analytics backend.

majiayu000 Bundle

Execute WASM-based skills mounted to virtual paths. Use this skill when the user requests skill execution such as "Execute the RAG skill", "Run the analytics skill", or "Call the skill at this path".

majiayu000 Bundle

Systematically test authorized targets for SQL, XSS, SSTI, XXE, command, and request-smuggling injection classes.

majiayu000 Bundle

Specialized Python tutoring for HR analytics professionals. Use when working on HR/talent analytics tasks involving turnover, time-to-fill, retention, headcount, recruiting analytics, or other People Analytics metrics. Loads HR-specific patterns and examples.

majiayu000 Bundle

How to read experiment results without fooling yourself. Confidence intervals, p-values, multiple testing, sequential testing, CUPED, heterogeneous treatment effects, ratio metrics, network effects, dashboard reconciliation, and the interpretation failures that produce confidently wrong shipping decisions.