OpenLinkSoftware_mcp-jdbc-server
The Java based Model Context Protocol (MCP) Server for JDBC is a versatile tool for managing and interacting with databases through a lightweight server. It is compatible with multiple DBMS backends using JDBC drivers and offers features like schema fetching, table description, and executing queries.
Java based Model Context Protocol (MCP) Server for JDBC
A lightweight MCP server for JDBC built with Quakrus, compatible with Virtuoso DBMS and other DBMS backends with JDBC drivers.
Features
- Get Schemas: Fetch all schema names from the connected database.
- Get Tables: Retrieve table information for specific schemas.
- Describe Table: Provide details of table structures.
- Search Tables: Filter tables by name substrings.
- Execute Stored Procedures: Execute stored procedures, specific to Virtuoso.
- Execute Queries: Return results in JSONL or Markdown table format.
Prerequisites
- Java 21 or above required.
Installation
Clone the repository and navigate to the directory.
Environment Variables
Configure JDBC connection settings in the .env file.
Configuration
For Claude Desktop users, configuration can be added to claude_desktop_config.json.
Use
Provides tools for MCP client applications to interact with databases through various operations like jdbc_get_schemas, jdbc_get_tables, jdbc_describe_table, jdbc_filter_table_names, jdbc_query_database, jdbc_execute_query_md, among others.
Troubleshooting
Use MCP Inspector for basic MCP client troubleshooting with command-line instructions provided.