广告合作
MCP.so
登录

Java based Model Context Procotol (MCP) Server for JDBC

@OpenLinkSoftware

代码仓库

基本信息

分类

其他

许可证

MIT

传输方式

stdio

作者

OpenLinkSoftware

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

Java based Model Context Procotol (MCP) Server for JDBC

Java based Model Context Procotol (MCP) Server for JDBC 配置

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

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

Java based Model Context Procotol (MCP) Server for JDBC 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

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.

常见问题

1

What are the runtime requirements?

Java 21 or above is required.

2

Which databases are supported?

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

3

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.

4

What output formats are available for queries?

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

5

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 服务器

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

Health by Dr Brad

Dr Brad Stanfield

Health by Dr Brad works out a health plan from your own results: which screening is due at your age, and evidence-based suggestions, each with the reason and the published guideline or study behind it. Your record is one

P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K
广告合作