JDBC Explorer
About
A server that enables LLMs to connect and interact with databases via JDBC, built using the Spring AI MCP framework.
Details
- Author
- mikechao
- Categories
- Database
Jump to
Setup
Install JDBC Explorer in your MCP client (Claude Desktop, Cursor, Windsurf, and others).
Repository: https://github.com/mikechao/jdbc-explorer
Follow the installation instructions in the repository README, then restart your MCP client.
AModel Context Protocolserver for connecting LLM to databases via JDBC. This server is implemented using theSpring AI MCPframework. The server exposes tools, a prompt and resources to interact with the connected database.
The server contains the following tools.
- Adds business insights discovered during data analysis to the "Business Insights" resource. Usually executed as part of the prompt "data-explorer"
- Inputs:
- insight(String): business insight discovered during data analysis
- Executes a SQL query against the connected database, returning the results
- Inputs:
- query(string): the SQL query to be executed
- Gets the table names, including type, schema, and remarks
- Inputs: none
- Describe a table in the database including column information, primary keys, foreign keys, and indexes.
- Inputs:
- catalog(string, optional): Catalog Name
- schema(string, optional): Schema Name
- tableName(string): Name of the table to get description for
- Get information about the database including SQL dialect, keywords, database product name, etc.
- Inputs: none
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.
- Contains the list of business insights that the LLM came up with during data analysis.
- uri: "memo://insights"
This server currently supports the following databases.
Sample movie data based on Netflix catalogNetflix sample DB
Classic Microsoft sample database with customers, orders, products etc.
Sample music store data including artists, albums, tracks, invoices etc.
- Download the jar from theReleases
- Or clone the repo and build the jar with maven
Add this to yourclaude_desktop_config.json:
{ "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" ] } } }
{ "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" ] } } }
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
Add this to yourclaude_desktop_config.json:
{ "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" ] } } }
Contributions are welcome! Please feel free to submit a Pull Request.
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.
Official Airtable MCP server and skills for working with bases, records, workflows, and business operations from AI agents.
MCP Server For Apache Doris, an MPP-based real-time data warehouse.
Official MCP Server from Atlan which enables you to bring the power of metadata to your AI tools
Query Onchain data, like ERC20 tokens, transaction history, smart contract state.
Read and write access to your Baserow tables.
Introspect and query your apps deployed to Convex.
Interact with the data stored in Couchbase clusters using natural language.
Maritime intelligence for tracking vessels, analysing ports, and exploring ship data.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
