广告合作
MCP.so
登录

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

常见问题

1

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.

2

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`.

3

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.

4

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.

5

Does the server support other databases?

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

评论

数据库 分类下的更多 MCP 服务器

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

广告合作