home / mcp / raisers edge nxt mcp server
This read-only MCP Server allows you to connect to Raisers Edge NXT data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).
Configuration
View docs{
"mcpServers": {
"cdatasoftware-raisers-edge-nxt-mcp-server-by-cdata": {
"command": "java",
"args": [
"-jar",
"CDataMCP-jar-with-dependencies.jar",
"/PATH/TO/raisers-edge-nxt.prp"
]
}
}
}You can run a local, read-only MCP server that exposes Raisers Edge NXT data through a simple MCP interface. This server lets you ask natural-language questions and receive live data without writing SQL, while staying on the same machine for secure, read-only access.
Once the server is running, you connect an MCP client (such as Claude Desktop) to the local process. The client will access Raisers Edge NXT data through the MCP tools exposed by the server. You can ask questions like “What are my open opportunities?” or “Show me the calendar events for today,” and the AI client will use the built-in tools to query the data source and return results. The server runs locally via a standard Java command and reads from a JDBC connection configured to Raisers Edge NXT.
Prerequisites: you need a Java Runtime Environment and Maven to build and run the MCP server.
# 1) Install Java and Maven (examples; use your platform's package manager)
# - Java 11+ (or as required by the project)
# - Maven
# 2) Build the MCP server
mvn clean install
# 3) The build creates the runnable JAR
# 4) Prepare the JDBC driver and connection details as described in the setup stepsFollow these concrete steps to set up the MCP server from source: - Clone the MCP server repository - Build the project to produce the runnable JAR (CDataMCP-jar-with-dependencies.jar) - Install and license the CData JDBC Driver for Raisers Edge NXT - Configure the JDBC connection and create a .prp file describing the connection - Run the MCP server with the prepared .prp file using Java
The MCP server is designed to be run locally and used with a client on the same machine. The server presents a minimal, read-only surface for Raisers Edge NXT data and requires a properly configured JDBC connection string and prp file.
Example runtime command to start the MCP server (replace paths with your actual ones):
java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/raisers-edge-nxt.prpIf the MCP server does not appear in your client, ensure you have fully quit and restarted the client so it re-scans available MCP servers. Verify the .prp file contains a valid JdbcUrl and other required fields, and confirm the JDBC driver is licensed and accessible.
If data cannot be retrieved, double-check the connection string using the JDBC Driver’s connection utility and ensure the token or OAuth flow (if used) is completed in the browser as required.
Retrieves a list of tables available in the Raisers Edge NXT data source. The output is presented in CSV format with column headers on the first line.
Retrieves a list of columns for a specified table. The output is presented in CSV format with column headers on the first line.
Executes a SQL SELECT query against the Raisers Edge NXT data source and returns the results.