How to Connect Mixpanel to Gemini via MCP

💡 No install? Use cloud.anythingmcp.com directly. Sign in, click Connectors → Mixpanel, paste your credentials, mint an MCP API key and you're done. No Docker, no git clone, no local server.

Mixpanel + Gemini

Let your AI read your Mixpanel product analytics: event trends, segmentation by any property, saved funnels, retention, frequency, saved Insights reports, cohorts and user profiles, and manage chart annotations. Signs in with a service account; US, EU and India data residency. Reports need the Growth or Enterprise plan.

Prerequisites

See the full setup instructions baked into the connector (visible in the in-app store when you select the connector). The required environment variables for this connector are:

MIXPANEL_API_HOST, MIXPANEL_SERVICE_ACCOUNT_USERNAME, MIXPANEL_SERVICE_ACCOUNT_SECRET, MIXPANEL_PROJECT_ID

Step 1 — Get credentials

1. With the Owner or Admin role, open Organization Settings → Service Accounts (https://mixpanel.com/settings/org#serviceaccounts, for an EU project https://eu.mixpanel.com/settings/org#serviceaccounts) and add a service account. A project Owner or Admin can also create one under Project Settings → Service Accounts for that project only.
2. Name it (for example AnythingMCP), give it access to the project and choose the role: Consumer is enough to read reports and profiles; creating, editing or deleting annotations and listing annotation tags need Analyst or higher. An expiry date is optional: once it passes, every call fails with 401.
3. Copy the username (it looks like anythingmcp.abc123.mp-service-account) into MIXPANEL_SERVICE_ACCOUNT_USERNAME and the secret into MIXPANEL_SERVICE_ACCOUNT_SECRET straight away: Mixpanel shows the secret only once. If you lose it, create a new service account.
4. Put the project id into MIXPANEL_PROJECT_ID: Project Settings → Overview → Project ID, or the number after /project/ in the project's address.
5. Set MIXPANEL_API_HOST to where the project stores its data (Project Settings → Overview → Data Residency): https://mixpanel.com (US, the default), https://eu.mixpanel.com (EU) or https://in.mixpanel.com (India).
6. Only if your project uses Data Views: set MIXPANEL_WORKSPACE_ID to the id of the global data view (the number after /view/ in the address). Otherwise leave it empty.
7. Install the connector and run mixpanel_list_event_names to see which events your project tracks.

Plan: reports use Mixpanel's Query API, which comes with the Growth and Enterprise plans. On the Free plan every report tool answers 402, and so does the connection check at install. The annotation tools work on every plan. A Growth trial is enough to try the reports.

Limits: Mixpanel allows 60 queries per hour and 5 at the same time per project, shared with every other integration that queries the project. Each report is one query, so ask for a breakdown in one go rather than day by day or user by user. Above the limit Mixpanel answers 429: wait instead of retrying straight away.

What it reads: event trends, segmentation by any property with sums and averages, saved funnels, retention, frequency, saved Insights reports, cohorts and user or group profiles. Only saved funnels and saved Insights reports can be run; a report is found by the number after report- in its address. Dates are whole days in the project's time zone (Project Settings → Overview → Timezone).

Confirm first: annotations are notes pinned to a date that every chart of the project shows to all its members. The AI confirms the text and date with you before mixpanel_create_annotation or mixpanel_update_annotation. mixpanel_delete_annotation is switched off at install.

Common errors: 401: wrong username or secret, or the service account expired. 403: the service account has no access to this project, or its role is too low (annotation changes need Analyst). 400: usually a misspelled parameter, a date not written YYYY-MM-DD or a filter with a syntax error. If a correct project id is refused, check MIXPANEL_API_HOST against the project's data residency. Empty results are not errors: there is no data for that event or range.

The connector does not send or import events or profiles, export raw events, run JQL or the per-user activity stream, edit Lexicon, create cohorts, or handle feature flags, experiments or project administration.

Step 2 — Install the adapter

curl -fsSL https://raw.githubusercontent.com/HelpCode-ai/anythingmcp/main/docker-compose.quickstart.yml -o docker-compose.yml
printf 'JWT_SECRET=%s\nENCRYPTION_KEY=%s\n' "$(openssl rand -hex 32)" "$(openssl rand -hex 32)" > .env
docker compose up -d

Step 3 — Add the connector in Gemini

Your server URL: in AnythingMCP, open MCP Servers → the server this connector is on, and copy its URL (https://cloud.anythingmcp.com/mcp/…). Use it wherever this guide shows YOUR_SERVER_ID.

Gemini CLI reads MCP servers from ~/.gemini/settings.json (on Windows %USERPROFILE%\.gemini\settings.json). Add:

{
  "mcpServers": {
    "anythingmcp": {
      "httpUrl": "https://cloud.anythingmcp.com/mcp/YOUR_SERVER_ID",
      "headers": { "X-API-Key": "YOUR_MCP_API_KEY" }
    }
  }
}

1. Create an MCP API key in AnythingMCP under MCP Servers → your server → API keys, and paste it in place of YOUR_MCP_API_KEY.
2. Save the file and restart gemini.
3. Run /mcp inside Gemini CLI (or gemini mcp list in your shell): anythingmcp should show as connected.
4. Start prompting: Gemini CLI can now call the Mixpanel tools.

Available tools

Example prompts

• "How many sign ups did we have per week over the last three months, broken down by country?"
• "Show me the conversion of our saved onboarding funnel for last month and the step where most users drop off."
• "Of the users who signed up in September, what share came back in each of the following eight weeks?"
• "Add an annotation for the pricing page relaunch on 1 October and show me the text and date before you save it."

FAQ

Where does Gemini CLI look for MCP servers? In ~/.gemini/settings.json for your user, or in .gemini/settings.json inside a project. gemini mcp list shows each server and whether it connects.

Next steps

• Connector landing page
• Connect to Claude
• Connect to ChatGPT