Labsco
MCP SERVER

CData IBM Cloud Object Storage

by CDataSoftware

Ask about buckets and objects in IBM Cloud Object Storage in plain English, answered as SQL SELECTs.

SaaS-to-SQL Connectors
Summary
Object storage, addressed as rows.

Storage questions are usually shaped like queries — what is in this bucket, how big, how old, changed by whom — and the console makes you browse for them instead. The driver flattens buckets and object metadata into tables, so the assistant can aggregate rather than page. It reads only: nothing here uploads, moves or deletes an object. Setup is a Maven build, a licensed driver and a property file.

What it is

A local, read-only bridge between an assistant and IBM Cloud Object Storage. CData's JDBC driver exposes IBM Cloud Object Storage as relational SQL models; this server wraps the driver so a model can discover the tables and query them, and you can ask in plain language instead of writing SQL. It runs over stdio, so the client has to be on the same machine.

What you get
  • `get_tables` lists the tables the driver exposes, returned as CSV with a header row
  • `get_columns` lists the columns on one of those tables, in the same CSV shape
  • `run_query` executes a SQL SELECT against live IBM Cloud Object Storage data
  • Tool names carry the prefix you set in the property file — the sample config uses `Prefix=ibmcloudobjectstorage`
  • Leaving `Tables=` blank exposes everything the driver can reach; naming tables there narrows it
Requirements

Java and Maven: `mvn clean install` builds `CDataMCP-jar-with-dependencies.jar`. Separately install the CData JDBC Driver for IBM Cloud Object Storage and license it by running `java -jar cdata.jdbc.ibmcloudobjectstorage.jar --license`, entering `TRIAL` or a license key. Build the connection string with the same jar, authenticating in the browser if the source uses OAuth, then write a `.prp` file naming the driver path, the driver class `cdata.jdbc.ibmcloudobjectstorage.IBMCloudObjectStorageDriver` and that JDBC URL. Point your client at `java -jar` with the built jar and the `.prp` file.

Setup effort

Build from source — clone the repository and build it, then point your client at the binary