Kintone MCP Server by CData

What is Kintone MCP Server by CData?

This is a read-only Model Context Protocol (MCP) server that enables large language models (LLMs) like Claude Desktop to query live data from Kintone. It wraps the CData JDBC Driver for Kintone, exposing Kintone data as relational SQL models accessed through natural language.

How to use Kintone MCP Server by CData?

Clone the repository, build with Maven (mvn clean install), download and license the CData JDBC Driver for Kintone, create a .prp file with your connection details, and configure the Claude Desktop client to point to the server JAR and .prp file. Once configured, ask the LLM questions like “How many open tickets do I have in the SUPPORT project?”.

Key features of Kintone MCP Server by CData

• Read-only access to Kintone data via the CData JDBC Driver.
• Exposes tools: get_tables, get_columns, and run_query (SQL SELECT).
• Uses stdio transport for local client execution.
• No SQL required – query with natural language.
• Integrates with Claude Desktop and similar MCP clients.

Use cases of Kintone MCP Server by CData

• Query live Kintone records from an AI assistant without manual SQL.
• Analyze Kintone ticket data (e.g., counts, correlations) through chat.
• Generate insights from Kintone apps using conversational prompts.
• Provide support teams with instant answers from Kintone databases.

FAQ from Kintone MCP Server by CData

Is this server read-only?

Yes, this project builds a read-only MCP server. For full create, update, delete, and action capabilities, use the separate beta version linked in the README.

What are the runtime dependencies?

You need Java, Maven (for building), and the CData JDBC Driver for Kintone (installed and licensed). The server runs as a standalone JAR.

Where does the Kintone data live?

Data resides in your Kintone instance (cloud or on-premise). The JDBC Driver connects to it directly; no local copy is created.

How is data transmitted?

The MCP server uses stdio transport, so it communicates with the MCP client over standard input/output on the same machine. No network listener is exposed.

Do I need to authenticate to Kintone?

Yes. Authentication is configured via the connection string utility of the JDBC Driver, which supports OAuth and other methods.