tsurugi-mcp-server

project-tsurugi/tsurugi-mcp-server

3.4

If you are the rightful owner of tsurugi-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The Tsurugi MCP Server is a Model Context Protocol server designed to interface with the Tsurugi database, providing a structured way to access and manipulate data.

The Tsurugi MCP Server is a specialized server that facilitates communication with the Tsurugi database using the Model Context Protocol (MCP). It is designed to work with Tsurugi version 1.4.0 or later and requires Java 21 or later to operate. The server provides a suite of tools that allow users to perform various database operations such as querying, updating, and managing table schemas. It is particularly useful for developers and database administrators who need a reliable and efficient way to interact with Tsurugi databases. The server can be integrated with different platforms, including Claude Desktop, by configuring the appropriate settings in the platform's configuration files. This integration allows for seamless data management and manipulation, making it a valuable tool for those working with large datasets or complex database structures.

Features

  • Supports Tsurugi 1.4.0 or later and requires Java 21 or later.
  • Provides tools for listing table names, retrieving table metadata, and executing SQL queries.
  • Allows for the execution of DDL commands to create or drop database structures.
  • Can be configured for read-only access by limiting the tools used.
  • Integrates with platforms like Claude Desktop for enhanced functionality.

Tools

  1. listTableNames

    List table names.

  2. getTableMetadata

    Get table metadata (table schema).

  3. query

    Execute SQL (select).

  4. update

    Execute SQL (insert, update, delete).

  5. executeDdl

    Execute DDL (create, drop).