---
title: "AWS Labs MCP Server for Oracle Database: review, setup & limitations · Undominated.ai"
canonical: https://undominated.ai/mcp-servers/awslabs-oracle/
description: "Pins the Oracle server whose README defaults to read-only SQL and keeps the secret ARN off the tool surface."
---

# AWS Labs MCP Server for Oracle Database: review, setup & limitations · Undominated.ai

> Pins the Oracle server whose README defaults to read-only SQL and keeps the secret ARN off the tool surface.

[← Explore all mcp servers](/mcp-servers/)

DATABASE EXPLORATION / AWS Labs

# AWS Labs MCP Server for Oracle Database

Pins the Oracle server whose README defaults to read-only SQL and keeps the secret ARN off the tool surface.

 [See setup guidance ↓](#setup)[Original source ↗](https://github.com/awslabs/mcp/tree/8840003820a78dd018561d55c7ab12fcdd708464/src/oracle-mcp-server)

SOURCE REVIEW

 Reviewed 2026-10-14
 Evidence 4 linked sources
 Publisher AWS Labs
 Licence [Apache-2.0 ↗](https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/LICENSE)
 Revision 8840003820a7
 [Read what was—and wasn’t—checked ↓](#review)

“Queries one startup-fixed Oracle connection, blocks mutating SQL by default, and uses a separate flag for writes.”

 [AWS Labs · upstream description ↗](https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/oracle-mcp-server/README.md) Our analysis follows below.

01 / THE REASONING

## Why this made the selection.

 - The README separates a default read-only mode, including mutating-keyword rejection and SET TRANSACTION READ ONLY, from an explicit allow_write_query flag.
- The connection target and secret ARN are fixed at startup. connect_to_database has no parameters, and the secret flag is not an MCP tool parameter.

### A good fit for

 - Querying one operator-chosen Oracle database with the default read-only mode and a database account limited to reads

### Weigh up before choosing

 - This review did not execute the resource.
- Pinning commit 8840003820a78dd018561d55c7ab12fcdd708464 does not verify transitive dependencies.
- No uvx line and no @latest string appear in the server README, so install.command is null. The launch examples are continued shell lines, not one install command.
- The server README does not name stdio, SSE, or streamable HTTP. Kiro, Cursor, and VS Code are install badges on the repository README row.
- The keyword filter is explicitly best-effort. The README's own example is a SELECT that calls a writing function, and that example is not reconciled with the sentence that says the database rejects every slipped mutation.
- Omitting the secret ARN requires rds:DescribeDBInstances. Supplying the ARN can skip the multi-tenant guard when that permission is absent.
- The default TLS mode does not change the process port default of 1521. The README says require and noverify need port 2484. noverify skips certificate and hostname checks, and off removes TLS.
- The read-only user comment says specific schemas, and the statement grants SELECT ANY TABLE. A later comment offers per-table grants instead.
- The README ends mid-sentence and does not state a licence. The pinned root LICENSE and server LICENSE are Apache-2.0, so they do not disagree.
- The IAM section lists AWS permissions the process uses. It does not document a tool that writes IAM roles, policies, or access keys.

02 / THE REVIEW RECORD

## What we actually inspected.

Source review has boundaries. A clear record is more useful than a “safe” badge.

### Material inspected

 - src/oracle-mcp-server/README.md
- README.md
- LICENSE
- src/oracle-mcp-server/LICENSE

### Our findings

 - The features list blocks mutating SQL and forces SET TRANSACTION READ ONLY. A later section repeats the read-only default and says writes require allow_write_query, which the earlier launch examples do not pass.
- The secret ARN is startup-only and is not an MCP tool parameter, so the model cannot choose an arbitrary secret. Passing the flag makes the RDS describe permission optional, and the README says the multi-tenant guard is then skipped if that permission is missing.
- TLS defaults to require and validates the server certificate. noverify keeps encryption but skips certificate and hostname checks. off is plain TCP. require and noverify still need port 2484 because the process default remains 1521.
- The keyword and pattern checks are called a best-effort safeguard, not a security boundary. The README says they cannot guarantee that no mutation reaches the database, and it points to a database user with only read permissions for a harder boundary.
- connect_to_database takes no parameters because the target is fixed by launch flags. Exactly one of service_name or sid must be provided.
- The recommended read-only grant comment says specific schemas, then shows SELECT ANY TABLE. The next comment says specific table grants are optional instead of SELECT ANY TABLE.

### Not established by this review

 - The resource was not executed and its tools were not called.
- No SQL was sent, and read-only mode was not tested against a database.
- TLS verification and Secrets Manager retrieval were not tested.

The review applies to the material and revision named here. A newer upstream release can change its behavior.

03 / PUT IT TO WORK

## Connect a server deliberately.

[Upstream setup instructions ↗](https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/oracle-mcp-server/README.md)
 - The server README never prints a uvx or pip install line, with or without @latest, so there is no install.command.
- Start awslabs.oracle-mcp-server with ORACLE_PASSWORD, an endpoint or Autonomous identifier, exactly one of service_name or sid, and port 2484 when the default TLS mode stays on.
- Leave allow_write_query unset to keep the documented read-only default. Pass the secret ARN at startup when the RDS master-user secret should not be used.

### Before you start

 - AWS credentials that can read the chosen Secrets Manager secret
- A reachable Oracle endpoint
- python-oracledb thin mode, which the README says does not need Oracle Instant Client

### Compatibility

Kiro · Cursor · VS Code

### Implementation

python

### Read-only Oracle SQL on AWS unless write mode is enabled

 - Run SQL and read ALL_TAB_COLUMNS on the startup-fixed connection
- Reject mutating keywords and open a read-only transaction unless allow_write_query is set
- Read one Secrets Manager secret chosen at launch, not a secret selected by a tool call

### Cost model

Apache-2.0; no database call was made

04 / FOLLOW THE EVIDENCE

## The source trail.

Our notes are separate from the original resource. Check upstream before adopting a new version.

 - [Oracle Database MCP README ↗](https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/oracle-mcp-server/README.md) Checked 2026-10-14 https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/oracle-mcp-server/README.md Supports: Default read-only SQL, a separate write flag, and a startup-only secret ARN
- [Repository README ↗](https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/README.md) Checked 2026-10-14 https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/README.md Supports: Apache-2.0 licence line and Kiro, Cursor, and VS Code install badges for this server
- [Repository LICENSE ↗](https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/LICENSE) Checked 2026-10-14 https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/LICENSE Supports: Apache License Version 2.0
- [Oracle MCP LICENSE ↗](https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/oracle-mcp-server/LICENSE) Checked 2026-10-14 https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/oracle-mcp-server/LICENSE Supports: Apache License Version 2.0 beside the server README

KEEP COMPARING

## Other approaches to consider.

Related by category or shared topics. These are alternatives to inspect, not a measured quality order.

 [### Couchbase MCP Server ↗ Self-hosted Couchbase server with cluster health, schema, key-value, SQL++ and performance tools. Read-only mode is on by default, individual tools can be disabled, and the underlying Couchbase RBAC remains the authoritative boundary across stdio, Streamable HTTP and SSE transports.](/mcp-servers/couchbase/)[### MongoDB MCP Server ↗ Provides MongoDB database and Atlas operations through a local server with an explicit read-only startup option.](/mcp-servers/mongodb/)[### Neo4j MCP ↗ Explore a Neo4j graph schema and run Cypher through a server with an explicit read-only configuration.](/mcp-servers/neo4j/)

 [AI Tools ↗](/tools/)[Skills ↗](/skills/)[Agents ↗](/agents/)[MCP Servers ↗](/mcp-servers/)[Workflows ↗](/workflows/)

## Continue your investigation

 - [Inspect resource evidence](/tools/)
- [Choose a host](/agents/)
- [Inspect reusable workflows](/skills/)
- [Use Undominated data](/api/)
