Oracle MCP implementation

[marcelo-ochoa]

Description

Server Details

Motivation and Context

This MCP server is specially tailored for Oracle Database intended to be a tool for developers/dba in development optimized applications with AI assisted SQL queries.

How Has This Been Tested?

The MCP servers was tested with Claude Desktop on Mac and Oracle 23c RDBMS using OracleFree 23c embedded RDBMS - Faststart - Docker Desktop Extension. It also was tested with Docker Desktop Gordon AI tool and VSCode Insiders using Ask Copilot to edit projects files in agent mode.

Breaking Changes

Types of changes

• Initial implementation.

Checklist

• [x] I have read the MCP Protocol Documentation
• [x] My changes follows MCP security best practices
• [ ] I have updated the server's README accordingly
• [x] I have tested this with an LLM client
• [x] My code follows the repository's style guidelines
• [x] New and existing tests pass locally
• [x] I have added appropriate error handling
• [x] I have documented all environment variables and configuration options

Additional context

For Oracle RDBMS usage is recommended to use OracleFree 23c embedded RDBMS - Faststart - Docker Desktop Extension