mcp-jdbc-server
If you are the rightful owner of 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 seamless interaction 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 features that allow users to interact with databases, such as fetching schema and table information, executing queries, and running stored procedures. It supports various output formats, including JSONL and Markdown, making it suitable for structured data handling and reporting. 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: Execute stored procedures and retrieve results, specifically for Virtuoso.
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
qinput field.jdbc_query_database
Execute a SQL query and return results in JSONL format.
