skills.rest
jaredmcfarland
jaredmcfarlandOFFICIAL
Explore all skills by this author →
GitHub

mixpanel-data

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
One-click install
npx skills add https://github.com/jaredmcfarland/mixpanel_data --skill mixpanel-data
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
Amar1404Amar1404
1

connect-data

Connect to CSV, DuckDB, PostgreSQL, BigQuery, Snowflake, Athena, and ClickHouse data sources.

Community
Intermediate
crossxwillcrossxwill
5

duckdb-parquet-lab-workflow

Query Parquet data with DuckDB and convert results to pandas DataFrames.

Community
Intermediate
DatTran26DatTran26

ck:pdf

Extract text and tables, merge, split, and fill PDF forms.

Community
Intermediate
nrminornrminor

duckdb

Query Parquet, CSV, and JSON files in place with DuckDB SQL.

Community
Intermediate