Analyze Mixpanel analytics data using the mixpanel_data Python library or mp CLI. Use when working with Mixpanel event data, user profiles, funnels, retention, cohorts, segmentation queries, JQL scripts, or SQL analysis on local DuckDB. Triggers on mentions of Mixpanel, event analytics, funnel analysis, retention curves, user behavior tracking, JQL queries, filter expressions, 'fetch data from Mixpanel', 'query Mixpanel with SQL', 'run DuckDB queries on events', 'analyze user behavior', 'export Mixpanel data', 'mp command', or requests to work with analytics pipelines. Supports filter expressions for WHERE/ON clauses, JQL (JavaScript Query Language) for complex transformations, Python scripts with pandas integration, and CLI pipelines with jq/Unix tools.
View on GitHubjaredmcfarland/mixpanel_data
mixpanel-data
January 23, 2026
Select agents to install to:
npx add-skill https://github.com/jaredmcfarland/mixpanel_data/blob/main/mixpanel-plugin/skills/mixpanel-data/SKILL.md -a claude-code --skill mixpanel-dataInstallation paths:
.claude/skills/mixpanel-data/# Mixpanel Data Analysis
Fetch Mixpanel data once into local DuckDB, then query repeatedly with SQL—preserving context for reasoning rather than consuming it with raw API responses.
## Documentation Access
Full documentation is hosted at **https://jaredmcfarland.github.io/mixpanel_data/** with LLM-optimized access:
| Resource | URL | Use Case |
|----------|-----|----------|
| **llms.txt** | `https://jaredmcfarland.github.io/mixpanel_data/llms.txt` | Index of all docs with descriptions |
| **llms-full.txt** | `https://jaredmcfarland.github.io/mixpanel_data/llms-full.txt` | Complete documentation (~400KB) |
| **Individual pages** | `https://jaredmcfarland.github.io/mixpanel_data/{path}/index.md` | Specific topic deep-dive |
### When to Fetch Documentation
- **Use this skill** for quick patterns, common examples, and API summaries
- **Fetch llms.txt** to discover what documentation exists
- **Fetch llms-full.txt** when you need comprehensive reference (API signatures, all parameters, edge cases)
- **Fetch individual .md** for focused deep-dives (e.g., `/api/workspace/index.md` for Workspace class details)
### Documentation Structure
| Path | Content |
|------|---------|
| `/getting-started/installation/index.md` | Installation options |
| `/getting-started/quickstart/index.md` | 5-minute tutorial |
| `/getting-started/configuration/index.md` | Credentials and config |
| `/guide/fetching/index.md` | Fetching events/profiles |
| `/guide/streaming/index.md` | Streaming without storage |
| `/guide/sql-queries/index.md` | DuckDB SQL patterns |
| `/guide/live-analytics/index.md` | Segmentation, funnels, retention |
| `/guide/discovery/index.md` | Schema exploration |
| `/api/workspace/index.md` | Workspace class reference |
| `/api/auth/index.md` | Authentication module |
| `/api/exceptions/index.md` | Exception hierarchy |
| `/api/types/index.md` | Result types |
| `/cli/commands/index.md` | CLI command reference |
## Reference Files Guide
When you need detailed i