You can query live HCL Domino data with this MCP server, which exposes the data through a simple MCP interface in read-only mode. This makes it easy for language models and clients to ask natural-language questions and receive live data without writing SQL.

How to use

After you start the MCP server, you can use any MCP client to access the live HCL Domino data. You don’t need to run SQL queries directly; just ask questions like: “What is the status of recent Domino tickets?” or “Show me the open opportunities by account industry.” The server exposes a set of built-in tools that let the client discover available tables and columns, and run read-only queries against the data source.

How to install

Prerequisites: Java installed on your machine and Maven for building the server. You will also need the CData JDBC Driver for HCL Domino.

git clone https://github.com/cdatasoftware/hcl-domino-mcp-server-by-cdata.git
cd hcl-domino-mcp-server-by-cdata
```} ,{

mvn clean install

This builds the server and creates the JAR: CDataMCP-jar-with-dependencies.jar

Install the CData JDBC Driver for HCL Domino from the vendor site and license it as part of the setup.

Example steps (paths will vary by your OS and install location)

Download and install the driver from:

https://www.cdata.com/drivers/domino/download/jdbc

License the driver (run in the driver’s lib folder)

java -jar cdata.jdbc.domino.jar --license

{Follow prompts to enter your name, email, and either TRIAL or your license key.}

Configure your connection using the Connection String utility, then create a .prp file for the JDBC connection.

java -jar cdata.jdbc.domino.jar

After tests complete, copy the resulting connection string for use in the .prp file.

Create a .prp file to define the MCP connection, for example hcl-domino.prp, using these properties.

Prefix=domino ServerName=CDataDomino ServerVersion=1.0 DriverPath=PATH\TO\cdata.jdbc.domino.jar DriverClass=cdata.jdbc.domino.DominoDriver JdbcUrl=jdbc:domino:InitiateOAuth=GETANDREFRESH; Tables=

Replace PATH\TO with the actual installation path of the JDBC driver and adjust JdbcUrl as needed.

Running the server

Start the MCP server using the Java runtime and point it to your .prp file. The server runs in stdio mode so it works with clients on the same machine.

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/hcl-domino.prp

Replace the paths with your actual locations. The server will start and listen for MCP client requests on the local machine.

## Notes on usage and security

This MCP server is read-only by design. If you need full read, write, update, and delete capabilities, explore the other MCP server option from CData that supports full CRUD operations.

If you need to reconfigure connections, update the .prp file and restart the server so the changes take effect.

## Troubleshooting

If you don’t see the MCP server in your client, quit and restart the client to refresh the list of available servers.

If the client cannot retrieve data, verify the connection string in the .prp file and ensure the JDBC driver is licensed and accessible in the DriverPath.

If you encounter issues connecting to the data source, contact CData Support for assistance.

## License

This MCP server is licensed under the MIT License. You may use, modify, and distribute it in compliance with the MIT terms.

## Available tools

### domino\_mcp\_get\_tables

Retrieves the list of available tables from the HCL Domino data source. Output is provided in CSV format with column headers as the first line.

### domino\_mcp\_get\_columns

Retrieves the list of columns for a specified table. Output is provided in CSV format with column headers as the first line.

### domino\_mcp\_run\_query

Executes a SQL SELECT query against the configured Domino data source and returns the result set.