mixpanel-data

Name: mixpanel-data
Availability: InStock
Author: jaredmcfarland

Fetch Mixpanel events and profiles into a local DuckDB store for SQL analytics.

14|4|Updated Dec 20, 2025

Search Tags:#analytics #data #sql #jql #duckdb #mixpanel

Ready to run

npx skills add https://github.com/jaredmcfarland/mixpanel_data --skill mixpanel-data

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: mixpanel-data
Source: https://github.com/jaredmcfarland/mixpanel_data/tree/main/mixpanel-plugin/skills/mixpanel-data
Command: npx skills add https://github.com/jaredmcfarland/mixpanel_data --skill mixpanel-data

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Fetching and analyzing Mixpanel data can be complex and error-prone; this skill provides a cohesive way to fetch data into a local DuckDB-enabled workspace and analyze it with Python, SQL, or JQL.

Core Features & Use Cases

Local data import: fetch events and profiles into a local store for repeatable analysis.
Flexible analytics: run SQL queries, JQL scripts, or Python dataframes against a persistent local dataset.
CLI and Python workflows: automate discovery, fetch, and analysis with mp CLI or the mixpanel_data library.

Quick Start

Fetch a month's events into a local table named events, then run a DuckDB query to summarize counts by event.

Frequently Asked Questions about mixpanel-data

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I run SQL queries on Mixpanel events locally?▼

You can run SQL queries on Mixpanel events locally by fetching events into a local DuckDB store using the provided Python library or CLI, then querying the persistent local dataset directly.

Can I execute JQL scripts and stream Mixpanel data using Python?▼

Yes, you can execute JQL scripts and streaming pipelines against Mixpanel data using the Python library to apply robust filtering expressions and handle JSON properties directly in your workflows.

What is the best way to analyze Mixpanel profiles without repeated API calls?▼

The best way to analyze Mixpanel profiles without repeated API calls is to import them into a local persistent store, allowing you to run repeatable Python dataframes or SQL analytics offline.

Does the Mixpanel data skill support parallel fetching and discovery workflows?▼

Yes, the skill supports optional parallelization for data fetching and provides an API surface for discovery, allowing you to automate finding and importing Mixpanel events and profiles efficiently.

How do I handle complex filtering and JSON properties when fetching Mixpanel data?▼

Handle complex filtering and JSON properties when fetching Mixpanel data by using the skill's robust filtering expressions and built-in JSON property handling within the Python library or CLI workflows.