Oracle MCP

Production-ready Oracle Model Context Protocol (MCP) Server built with Node.js.

Oracle MCP provides AI assistants with secure, structured access to Oracle Database through the Model Context Protocol (MCP). The project follows a layered architecture with adapters, repositories, services, registries, and MCP tools, making it easy to extend while keeping database access safe and maintainable.

Features

• Oracle Database connectivity

• Connection pooling

• Read-only mode support

• SQL validation

• Metadata exploration

• Object discovery

• DDL extraction

• Stored procedure execution

• Function execution

• Transaction management

• Modular MCP tool registry

• Logging & audit middleware

• Environment-based configuration

Related MCP server: Database MCP Server

Project Structure

.
├── src
│   ├── adapters/
│   ├── bootstrap/
│   ├── config/
│   ├── constants/
│   ├── context/
│   ├── db/
│   ├── exceptions/
│   ├── middleware/
│   ├── queries/
│   ├── registry/
│   ├── repositories/
│   ├── schemas/
│   ├── security/
│   ├── services/
│   │   ├── customer/
│   │   └── metadata/
│   ├── tools/
│   │   ├── customer/
│   │   └── database/
│   ├── utils/
│   ├── validators/
│   ├── app.js
│   └── server.js
├── docs/
├── tests/
├── logs/
├── package.json
├── .env.example
└── README.md

Requirements

• Node.js 20+

• Oracle Database 19c or later

• Oracle Instant Client (when required)

Installation

git clone https://github.com/danangpriabada/bob-oracle-mcp.git

cd bob-oracle-mcp

npm install

cp .env.example .env

Environment

NODE_ENV=development
PORT=3000

DB_HOST=localhost
DB_PORT=1521
DB_SERVICE_NAME=FREEPDB1

DB_USER=
DB_PASSWORD=

DB_POOL_MIN=2
DB_POOL_MAX=10
DB_POOL_INCREMENT=1

READ_ONLY=true

Running

node src/server.js

or

npm start

MCP Inspector

Install the inspector:

npm install -g @modelcontextprotocol/inspector

Run the server with the inspector:

npx @modelcontextprotocol/inspector node src/server.js

Remove the global installation if no longer needed:

npm uninstall -g @modelcontextprotocol/inspector

Available Database Tools

Available Customer Tools

• create

• update

• delete

• get

• list

Architecture

MCP Client
      │
      ▼
 Registry
      │
      ▼
    Tools
      │
      ▼
  Services
      │
      ▼
Repositories
      │
      ▼
 Oracle Adapter
      │
      ▼
 Oracle Database

Security

The project is designed with production deployments in mind.

• Read-only mode support

• SQL validation

• Permission layer

• Audit middleware

• Centralized error handling

• Modular registry for controlled tool exposure

Roadmap

• Authentication & Authorization

• Role-based tool permissions

• OCI integration

• Oracle Thin Driver optimization

• Docker support

• Kubernetes deployment

• GitHub Actions CI/CD

• OpenTelemetry

• Unit tests

• Integration tests

License

MIT

Author

Danang Priabada

GitHub: https://github.com/danangpriabada