Tsurugi
MCP server to access Tsurugi
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
Maintainer
Works with
Installation
Manual Installation
npx tsurugiConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
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
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.jarAlternatively 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.jarTest 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:12345Add 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"
]
}
}
}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-authRestart 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.
Tsurugi Alternatives — Similar Databases Servers
Looking for alternatives to Tsurugi? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
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.
Set Up Tsurugi in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
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.