You can run a local MCP server that exposes Kintone data as MCP tools, enabling LLMs to query live data without writing SQL. This server wraps the CData JDBC Driver for Kintone and presents a simple MCP interface for read-only access to Kintone data, making it easy to ask natural-language questions and get live results.

How to use

Start the MCP server on your machine and connect your MCP client (such as Claude Desktop) to it. You will use a local stdio-based server process that reads a prepared .prp configuration and serves data through the MCP interface. Once running, you can ask questions like “What is the number of open tickets in the SUPPORT project?” or “Which accounts have activity this month?” The server surfaces tables and columns so your client can discover data structure and then execute read-only queries through the built-in tools.

How to install

Prerequisites you need before installation: a Java Development Kit (JDK) installed on your machine, and a Maven-enabled project to build the MCP server jar.

Step 1: Clone the project repository and navigate into it.

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

Step 2: Build the server JAR with dependencies.

mvn clean install

Step 3: Install the CData JDBC Driver for Kintone from the official source and license it. This enables the MCP server to connect to Kintone.

# Download and install the driver from the vendor's site, then license it using the provided jar
java -jar cdata.jdbc.kintone.jar --license

Step 4: Configure your JDBC connection to Kintone by running the connection string utility and testing the connection. Copy the resulting JDBC URL string for later use.

java -jar cdata.jdbc.kintone.jar

Configure connection and test, then copy the JDBC URL string

## Additional configuration and startup notes

Step 5: Create a .prp configuration file for the JDBC connection and the MCP server. Use the properties shown in the example below.

Prefix=kintone ServerName=CDataKintone ServerVersion=1.0 DriverPath=PATH\TO\cdata.jdbc.kintone.jar DriverClass=cdata.jdbc.kintone.KintoneDriver JdbcUrl=jdbc:kintone:InitiateOAuth=GETANDREFRESH; Tables=

## Running the MCP server

Run the MCP server using the Java runtime with the prepared configuration file. This starts a local stdio server that can be used with the MCP client on the same machine.

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

## Notes on usage with Claude Desktop

Configure Claude Desktop to load the new MCP server by adding an entry to the MCP config, specifying the Java command and arguments to run the jar with your kintone.prp file. After updating the config, restart Claude Desktop so the MCP server appears in the client.

## Available tools

### kintone\_get\_tables

Retrieves a list of tables (data sources) available from the Kintone connection. The resulting output is provided as CSV with the first line containing column headers.

### kintone\_get\_columns

Retrieves a list of columns for a specified table. The output is CSV with a header row.

### kintone\_run\_query

Executes a SQL SELECT query against the connected Kintone data source and returns the results.