Java based Model Context Procotol (MCP) Server for JDBC

@OpenLinkSoftware

About Java based Model Context Procotol (MCP) Server for JDBC

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

Fetch the live tool list by running this server in a temporary sandbox using the button above.

Overview

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.

Frequently asked questions

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.

Comments

Basic information

More Other MCP servers

AutoBrowser MCP

autobrowser-ai

Browser MCP is a Model Context Provider (MCP) server that allows AI applications to control your browser

6.8K

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.

Unity MCP ✨

justinpbarnett

Unity MCP acts as a bridge between AI assistants and your Unity Editor. Give your LLM tools to manage assets, control scenes, edit scripts, and automate tasks within Unity.

12.2K

Nginx UI

0xJacky

Yet another WebUI for Nginx

11.3K

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K