概要
Oracle provides a Model Context Protocol (MCP) server implementation that enables seamless interaction with Oracle databases. Built on Spring Boot and utilizing Server-Sent Events (SSE) for real-time communication, it offers a set of tools for listing tables, describing their structure, and executing SQL statements. With secure connection management and robust error handling, Oracle simplifies database operations within an MCP environment.
主な機能
- Lists all tables in the Oracle database.
- Secure database connection management
- Describes table structure, including columns, data types, and constraints.
- 3 GitHub stars
- Provides real-time communication via SSE.
- Executes SQL statements (SELECT, INSERT, UPDATE, DELETE).
ユースケース
- Listing all tables within a given database.
- Describing the structure of a specified table, including all of its constraints and datatypes.
- Executing arbitrary SQL queries against a database