Overview
OpenLink MCP Server for JDBC is a lightweight Java-based MCP (Model Context Protocol) server built with Quakrus that serves as a bridge between MCP clients and relational databases via JDBC. It is designed to work with Virtuoso DBMS and any other DBMS backend that provides a JDBC driver. The server exposes MCP operations to discover and introspect database structure, including getting schemas, listing tables, and describing tables (columns, data types, nullability, and keys). It also supports filtering tables by name and executing stored procedures (Virtuoso-specific). For data retrieval, it can execute standard SQL queries and return results in multiple formats, notably JSONL and Markdown tables. Prerequisites include Java 21 or higher. Configuration is achieved through environment variables (jdbc.url, jdbc.user, jdbc.password, jdbc.api_key) and optional Claude Desktop JSON configurations for desktop tooling. The MCP inspector can connect directly to the server or via additional JDBC drivers registered in the JVM classpath. This server is suitable for development, testing, and integration workflows requiring MCP-based access to JDBC-backed databases.
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
Provide a detailed description of a table, including column names, data types, nullability, and keys.
Search Tables
Filter and retrieve tables based on a substring match of table names.
Execute Stored Procedures
Virtuoso-specific feature to execute stored procedures and retrieve results.
Execute Queries (JSONL)
Execute a SQL query and return results in JSON Lines format.
Execute Queries (Markdown)
Execute a SQL query and return results formatted as a Markdown table.
