Connect to Oracle databases via MCP, providing secure read-only access with support for schema ex...
10K+
Connect to Oracle databases via MCP, providing secure read-only access with support for schema exploration, query execution, and metadata inspection.
| Attribute | Details |
|---|---|
| Docker Image | mcp/oracle |
| Author | git-scarrow |
| Repository | https://github.com/samscarrow/oracle-mcp-server |
| 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 |
| 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. |
build_dispatch_packetValidate a Lab work item and build an execution packet for an external execution plane.
| Parameters | Type | Description |
|---|---|---|
work_item_id | string | Work item UUID |
check_gatesCheck 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 |
describe_tableDescribe columns for a table
| Parameters | Type | Description |
|---|---|---|
table_name | string | Table name |
schema | string optional | Schema name (optional) |
dispatch_sceneCreate 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 |
execute_queryExecute 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) |
fail_dispatch_preflightRecord 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 |
get_dispatchable_itemsList backend-owned Lab work items ready for dispatch.
| Parameters | Type | Description |
|---|---|---|
limit | number optional | Maximum items to return (default 25) |
get_table_constraintsList constraints for a table
| Parameters | Type | Description |
|---|---|---|
table_name | string | Table name |
schema | string optional | Schema name (optional) |
get_table_indexesList indexes for a table
| Parameters | Type | Description |
|---|---|---|
table_name | string | Table name |
schema | string optional | Schema name (optional) |
handle_final_returnIngest 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 |
list_schemasList all accessible schemas in the Oracle database
list_tablesList 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) |
stamp_dispatch_consumedAccept 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 |
{
"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>"
}
}
}
}
Content type
Image
Digest
sha256:1e73b1423…
Size
211.5 MB
Last updated
3 months ago
docker pull mcp/oraclePulls:
99
Last week