home / mcp / monday.com mcp server
Provides a read-only MCP server to query live Monday.com data via MCP interface.
Configuration
View docs{
"mcpServers": {
"cdatasoftware-monday.com-mcp-server-by-cdata": {
"command": "java",
"args": [
"-jar",
"/PATH/TO/CDataMCP-jar-with-dependencies.jar",
"/PATH/TO/monday.com.prp"
]
}
}
}You run a local MCP (Model Context Protocol) server that exposes Monday.com data through a simple MCP interface. This lets your AI client ask natural language questions and retrieve live data from Monday.com without writing SQL, while keeping the data access read-only and self-contained on your machine.
Start the MCP server on your machine and connect your MCP client (such as Claude Desktop) to it. With the server running, you can ask questions like “What is the status of open Monday.com projects this quarter?” or “Show me the recent activity on the Monday.com boards I track.” The client will automatically discover the available data and tools exposed by the MCP server and present relevant queries. You do not need to call the underlying tools directly; simply pose natural language questions and the AI client will translate them into the appropriate data operations.
Prerequisites: make sure you have Java installed on your machine. You will also need to build the MCP server jar and obtain the Monday.com JDBC driver to connect to your data source.
1. Build the MCP server jar using Maven.
2. Obtain and license the CData JDBC Driver for Monday.com and place the driver jar where you can reference it in your configuration.
3. Create a properties file for your JDBC connection (for example, monday.com.prp) with your connection details, including the JDBC URL produced by the driver and the path to the driver jar. Ensure this file points to the tables you want to access or leave Tables blank to access all data.
4. Run the MCP server using the Java runtime and point it at your .prp file to start the server.
Configuration overview You will expose a single local MCP server that reads from Monday.com via the CData JDBC Driver. The server runs in read-only mode and is designed for local, development, or testing scenarios where you want to query live data from Monday.com without direct SQL access.
Run command you will use to start the server (examples assume you have built the jar and created monday.com.prp):
java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/monday.com.prpIf you cannot see the MCP server in your client, be sure you fully exit and restart the client after starting the server.
If the client cannot retrieve data, verify your connection string and that the .prp file contains the correct DriverPath, DriverClass, and JdbcUrl entries as produced by the JDBC Driver’s connection utility.
Retrieves a list of tables available in the data source. The output is in CSV format with headers on the first line.
Retrieves a list of columns for a specified table. The output is in CSV format with headers on the first line.
Executes a SQL SELECT query against the data source.