広告掲載
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.

コメント

「その他」の他のコンテンツ

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

🚀 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

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

ICSS

chokcoco

不止于 CSS

20.7K
広告掲載