cvent_get_tablesLABSCO SUMMARY
Event data as tables, for the questions the event dashboard does not answer.
Registrations, sessions and attendee records arrive through the CData JDBC Driver as relational models, so counting across events or joining registrations to sessions is one SELECT. The server reads only — nothing here registers, cancels or edits.
What it is
A Java MCP server that puts CData's JDBC Driver for Cvent behind three read-only tools: list the tables, list a table's columns, and run a SQL SELECT. The driver is what does the work — it exposes Cvent as relational SQL models — and the server hands those models to your client so you can ask questions in plain language instead of writing SQL yourself.
What you get
get_tablesreturns the tables available in the data source, as CSV with a header rowget_columnsreturns the columns of one table, in the same CSV shaperun_queryexecutes a SQL SELECT and returns the rows- Every tool name starts with the
Prefixin your.prpfile (cvent_in the sample), so several CData servers can run side by side without colliding - Ask in plain language — how many people registered for an event, say — and the client picks the tools and writes the SQL
Requirements
Build the server with mvn clean install, which produces CDataMCP-jar-with-dependencies.jar. Separately download the CData JDBC Driver for Cvent and license it: run java -jar cdata.jdbc.cvent.jar --license and enter your name, email and either TRIAL or a licence key. Then write a .prp file naming DriverClass=cdata.jdbc.cvent.CventDriver plus the JdbcUrl you build in the driver's connection-string utility, and point your client at java -jar with the jar and that file. Transport is stdio, so the server has to run on the same machine as the client.
Setup effort
Build from source — clone the repository, then point your client at the binary
USE CASES
Counting registrations across events
Query several events from one table instead of opening each dashboard.
Checking session attendance
Join the session and attendee tables and filter to the ones you care about.
Seeing what Cvent exposes
List tables and columns before designing a report.
3 tools
Listed in project docs. Your client may show a different list.
cvent_get_columnscvent_run_queryBEFORE YOU INSTALL
What to know first
Tools you get
3 tools named in the project's documentation. All tools are read-only; full read-write access is the separate paid CData MCP Server for Cvent. Tool names start with the Prefix in the .prp file (cvent_ in the sample), and Tables= in the .prp limits which data they reach.
Where it runs
The documented client runs the server on your machine.
INSTALLATION
Connect your client
Clone the repository, then point your client at the binary. This one is built from source rather than installed with a single command.
Server setup
git clone https://github.com/cdatasoftware/cvent-mcp-server-by-cdata.git
cd cvent-mcp-server-by-cdata
mvn clean installDownload and install the CData JDBC Driver for Cvent from https://www.cdata.com/drivers/cvent/download/jdbc
License the driver: in the driver's lib folder run java -jar cdata.jdbc.cvent.jar --license, then enter name, email and "TRIAL" (or your license key)
Run java -jar cdata.jdbc.cvent.jar to open the Connection String utility, test the connection and copy the connection string
Create a .prp file with Prefix / ServerName / ServerVersion / DriverPath / DriverClass=cdata.jdbc.cvent.CventDriver / JdbcUrl / Tables
Add the mcpServers entry below to claude_desktop_config.json and restart the client
MCP Clients
Claude Desktop — macOS or Linux
{
"mcpServers": {
"cvent": {
"command": "<YOUR_PATH_TO_JAVA>",
"args": [
"-jar",
"<YOUR_PATH_TO_CDATA_MCP_JAR_WITH>",
"<YOUR_PATH_TO_CVENT>"
]
}
}
}