← Explore all 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.

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

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.

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 ↗
  1. The server README never prints a uvx or pip install line, with or without @latest, so there is no install.command.
  2. 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.
  3. 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

04 / FOLLOW THE EVIDENCE

The source trail.

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

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

  2. Repository README ↗Checked

    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

  3. Repository LICENSE ↗Checked

    https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/LICENSE

    Supports: Apache License Version 2.0

  4. Oracle MCP LICENSE ↗Checked

    https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/oracle-mcp-server/LICENSE

    Supports: Apache License Version 2.0 beside the server README

Evidence & Ask