oracle-mcp-server
Oracle MCP Server is designed to facilitate interactions with Oracle databases via the Model Context Protocol (MCP). It includes tools for database management and real-time communication, emphasizing secure connection handling and usability. Key features include table listing, structure description, and SQL execution.
Oracle MCP Server
A Model Context Protocol (MCP) server implementation for Oracle database operations offering tools for database interaction, including listing tables, describing table structures, and executing SQL statements. Built on spring-ai-mcp-server-webmvc-spring-boot-starter, it supports secure connection management and real-time communication via SSE.
Features
- List and describe Oracle database tables
- Execute SQL statements (SELECT, INSERT, UPDATE, DELETE)
- Secure connection management
- Real-time communication using SSE
Getting Started
Requires JDK 17, Maven 3.6+, Oracle Database, and MCP Server environment.
API Tools
- List Tables: Retrieve all table names
- Describe Table: Retrieve information about table structure
- Execute SQL: Execute SQL statements
Testing
Includes comprehensive unit tests for SQL execution and error handling.
Contributing
Fork the repository, create a branch, commit changes, and make a pull request.
License
MIT License.