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.
- 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
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 ↗Checked
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 ↗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
- Repository LICENSE ↗Checked
https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/LICENSE
Supports: Apache License Version 2.0
- 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