OpenLinkSoftware_mcp-jdbc-server
If you are the rightful owner of OpenLinkSoftware_mcp-jdbc-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A lightweight MCP server for JDBC built with Quarkus, compatible with Virtuoso DBMS and other DBMS backends with JDBC drivers.
The Java-based Model Context Protocol (MCP) Server for JDBC is a lightweight server built using Quarkus, designed to facilitate communication with databases through JDBC. It is particularly compatible with Virtuoso DBMS but can also work with other database management systems that support JDBC drivers. The server provides a range of functionalities, including schema and table retrieval, table description, and query execution. It supports both JSONL and Markdown formats for query results, making it versatile for different reporting and visualization needs. Additionally, it offers Virtuoso-specific features like executing stored procedures and SPARQL queries, enhancing its utility for users of the Virtuoso platform. The server requires Java 21 or above and can be configured using environment variables or JSON configuration files for integration with platforms like Claude Desktop.
Features
- Get Schemas: Fetch and list all schema names from the connected database.
- Get Tables: Retrieve table information for specific schemas or all schemas.
- Describe Table: Generate a detailed description of table structures, including column names, data types, nullable attributes, and keys.
- Search Tables: Filter and retrieve tables based on name substrings.
- Execute Stored Procedures: A Virtuoso-specific feature to execute stored procedures and retrieve results.
Tools
jdbc_get_schemas
List database schemas accessible to connected DBMS.
jdbc_get_tables
List tables associated with a selected database schema.
jdbc_describe_table
Provide the description of a table associated with a designated database schema.
jdbc_filter_table_names
List tables based on a substring pattern from the 'q' input field.
jdbc_query_database
Execute a SQL query and return results in JSONL format.
jdbc_execute_query
Execute a SQL query and return results in JSONL format.
jdbc_execute_query_md
Execute a SQL query and return results in Markdown table format.
jdbc_spasql_query
Execute a SPASQL query and return results.
jdbc_sparql_query
Execute a SPARQL query and return results.
jdbc_virtuoso_support_ai
Interact with LLMs through the Virtuoso Support Assistant/Agent.
