Suggesting Data Imports
技能 活跃Use when the user asks about revenue, payments, subscriptions, billing, CRM deals, support tickets, production database tables, or other data that PostHog does not collect natively. Also use when a query fails because a table does not exist or returns no results for expected external data. The data warehouse can import from SaaS tools (Stripe, Hubspot, etc.), production databases (Postgres, MySQL, BigQuery, Snowflake), and other arbitrary data sources. Covers checking existing sources, identifying the right source type, and guiding the setup.
To help users understand and overcome data gaps by guiding them to import necessary external data into PostHog for comprehensive analysis.
功能
- Identify missing external data needs
- Check existing data warehouse connections
- Guide selection of appropriate data source types
- Facilitate data correlation between PostHog events and external business data
使用场景
- When a HogQL query fails due to a missing table.
- When a user asks to analyze revenue, CRM deals, or support tickets alongside product analytics.
- When a user needs to correlate external business data with user behavior tracked in PostHog.
- When a user asks 'how do I get my X data into PostHog?'
非目标
- Performing the actual setup of data warehouse sources.
- Collecting external business data natively within PostHog.
- Writing complex SQL queries beyond basic demonstration joins.
Trust
- warning:Issues AttentionOpen issues (544) far exceed closed issues (163) in the last 90 days, indicating slow maintainer response times.
Practical Utility
- info:Usage examplesWhile the skill outlines how to suggest imports and use related tools, explicit end-to-end examples demonstrating the full user journey and observable outcomes are not present within the SKILL.md.
安装
npx skills add PostHog/posthog通过 npx 运行 Vercel skills CLI(skills.sh)— 需要本地安装 Node.js,以及至少一个兼容 skills 的智能体(Claude Code、Cursor、Codex 等)。前提是仓库遵循 agentskills.io 格式。
质量评分
类似扩展
Tuning Incremental Sync Config
99Change the sync configuration of an existing data warehouse schema — switch sync_type, pick a different incremental_field, set primary_key_columns, choose cdc_table_mode, or change sync_frequency. Use when the user asks "switch my orders table from full refresh to incremental", "this table is syncing too slowly / too frequently", "I need to pick a different incremental column", "set up CDC for this Postgres table", or when diagnosis of a failing sync pointed to an incremental-field or PK misconfiguration.
Implementing Warehouse Sources
87Implement and extend PostHog Data warehouse import sources. Use when adding a new source under posthog/temporal/data_imports/sources, adding datasets/endpoints to an existing source, or adding incremental sync, resumable imports, webhook ingestion, pagination, credentials validation, and source tests.
Lifecycle Progression Workflow
100Build workflows to automate contact progression through the sales funnel: Lead to MQL to SQL to Opportunity to Customer. Each transition is triggered by a specific event (score threshold, meeting booked, deal created, deal won).
Cleanup Dashboards
100Audit and consolidate HubSpot reporting dashboards. Identifies unused, duplicate, or outdated dashboards. Must be performed manually — no dashboard API is available.
Salesforce Developer
100Writes and debugs Apex code, builds Lightning Web Components, optimizes SOQL queries, implements triggers, batch jobs, platform events, and integrations on the Salesforce platform. Use when developing Salesforce applications, customizing CRM workflows, managing governor limits, bulk processing, or setting up Salesforce DX and CI/CD pipelines.
Migrate Validate
100Validate pending migrations for foreign key consistency, rollback safety, and best practices