MCP.so
Sign In

Java based Model Context Procotol (MCP) Server for JDBC

@OpenLinkSoftware

Repository

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

Java based Model Context Procotol (MCP) Server for JDBC

Basic information

Category

Other

License

MIT

Runtime

java

Transports

stdio

Publisher

OpenLinkSoftware

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

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

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.

Comments

More Other MCP servers

ICSS

chokcoco

不止于 CSS

20.7K

Mcp

browsermcp

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

6.8K

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

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

🪟 Windows-MCP

CursorTouch

MCP Server for Computer Use in Windows

6.3K