mcp-oracle 0.1.0

MCP server for Oracle databases — thin mode, no Instant Client required

mcp-oracle

Oracle database MCP server using python-oracledb in thin mode — no Oracle Instant Client required.

Installation

No manual installation needed. Run directly with:

uvx mcp-oracle

Configuration

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "oracle": {
      "command": "uvx",
      "args": ["mcp-oracle"],
      "env": {
        "ORACLE_DSN": "host:1521/service_name",
        "ORACLE_USER": "usuario",
        "ORACLE_PASSWORD": "senha"
      }
    }
  }
}

DSN Format

Format	Example	Use when
host:port/service_name	db.example.com:1521/ORCL	Most modern Oracle databases
host:port:SID	db.example.com:1521:ORCL	Legacy SID-based connections

service_name vs SID: Modern Oracle databases use service names (check with your DBA). Use the / separator for service names and the : separator for SIDs.

Environment Variables

Variable	Required	Default	Description
ORACLE_DSN	Yes	—	Database connection string
ORACLE_USER	Yes	—	Database username
ORACLE_PASSWORD	Yes	—	Database password
ORACLE_QUERY_ROW_LIMIT	No	1000	Maximum rows returned per query
ORACLE_QUERY_TIMEOUT_SECONDS	No	30	Query timeout in seconds
ORACLE_POOL_MIN	No	1	Minimum connection pool size
ORACLE_POOL_MAX	No	4	Maximum connection pool size

Available Tools

• list_tables — List tables and views accessible to the connected user. Pass schema to list objects from another schema.
• describe_table — Return columns, data types, nullability, and primary keys for a table. Pass schema for cross-schema lookups.
• run_query — Execute a SELECT statement and return results as JSON. Supports bind parameters via the params argument.

Table Name Case Sensitivity

Oracle stores identifiers in uppercase by default. describe_table("employees") and describe_table("EMPLOYEES") are equivalent — the server normalizes to uppercase automatically.

License

MIT — © Leonardo Cardoso