oraclemcp
Verified Safeby omandotkom
Overview
Enables LLMs to interact with Oracle databases for schema inspection and read-only query execution.
Installation
mcp_oracle.exeEnvironment Variables
- ORACLE_USER
- ORACLE_PASSWORD
- ORACLE_CONNECT_STRING
Security Notes
The `sql-select` tool directly executes arbitrary `SELECT` or `WITH` SQL queries provided by the LLM. While this is its intended purpose, it means any LLM (or compromised input from an LLM) can query *any* data accessible by the configured `ORACLE_USER`. This poses a significant data exfiltration risk and potential for resource exhaustion (even if result rows are truncated, the query itself can be expensive). Error messages might expose internal database details. The `list-tables` and `get-table-schema` tools use parameterized queries or hardcoded SQL and are safer. Configuration is via environment variables, preventing hardcoded secrets. No 'eval' or similar dangerous functions were found.
Similar Servers
mcp
This repository provides a collection of Model Context Protocol (MCP) servers to enable AI agents to interact with and manage various Oracle Cloud Infrastructure (OCI) services, Oracle Database, and MySQL databases through natural language.
DBchat
Transforms a database into an intelligent conversational partner, enabling natural language queries, instant answers, and data visualizations via MCP clients.
sqlite-mcp
A Model Context Protocol (MCP) server that enables LLMs to interact with SQLite databases by providing tools and resources for querying and managing data.
ocireg-mcp
An MCP server enabling LLM-powered applications to interact with OCI registries for querying image information, tags, manifests, and configurations.