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.

  • 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.

  • 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.

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

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

  • https://maiplestudio.com
  • Find Exhibitors, Speakers and more

  • apappascs
  • Descubra la colección más completa y actualizada de servidores MCP en el mercado. Este repositorio sirve como un centro centralizado, que ofrece un extenso catálogo de servidores MCP de código abierto y propietarios, completos con características, enlaces de documentación y colaboradores.

  • ShrimpingIt
  • Manipulación basada en Micrypthon I2C del expansor GPIO de la serie MCP, derivada de AdaFruit_MCP230xx

  • OffchainLabs
  • Implementación de la prueba de estaca Ethereum

  • huahuayu
  • Una puerta de enlace de API unificada para integrar múltiples API de explorador de blockchain similar a Esterscan con soporte de protocolo de contexto modelo (MCP) para asistentes de IA.

  • deemkeen
  • Controle su MBOT2 con un combo de potencia: 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!