| name | mcp-architecture |
| description | Model Context Protocol (MCP) integration patterns for Oracle Cloud — Oracle Database MCP, OCI resource management, and enterprise agent architecture |
| version | 1.0.0 |
| platform | ["claude-code","cline","cursor","roocode"] |
| activation | {"cline":"@skills/mcp-architecture/SKILL.md","cursor":"@skills/mcp-architecture/SKILL.md"} |
MCP Architecture for Oracle
You are an expert in Model Context Protocol (MCP) integration with Oracle Cloud Infrastructure.
When to Use
- Integrating MCP servers with OCI services
- Building Oracle Database MCP connections
- Creating OCI infrastructure MCP tools
- Enterprise MCP architecture patterns
Oracle MCP Servers
Oracle Database MCP
{
"mcpServers": {
"oracle-database": {
"command": "npx",
"args": ["-y", "@anthropic/oracle-database-mcp"],
"env": {
"ORACLE_USER": "your_user",
"ORACLE_PASSWORD": "your_password",
"ORACLE_CONNECT_STRING": "host:port/service"
}
}
}
}
Tools: query, describe_table, list_tables, get_ddl
Oracle AI Database 26ai + MCP
26ai introduces Select AI Agent — in-database AI agents that can be called via MCP:
- Natural language to SQL translation
- In-database vector search via MCP
- Agent-to-agent communication
- MCP as the protocol layer between agents and database
Architecture Patterns
Pattern 1: Direct Database Access
AI Assistant → Oracle DB MCP → AI Database 26ai
Pattern 2: OCI Resource Management
AI Assistant → OCI MCP → OCI APIs → Resources
Pattern 3: Agent-Orchestrated
┌→ Oracle DB MCP
AI Assistant → ADK Agent ┼→ OCI MCP
└→ Custom Tools
Pattern 4: Enterprise (Production)
┌──────────────────────────────────────┐
│ Enterprise Zone │
│ ┌─────────────┐ ┌────────────┐ │
│ │ AI Assistant│───▶│ MCP Gateway│ │
│ └─────────────┘ └──────┬─────┘ │
│ │ │
│ ┌──────────────────────┼────────│
│ ▼ ▼ │
│ ┌───────────┐ ┌──────────┐ │
│ │ DB MCP │ │ OCI MCP │ │
│ └─────┬─────┘ └────┬─────┘ │
│ ▼ ▼ │
│ ┌───────────┐ ┌──────────┐ │
│ │ Oracle │ │ OCI │ │
│ │ AI DB 26ai│ │ Services │ │
│ └───────────┘ └──────────┘ │
└──────────────────────────────────────┘
Security
- Use instance principals (no API keys on instances)
- Private endpoints for MCP servers
- Audit all MCP tool invocations
- Least privilege IAM policies
Resources
Cline Activation
To use this skill in Cline, reference it at the start of your message:
@skills/mcp-architecture/SKILL.md
Design an enterprise MCP architecture connecting Oracle AI Database 26ai and OCI services for an agentic RAG system.
Or in a .clinerules workflow:
## MCP Integration
When integrating MCP with Oracle services, load @skills/mcp-architecture/SKILL.md. Use instance principals for auth, private endpoints, and audit all tool invocations.
Triggers: MCP, Model Context Protocol, Oracle MCP, OCI MCP, database MCP, Select AI Agent, MCP gateway
