What are the prerequisites for using Tsurugi MCP server?

You need Tsurugi version 1.4.0 or later and Java 21 or later installed on your system.

How do I configure Tsurugi MCP server to work with Claude Desktop?

Add a configuration block to your `claude_desktop_config.json` file, specifying the command to execute the server JAR and connection details to your Tsurugi instance.

What transaction types are supported by Tsurugi MCP server?

The server supports OCC (Optimistic Concurrency Control), LTX (Long Transaction), and RTX transaction types for SQL operations, providing flexibility for different use cases.

What database operations can I perform using Tsurugi?

You can execute SQL queries (SELECT, INSERT, UPDATE, DELETE) and DDL statements (CREATE, DROP). Transaction type options like OCC and LTX are also supported.

What is Tsurugi MCP server?

Tsurugi MCP server provides a Model Context Protocol interface to access the Tsurugi database. It allows you to list tables, retrieve metadata, execute SQL queries, and perform DDL operations.

Tsurugi

Name: Tsurugi
Author: project-tsurugi

•

Provides a Model Context Protocol server to access the Tsurugi database.

The Tsurugi MCP server enables access to the Tsurugi database through the Model Context Protocol. It offers a range of tools for managing and querying the database, including listing table names, retrieving table metadata, executing SQL queries and updates, and executing DDL statements. Configuration is provided for use with Claude Desktop, allowing seamless integration. It supports different transaction types (OCC, LTX, RTX) and provides options to enable/disable tools, resources, and prompts to tailor the server's functionality to specific needs.

主な機能

01Supports listing table names and retrieving table metadata.

020 GitHub stars

03Facilitates SQL updates (insert, update, delete) with transaction type options.

04Configurable for use with Claude Desktop.

05Enables execution of SQL queries (select) with continuation support via cursors.

06Allows execution of DDL statements (create, drop) with transaction type choices.

ユースケース

01Providing a read-only interface to Tsurugi for data analysis.

02Integrating Tsurugi database with applications via MCP.

03Managing and querying Tsurugi database schema and data.