MCP Server for working with large Oracle databases
接入配置
选择客户端,复制配置,再按项目文档补齐环境变量。
claude mcp add oracle-db-context --env ORACLE_CONNECTION_STRING='<ORACLE_CONNECTION_STRING>' --env TARGET_SCHEMA='<TARGET_SCHEMA>' --env CACHE_DIR='<CACHE_DIR>' -- docker run -i --rm -e ORACLE_CONNECTION_STRING -e TARGET_SCHEMA -e CACHE_DIR dmeppiel/mcp-db-context~/.codex/config.toml
[mcp_servers.oracle-db-context]
command = "docker"
args = ["run", "-i", "--rm", "-e", "ORACLE_CONNECTION_STRING", "-e", "TARGET_SCHEMA", "-e", "CACHE_DIR", "dmeppiel/mcp-db-context"]
env = { ORACLE_CONNECTION_STRING = "<ORACLE_CONNECTION_STRING>", TARGET_SCHEMA = "<TARGET_SCHEMA>", CACHE_DIR = "<CACHE_DIR>" }
# codex mcp add oracle-db-context --env ORACLE_CONNECTION_STRING='<ORACLE_CONNECTION_STRING>' --env TARGET_SCHEMA='<TARGET_SCHEMA>' --env CACHE_DIR='<CACHE_DIR>' -- docker run -i --rm -e ORACLE_CONNECTION_STRING -e TARGET_SCHEMA -e CACHE_DIR dmeppiel/mcp-db-context~/.cursor/mcp.json
{
"mcpServers": {
"oracle-db-context": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"ORACLE_CONNECTION_STRING",
"-e",
"TARGET_SCHEMA",
"-e",
"CACHE_DIR",
"dmeppiel/mcp-db-context"
],
"env": {
"ORACLE_CONNECTION_STRING": "<ORACLE_CONNECTION_STRING>",
"TARGET_SCHEMA": "<TARGET_SCHEMA>",
"CACHE_DIR": "<CACHE_DIR>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"oracle-db-context": {
"type": "stdio",
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"ORACLE_CONNECTION_STRING",
"-e",
"TARGET_SCHEMA",
"-e",
"CACHE_DIR",
"dmeppiel/mcp-db-context"
],
"env": {
"ORACLE_CONNECTION_STRING": "<ORACLE_CONNECTION_STRING>",
"TARGET_SCHEMA": "<TARGET_SCHEMA>",
"CACHE_DIR": "<CACHE_DIR>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"oracle-db-context": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"ORACLE_CONNECTION_STRING",
"-e",
"TARGET_SCHEMA",
"-e",
"CACHE_DIR",
"dmeppiel/mcp-db-context"
],
"env": {
"ORACLE_CONNECTION_STRING": "<ORACLE_CONNECTION_STRING>",
"TARGET_SCHEMA": "<TARGET_SCHEMA>",
"CACHE_DIR": "<CACHE_DIR>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"oracle-db-context": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"ORACLE_CONNECTION_STRING",
"-e",
"TARGET_SCHEMA",
"-e",
"CACHE_DIR",
"dmeppiel/mcp-db-context"
],
"env": {
"ORACLE_CONNECTION_STRING": "<ORACLE_CONNECTION_STRING>",
"TARGET_SCHEMA": "<TARGET_SCHEMA>",
"CACHE_DIR": "<CACHE_DIR>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"oracle-db-context": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"ORACLE_CONNECTION_STRING",
"-e",
"TARGET_SCHEMA",
"-e",
"CACHE_DIR",
"dmeppiel/mcp-db-context"
],
"env": {
"ORACLE_CONNECTION_STRING": "<ORACLE_CONNECTION_STRING>",
"TARGET_SCHEMA": "<TARGET_SCHEMA>",
"CACHE_DIR": "<CACHE_DIR>"
}
}
}
}需要的环境变量
ORACLE_CONNECTION_STRINGTARGET_SCHEMACACHE_DIR
把占位值换成你自己的密钥;不要把密钥提交到代码仓库。