Tsurugi

v1.0.0Databasesstable

MCP server to access Tsurugi

mcp-servertsurugidb
Share:
9
Stars
0
Downloads
0
Weekly
0/5

What is Tsurugi?

Tsurugi is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to mcp server to access tsurugi

MCP server to access Tsurugi

This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.

Features

  • MCP server to access Tsurugi

Use Cases

Access Tsurugi database functionality through MCP.
project-tsurugi

Maintainer

LicenseApache-2.0
Languagejava
Versionv1.0.0
UpdatedApr 16, 2026
Statushealthy
Maintenanceactive

Works with

ClaudeOpenAIwindowsmacoslinux

Installation

Manual Installation

npx tsurugi

Configuration

Configuration Details

Config File

claude_desktop_config.json

Performance

Response Metrics

Response Time< 200ms
ThroughputMedium

Resource Usage

Memory UsageLow
CPU UsageLow

How to Set Up and Use Tsurugi

The Tsurugi MCP Server is a Java-based MCP server that provides AI assistants with direct SQL access to TsurugiDB, a high-performance transactional database developed by NTT. It exposes five tools covering table discovery, schema inspection, SELECT queries with transaction type selection, INSERT/UPDATE/DELETE operations, and DDL execution. The server connects to a running TsurugiDB instance over TCP or IPC and supports multiple authentication methods including username/password, auth tokens, and credential files. It requires Java 21+ and TsurugiDB 1.11.0 or later.

Prerequisites

  • Java 21 or later installed and available on the PATH
  • TsurugiDB 1.11.0 or later installed and running
  • The tsurugi-mcp-server JAR file downloaded from the GitHub releases page
  • Network access to the TsurugiDB endpoint (TCP URL such as tcp://localhost:12345)
  • Claude Desktop or another MCP-compatible AI client
1

Download the server JAR from the releases page

Visit the GitHub releases page at https://github.com/project-tsurugi/tsurugi-mcp-server/releases and download the latest tsurugi-mcp-server-all.jar file.

# Example using curl to download the JAR:
curl -L -o tsurugi-mcp-server-all.jar \
  https://github.com/project-tsurugi/tsurugi-mcp-server/releases/latest/download/tsurugi-mcp-server-all.jar
2

Alternatively build from source with Gradle

If you prefer to build from source, clone the repository and use the Gradle shadowJar task to produce the fat JAR.

git clone https://github.com/project-tsurugi/tsurugi-mcp-server.git
cd tsurugi-mcp-server
./gradlew shadowJar
# Output: build/libs/tsurugi-mcp-server-all.jar
3

Test the connection to TsurugiDB

Run the server manually to verify it can connect to your TsurugiDB instance. The -c flag specifies the connection endpoint URL.

java -jar /path/to/tsurugi-mcp-server-all.jar -c tcp://localhost:12345
4

Add the server to Claude Desktop configuration

Edit claude_desktop_config.json to add the tsurugidb server entry. Adjust the JAR path and connection URL to match your environment.

{
  "mcpServers": {
    "tsurugidb": {
      "command": "java",
      "args": [
        "-jar",
        "/path/to/tsurugi-mcp-server-all.jar",
        "-c", "tcp://localhost:12345"
      ]
    }
  }
}
5

Configure authentication if required

TsurugiDB supports several authentication methods. Choose the one that matches your database configuration.

# Username and password
java -jar tsurugi-mcp-server-all.jar -c tcp://localhost:12345 --user admin --password secret

# Auth token via environment variable
export TSURUGI_AUTH_TOKEN=your_token
java -jar tsurugi-mcp-server-all.jar -c tcp://localhost:12345

# Credential file
java -jar tsurugi-mcp-server-all.jar -c tcp://localhost:12345 --credentials /path/to/creds

# No authentication
java -jar tsurugi-mcp-server-all.jar -c tcp://localhost:12345 --no-auth
6

Restart Claude Desktop and query the database

After restarting Claude Desktop, ask it to list tables or query data to confirm the Tsurugi MCP tools are connected.

Tsurugi Examples

Client configuration

Claude Desktop configuration for the Tsurugi MCP Server with TCP connection and credential file authentication.

{
  "mcpServers": {
    "tsurugidb": {
      "command": "java",
      "args": [
        "-jar",
        "/opt/tsurugi/tsurugi-mcp-server-all.jar",
        "-c", "tcp://localhost:12345",
        "--credentials", "/home/user/.tsurugi/credentials"
      ]
    }
  }
}

Prompts to try

Use natural language to explore the TsurugiDB schema and run queries through Claude.

- "List all tables available in the TsurugiDB database"
- "Show me the schema and column types for the orders table"
- "Run a SELECT query to get the 10 most recent orders sorted by date descending"
- "Insert a new record into the products table with name 'Widget' and price 9.99"
- "Create a new table called audit_log with columns id, action, and timestamp"

Troubleshooting Tsurugi

Connection refused when starting the server

Ensure TsurugiDB 1.11.0 or later is running and listening on the specified TCP port. Verify the endpoint URL format — it should be tcp://host:port or ipc:path for local connections. Check TsurugiDB logs for any startup errors.

Java version error on startup

The server requires Java 21 or later. Run 'java -version' to check your current version. If you have multiple Java versions installed, set JAVA_HOME to point to Java 21+ and ensure the correct java binary is used in the command field of your MCP config.

Authentication failure connecting to TsurugiDB

Check which authentication method your TsurugiDB instance expects. If using a credential file, ensure the path in --credentials is absolute and the file has the correct permissions. The TSURUGI_AUTH_TOKEN environment variable takes priority over other auth methods if set, which can cause unexpected failures.

Frequently Asked Questions about Tsurugi

What is Tsurugi?

Tsurugi is a Model Context Protocol (MCP) server that mcp server to access tsurugi It connects AI assistants to external tools and data sources through a standardized interface.

How do I install Tsurugi?

Follow the installation instructions on the Tsurugi GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.

Which AI clients work with Tsurugi?

Tsurugi works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.

Is Tsurugi free to use?

Yes, Tsurugi is open source and available under the Apache-2.0 license. You can use it freely in both personal and commercial projects.

Browse More Databases MCP Servers

Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.

Quick Config Preview

{ "mcpServers": { "tsurugi": { "command": "npx", "args": ["-y", "tsurugi"] } } }

Add this to your claude_desktop_config.json or .cursor/mcp.json

Read the full setup guide →

Ready to use Tsurugi?

Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.

33,000+ ServersFree & Open SourceStep-by-Step Guides