Comprehensive monitoring and analysis of Oracle Cloud Infrastructure databases
MCP OCI OPSI Server
Version 3.0 | FastMCP 2.0 | 13 DBA Skills | OAuth + API Key Auth | Multi-Tenancy
MCP (Model Context Protocol) server for Oracle Cloud Infrastructure (OCI) Operations Insights. This server provides comprehensive Oracle database monitoring and analysis capabilities through Claude Desktop, Claude Code, ChatGPT, or any MCP-compatible client (stdio or HTTP transports).
Quick Links: Installation | Quick Start | Startup & Transports | Prompts & Playbooks | OCI VM Deployment | API Reference
Guides: Skills Guide | FastMCP v3 Guide | OCI Deployment Guide
Standards
docs/OCI_MCP_SERVER_STANDARD.md
Screenshots
Fleet Summary - Instant Overview
Get a complete overview of your database fleet with zero API calls:
Fleet overview showing database counts, types, and compartment distribution - instant response from local cache
Database Search Results
Search and discover databases across your tenancy instantly:
Comprehensive database list with OCIDs, types, and compartments - cached for instant queries
Database Details
Get detailed information about any specific database:
Detailed database information including OCID, type, compartment, and status - instant lookup from cache
What's New in v3.0
| Feature | Description |
|---|---|
| OCI IAM OAuth | Enterprise authentication with OCI Identity Domains |
| API Key Fallback | Seamless fallback to ~/.oci/config for development |
| MCP Resources | 10 read-only data endpoints for efficient access |
| MCP Prompts | 15 guided DBA workflow templates |
| Server Composition | 4 modular sub-servers with tool prefixes |
| DBA Skills | 13 specialized skills for token-efficient workflows |
| Di[Link to Secure Variable: OPENAI_API_KEY] Storage | No Redis required - encrypted file storage |
| OCI VM Ready | Terraform scripts for automated deployment |
| Async Tasks | Background cache builds (cache_start_cache_build_task) with polling |
| Prebuilt Playbooks | admin_get_troubleshooting_playbook and admin_list_prompts for fast LLM guidance |
Startup & Transports
- stdio (default):
python -m mcp_oci_opsi(best for Claude Desktop/Code, ChatGPT MCP). - HTTP:
MCP_TRANSPORT=http MCP_PORT=8000 python -m mcp_oci_opsi(for remote clients). - SSE / Streamable HTTP:
MCP_TRANSPORT=sse|streamable-http MCP_PORT=8000 python -m mcp_oci_opsi(if supported by your FastMCP runtime). - Version switch:
MCP_VERSION=v2(FastMCP server).MCP_VERSION=v3runs a local bootstrap/CLI (not an MCP server). - Logging: Set
LOG_LEVEL=DEBUGfor verbose startup; OCI SDK logs default to WARNING. - Timeouts:
OCI_CLIENT_TIMEOUT,OPSI_CLIENT_TIMEOUT,DBM_CLIENT_TIMEOUT(seconds) bound per-call latency;MCP_CLIENT_TIMEOUT_MScaps tool invocations.
Architecture Overview
High-Level Architecture
┌─────────────────────────────────────┐
│ MCP Clients │
│ (Claude Desktop/Code, ChatGPT) │
└──────────────┬──────────────────────┘
│
MCP Protocol (stdio/HTTP)
│
┌──────────────────────────────────────────────────┴──────────────────────────────────────────────────┐
│ │
│ MCP OCI OPSI SERVER v3.0 │
│ │
│ ┌────────────────────────────────────────────────────────────────────────────────────────────────┐ │
│ │ FastMCP 2.0 Core │ │
│ │ │ │
│ │ ┌─────────────┐ ┌─────────────┐ ┌─────────────┐ ┌─────────────┐ ┌─────────────────────┐ │ │
│ │ │ cache_* │ │ opsi_* │ │ dbm_* │ │ admin_* │ │ Skills Engine │ │ │
│ │ │ 8 tools │ │ 9 tools │ │ 8 tools │ │ 10 tools │ │ 13 DBA skills │ │ │
│ │ │ 4 resources│ │ 1 resource │ │ 2 resources│ │ 3 resources│ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ • Fleet Overview │
Tools (3)
cache_start_cache_build_taskInitiates a background cache build task for OCI data.admin_get_troubleshooting_playbookRetrieves a guided DBA troubleshooting playbook.admin_list_promptsLists available DBA workflow prompts.Environment Variables
MCP_TRANSPORTTransport protocol (stdio, http, sse)MCP_PORTPort for HTTP/SSE transportLOG_LEVELLogging verbosity levelOCI_CLIENT_TIMEOUTTimeout for OCI SDK callsConfiguration
{"mcpServers": {"oci-opsi": {"command": "python", "args": ["-m", "mcp_oci_opsi"], "env": {"OCI_CONFIG_FILE": "~/.oci/config"}}}}