Advertise
MCP.so
Sign In

Java based Model Context Procotol (MCP) Server for JDBC

@OpenLinkSoftware

Repository

Basic information

Category

Other

License

MIT

Transports

stdio

Author

OpenLinkSoftware

About 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 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"
      ]
    }
  }
}

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

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

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.

Frequently asked questions

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.

Comments

More Other MCP servers

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

The Living Bread

The Living Bread

A free remote MCP server for The Living Bread. Bible passages read word for word from a stored public domain text with an evidence label, keyword search and cross references, real churches, gatherings and prayer groups w

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

Advertise