Java based Model Context Procotol (MCP) Server for JDBC

@OpenLinkSoftware

关于 Java based Model Context Procotol (MCP) Server for JDBC

Java based Model Context Procotol (MCP) Server for JDBC

基本信息

分类

其他

许可证

MIT

运行时

java

传输方式

stdio

发布者

OpenLinkSoftware

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp-jdbc-server": {
      "command": "npx",
      "args": [
        "@modelcontextprotocol/inspector",
        "java",
        "-jar",
        "/path/to/mcp-jdbc-server/MCPServer-1.0.0-runner.jar"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Java based Model Context Procotol (MCP) Server for JDBC?

A lightweight Java-based MCP server built with Quarkus that enables MCP clients to interact with any JDBC-compliant database management system, including OpenLink Virtuoso. It provides tools for schema inspection, query execution, and Virtuoso-specific features.

How to use Java based Model Context Procotol (MCP) Server for JDBC?

Clone the repository, configure environment variables (jdbc.url, jdbc.user, jdbc.password, jdbc.api_key), then run the server using java -jar MCPServer-1.0.0-runner.jar. For Claude Desktop, add the server configuration to claude_desktop_config.json with the appropriate command and environment variables.

Key features of Java based Model Context Procotol (MCP) Server for JDBC

Get database schemas accessible to the connected DBMS.
List tables for a selected schema.
Describe table structure including columns, keys, and nullability.
Filter table names by substring pattern.
Execute SQL queries returning results in JSONL format.
Execute SQL queries returning results as Markdown tables.
Execute Virtuoso-specific SPASQL, SPARQL queries, and AI assistant.

Use cases of Java based Model Context Procotol (MCP) Server for JDBC

Exploring database schemas and table structures from an MCP client.
Running ad hoc SQL queries and formatting results for reporting or analysis.
Leveraging Virtuoso’s hybrid SQL/SPARQL capabilities within MCP workflows.
Integrating any JDBC-compatible database as a data source for AI assistants.

FAQ from Java based Model Context Procotol (MCP) Server for JDBC

What are the runtime requirements?

Java 21 or above is required.

Which databases are supported?

Any DBMS with a JDBC driver, with special support for OpenLink Virtuoso (stored procedures, SPASQL, SPARQL, and an AI assistant).

How do I use a non-Virtuoso JDBC driver?

Include the driver JAR files in the classpath using -cp and start the server with io.quarkus.runner.GeneratedMain as the main class.

What output formats are available for queries?

Results can be returned in JSONL (line-delimited JSON), JSON, or Markdown table format.

Is an API key required?

Yes, the jdbc.api_key environment variable is required; it can be set to a dummy value for internal use.

评论

其他分类下的更多 MCP 服务器

Nginx UI

Yet another WebUI for Nginx

IDA Pro MCP

AI-powered reverse engineering assistant that bridges IDA Pro with language models through MCP.

FastMCP v2 🚀

🚀 The fast, Pythonic way to build MCP servers and clients.

Awesome-MCP-ZH

MCP 资源精选， MCP指南，Claude MCP，MCP Servers, MCP Clients

Production-ready MCP integrations for AI applications

Klavis AI: MCP integration platforms that let AI agents use tools reliably at any scale