home / mcp / hubdb mcp server

HubDB MCP Server

This read-only MCP Server allows you to connect to HubDB data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out our MCP Server for HubDB (https://www.cdata.com/drivers/hubdb/download/mcp).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

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

You can run a read-only MCP Server that lets you query live HubDB data through the CData JDBC Driver. This server exposes HubDB tables as relational models and lets you ask natural-language questions to retrieve up-to-date information without writing SQL.

How to use

Once the HubDB MCP Server is running, you connect your MCP client (for example Claude Desktop) to the local stdio server you started. You do not need to call individual tools manually in typical use; you simply ask questions like, “What are the open HubDB entries for today?” or “Show me the latest HubDB records for a given project.” The server presents available tables and columns as part of its capabilities, and you can perform read-only queries to retrieve live data. The MCP server provides three core actions you can leverage through your client: get_tables to list tables, get_columns to list columns for a table, and run_query to execute a SELECT-like query against the HubDB data. All responses come through the MCP client as structured results, which you can integrate into your prompts and workflows.

How to install

Prerequisites you need before installing this MCP Server: a Java Runtime Environment (JRE/JDK) with access to the mvn tool and a working network connection to install the CData JDBC Driver for HubDB.

Step 1: Clone the project and navigate into it.

git clone https://github.com/cdatasoftware/hubdb-mcp-server-by-cdata.git
cd hubdb-mcp-server-by-cdata

Step 2: Build the MCP Server package.

mvn clean install

Step 3: Obtain and license the CData JDBC Driver for HubDB. Follow the driver installation steps and license as shown by the driver's installer. After licensing, locate the driver JAR and prepare it for the MCP configuration.

Step 4: Create a HubDB connection configuration file (hubdb.prp) with your JDBC connection details. You will specify the driver class, JDBC URL, and the path to the driver JAR in this file.

Prefix=hubdb
ServerName=CDataHubDB
ServerVersion=1.0
DriverPath=PATH\\TO\\cdata.jdbc.hubdb.jar
DriverClass=cdata.jdbc.hubdb.HubDBDriver
JdbcUrl=jdbc:hubdb:InitiateOAuth=GETANDREFRESH;
Tables=

Step 5: Start the MCP Server using the prepared HubDB configuration. The server runs as a stdio process and uses the configuration file you created.

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

Available tools

hubdb_get_tables

Retrieves a list of tables available in the HubDB data source. The output is provided in CSV format with the first line containing column headers.

hubdb_get_columns

Retrieves a list of columns for a specific table. The output is provided in CSV format with the first line containing column headers.

hubdb_run_query

Executes a SQL SELECT-like query against HubDB and returns the results.