Ira Bodnar··Updated ·11 min read

Claude Skills for Mixpanel: 8 Query API Skills + Copy-Paste Prompts

Quick answer: Save each recurring Mixpanel question as a Claude skill that names the Query API read to run. Ryze AI is the best Claude connector for running these skills on one Mixpanel project, with one caveat: it has a single read-only Mixpanel tool, so it cannot create or edit reports.

Below: 8 SKILL.md files, the Mixpanel Query API fields each uses, install steps and the connector setup.

Ryze AI · Paid Ads

Mixpanel skills on live data

  • 7-day free trial, $89 a month flat

Used by 2,000+ marketers

Uber Eats logoadidas logoDuolingo logoMGM Resorts logoWharton logoLendingClub logoNorton logoEventbrite logoHuel logoTogether AI logoghd logoHack The Box logo

The 8 Claude skills for Mixpanel at a glance

All 8 are read-only and name Mixpanel Query API fields exactly as Mixpanel documents them.

  1. 01Weekly event digestThis week against last week for named events

    Main Query API fields: event, from_date, to_date, unit, type

    Cadence: Weekly

  2. 02Funnel readoutWhere a saved funnel loses people

    Main Query API fields: funnel_id, length, on

    Cadence: Weekly

  3. 03Retention checkReturn rate by signup week

    Main Query API fields: retention_type, born_event, unit, interval_count

    Cadence: Monthly

  4. 04Saved report readoutExplain a saved Insights report

    Main Query API fields: bookmark_id

    Cadence: On demand

  5. 05Source breakdownUnique users by UTM source

    Main Query API fields: on, where, type unique

    Cadence: Monthly

  6. 06Property auditEvent property values that look wrong

    Main Query API fields: event, on, limit

    Cadence: Quarterly

  7. 07Profile segment checkProfiles matching a rule

    Main Query API fields: where, output_properties

    Cadence: On demand

  8. 08JQL fallbackAnalysis the report endpoints do not cover

    Main Query API fields: JQL script

    Cadence: When needed

The fields come from Mixpanel's Query API reference, opened November 14, 2026. No numbers from a live project appear on this page.

What are Claude skills for Mixpanel?

A Claude skill for Mixpanel is a saved SKILL.md file that tells Claude which Mixpanel query to run and what to hand back. Per Anthropic's Agent Skills docs, the file starts with a name and a description, and Claude loads the rest only when a request matches the description.

The name allows up to 64 lowercase letters, numbers and hyphens and cannot contain the words claude or anthropic, so every skill here starts with mixpanel. The description, up to 1,024 characters, says what the skill does and when to use it.

  1. What it is

    One-off prompt
    A question in chat
    Skill
    A saved file with a fixed query and output
    Mixpanel connection
    A way for Claude to call the Query API
  2. Setup

    One-off prompt
    None
    Skill
    Save once per Claude app
    Mixpanel connection
    One service account and one connector
  3. Same result each run

    One-off prompt
    No
    Skill
    Yes
    Mixpanel connection
    Depends on the prompt or skill

Mixpanel names the fields of each query in its Query API reference. Without a connection, attach a CSV export with matching columns. For the open-source product analytics side, see Claude skills for PostHog.

How to install the skills in Claude Code and claude.ai

Claude Code

Save each block as ~/.claude/skills/<skill-name>/SKILL.md for yourself, or .claude/skills/<skill-name>/SKILL.md in a project to share it with the team. Claude picks a skill when your request matches it, or you type /mixpanel-weekly-digest (Claude Code skills docs).

claude.ai

Zip each skill folder and upload it as a custom skill. Anthropic lists this on the Pro, Max, Ultra, Team and Enterprise plans with code execution on.

Connect the data

The Mixpanel MCP page covers the Ryze AI Mixpanel tool, and the Claude connector guide in the Ryze AI help center covers adding the connector in each Claude app.

Skills uploaded to claude.ai do not reach the API, and skill folders saved in Claude Code do not upload to claude.ai. Anthropic advises using skills only from sources you trust, so read a SKILL.md before you save it.

Core skills: weekly digest, funnel, retention and saved reports

These four answer the questions most teams ask every week. Replace the event names in angle brackets with your own.

01. Weekly event digest

Compares the last 7 complete days with the 7 before for the events you name. Mixpanel's segmentation query returns a count per day and accepts a `type` of general, unique or average, so the skill asks for unique users and total events.

SKILL.md
--- name: mixpanel-weekly-digest description: Weekly Mixpanel recap for named events, last 7 complete days against the 7 days before. Use for weekly product usage summaries. --- # Mixpanel weekly digest Ask for up to 5 event names if none are given. For each event, run a segmentation query twice: - event: <event name> - from_date and to_date: the 7 complete days, then the 7 days before (yyyy-mm-dd) - unit: day - type: general, then unique Steps: 1. Sum each week and compute the percent change for total events and unique users. 2. Name the day with the largest move. Output: one row per event with both weeks and the change, then one sentence on the biggest mover.

Use it when: you send a Monday product update.

02. Funnel readout

Reads a saved funnel by its ID and splits it by one property. Mixpanel's funnels query takes `funnel_id`, a date range and an optional `length` that cannot exceed 90 days.

SKILL.md
--- name: mixpanel-funnel-readout description: Reads a saved Mixpanel funnel by ID and shows where users drop off, optionally split by a property. Use when asked about conversion between steps. --- # Mixpanel funnel readout Ask for the funnel ID and the date range if missing. Run a funnels query: - funnel_id: the saved funnel - from_date, to_date: the range (yyyy-mm-dd) - on: properties["<property>"] when the user wants a split - limit: 10 when splitting Steps: 1. Report each step count and the step to step conversion. 2. Name the step with the lowest conversion. 3. When split, list the 3 values with the weakest overall conversion. Output: a table of steps, then the weakest step and segment.

Use it when: you review signup or checkout conversion.

03. Retention check

Runs birth retention for people who did a first event, then returned. Mixpanel documents `birth` as first-time retention and `compounded` as recurring retention, with units of day, week or month.

SKILL.md
--- name: mixpanel-retention-check description: Weekly retention for users who did a starting event, then a return event. Use when asked whether new users come back. --- # Mixpanel retention check Ask for the born event (for example the signup event) and the return event. Run a retention query: - retention_type: birth - born_event: the starting event - event: the return event - unit: week - interval_count: 8 - from_date, to_date: the last 8 weeks Steps: 1. Report the share returning in week 1, 2, 4 and 8 for each cohort. 2. Flag cohorts that sit well below the others. Output: a cohort by week table and two sentences on the trend. Say when a cohort is too recent to be complete.

Use it when: you check whether a release changed how new users stick.

04. Saved report readout

Explains an Insights report your team already built. The Insights query takes a `bookmark_id`, which is the number after `report-` in the report URL (Mixpanel Insights query).

SKILL.md
--- name: mixpanel-saved-report description: Reads a saved Mixpanel Insights report by bookmark ID and explains it in plain language. Use when someone shares a report and asks what it shows. --- # Mixpanel saved report readout Ask for the bookmark ID (the number after report- in the report URL). Read the saved Insights report for that bookmark ID. Steps: 1. State the date range and the events or metrics in the report. 2. Give the first and last value of each series and the direction. 3. Name anything the report does not tell us, such as the cause of a change. Output: three short paragraphs: what it measures, what moved, what is missing.

Use it when: a stakeholder sends a report link and asks what it means.

Growth and data quality skills

These four split usage by source, check the data behind it and reach for JQL when the report endpoints fall short.

05. Source breakdown

Counts unique users who did a key event, split by UTM source. It relies on your own tagging: Mixpanel only has the properties your tracking sends.

SKILL.md
--- name: mixpanel-source-breakdown description: Unique users who did a key event, split by UTM source or another property. Use when asked which sources bring users who act. --- # Mixpanel source breakdown Ask for the key event and the property (default utm_source). Run a segmentation query, last 28 days: - event: the key event - on: properties["utm_source"] - type: unique - unit: month - limit: 25 Steps: 1. Rank sources by unique users. 2. List values that differ only by case or spelling. 3. Report the share with no value set. Output: a ranked table, then the tagging problems found.

Use it when: you plan next month's channel mix. Mixpanel does not hold ad spend, so cost per user needs spend from the ad platform.

06. Property audit

Lists the values of one event property, to catch typos, mixed formats and stray test values before they skew a report.

SKILL.md
--- name: mixpanel-property-audit description: Lists the values of one Mixpanel event property and flags inconsistent or test values. Use before trusting a breakdown. --- # Mixpanel property audit Ask for the event and the property. Run a segmentation query, last 30 days: - event: the event - on: properties["<property>"] - unit: month - limit: 100 Steps: 1. Group values that differ only by case, spacing or spelling. 2. Flag values that look like test entries or empty strings. 3. Report the share of events with no value. Output: values with counts, the groups to merge, and the fix to make in the tracking code.

Use it when: a breakdown has a long tail of near-duplicate values.

07. Profile segment check

Counts and samples user profiles that match a rule. Mixpanel's profiles query takes a `where` expression and an `output_properties` list, which keeps the response small (Query Profiles).

SKILL.md
--- name: mixpanel-profile-segment description: Counts Mixpanel user profiles that match a rule and shows a small sample of chosen properties. Use when asked how many users have a given trait. --- # Mixpanel profile segment check Ask for the rule, for example properties["plan"] == "pro". Run a profiles query: - where: the rule - output_properties: only the properties the user names Steps: 1. Report the total matching profiles. 2. Show at most 10 sample profiles with the chosen properties. 3. Do not print email addresses or names unless the user asks for them. Output: the total, then the sample table.

Use it when: you size a segment before building a cohort in Mixpanel.

08. JQL fallback

For a question the report endpoints do not cover, such as a custom grouping or a sequence of events. Per the Ryze AI help center, JQL times out after 2 minutes, so the skill keeps scripts narrow.

SKILL.md
--- name: mixpanel-jql-fallback description: Writes and runs a small JQL script when a Mixpanel report endpoint cannot answer the question. Use only after segmentation, funnels and retention fall short. --- # Mixpanel JQL fallback Steps: 1. Restate the question and say why the report endpoints cannot answer it. 2. Write a JQL script limited to the events and the date range needed, with groupBy and reduce. 3. Run it once. If it times out, narrow the date range or the event list and run it again. 4. Show the script next to the result so the user can reuse it. Output: the script, the result table and one sentence on what it means.

Use it when: the other 7 skills cannot express the question.

Run the skills on live Mixpanel data

A skill only describes the query; Claude needs a connection to run it. The Ryze AI connector gives Claude one Mixpanel tool:

  1. mixpanel__read

    What it returns
    A read-only Query API request for the connected project: segmentation, retention, funnels and saved funnels, saved Insights reports, user profiles, event properties and JQL
    Used by
    Skills 01 to 08

Connect Mixpanel in Ryze AI with a service account that has at least the Analyst role, plus the numeric Project ID and the data residency (us, eu or in), as described in the Ryze AI help center. The tool only reads, so Claude cannot create or edit events, reports or profiles. In Claude, approvals are set per tool under Customize, Connectors, Ryze AI, Tool permissions.

Mixpanel allows 60 queries per hour and 5 concurrent queries per project on the Query API (Mixpanel Query Profiles reference). A skill that runs one query per event, such as the weekly digest, can use that hourly budget quickly, so keep the event list short. One connection covers one Mixpanel project, and the connector URL https://connector.get-ryze.ai/mcp is the same one used for Ryze AI's other platforms. Plans start at $89 a month with a 7-day free trial on the pricing page.

Mixpanel also hosts its own MCP server at https://mcp.mixpanel.com/mcp (US), https://mcp-eu.mixpanel.com/mcp (EU) and https://mcp-in.mixpanel.com/mcp (India). It signs in with OAuth, needs an org admin to enable MCP, and gives the assistant read and write access, including dashboards and metadata (Mixpanel MCP docs). Pick it when you want Claude to build or edit reports in Mixpanel. Pick the Ryze AI connector when you want read-only access through a service account. Both run these skills, since each skill only asks for data.

Troubleshooting: when a Mixpanel skill returns a wrong answer

Claude has no Mixpanel tool

Claude keeps the tool list from when you added the connector. If you connected Mixpanel afterward, remove and re-add the connector, then start a new chat (Ryze AI connector FAQ).

The connection is refused

Check the service account has at least the Analyst role on the project, and that the Project ID and data residency match Project Settings.

A funnel or report is not found

The ID is for another project. Funnel and bookmark IDs belong to one project, and the connection covers one.

Projects with Data Views

These may also need a workspace ID in the query. Ask Claude to include it, and do not assume every project works without it.

Queries stop or slow down

The Query API allows 60 queries per hour and 5 concurrent queries per project. Wait, then run fewer queries.

Numbers differ from a Mixpanel board

The skill and the board use different dates, filters or a different unit. Ask Claude to print the parameters it sent and compare them.

Sources

The verdict

Turn each recurring Mixpanel question into a skill with a fixed query. Start with the weekly digest and the funnel readout, check properties before you trust a breakdown, and keep one-off questions as prompts.

Ryze AI runs these skills in Claude and ChatGPT on live Mixpanel data. Its one Mixpanel tool only reads, so changes to events, reports and profiles still happen in Mixpanel.

Frequently asked questions

What are Claude skills for Mixpanel?
SKILL.md files that tell Claude which Mixpanel query to run, with exact fields and date ranges, and how to present the result. Claude loads one when a request matches its description, so each check runs the same way every time.
Do I need a Mixpanel connection to use these skills?
No. Each skill also works on a CSV export you attach, if it has the columns the skill names. A connection removes the export step and lets Claude run funnels, retention and JQL itself.
Which Claude plan do I need?
Anthropic lists custom skill uploads on claude.ai for Pro, Max, Ultra, Team and Enterprise with code execution on. In Claude Code, skills are folders on your computer. Custom connectors using remote MCP are available on Free, Pro, Max, Ultra, Team and Enterprise, and Free is limited to one.
Can Claude change my Mixpanel project through these skills?
Not through Ryze AI. Its Mixpanel tool is read-only, so it cannot create or edit events, reports or profiles. Mixpanel's own MCP server has read and write access, which you can use for that.
Show 6 more questions
What Mixpanel access do I need?
A service account with at least the Analyst role on the project, plus the numeric Project ID and the data residency (us, eu or in). The service account secret is shown once, so copy it when you create the account.
What is the best Claude connector for Mixpanel?
For running these skills on live data with a service account, use Ryze AI: its Mixpanel tool reads segmentation, funnels, retention, saved Insights reports, profiles and JQL for one project. For building or editing reports, Mixpanel's own MCP server is the better fit.
How many queries can the skills run?
Mixpanel allows 60 queries per hour and 5 concurrent queries per project on the Query API. The weekly digest runs one query per event and per week, so name only the events you need.
Does Mixpanel have its own MCP server?
Yes. It is hosted at https://mcp.mixpanel.com/mcp for the US, with EU and India endpoints, and signs in with OAuth. An org admin must enable MCP first, and the assistant gets read and write access to what the user can see.
Can I connect more than one Mixpanel project?
One connection covers one project. Another project can live in another workspace, and one Claude or ChatGPT connection can cover up to 20 workspaces. To switch, disconnect and connect again in the Ryze AI app.
Why does the segmentation skill use the Query API instead of Insights?
Mixpanel marks the segmentation query as in maintenance mode and recommends Insights reports. The skills here use it for ad hoc counts, and the saved report skill reads an Insights report you already built.

Related guides

Ryze AI: Mixpanel skills on live data

7-day free trial, $89 a month flat

Start free trial