Mixpanel MCP

Instructions

Implementation Reference

• src/index.ts:1252-1311 (handler)

  The handler function that implements the core logic of the query_segmentation_report tool by making an authenticated GET request to Mixpanel's /segmentation API endpoint with the specified event, date range, segmentation property, and filters.

  async function handleQuerySegmentationReport(args: any, config: any) {
    const { 
      project_id = config.DEFAULT_PROJECT_ID, 
      event, 
      from_date, 
      to_date, 
      on, 
      where, 
      unit = "day" 
    } = args;
    
    try {
      const credentials = `${config.SERVICE_ACCOUNT_USER_NAME}:${config.SERVICE_ACCOUNT_PASSWORD}`;
      const encodedCredentials = Buffer.from(credentials).toString('base64');
      
      let url = `${config.MIXPANEL_BASE_URL}/segmentation?project_id=${project_id}&event=${encodeURIComponent(event)}&from_date=${from_date}&to_date=${to_date}&on=${encodeURIComponent(on)}&unit=${unit}`;
      
      if (where) {
        url += `&where=${encodeURIComponent(where)}`;
      }
      
      const options = {
        method: 'GET',
        headers: {
          'accept': 'application/json',
          'authorization': `Basic ${encodedCredentials}`
        }
      };
      
      const response = await fetch(url, options);
      
      if (!response.ok) {
        const errorText = await response.text();
        throw new Error(`HTTP error! status: ${response.status} - ${errorText}`);
      }
      
      const data = await response.json();
      
      return {
        content: [
          {
            type: "text",
            text: JSON.stringify(data)
          }
        ]
      };
    } catch (error: unknown) {
      console.error("Error querying segmentation report:", error);
      const errorMessage = error instanceof Error ? error.message : String(error);
      return {
        content: [
          {
            type: "text",
            text: `Error querying segmentation report: ${errorMessage}`
          }
        ],
        isError: true
      };
    }
  }

• src/index.ts:534-568 (schema)

  JSON schema defining the input parameters for the query_segmentation_report tool, including required fields event, from_date, to_date, on, and optional project_id, where, unit.

  inputSchema: {
    type: "object",
    properties: {
      project_id: {
        type: "string",
        description: "The Mixpanel project ID. Optional since it has a default."
      },
      event: {
        type: "string",
        description: "The event to segment"
      },
      from_date: {
        type: "string",
        description: "The date in yyyy-mm-dd format to begin querying from (inclusive)"
      },
      to_date: {
        type: "string",
        description: "The date in yyyy-mm-dd format to query to (inclusive)"
      },
      on: {
        type: "string",
        description: "The property to segment by"
      },
      where: {
        type: "string",
        description: "JSON string representing additional filters"
      },
      unit: {
        type: "string",
        enum: ["hour", "day", "week", "month"],
        description: "The time unit for segmentation, defaults to day"
      }
    },
    required: ["event", "from_date", "to_date", "on"]
  }

• src/index.ts:642-643 (registration)

  Dispatch case in the CallToolRequestSchema handler that registers and routes calls to the specific handleQuerySegmentationReport function.

  case "query_segmentation_report":
    return await handleQuerySegmentationReport(args, { SERVICE_ACCOUNT_USER_NAME, SERVICE_ACCOUNT_PASSWORD, DEFAULT_PROJECT_ID, MIXPANEL_BASE_URL });

• src/index.ts:531-569 (registration)

  Tool definition registered in the ListToolsRequestSchema response, including name, description, and input schema.

  {
    name: "query_segmentation_report",
    description: "Segment events by properties. Useful for analyzing how different user segments behave and comparing event patterns across groups.",
    inputSchema: {
      type: "object",
      properties: {
        project_id: {
          type: "string",
          description: "The Mixpanel project ID. Optional since it has a default."
        },
        event: {
          type: "string",
          description: "The event to segment"
        },
        from_date: {
          type: "string",
          description: "The date in yyyy-mm-dd format to begin querying from (inclusive)"
        },
        to_date: {
          type: "string",
          description: "The date in yyyy-mm-dd format to query to (inclusive)"
        },
        on: {
          type: "string",
          description: "The property to segment by"
        },
        where: {
          type: "string",
          description: "JSON string representing additional filters"
        },
        unit: {
          type: "string",
          enum: ["hour", "day", "week", "month"],
          description: "The time unit for segmentation, defaults to day"
        }
      },
      required: ["event", "from_date", "to_date", "on"]
    }
  },