mcpField
N
Node.js JDBC MCP Server

Node.js JDBC MCP Server

Local
github.com/darkSheep404Databases0Updated 84w ago
Repository

About Node.js JDBC MCP Server

Node.js JDBC MCP Server is a Node.js server for querying MySQL, Oracle, and SQLite databases. It is intended for setups that need a common SQL query interface across these database types.

Key features

  1. 01MySQL, Oracle, and SQLite support
  2. 02SQL queries with parameters
  3. 03Database connection close endpoint
  4. 04Health check endpoint
  5. 05Development mode with hot reload

Use cases

  1. 01Run parameterized SQL queries against MySQL
  2. 02Query Oracle or SQLite databases through the API

MCP support

The project identifies itself as an MCP server, but the README describes HTTP endpoints for health checks, SQL queries, and closing database connections without detailing MCP tools or transport.

#nodejs#jdbc#mcp-server

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

No install method listed yet

We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.

Repository

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

Node.js JDBC MCP Server

这是一个基于Node.js的JDBC MCP服务器，支持MySQL、Oracle和SQLite数据库。

系统要求

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

安装

  1. 克隆项目：
git clone [repository-url]
cd node-jdbc-server
  1. 安装依赖：
npm install
  1. 配置环境变量： 复制 .env.example 文件为 .env，并根据实际情况修改配置。

使用方法

  1. 启动服务器：
npm start
  1. 开发模式启动（支持热重载）：
npm run dev

API接口

健康检查
GET /health
执行SQL查询
POST /query
Content-Type: application/json

{
  "type": "mysql|oracle|sqlite",
  "sql": "SELECT * FROM users WHERE id = ?",
  "params": [1]
}
关闭数据库连接
POST /close
Content-Type: application/json

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

注意事项

  1. 使用Oracle数据库时，需要安装Oracle客户端
  2. 确保数据库服务器已启动并可访问
  3. 正确配置数据库连接信息
  4. 建议在生产环境中使用环境变量管理敏感信息

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.