home / mcp / cloudant mcp server

Cloudant MCP Server

This read-only MCP Server allows you to connect to Cloudant 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/).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-cloudant-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/cloudant.prp"
      ]
    }
  }
}

You can run a local, read-only MCP server that exposes your Cloudant data through a simple MCP interface. This lets you ask natural-language questions and retrieve live data without writing SQL. The server wraps the CData JDBC Driver for Cloudant and serves data from your Cloudant instance in an easy-to-consume way for an AI client running on the same machine.

How to use

Install and run the MCP server locally, then connect your MCP client (such as Claude Desktop) to the local stdio-based server. Once running, you can ask questions like “What is the status of open Cloudant records by region?” and the AI client will read the data through built-in tools without needing SQL.

How to install

Prerequisites: you need Java installed to run the MCP server jar.

1. Clone the project and navigate to the folder.

# Clone the repository
git clone https://github.com/cdatasoftware/cloudant-mcp-server-by-cdata.git
cd cloudant-mcp-server-by-cdata

2. Build the server to produce the executable jar.

mvn clean install

3. Install the CData JDBC Driver for Cloudant and license it following the driver’s installation steps. The driver enables Cloudant data to be accessed as SQL models.

4. Create a properties file for the JDBC connection (for example cloudant.prp) with your connection details. The properties include Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, and Optional Tables.

5. Start the MCP server locally using the stdio configuration. The server runs on your machine and communicates with clients that also run locally.

Running the server and connecting a client

After you have built the server and prepared cloudant.prp, you start the MCP server with the following command. This starts a stdio server on your machine and reads your configuration.

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/cloudant.prp

Available tools

cloudant_get_tables

Retrieves a list of tables (data sources) available from the Cloudant connection. Output is in CSV format with column headers.

cloudant_get_columns

Retrieves a list of columns for a specific table. Output is in CSV format with column headers.

cloudant_run_query

Executes a SQL SELECT query against the Cloudant data as exposed through the MCP server.