ConnectCrewAIto Mixpanel MCP Server

import os
from crewai import Agent, Task, Crew, Process
from crewai_tools import MCPServerAdapter
from klavis import Klavis
from klavis.types import McpServerName, ConnectionType

# Initialize clients
klavis_client = Klavis(api_key=os.getenv("KLAVIS_API_KEY"))

mixpanel_mcp_instance = klavis_client.mcp_server.create_server_instance(
    server_name=McpServerName.MIXPANEL,
    user_id="1234",
    platform_name="Klavis",
    connection_type=ConnectionType.STREAMABLE_HTTP,
)

with MCPServerAdapter(mixpanel_mcp_instance.server_params) as mcp_tools:
    # Create a Mixpanel Analysis Agent
    mixpanel_agent = Agent(
        role="Mixpanel Analyst",
        goal="Research and analyze mixpanel to extract comprehensive insights",
        backstory="You are an expert at analyzing mixpanel and creating professional summaries.",
        tools=mcp_tools,
        reasoning=True,
        verbose=False
    )
    
    # Define Task
    analysis_task = Task(
        description=f"Research and analyze mixpanel data. Extract relevant information and create a comprehensive summary with key points and main takeaways.",
        expected_output="Complete analysis with structured summary, key insights, and main takeaways",
        agent=mixpanel_agent,
        markdown=True
    )
    
    # Create and execute the crew
    mixpanel_crew = Crew(
        agents=[mixpanel_agent],
        tasks=[analysis_task],
        verbose=False,
        process=Process.sequential
    )
    
    result = mixpanel_crew.kickoff()