A collection of MCP examples developed with Java SDKs.

• Java 17 or later
• Maven 3.9.16 or the included Maven Wrapper
• Docker with Docker Compose

The Model Context Protocol (MCP) lets servers expose data and functionality to LLM applications in a standardized way. MCP servers can expose resources, tools, prompts, and more.

• JDBC Server - Exposes JDBC database metadata through an MCP resource

The JDBC example includes an annotated-sdk implementation backed by a JDBC connection. The packaged server starts in STDIO mode by default.

Implemented resource:

• db://schema - Returns database product/version plus table and column metadata as JSON

JDBC configuration for the MCP server process:

• JDBC_URL is required
• JDBC_USERNAME is optional
• JDBC_PASSWORD is optional

Sample database:

• MySQL runs in Docker with initialization data from mcp-server-jdbc/mcp-server-jdbc-common/src/test/resources/init.sql

Start the sample MySQL database:

docker compose -f mcp-server-jdbc/docker-compose.yml up -d

The container initializes the mcp_examples database on first startup. To recreate the database from init.sql, remove the container and start it again:

docker compose -f mcp-server-jdbc/docker-compose.yml down -v
docker compose -f mcp-server-jdbc/docker-compose.yml up -d

Build the MCP server jar first:

./mvnw -pl mcp-server-jdbc/mcp-server-jdbc-annotated-sdk -am package

On Windows PowerShell, use .\mvnw.cmd instead of ./mvnw.

The jar is created at:

• mcp-server-jdbc/mcp-server-jdbc-annotated-sdk/target/mcp-server-jdbc-annotated-sdk.jar

Use these paths in the examples below:

• <repo> - absolute path to this repository
• <jar> - <repo>/mcp-server-jdbc/mcp-server-jdbc-annotated-sdk/target/mcp-server-jdbc-annotated-sdk.jar
• <mysql-url> - jdbc:mysql://127.0.0.1:3306/mcp_examples?allowPublicKeyRetrieval=true&useSSL=false&nullCatalogMeansCurrent=true

For Windows paths in JSON/TOML, prefer forward slashes, for example C:/Users/me/code/mcp-java-sdk-examples/....

Start Inspector with the JDBC server as a STDIO server:

npx @modelcontextprotocol/inspector \
  -e JDBC_URL="<mysql-url>" \
  -e JDBC_USERNAME=mcp \
  -e JDBC_PASSWORD=mcp \
  -- java -jar <jar>

Open the Inspector URL printed in the terminal, then browse the db://schema resource.

Add the server to Claude Desktop MCP settings:

{
  "mcpServers": {
    "jdbc-mcp-server": {
      "command": "java",
      "args": ["-jar", "<jar>"],
      "env": {
        "JDBC_URL": "<mysql-url>",
        "JDBC_USERNAME": "mcp",
        "JDBC_PASSWORD": "mcp"
      }
    }
  }
}

Restart Claude Desktop, then browse the db://schema resource from the MCP tools/resources panel.

Add the server with the Codex CLI:

codex mcp add jdbc-mcp-server \
  --env JDBC_URL="<mysql-url>" \
  --env JDBC_USERNAME=mcp \
  --env JDBC_PASSWORD=mcp \
  -- java -jar <jar>

Or add it to ~/.codex/config.toml or a trusted project .codex/config.toml:

[mcp_servers.jdbc-mcp-server]
command = "java"
args = ["-jar", "<jar>"]

[mcp_servers.jdbc-mcp-server.env]
JDBC_URL = "<mysql-url>"
JDBC_USERNAME = "mcp"
JDBC_PASSWORD = "mcp"

Add this server in Cursor MCP settings:

{
  "mcpServers": {
    "jdbc-mcp-server": {
      "command": "java",
      "args": ["-jar", "<jar>"],
      "env": {
        "JDBC_URL": "<mysql-url>",
        "JDBC_USERNAME": "mcp",
        "JDBC_PASSWORD": "mcp"
      }
    }
  }
}

Open Cline MCP settings and add:

{
  "mcpServers": {
    "jdbc-mcp-server": {
      "command": "java",
      "args": ["-jar", "<jar>"],
      "env": {
        "JDBC_URL": "<mysql-url>",
        "JDBC_USERNAME": "mcp",
        "JDBC_PASSWORD": "mcp"
      }
    }
  }
}

Create or update .vscode/mcp.json:

{
  "servers": {
    "jdbc-mcp-server": {
      "type": "stdio",
      "command": "java",
      "args": ["-jar", "<jar>"],
      "env": {
        "JDBC_URL": "<mysql-url>",
        "JDBC_USERNAME": "mcp",
        "JDBC_PASSWORD": "mcp"
      }
    }
  }
}

For databases that require credentials, add them to the MCP server environment:

"env": {
  "JDBC_URL": "<mysql-url>",
  "JDBC_USERNAME": "mcp",
  "JDBC_PASSWORD": "mcp"
}