Pipedrive MCP Server by CData

What is Pipedrive MCP Server by CData?

Pipedrive MCP Server by CData is a read-only Model Context Protocol (MCP) server that allows large language models (like Claude Desktop) to query live data from Pipedrive. It wraps the CData JDBC Driver for Pipedrive, exposing Pipedrive data as relational SQL models that LLMs can query with natural language questions—no SQL required.

How to use Pipedrive MCP Server by CData?

Clone the repository, build the JAR with mvn clean install, download and license the CData JDBC Driver for Pipedrive, and configure a .prp file with your connection string. Then add the server to your Claude Desktop configuration (claude_desktop_config.json) using the java -jar command with the JAR and .prp file. The server uses stdio transport, so it must run on the same machine as the client.

Key features of Pipedrive MCP Server by CData

• Read-only access to Pipedrive data via MCP
• Exposes Pipedrive as relational SQL models
• Natural language querying by LLMs
• Built-in tools: get_tables, get_columns, and run_query
• Works with any MCP client that supports stdio
• Supports OAuth authentication for Pipedrive

Use cases of Pipedrive MCP Server by CData

• Querying Pipedrive deals, contacts, and activities via Claude Desktop
• Answering natural language questions about sales pipelines
• Analyzing live Pipedrive data without writing SQL
• Integrating Pipedrive data into AI-driven reporting workflows

FAQ from Pipedrive MCP Server by CData

What is the difference between this server and the CData MCP Server for Pipedrive (beta)?

This server is read-only. The full CData MCP Server for Pipedrive (beta) supports read, write, update, delete, and action capabilities with a simplified setup.

What are the runtime requirements?

Java (to run the JAR), Maven (to build the project), and the CData JDBC Driver for Pipedrive (must be downloaded and licensed separately).

How do I configure the connection to Pipedrive?

Use the CData JDBC Driver’s connection string utility (java -jar cdata.jdbc.pipedrive.jar), test the connection, copy the resulting JDBC URL, and place it in a .prp file along with driver path, driver class, and other properties.

What transport does the server use?

The server uses stdio transport, so it can only be used with clients running on the same machine.

Does the server support OAuth?

Yes, the JDBC connection string can include InitiateOAuth=GETANDREFRESH to handle OAuth authentication via a browser prompt during setup.