Greenhouse MCP Server by CData

What is Greenhouse MCP Server by CData?

Greenhouse MCP Server by CData is a read-only MCP server that allows large language models (like Claude Desktop) to query live data from Greenhouse via natural language questions. It wraps the CData JDBC Driver for Greenhouse, which exposes Greenhouse data as relational SQL models, and makes that data available through a simple MCP interface — no SQL required.

How to use Greenhouse MCP Server by CData?

Clone the repository, build the JAR with mvn clean install, then install and license the CData JDBC Driver for Greenhouse. Use the driver’s connection string utility to configure and test a connection, and save the resulting JDBC URL in a .prp configuration file. Finally, either run the JAR directly with java -jar CDataMCP-jar-with-dependencies.jar <path>.prp (uses stdio) or add the server to a client config like claude_desktop_config.json.

Key features of Greenhouse MCP Server by CData

• Read-only access to live Greenhouse data.
• Exposes three MCP tools: get_tables, get_columns, run_query.
• Supports natural language queries (LLM translates to SQL).
• Built on the CData JDBC Driver for Greenhouse.
• Can be configured to limit access to specific tables.
• Operates over stdio transport (local client only).

Use cases of Greenhouse MCP Server by CData

• An LLM answering questions about Greenhouse candidates, jobs, or interviews.
• Exploring Greenhouse table schemas without writing SQL.
• Generating ad‑hoc reports from Greenhouse data through a chat interface.
• Integrating Greenhouse data into AI‑powered workflows or assistants.

FAQ from Greenhouse MCP Server by CData

What tools does the server provide?

The server provides {servername}_get_tables, {servername}_get_columns, and {servername}_run_query (SQL SELECT only). The actual tool names depend on the prefix set in the .prp file.

Does this server support write, update, or delete operations?

No. This specific project is explicitly read‑only. For full CRUD and action support, CData offers a separate beta MCP Server for Greenhouse.

What are the runtime requirements?

Java (any recent version) and the CData JDBC Driver for Greenhouse (free trial or licensed). The driver must be downloaded, installed, and licensed separately on the same machine as the server.

How is the server connected to a client like Claude Desktop?

The server communicates over stdio. Add a corresponding entry in the client’s mcpServers config (e.g., claude_desktop_config.json) pointing to the Java executable and the CDataMCP-jar-with-dependencies.jar with the path to your .prp file.

What authentication methods does the JDBC driver support?

The README shows OAuth as an example (using InitiateOAuth=GETANDREFRESH in the JDBC URL). The exact method depends on how you configure the connection via the driver’s connection string utility.