Node-JDBC-MCP-Server

Node-JDBC-MCP-Server

0
databases

The Node.js JDBC MCP Server enables users to interact with MySQL, Oracle, and SQLite databases using standard SQL queries. It requires Node.js 18 or higher and provides simple API endpoints for executing SQL commands and managing database connections.

Node.js JDBC MCP Server

A Node.js-based JDBC MCP Server supporting MySQL, Oracle, and SQLite databases.

System Requirements

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

Installation

  1. Clone the project: [repository-url]
  2. Install dependencies
  3. Configure environment variables by copying .env.example to .env and modifying it as needed.

Usage

  1. Start server
  2. Start in development mode (with hot reload)

API Endpoints

  • Health Check: GET /health
  • Execute SQL Query: POST /query
  • Close Database Connection: POST /close

Notes

  • Install Oracle client for Oracle database
  • Ensure database servers are running and accessible
  • Configure database connection information properly
  • Use environment variables to manage sensitive information in production.