Corvic MCP with CrewAI

Home
Introduction to Corvic
How to Use Corvic
User Access
Rooms
Data Sources
Data Apps
Agents
Admin Console
Datasets
API Integrations
Python Integration
Jupyter Notebook
OpenAI
CrewAI
Langchain
FastAPI
Release Notes
Glossary

This tutorial demonstrates how to use Corvic's MCP protocol with CrewAI to analyze video game sales data, perform content research, and write results to a markdown file.

Use Case

Using a Corvic-powered agent, CrewAI identifies the top game genre by global sales, searches for relevant content using Serper, and writes the results to a file using CrewAI's file writer tool.

Prerequisites

  • Deploy a Corvic agent using the parquet version of the video game sales dataset.
  • Configure your Python environment with:
    • crewai
    • serper-dev-tool
    • corvic-mcp
  • Obtain your Corvic MCP endpoint and token.

Question Asked

Pass the following question to the tool as is (do not convert to SQL):

Group all the data by Genre and find the top titles by global sales. Provide the top 1 genre in a tabular format.

The following code shows the relevant Crew AI configuration discussed above. You can incorporate it in your Crew AI project as needed.

python
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77

Response

The output written to results_with_content.md includes a tabular summary of the top genre by sales and curated content recommendations (e.g., related to Action and Grand Theft Auto V).

CrewAI Output Screenshot

Need help? Contact support@corvic.ai or visit https://www.corvic.ai.