Data Analyst MCP Pack (2025) — Mixpanel, PostHog, Snowflake: Ask Better Questions, Faster

• By RouterMCP Team

A Data Analyst pack that pulls cohorts and funnels from product analytics and joins them with warehouse queries via MCP.

Dashboard showing cohort + funnel + SQL query results combined.

Data Analyst MCP Pack (2025) — Mixpanel, PostHog, Snowflake: Ask Better Questions, Faster

TL;DR: Pull a cohort from Mixpanel, fetch a funnel from PostHog, then query Snowflake for revenue joins — all in one conversation.

Servers

  • Mixpanel MCP. https://github.com/rammyblog/mcp-server-mixpanel
  • PostHog MCP. https://github.com/rammyblog/mcp-server-posthog
  • Snowflake MCP (Labs/SQL). https://github.com/Snowflake-Labs/sfguide-building-snowflake-mcp-server

Workflow

  1. “What’s the 30‑day retention for cohort X?” → Mixpanel.
  2. “Show funnel for signup→activate last 7 days” → PostHog.
  3. “Join with revenue events in Snowflake” → SQL query.
  4. Save a Lightdash chart (optional) and attach to the PM’s Notion doc.

Internal links

  • Pack docs: /packs/data-analyst
  • Related posts: Benchmarking (07), Observability (10)

FAQ Q: Can I parameterize sensitive queries?
A: Yes — restrict schemas/tables per project and require review for new queries.

Schema

Checklist (fast)

  1. One intent. 2) Title/meta. 3) Slug. 4) TL;DR. 5) Case flow. 6) FAQ. 7) Links. 8) Images/alt. 9) Edit. 10) CTA.

CTA

  • Use the template: examples/packs/data-analyst.mcp.json and cohort/funnel query templates.