Oracle MCP Server

@yyue9527

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

yyue9527

Oracle MCP Server について

A Model Context Protocol (MCP) server implementation for Oracle database operations

Oracle MCP Server の設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

Oracle MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is Oracle MCP Server?

Oracle MCP Server is a Model Context Protocol (MCP) implementation for Oracle database operations. Built on spring-ai-mcp-server-webmvc-spring-boot-starter, it uses Server-Sent Events (SSE) for real-time communication. Developers can list tables, describe table structures, and execute SQL statements through MCP tools.

How to use Oracle MCP Server?

Prerequisites include JDK 17, Maven 3.6+, an Oracle database instance, and the Cursor IDE. Configure database credentials in application.properties or application.yml, then set the MCP server URL in Cursor’s settings (http://{server-ip}:{server-port}/sse). Build with mvn clean install and run with mvn spring-boot:run.

Key features of Oracle MCP Server

List all tables in the Oracle database
Describe table structure (columns, data types, constraints)
Execute SQL statements (SELECT, INSERT, UPDATE, DELETE)
Secure database connection management
Real-time communication via SSE
Built on Spring Boot 3.2.0 and spring-ai-mcp-server-webmvc-spring-boot-starter

Use cases of Oracle MCP Server

Quickly browse all tables in an Oracle database
Inspect column definitions, data types, and constraints for any table
Run ad‑hoc SELECT queries and get results in CSV format
Execute INSERT/UPDATE/DELETE and see the count of affected rows
Integrate Oracle operations into AI‑assisted development workflows in Cursor IDE

よくある質問

What are the runtime requirements?

JDK 17, Maven 3.6+, an accessible Oracle database instance, and the Cursor IDE. The server runs as a Spring Boot application.

What MCP transport does the server use?

The server uses Server-Sent Events (SSE) for real-time communication. The Cursor client connects via an SSE endpoint at `/sse`.

How are database credentials configured?

Credentials are set in `application.properties` or `application.yml` with the fields `oracle.connectionString`, `oracle.username`, and `oracle.password`. The configuration supports encryption for secure password management.

What security measures are implemented?

The server includes SQL injection prevention, connection pooling with auto-closing of resources, password encryption in configuration, and sanitized error messages.

Does the server support other databases?

No. The server is specifically built for Oracle database operations using the Oracle JDBC Driver.

「データベース」の他のコンテンツ

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi