home / mcp / apache hbase mcp server

Apache HBase MCP Server

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

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

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

You can query live Apache Hbase data through a read-only MCP server that wraps the CData JDBC Driver. This server exposes data as MCP tools so you can ask natural language questions and retrieve up-to-date results without writing SQL.

How to use

After you start the MCP server, you interact with it through an MCP client. You do not manually call SQL; instead, you rely on built-in tools that translate your questions into data operations. You can ask questions like you would ask a data assistant, and the client will use the available tools to fetch, filter, and present results from Apache Hbase.

How to install

Prerequisites you need before building and running the MCP server:

Java Development Kit (JDK) installed and available on your PATH
Maven installed and available on your PATH
Git installed to clone the project

1. Clone the project repository and navigate into the project directory.

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

2. Build the server to create the MCP JAR with dependencies.

mvn clean install

3. Obtain and license the CData JDBC Driver for Apache Hbase. Follow the driver’s licensing steps in your environment to ensure the driver is usable in the JVM.

4. Configure the JDBC connection and create the MCP properties file for Apache Hbase. You will typically create a file named apache-hbase.prp with your connection details including the JDBC URL and driver information.

5. Example contents for the MCP properties file apache-hbase.prp

Prefix=apachehbase
ServerName=CDataApacheHbase
ServerVersion=1.0
DriverPath=PATH\\TO\\cdata.jdbc.apachehbase.jar
DriverClass=cdata.jdbc.apachehbase.ApacheHbaseDriver
JdbcUrl=jdbc:apachehbase:InitiateOAuth=GETANDREFRESH;
Tables=

Starting the MCP server

Run the MCP server locally using the built JAR and the MCP properties file you created. The server runs via standard input/output, so you can connect from clients on the same machine.

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/apache-hbase.prp

Available tools

apachehbase_get_tables

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

apachehbase_get_columns

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

apachehbase_run_query

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