Oracle Database
Connect to Oracle databases via MCP, providing secure read-only access with support for schema exploration, query execution, and metadata inspection.
6.9K
6 Tools
Packaged by
Requires Secrets
Add to Docker Desktop
Version 4.43 or later needs to be installed to add the server automatically
Use cases
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.
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/758e33bff0f33951e6572057000932b6fd550c5e/Dockerfile |
| Commit | 758e33bff0f33951e6572057000932b6fd550c5e |
| 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 | stringoptional | 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 | numberoptional | Maximum number of rows to return (default: 1000) |
params | arrayoptional | 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 | stringoptional | 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 | stringoptional | 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 | stringoptional | Table name pattern (supports % wildcards) |
schema | stringoptional | 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>"
}
}
}
}