Connects to an Oracle database and exposes configured tables and columns so an LLM can generate and run SQL.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add oracledb -- npx @modelcontextprotocol/inspector uv --directory D:MyDevmcporacledb_mcp_server run -m oracledb_mcp_server~/.codex/config.toml
[mcp_servers.oracledb]
command = "npx"
args = ["@modelcontextprotocol/inspector", "uv", "--directory", "D:MyDevmcporacledb_mcp_server", "run", "-m", "oracledb_mcp_server"]
# codex mcp add oracledb -- npx @modelcontextprotocol/inspector uv --directory D:MyDevmcporacledb_mcp_server run -m oracledb_mcp_server~/.cursor/mcp.json
{
"mcpServers": {
"oracledb": {
"command": "npx",
"args": [
"@modelcontextprotocol/inspector",
"uv",
"--directory",
"D:MyDevmcporacledb_mcp_server",
"run",
"-m",
"oracledb_mcp_server"
]
}
}
}.vscode/mcp.json
{
"servers": {
"oracledb": {
"type": "stdio",
"command": "npx",
"args": [
"@modelcontextprotocol/inspector",
"uv",
"--directory",
"D:MyDevmcporacledb_mcp_server",
"run",
"-m",
"oracledb_mcp_server"
]
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"oracledb": {
"command": "npx",
"args": [
"@modelcontextprotocol/inspector",
"uv",
"--directory",
"D:MyDevmcporacledb_mcp_server",
"run",
"-m",
"oracledb_mcp_server"
]
}
}
}claude_desktop_config.json
{
"mcpServers": {
"oracledb": {
"command": "npx",
"args": [
"@modelcontextprotocol/inspector",
"uv",
"--directory",
"D:MyDevmcporacledb_mcp_server",
"run",
"-m",
"oracledb_mcp_server"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"oracledb": {
"command": "npx",
"args": [
"@modelcontextprotocol/inspector",
"uv",
"--directory",
"D:MyDevmcporacledb_mcp_server",
"run",
"-m",
"oracledb_mcp_server"
]
}
}
}