outreach.io -by-cdata

This MCP server exposes Outreach.io data through a read-only MCP interface by wrapping the CData JDBC Driver for Outreach.io. It enables LLMs to issue natural language requests and have them translated into SQL-backed queries against Outreach.io without needing to write SQL themselves. The server communicates via standard MCP tools such as get_tables, get_columns, and run_query, allowing you to discover available data and fetch results in real time. Tools are named based on the server prefix (e.g., outreach_io_get_tables, outreach_io_get_columns, outreach_io_run_query) and return results in CSV format for tables and columns, or row results for queries.

To use it with Claude Desktop or similar clients, run the MCP server on your machine (it uses stdio for communication). In Claude Desktop, add a config entry pointing to the Java JAR and the PRP file you created, then launch or refresh the client so that the new server appears in your list of MCP servers. Once registered, you can ask questions like, “What are my open Outreach tickets?” or “Show me opportunities by stage and close date,” and the client will route those requests to the underlying JDBC-based data source through the MCP server.

Prerequisites:

• Java Runtime Environment (JRE) or JDK installed and available on PATH
• Maven (for building the MCP server) if you choose to build locally from source
• Access to the Outreach.io JDBC driver (CData) and a valid license

Installation steps:

1. Clone the repository and navigate into it: git clone https://github.com/cdatasoftware/outreach.io-mcp-server-by-cdata.git cd outreach.io-mcp-server-by-cdata

2. Build the server (if you are compiling from source): mvn clean install This will produce a JAR named like CDataMCP-jar-with-dependencies.jar in the target/ directory.

3. Download and install the CData JDBC Driver for Outreach.io from: https://www.cdata.com/drivers/outreach/download/jdbc

4. License the JDBC driver (follow the driver's instructions, typically involving:

   • Navigating to the lib folder of the installation
   • Running: java -jar cdata.jdbc.outreach.jar --license
   • Providing your name, email, and license type/link

5. Prepare a .prp configuration file for your connection (example content provided in the README): Prefix=outreach ServerName=CDataOutreach ServerVersion=1.0 DriverPath=PATH\TO\cdata.jdbc.outreach.jar DriverClass=cdata.jdbc.outreach.OutreachDriver JdbcUrl=jdbc:outreach:InitiateOAuth=GETANDREFRESH; Tables=

6. Run the MCP server with the prepared PRP file: java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/outreach.io.prp

Notes:

• The server uses stdio for communication, so it is typically run on the same machine as the client.
• Ensure the PRP file accurately points to the JDBC driver and the generated JDBC URL.
• If you need Claude Desktop to see the server, add the appropriate entry to claude_desktop_config.json as shown in the README.

Tips and caveats:

• This is a read-only MCP server unless you have a connected driver that supports write operations via the underlying data source; the MCP layer itself is read-through for this setup.
• If Claude Desktop cannot see the server, fully quit and restart the client after starting the MCP server.
• Verify the JDBC connection string (JdbcUrl) by using the CData Connection String Utility and test the connection before populating the .prp file.
• Ensure network/firewall settings allow the client to access the local MCP server if running remotely via port-forwarding or similar setup (this server, as configured, uses stdio and is typically local).
• When updating credentials or OAuth flows, you may need to re-authenticate in the JDBC driver utility and re-export a new connection string into the .prp file.