JDBC Explorer

A Model Context Protocol server for connecting LLM to databases via JDBC. This server is implemented using the Spring AI MCP framework. The server exposes tools, a prompt and resources to interact with the connected database.

Tools 🛠

The server contains the following tools.

• addBusinessInsight

• executeQuery

• getTableNames

• describeTable

• getDatabaseInfo

Prompts 📄

The server contains 1 prompt.

• data-explorer

This prompt helps the user explore the data in their databases. It should present the user with a choice of dashboards that the LLM can create. The LLM will then execute the necessary queries and create the selected dashboard using an artifact.

The prompt result in Claude Desktop

Resources 🗂️

The server contains 1 resource.

• Business Insights

Supported JDBC variants

This server currently supports the following databases.

Example Databases

Netflix Movies

Sample movie data based on Netflix catalog

Netflix sample DB

Northwind

Classic Microsoft sample database with customers, orders, products etc.

Northwind Sqlite

Chinook

Sample music store data including artists, albums, tracks, invoices etc.

Chinook Database

Usage with Claude Desktop

From jar

1. Download the jar from the Releases

2. Or clone the repo and build the jar with maven

mvn clean package

Add this to your `claude_desktop_config.json`:

Sqlite

{
    "mcpServers": {
		  "jdbc-explorer": {
			"command": "java",
			"args": [
			  "-jar",
			  "C:\\\\mcp\\\\jdbc.explorer-0.4.0.jar",
			  "--db.url=jdbc:sqlite:C:\\\\mcp\\\\jdbc-explorer\\\\netflixdb.sqlite"
			]
		  }
	}
}

Database with username and password

{
    "mcpServers": {
		  "jdbc-explorer": {
			"command": "java",
			"args": [
			  "-jar",
			  "C:\\\\mcp\\\\jdbc.explorer-0.4.0.jar",
			  "--db.url=jdbc:postgresql://localhost:5432/chinook",
			  "--db.username=dbuser",
			  "--db.password=dbpassword"
			]
		  }
	}
}

From Docker image

You can either build the image locally or pull it from GitHub Container Registry:

Option 1: Pull from GitHub Container Registry

docker pull ghcr.io/mikechao/jdbc-explorer:latest

Option 2: Build locally

1. Clone the repo

2. Build the docker image

docker build -t jdbc-explorer .

Add this to your `claude_desktop_config.json`:

Database with username and password

{
    "mcpServers": {
		  "jdbc-explorer": {
			"command": "docker",
			"args": [
			  "run",
			  "-i",
			  "--rm",
			  "-e",
			  "DB_URL=jdbc:postgresql://host.docker.internal:5432/chinook",
			  "-e",
			  "DB_USERNAME=dbuser",
			  "-e",
			  "DB_PASSWORD=dbpassword",
			  "ghcr.io/mikechao/jdbc-explorer"
			]
		  }
	}
}

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

License

This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.