mcp-jdbc-server

mcp-jdbc-server

1
databases

This project provides a Model Context Protocol server specifically designed for JDBC. It facilitates interaction with databases like Virtuoso DBMS, allowing operations such as schema and table retrieval, query executions, and more. Notably, it supports features exclusive to Virtuoso, enhancing database management capabilities.

Java based Model Context Protocol (MCP) Server for JDBC

A lightweight MCP server for JDBC built with Quarkus. This server is compatible with Virtuoso DBMS and other DBMS backends that have JDBC drivers.

Features

  • Fetch and list schema names.
  • Retrieve table information.
  • Generate a detailed description of table structures.
  • Filter and retrieve tables by name.
  • Execute stored procedures and queries.

Prerequisites

  • Requires Java 21 or above.

Installation

Clone the repo and navigate to the directory.

Use

Tools available for MCP client applications: schema listing, table information, detailed table descriptions, query executions in JSON and Markdown formats, SPASQL and SPARQL queries for Virtuoso, and AI support interactions.

Troubleshooting

Use MCP Inspector for client use troubleshooting.