mcpserver.so LogoMCPFly
Submit
Node.js JDBC MCP Server logo

Node.js JDBC MCP Server

by darkSheep404

Data/DatabasesNode.jsJDBCMySQLOracleSQLiteDatabase

This is a Node.js JDBC MCP server that supports MySQL, Oracle, and SQLite databases. It provides a simple API to execute SQL queries against these databases.

View on GitHub

Last updated: N/A

What is Node.js JDBC MCP Server?

A Node.js server that acts as a Multi-Connection Pool (MCP) for JDBC connections. It allows you to execute SQL queries against MySQL, Oracle, and SQLite databases through a simple HTTP API.

How to use Node.js JDBC MCP Server?

  1. Clone the repository. 2. Install dependencies using npm install. 3. Configure the environment variables in the .env file. 4. Start the server using npm start or npm run dev for development mode. 5. Use the API endpoints to perform health checks, execute SQL queries, and close database connections.

Key features of Node.js JDBC MCP Server

  • Supports MySQL, Oracle, and SQLite databases

  • Provides a simple HTTP API for executing SQL queries

  • Supports parameterized queries

  • Includes a health check endpoint

Use cases of Node.js JDBC MCP Server

  • Centralized database access for Node.js applications

  • Microservices architecture where database access is decoupled from individual services

  • Simplified database interaction for applications that need to support multiple database types

  • Quick prototyping and testing of database queries

FAQ from Node.js JDBC MCP Server

What Node.js version is required?

Node.js version 18.0.0 or higher is required.

How do I configure the database connections?

You need to configure the database connection details in the .env file. Refer to the .env.example file for the required environment variables.

How do I execute a SQL query?

Use the POST /query endpoint with the database type, SQL query, and parameters in the request body.

Do I need to install the Oracle client?

Yes, you need to install the Oracle client if you want to use the server with an Oracle database.

How do I close a database connection?

Use the POST /close endpoint with the database type in the request body.