Cover image
Try Now
2025-03-19

3 years

Works with Finder

1

Github Watches

1

Github Forks

0

Github Stars

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. 建议在生产环境中使用环境变量管理敏感信息

相关推荐

  • NiKole Maxwell
  • I craft unique cereal names, stories, and ridiculously cute Cereal Baby images.

  • Bora Yalcin
  • Evaluator for marketplace product descriptions, checks for relevancy and keyword stuffing.

  • Joshua Armstrong
  • Confidential guide on numerology and astrology, based of GG33 Public information

  • https://suefel.com
  • Latest advice and best practices for custom GPT development.

  • Alexandru Strujac
  • Efficient thumbnail creator for YouTube videos

  • Callycode Limited
  • A geek-themed horoscope generator blending Bitcoin prices, tech jargon, and astrological whimsy.

  • Emmet Halm
  • Converts Figma frames into front-end code for various mobile frameworks.

  • Khalid kalib
  • Write professional emails

  • Beniyam Berhanu
  • Therapist adept at identifying core issues and offering practical advice with images.

  • Elijah Ng Shi Yi
  • Advanced software engineer GPT that excels through nailing the basics.

  • apappascs
  • 发现市场上最全面,最新的MCP服务器集合。该存储库充当集中式枢纽,提供了广泛的开源和专有MCP服务器目录,并提供功能,文档链接和贡献者。

  • ShrimpingIt
  • MCP系列GPIO Expander的基于Micropython I2C的操作,源自ADAFRUIT_MCP230XX

  • OffchainLabs
  • 进行以太坊的实施

  • huahuayu
  • 统一的API网关,用于将多个Etherscan样区块链Explorer API与对AI助手的模型上下文协议(MCP)支持。

  • deemkeen
  • 用电源组合控制您的MBOT2:MQTT+MCP+LLM

    Reviews

    2 (1)
    Avatar
    user_xqU9EjJJ
    2025-04-16

    I've been using the Node-JDBC-MCP-Server created by darkSheep404 and it has significantly streamlined my database connectivity tasks with Node.js. The integration with JDBC is seamless and the performance is top-notch. Highly recommend this for anyone looking to enhance their backend server efficiency!