Oracle Database MCP Server

Oracle Database MCP Server

Connect to Oracle databases via MCP, providing secure read-only access with support for schema exploration, query execution, and metadata inspection.

698

6 Tools

Packaged by

Requires Secrets

Add to Docker Desktop

Version 4.43 or later needs to be installed to add the server automatically

Overview Tools (6)Config Manual installation

Docker Hub⁠Github repository⁠

Use cases

Get table structure including columns, data types, and constraints

Execute a SQL query on the Oracle database

Get constraints (primary keys, foreign keys, unique, check) for a table

Get indexes for a specific table

List all schemas in the database

List tables from specified schema or all accessible schemas

About

Oracle Database MCP Server MCP Server

Connect to Oracle databases via MCP, providing secure read-only access with support for schema exploration, query execution, and metadata inspection.

What is an MCP Server?⁠

Characteristics

Attribute	Details
Docker Image	mcp/oracle⁠
Author	samscarrow⁠
Repository	https://github.com/samscarrow/oracle-mcp-server⁠
Dockerfile	https://github.com/samscarrow/oracle-mcp-server/blob/main/Dockerfile⁠
Docker Image built by	Docker Inc.
Docker Scout Health Score
Verify Signature	`COSIGN_REPOSITORY=mcp/signatures cosign verify mcp/oracle --key https://raw.githubusercontent.com/docker/keyring/refs/heads/main/public/mcp/latest.pub`
Licence	MIT License

Available Tools (6)

Tools provided by this Server	Short Description
`describe_table`	Get table structure including columns, data types, and constraints
`execute_query`	Execute a SQL query on the Oracle database
`get_table_constraints`	Get constraints (primary keys, foreign keys, unique, check) for a table
`get_table_indexes`	Get indexes for a specific table
`list_schemas`	List all schemas in the database
`list_tables`	List tables from specified schema or all accessible schemas

Tools Details

Tool: `describe_table`

Get table structure including columns, data types, and constraints

Parameters	Type	Description
`table_name`	`string`	Table name
`schema`	`string`optional	Schema name (optional, searches all accessible schemas if not specified)

Tool: `execute_query`

Execute a SQL query on the Oracle database

Parameters	Type	Description
`query`	`string`	SQL query to execute
`maxRows`	`number`optional	Maximum number of rows to return (default: 1000)
`params`	`array`optional	Query parameters (optional)

Tool: `get_table_constraints`

Get constraints (primary keys, foreign keys, unique, check) for a table

Parameters	Type	Description
`table_name`	`string`	Table name
`schema`	`string`optional	Schema name (optional, searches all accessible schemas if not specified)

Tool: `get_table_indexes`

Get indexes for a specific table

Parameters	Type	Description
`table_name`	`string`	Table name
`schema`	`string`optional	Schema name (optional, searches all accessible schemas if not specified)

Tool: `list_schemas`

List all schemas in the database

Tool: `list_tables`

List tables from specified schema or all accessible schemas

Parameters	Type	Description
`pattern`	`string`optional	Table name pattern (supports % wildcards)
`schema`	`string`optional	Schema name (optional, shows all accessible schemas if not specified)

Use this MCP Server

{
  "mcpServers": {
    "oracle": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "ORACLE_CONNECTION_STRING",
        "-e",
        "ORACLE_USER",
        "-e",
        "ORACLE_PASSWORD",
        "mcp/oracle"
      ],
      "env": {
        "ORACLE_CONNECTION_STRING": "hostname:1521/servicename",
        "ORACLE_USER": "readonly_user",
        "ORACLE_PASSWORD": "<ORACLE_PASSWORD>"
      }
    }
  }
}

Why is it safer to run MCP Servers with Docker?⁠

Manual installation

You can install the MCP server using:

Installation for

Related servers