# Oracle Solution Design

> Orchestrate complete OCI solution designs with parallel agents and quality gates, producing Solution Design Documents, architectures, and bills of materials. Use when producing an OCI SDD, end-to-end solution architecture, or a bill of materials.

- Skill: `frankxai/oracle-solution-design` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add frankxai/oracle-solution-design`
- Raw SKILL.md: https://api.skillmd.com/api/skills/frankxai/oracle-solution-design/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: frankxai (https://skillmd.com/u/frankxai)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/frankxai/oracle-solution-design

---


# Oracle Solution Design Orchestrator

> **Replaces:** claude-flow swarm orchestration for solution design workflows
> **Method:** Native Claude Code Task agents with parallel dispatch + quality gates
> **Confidentiality:** Conversation-only context model. Zero persistent state.

## When to Use This Skill

Invoke when the user needs:
- A complete solution design for a customer engagement
- A Solution Design Document (SDD) for an OCI-based solution
- An architecture recommendation with BOM and visuals
- A prototype or interactive demo for a customer presentation

**Trigger:** `/oracle-solution-design` or when user says "solution design", "SDD", "architecture for [client]"

---

## The 5-Phase Workflow

```
  DISCOVER --> ARCHITECT --> VISUALIZE --> PROTOTYPE --> DELIVER
     |             |             |              |            |
  [Gate 1]     [Gate 2]     [Gate 3]       [Gate 4]    [Gate 5]
     |             |             |              |            |
  Parallel     system-       nano-banana    coder         Package
  research     architect     + infogenius   agent         + audit
  agents       agent
```

### Phase Execution Model

Each phase uses native Claude Code capabilities. No daemon, no vector DB, no external processes.

| Phase | Agent Strategy | Tools Used |
|-------|---------------|------------|
| DISCOVER | Parallel Task(researcher) x2-3 | WebSearch, WebFetch, Grep, Read |
| ARCHITECT | Task(system-architect) + Task(researcher) | Read, WebFetch, Write |
| VISUALIZE | Direct (main context) | Nano Banana MCP, Read |
| PROTOTYPE | Task(coder) or direct | Write, Edit, Bash |
| DELIVER | Direct (main context) | Write, Read, Bash |

---

## Phase 1: DISCOVER

### Objective
Gather all information needed to design the solution. Run research in parallel.

### Auto-Discovery Checklist (MANDATORY Before Building ANY Portal or Deliverable)

Before launching research agents, execute this checklist to gather existing context:

```
1. READ client deliverables folder (all .md files in clients/[CODE]/)
2. READ hub portfolio for matching industry portal
   → projects/hub/portals/ (11 portals available)
3. CHECK OCI AI Blueprints for relevant patterns
   → CLAUDE.md "Customer Project Decision Tree"
4. CHECK client's system landscape for integration depth
   → JDE, SAP, BestMix, LIMS, MES, SharePoint, etc.
5. INCLUDE discovery questions section (minimum 4 cards)
6. INCLUDE user flows page (minimum 4 personas)
7. INCLUDE prompt library page (minimum 4 system prompts)
8. LINK to existing OCI architectures in footer
```

**Why mandatory:** Without this step, agents follow the explicit scout list literally and miss:
- Pre-existing hub portfolio architectures for the client's industry
- OCI AI Blueprints with pre-built deployment patterns
- RAG tooling decision matrix context
- Discovery questions tailored to the client's specific system landscape

### Parallel Agent Dispatch Pattern

Launch 2-3 Task agents simultaneously:

**Agent 1 -- OCI Capabilities Research:**
```
Task(subagent_type="researcher")
"Research OCI services for [use case]. Check:
 1. OCI GenAI models available (docs.oracle.com/iaas/Content/generative-ai/)
 2. Relevant oracle-quickstart repos (github.com/oracle-quickstart)
 3. OCI AI Blueprints if GenAI workload
 Return: service list with capabilities and limitations."
```

**Agent 2 -- Industry/Domain Research:**
```
Task(subagent_type="researcher")
"Research [industry/domain] AI patterns:
 1. Common architecture patterns for [use case]
 2. Compliance/regulatory requirements
 3. Industry benchmarks and KPIs
 Return: requirements matrix and constraints."
```

**Agent 3 -- Pricing and Competitor Landscape (if needed):**
```
Task(subagent_type="researcher")
"Research current pricing for [specific OCI services]:
 1. Verify at oracle.com/cloud/price-list/
 2. Check OCI Cost Estimator for complex scenarios
 3. Note any commitment discounts or free tiers
 Return: verified pricing with sources and dates."
```

### Confidentiality Gate
Before proceeding, verify:
- No real customer names in any output
- All context uses codename only
- Research results are generic (industry patterns, not client-specific)

### Output
Mental model of the solution. No document yet. Just validated understanding.

### Quality Gate 1: Discovery Complete
- Core use cases identified (top 3)
- OCI services mapped to requirements
- Constraints documented (compliance, timeline, budget)
- Existing OCI patterns checked (oracle-quickstart, AI Blueprints)
- Auto-Discovery Checklist completed (hub portfolio, blueprints, system landscape)

---

## Phase 2: ARCHITECT

### Objective
Design the technical architecture with OCI service selection and cost estimation.

### Agent Strategy

**Primary: System Architect Agent**
```
Task(subagent_type="system-architect")
"Design an OCI architecture for [use case] with these requirements:
 [paste discovery results]

 Deliver:
 1. OCI service selection with rationale for each choice
 2. Architecture tiers (Basic / Advanced / Premium)
 3. Data flow: ingestion > processing > storage > retrieval > presentation
 4. Security architecture: IAM, encryption, network isolation
 5. Integration points and APIs"
```

**Support: Pricing Verification**
```
Task(subagent_type="researcher")
"Verify pricing for these OCI services: [list from architect]
 Source: oracle.com/cloud/price-list/
 Return: Monthly cost estimate by tier with line items."
```

### MANDATORY Checks Before Finalizing Architecture
1. AI Blueprints decision tree -- Does an existing blueprint cover this? (See CLAUDE.md)
2. Model selection -- Use the OCI GenAI Model Selection Matrix (See CLAUDE.md)
3. Pricing claims -- NEVER say "X times cheaper" without specific model comparison
4. Service availability -- Confirm services exist in target OCI region

### Document Generation

Generate the SDD in clients/[CODE]/ using /oracle-sdd-generator skill.

### Quality Gate 2: Architecture Validated
- Every OCI service verified against official docs
- Pricing confirmed via oracle.com/cloud/price-list/ (not from memory)
- No blanket cost comparison claims
- Existing patterns checked (oracle-quickstart, technology-engineering)
- Architecture follows OCI Well-Architected Framework principles
- Confidentiality audit passed (no client names, codename only)

---

## Phase 3: VISUALIZE

### Objective
Create architecture diagrams that are logo-free and technically accurate.

### Direct Execution (Main Context)
Visual generation stays in the main context for interactive refinement:

1. Invoke /oracle-infogenius or Nano Banana directly
2. Mandatory prompt elements:
   - "NO Oracle logos -- text labels only"
   - Oracle Red (#C74634) for accents
   - Dark background for professionalism
   - All service names must match official branding
3. Draft then Refine pattern:
   - Flash ($0.039) for initial draft
   - Review and adjust prompt
   - Pro ($0.134) for final version only after draft approved

### Recommended Visual Set

| Image | Audience | Focus |
|-------|----------|-------|
| Master Architecture | Technical + Executive | Full OCI stack, all tiers |
| User Journey | Executive | 4-5 step flow, business outcomes |
| Data Flow | Technical | Ingestion to Processing to Storage to Retrieval |
| Tier Comparison | Commercial | Side-by-side Basic/Advanced/Premium |

### Quality Gate 3: Visuals Compliant
- ZERO Oracle logos in any image
- Service names match official branding (26ai not 23ai)
- No spelling errors in diagrams
- Readable at presentation size (1920x1080 minimum)
- Architecture matches the SOLUTION-DESIGN.md

---

## Phase 4: PROTOTYPE

### Objective
Create an interactive HTML prototype the customer can experience.

### Agent Strategy

For complex prototypes:
```
Task(subagent_type="coder")
"Build an interactive HTML prototype for [solution name]:
 Requirements:
 - Single index.html with embedded CSS/JS (no build tools)
 - Simulated [core workflow] with mock data
 - Processing states (loading animations, progress bars)
 - AI insights panel with simulated responses
 - Mobile responsive
 - PROTOTYPE banner clearly visible
 - Oracle Red (#C74634) accents, dark theme
 - NO real customer data -- all mock/synthetic"
```

For simple prototypes: Build directly in main context.

### Portal Prototype (Template-First Pattern — MANDATORY)

When building a customer-facing HTML portal (not a single-page prototype), follow this process:

**STEP 1: SCOUT** — Read the best existing template portal
```
Read clients/P/portal/index.html (or designated template)
Extract: CSS variable system, nav pattern, hero pattern, card patterns
Note: line count, section count, page count
```

**STEP 2: ADAPT** — Map template patterns to new client
```
Keep: CSS architecture, component patterns, animation system
Change: colors, content, codename, branding
Add: client-specific sections (discovery questions, system landscape)
```

**STEP 3: EXPAND** — Minimum 7 pages
```
REQUIRED: index.html, strategy.html, architecture.html, matrix.html, bom.html
REQUIRED: user-flows.html (4+ personas with workflows)
REQUIRED: prompts.html (4+ system prompts with example queries)
ALWAYS: discovery questions section on index.html (4+ cards)
```

**STEP 4: VALIDATE** — Quality gate before delivery
```
[ ] Nav links all resolve (7 pages minimum)
[ ] No real company names, locations, or identifying details
[ ] Pricing disclaimer present on every page with pricing
[ ] Gradient text, animated dot, hero-stats all present on index
[ ] Pillar cards have background tints, not white
[ ] Footer with OCI reference links
[ ] Dark theme on architecture + prompts pages
```

**CSS Quality Patterns (COPY EXACTLY):**
```css
/* Gradient accent text */
.hero h1 .accent {
    background: linear-gradient(135deg, #4ADE80 0%, #059669 100%);
    -webkit-background-clip: text; -webkit-text-fill-color: transparent;
}
/* Animated pulse dot */
@keyframes dot-pulse {
    0%, 100% { opacity: 1; transform: scale(1); }
    50% { opacity: 0.4; transform: scale(0.85); }
}
/* Hero stats — large numbers, NOT badge pills */
.hero-stat-value { font-size: 42px; font-weight: 800; line-height: 1; }
/* Pillar cards with background tints, NOT white */
.pillar-card.llm { background: var(--color-llm-light); border: 1px solid rgba(5,150,105,0.18); }
/* Frosted glass nav */
.nav { background: rgba(255,255,255,0.95); backdrop-filter: blur(12px); }
```

**Agent Tool Selection:**
- Use Claude Code directly for portal pages (500+ lines). NEVER delegate large HTML to Cline.
- Cline can handle individual components (<200 lines) or nav/footer updates.

### Prototype Quality Standards
- One core workflow, executed perfectly
- Every element has obvious purpose
- No placeholder content, no broken buttons
- Demo/prototype clearly labeled
- Mock data is realistic but obviously synthetic

### Quality Gate 4: Prototype Functional
- Core interaction works end-to-end
- Processing states visible (loading, progress)
- No broken buttons or dead links
- PROTOTYPE/DEMO banner displayed
- No real customer data anywhere
- Mobile responsive (at minimum, not broken on mobile)
- If portal: all 7+ nav links resolve, template quality patterns present

---

## Phase 5: DELIVER

### Objective
Package everything for customer presentation.

### Output Structure
```
clients/[CODE]/
  SOLUTION-DESIGN.md           # Full SDD
  deliverables/
    images/
      architecture.png         # Master architecture (logo-free)
      user-journey.png         # Executive flow
      data-flow.png            # Technical detail
      tier-comparison.png      # Commercial comparison
    prototype/
      index.html               # Interactive demo
    docs/
      DISCOVERY.md             # Requirements captured
      BOM.md                   # Bill of Materials
  portal/                      # Customer-facing portal (if applicable)
    index.html                 # 7+ pages with template quality
    strategy.html
    architecture.html
    matrix.html
    bom.html
    user-flows.html
    prompts.html
    styles.css                 # Shared CSS (optional, can be embedded)
  README.md                    # Project overview (codename only)
```

### Final Confidentiality Audit
Before any delivery:
- grep for real customer names in all output files -- MUST return zero
- Solution name is generic or codename-based
- No internal Oracle pricing beyond published list prices
- No competitor attacks -- only OCI capability focus
- README.md contains ONLY: status, role, codename -- no industry/scope

### Quality Gate 5: Delivery Ready
- All files in correct structure
- README complete with codename only
- Images are logo-free (visual inspection)
- Prototype loads and works standalone
- BOM pricing verified against official sources
- Would McKinsey present this to a Fortune 500 CEO? Yes/No

---

## Quick Reference: Agent Routing Matrix

| Need | Agent | Why Not Other? |
|------|-------|----------------|
| OCI service research | Task(researcher) | Web search + fetch access |
| Competitor/market research | Task(researcher) | Web search access |
| Architecture design | Task(system-architect) | Architecture patterns expertise |
| Code review of prototype | Task(reviewer) | Code quality focus |
| Build prototype | Task(coder) | Implementation focus |
| Deep codebase exploration | Task(Explore) | Fast file search |
| Multi-step planning | Task(Plan) | Architecture planning |
| Pricing verification | Task(researcher) | Needs web access |

## Anti-Patterns

| Do Not Do This | Do This Instead |
|---------------|----------------|
| Run all phases sequentially with no parallelism | Parallel research agents in Phase 1 |
| Skip pricing verification | ALWAYS verify at oracle.com/cloud/price-list/ |
| Include Oracle logos in visuals | Text labels only, Oracle Red accents |
| Persist client context to files | Conversation-only context, codename in files |
| Use claude-flow daemon for orchestration | Native Task agents -- zero infrastructure |
| Generate final visuals on first attempt | Flash draft first, Pro only after approval |
| Build complex prototype without coder agent | Delegate to Task(coder) for complex HTML/JS |
| Deliver without confidentiality audit | Always grep for real names before delivery |
| Build portal from scratch without template | SCOUT existing template first (Client P portal) |
| Delegate 500+ line HTML to Cline | Use Claude Code Write tool directly |
| White pillar cards, badge-style stats | Background tints, large 42px stat numbers |
| Skip auto-discovery checklist | ALWAYS check hub portfolio, AI Blueprints, system landscape |

---

## Integration with Other Skills

| Phase | Complementary Skill | When to Invoke |
|-------|---------------------|---------------|
| DISCOVER | /oracle-research | Deep OCI service investigation |
| ARCHITECT | /oci-services-expert | Service selection + pricing |
| ARCHITECT | /oracle-sdd-generator | Full SDD document generation |
| VISUALIZE | /oracle-infogenius | Tiered image generation |
| VISUALIZE | /oracle-ai-architect-infogenius | Full validation pipeline |
| PROTOTYPE | /oracle-adk | If agent-based prototype needed |
| DELIVER | /oracle-confidentiality | Final audit before handoff |

---

*Version: 1.1 | Updated: 2026-02-25 | Added: Portal template mandate, Auto-Discovery Checklist*
*Version: 1.0 | Created: 2026-02-09 | Replaces: claude-flow swarm orchestration*