全部能力

Exécute des requêtes SQL en lecture seule sur plusieurs bases de données PostgreSQL. À utiliser pour : (1) interroger des bases PostgreSQL, (2) explorer les…

Identify content gaps between your site and competitors. Use when the user says "content gaps", "what am I missing", "competitor content", "content…

Expert analytics engineering covering data modeling, dbt development, data transformation, and semantic layer management. Use when building dbt models, designing star schemas, writing staging or mart SQL, configuring data tests, defining semantic-layer metrics, or optimizing warehouse query performance.

Validate and sanitize user input to prevent XSS, injection attacks, and ensure data quality. Use this skill when you need to validate forms, sanitize user…

Use this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables. **Trigger when user asks to:** - Analyze database tables for hypertable conversion potential - Identify time-series or event tables in an existing schema - Evaluate if a table would benefit from Timescale/TimescaleDB - Audit PostgreSQL tables for migration to Timescale/TimescaleDB/TigerData - Score or rank tables for hypertable candidacy **Keywords:** hypertable candidate, table analysis, migration assessment, Timescale, TimescaleDB, time-series detection, insert-heavy tables, event logs, audit tables Provides SQL queries to analyze table statistics, index patterns, and query patterns. Includes scoring criteria (8+ points = good candidate) and pattern recognition for IoT, events, transactions, and sequential data.

Analyze datasets with a decision-first workflow. Use when the user needs to inspect CSV/JSON/Parquet/SQL extracts, validate data quality, explain trends, compare segments, summarize experiment or telemetry results, or turn raw tables into evidence-backed findings — even if they ask in domain language like KPI, retention, funnel, cohort, revenue, campaign, export, dashboard data, or game telemetry. Choose the right lane (spreadsheet-scale triage, SQL slicing, notebook/statistical analysis, or stakeholder-ready summary) and hand off cleanly to dashboard, anomaly-detection, or implementation skills when needed.

Use when generating or regenerating Drizzle migration files, changing database schema tables or columns, resolving migration sequence conflicts after rebase,…

PostHog event tracking standards for Supabase Studio. Use when reviewing

Detects and redacts Personally Identifiable Information (PII) like emails, phone numbers, and credit cards. Use when cleaning logs, datasets, or communications…

Transform raw data from CSVs, Google Sheets, or databases into executive-ready reports with visualizations, key metrics, trend analysis, and actionable…

Expert-level Looker BI, LookML, explores, dimensions, measures, dashboards, and data modeling

SQL optimization for OLTP systems: EXPLAIN analysis, indexing, schema design, migrations, HA, and security across major SQL platforms.

Route BigQuery-backed Looker Studio work into one stakeholder-reporting packet: dashboard-spec, slow-dashboard triage, refresh-shape choice, audience split, or exec-handoff. Use when the user needs KPI boards, PM/ops reviews, marketing / GTM reporting, product funnel summaries, or game/live-ops telemetry dashboards on top of curated BigQuery data. Route KPI explanation to `data-analysis`, repeated anomaly hunting to `pattern-detection`, telemetry/alerting coverage to `monitoring-observability`, and semantic-platform choice to `survey`.

Generate professional markdown and HTML reports from data with charts, tables, and analysis.

Drizzle ORM schema management and SQLite migrations — adding tables, modifying columns, creating indexes, generating and running migrations, Drizzle query…

Expert guide for Drizzle ORM best practices, including schema definitions, queries, mutations, transactions, migrations, and performance optimization. Use when…

Query the public REST APIs that power dashboard.internetcomputer.org. Covers canister metadata, ICRC ledger data, SNS data, ICP ledger, and network metrics…

Advanced SQLModel patterns and comprehensive database migrations with Alembic. Use when creating SQLModel models, defining relationships (one-to-many,…

按统一规则记录交易流水。按个股落 Markdown，同时写入 SQLite 便于统计与量化复盘。

Expert product analytics strategist for SaaS and digital products. Use when designing product metrics frameworks, funnel analysis, cohort retention, feature…