Node JDBC MCP Server

🚀 JDBC MCP Server Based on Node.js

This is a JDBC MCP server based on Node.js, supporting MySQL, Oracle, and SQLite databases.

🚀 Quick Start

✨ Features

• This server is built on Node.js, offering high - performance and efficient database access.
• It supports multiple database types, including MySQL, Oracle, and SQLite.

📦 Installation

System Requirements

• Node.js >= 18.0.0
• MySQL Server
• Oracle Database (Optional)
• SQLite3

Steps

1. Clone the project:

git clone [repository-url]
cd node-jdbc-server

2. Install dependencies:

npm install

3. Configure environment variables: Copy the .env.example file to .env and modify the configuration according to your actual situation.

💻 Usage Examples

Basic Usage

1. Start the server:

npm start

2. Start in development mode (supports hot reloading):

npm run dev

📚 Documentation

API Interfaces

Health Check

GET /health

Execute SQL Query

POST /query
Content-Type: application/json

{
  "type": "mysql|oracle|sqlite",
  "sql": "SELECT * FROM users WHERE id = ?",
  "params": [1]
}

Close Database Connection

POST /close
Content-Type: application/json

{
  "type": "mysql|oracle|sqlite"
}

⚠️ Important Note

1. When using the Oracle database, you need to install the Oracle client.
2. Ensure that the database server is started and accessible.
3. Configure the database connection information correctly.
4. It is recommended to use environment variables to manage sensitive information in the production environment.