A RetroSearch Logo

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Search Query:

Showing content from https://github.com/OpenLinkSoftware/mcp-jdbc-server below:

OpenLinkSoftware/mcp-jdbc-server: Java based Model Context Procotol (MCP) Server for JDBC

OpenLink MCP Server for JDBC

A lightweight Java-based MCP (Model Context Protocol) server for JDBC built with Quakrus. This server is compatible with Virtuoso DBMS and any other DBMS backend that has a JDBC driver.

MCP server requires Java 21 or above.

Clone this repository:

git clone https://github.com/OpenLinkSoftware/mcp-jdbc-server.git  
cd mcp-jdbc-server

Update your .env by overriding these defaults to match your preferences:

jdbc.url=jdbc:virtuoso://localhost:1111
jdbc.user=dba
jdbc.password=dba
jdbc.api_key=xxx

For Claude Desktop users using Virtuoso and its JDBC driver:

Add the following to claude_desktop_config.json:

{
  "mcpServers": {
    "my_database": {
      "command": "java",
      "args": ["-jar", "/path/to/mcp-jdbc-server/MCPServer-1.0.0-runner.jar"],
      "env": {
        "jdbc.url": "jdbc:virtuoso://localhost:1111",
        "jdbc.user": "username",
        "jdbc.password": "password",
        "jdbc.api_key": "sk-xxx"
      }
    }
  }
}

For Claude Desktop users using another JDBC driver or a combination of drivers:

Add the following, edited to suit your local environment, to claude_desktop_config.json:

    "jdbc": {
      "command": "java",
      "args": [
        "-cp",
        "/path/to/mcp-jdbc-server/MCPServer-1.0.0-runner.jar:/path/to/jdbc_driver1.jar:/path/to/jdbc_driverN.jar",
        "io.quarkus.runner.GeneratedMain"
      ],
      "env": {
        "jdbc.url": "jdbc:virtuoso://localhost:1111",
        "jdbc.user": "dba",
        "jdbc.password": "dba"
      }
    }

After successful installation, the following tools will be available to MCP client applications.

name description jdbc_get_schemas List database schemas accessible to connected database management system (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. This includes information about column names, data types, nulls handling, autoincrement, primary key, and foreign keys. jdbc_filter_table_names List tables, based on a substring pattern from the q input field, associated with a selected database schema. 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 A Virtuoso-specific feature! Execute a SPASQL query and return results. jdbc_sparql_query A Virtuoso-specific feature! Execute a SPARQL query and return results. jdbc_virtuoso_support_ai A Virtuoso-specific feature! Interact with LLMs through the Virtuoso Support Assistant/Agent. Basic Use & Troubleshooting MCP Inspector Connecting to Virtuoso's ODBC Driver

For basic MCP client use and troubleshooting, use the MCP Inspector as follows:

  1. Install the MCP Inspector:

    npm install -g @modelcontextprotocol/inspector

  2. Start the inspector:

    npx @modelcontextprotocol/inspector java -jar /path/to/mcp-jdbc-server/MCPServer-1.0.0-runner.jar

Access the URL returned by the inspector to troubleshoot MCP server interactions.

MCP Inspector Connecting to additional Drivers

For basic MCP client use and troubleshooting, use the MCP Inspector as follows:

  1. Install the JDBC Driver(s), ensuring their JAR files are registered with the host operating system's Java Virtual Machine (JVM) via $CLASSPATH. For instance:

    export CLASSPATH=$CLASSPATH:/path/to/driver1.jar:/path/to/driver2.jar:/path/to/driverN.jar

  2. Start the inspector using the following command-line arguments:

    npx @modelcontextprotocol/inspector java -cp MCPServer-1.0.0-runner.jar:/path/to/driver1.jar:/path/to/driver2.jar:/path/to/driverN.jar io.quarkus.runner.GeneratedMain
Use Example based on Oracle and Informix Drivers

  1. Assuming the following JDBC Driver information:

  2. Install the Oracle (ojdbc17.jar) and/or Informix (jdbc-15.0.0.1.1.jar) JDBC Drivers, and ensure their JAR files are registered with the host operating system's Java Virtual Machine (JVM) via $CLASSPATH. For instance:

     export CLASSPATH=$CLASSPATH:/path/to/Java/Extensions/jdbc-15.0.0.1.1.jar
 export CLASSPATH=$CLASSPATH:/path/to/Java/Extensions/ojdbc17.jar

  3. Start the inspector using the following command-line arguments:

    npx @modelcontextprotocol/inspector java -cp MCPServer-1.0.0-runner.jar:/path/to/Java/Extensions/ojdbc17.jar:/path/to/Java/Extensions/jdbc-15.0.0.1.1.jar io.quarkus.runner.GeneratedMain

  4. Access the URL returned by the inspector and then use the jdbc_execute_query operation to query the target database, by providing actual values for the following input field templates:

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4