Oracle Database

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

10K+

13 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 (13)Config

Docker Hub⁠Github repository⁠

Use cases

Validate a Lab work item and build an execution packet for an external execution plane.

Check Pre-Flight Mode and cascade-depth gates for a work item in the backend-owned Lab mirror.

Describe columns for a table

Create a scene-item row and fire the writers-room entry signal.

Execute a SQL query on the Oracle database

Record a preflight failure and restore the work item to a dispatch-ready state.

List backend-owned Lab work items ready for dispatch.

List constraints for a table

List indexes for a table

Ingest a structured execution-plane return payload into the backend-owned Lab mirror.

View all

About

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.

What is an MCP Server?⁠

MCP Info

Attribute	Details
Docker Image	mcp/oracle⁠
Author	git-scarrow⁠
Repository	https://github.com/samscarrow/oracle-mcp-server⁠

Image Building Info

Attribute	Details
Dockerfile	https://github.com/samscarrow/oracle-mcp-server/blob/c3ff6e8fc97e87173a1d5ae62b3cf6a7b9cb0d27/Dockerfile⁠
Commit	`c3ff6e8fc97e87173a1d5ae62b3cf6a7b9cb0d27`
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 (13)

Tools provided by this Server	Short Description
`build_dispatch_packet`	Validate a Lab work item and build an execution packet for an external execution plane.
`check_gates`	Check Pre-Flight Mode and cascade-depth gates for a work item in the backend-owned Lab mirror.
`describe_table`	Describe columns for a table
`dispatch_scene`	Create a scene-item row and fire the writers-room entry signal.
`execute_query`	Execute a SQL query on the Oracle database
`fail_dispatch_preflight`	Record a preflight failure and restore the work item to a dispatch-ready state.
`get_dispatchable_items`	List backend-owned Lab work items ready for dispatch.
`get_table_constraints`	List constraints for a table
`get_table_indexes`	List indexes for a table
`handle_final_return`	Ingest a structured execution-plane return payload into the backend-owned Lab mirror.
`list_schemas`	List all accessible schemas in the Oracle database
`list_tables`	List database tables from a schema or all accessible schemas
`stamp_dispatch_consumed`	Accept dispatch start, stamp consumption, and move a work item to In Progress.

Tools Details

Tool: `build_dispatch_packet`

Validate a Lab work item and build an execution packet for an external execution plane.

Parameters	Type	Description
`work_item_id`	`string`	Work item UUID

Tool: `check_gates`

Check Pre-Flight Mode and cascade-depth gates for a work item in the backend-owned Lab mirror.

Parameters	Type	Description
`work_item_id`	`string`	Work item UUID

Tool: `describe_table`

Describe columns for a table

Parameters	Type	Description
`table_name`	`string`	Table name
`schema`	`string`optional	Schema name (optional)

Tool: `dispatch_scene`

Create a scene-item row and fire the writers-room entry signal.

Parameters	Type	Description
`creative_brief`	`string`
`scene_name`	`string`
`season`	`number`
`task_type`	`string`
`character_list`	`string`optional
`episode`	`number`optional
`prompt_notes`	`string`optional
`work_item_id`	`string`optional

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: `fail_dispatch_preflight`

Record a preflight failure and restore the work item to a dispatch-ready state.

Parameters	Type	Description
`reason`	`string`	Blocking reason
`run_id`	`string`	Dispatch run UUID
`work_item_id`	`string`	Work item UUID

Tool: `get_dispatchable_items`

List backend-owned Lab work items ready for dispatch.

Parameters	Type	Description
`limit`	`number`optional	Maximum items to return (default 25)

Tool: `get_table_constraints`

List constraints for a table

Parameters	Type	Description
`table_name`	`string`	Table name
`schema`	`string`optional	Schema name (optional)

Tool: `get_table_indexes`

List indexes for a table

Parameters	Type	Description
`table_name`	`string`	Table name
`schema`	`string`optional	Schema name (optional)

Tool: `handle_final_return`

Ingest a structured execution-plane return payload into the backend-owned Lab mirror.

Parameters	Type	Description
`duration_ms`	`number`
`lane`	`string`
`model`	`string`
`raw_output`	`string`
`run_id`	`string`
`status`	`string`
`summary`	`string`
`work_item_id`	`string`
`artifacts`	`string`optional
`commit_sha`	`string`optional
`error`	`string`optional
`files_changed`	`string`optional
`metrics`	`string`optional
`pr_url`	`string`optional
`tool_calls`	`string`optional
`verdict`	`string`optional

Tool: `list_schemas`

List all accessible schemas in the Oracle database

Tool: `list_tables`

List database tables from a schema or all accessible schemas

Parameters	Type	Description
`pattern`	`string`optional	Table name pattern with % wildcards (optional)
`schema`	`string`optional	Schema name (optional)

Tool: `stamp_dispatch_consumed`

Accept dispatch start, stamp consumption, and move a work item to In Progress.

Parameters	Type	Description
`run_id`	`string`	Dispatch run UUID
`work_item_id`	`string`	Work item UUID

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?⁠

Oracle Database

Oracle Database MCP Server

MCP Info

Image Building Info

Available Tools (13)

Tools Details

Tool: `build_dispatch_packet`

Tool: `check_gates`

Tool: `describe_table`

Tool: `dispatch_scene`

Tool: `execute_query`

Tool: `fail_dispatch_preflight`

Tool: `get_dispatchable_items`

Tool: `get_table_constraints`

Tool: `get_table_indexes`

Tool: `handle_final_return`

Tool: `list_schemas`

Tool: `list_tables`

Tool: `stamp_dispatch_consumed`

Use this MCP Server

Related servers

Couchbase

MongoDB

Neon

Amazon Neptune

Oracle Database

Oracle Database MCP Server

MCP Info

Image Building Info

Available Tools (13)

Tools Details

Tool: build_dispatch_packet

Tool: check_gates

Tool: describe_table

Tool: dispatch_scene

Tool: execute_query

Tool: fail_dispatch_preflight

Tool: get_dispatchable_items

Tool: get_table_constraints

Tool: get_table_indexes

Tool: handle_final_return

Tool: list_schemas

Tool: list_tables

Tool: stamp_dispatch_consumed

Use this MCP Server

Related servers

Couchbase

MongoDB

Neon

Amazon Neptune

Tool: `build_dispatch_packet`

Tool: `check_gates`

Tool: `describe_table`

Tool: `dispatch_scene`

Tool: `execute_query`

Tool: `fail_dispatch_preflight`

Tool: `get_dispatchable_items`

Tool: `get_table_constraints`

Tool: `get_table_indexes`

Tool: `handle_final_return`

Tool: `list_schemas`

Tool: `list_tables`

Tool: `stamp_dispatch_consumed`