soccer-workshop-setup

Bootstrap the soccer analytics agent workshop environment with Oracle AI Database, ML models, and hybrid retrieval.

4.4k|819|Updated Jan 16, 2024
One-click install
npx skills add https://github.com/oracle-devrel/oracle-ai-developer-hub --skill soccer-workshop-setup
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: soccer-workshop-setup
Source: https://github.com/oracle-devrel/oracle-ai-developer-hub/tree/main/workshops/soccer-analytics-agent/.claude/skills/soccer-workshop-setup
Command: npx skills add https://github.com/oracle-devrel/oracle-ai-developer-hub --skill soccer-workshop-setup

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires oracledb, python-dotenv, and includes scripts (resource) components.

What problem does it solve?

Setting up the soccer analytics agent workshop requires many ordered, failure-prone steps: starting an Oracle AI Database container, creating users with the right grants, loading FIFA match data, training or validating ML models, loading an ONNX embedding model, and populating LangChain OracleVS hybrid retrieval and LangGraph OracleDB observability stores. This Skill walks an AI agent through the entire bootstrap sequence with known failure hints for each step.

Core Features & Use Cases

  • End-to-end environment bootstrap: Starts the Oracle AI Database Free container (Docker or Podman, with Apple Silicon image detection), creates the workshop user with required grants including CREATE MINING MODEL, and loads the Kaggle international football results dataset.
  • ML and vector pipeline setup: Validates or trains XGBoost prediction artifacts, loads an augmented ONNX embedding model via onnx2oracle, loads precomputed predictions, and populates the SOCCER_LANGCHAIN_DOCS hybrid retrieval store and semantic memory.
  • Verification and observability: Runs verify.py and smoke_test.py to confirm predictions, hybrid retrieval, and LangGraph OracleDB step observability, plus builds and polishes the React front-end.
  • Use Case: An instructor preparing a workshop asks the agent to set up the environment; the Skill runs all 15 steps in order, gates on required OCI GenAI credentials, and surfaces exact fixes for common errors like ORA-01031 or ORA-54426.

Quick Start

Ask the agent to set up the soccer analytics workshop environment from scratch and verify it is ready for the demo.

Frequently Asked Questions about soccer-workshop-setup

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I set up the Oracle AI Database container for the workshop?

Run the 01_start_oracle.sh script, which auto-detects Docker or Podman, selects an ARM-native image on Apple Silicon Macs, and polls until the container is healthy. The database binds to localhost port 1525 to avoid conflicts with common Oracle ports.

How do I load an ONNX embedding model into Oracle AI Database?

Use the onnx2oracle PyPI package, which builds an augmented ONNX graph with the tokenizer baked in. Plain optimum-cli exports fail with ORA-54426 because Oracle rejects models with multiple variable-size dimensions, and the user needs the CREATE MINING MODEL grant.

Why does DBMS_VECTOR.LOAD_ONNX_MODEL fail with ORA-01031?

ORA-01031 occurs because the database user lacks the CREATE MINING MODEL privilege, which is not included in the default CONNECT and RESOURCE grants. Re-run the setup.sh script, which explicitly grants CREATE MINING MODEL to the workshop user.

Does OCI Generative AI support native tool calling with the bearer API key?

No, the OCI GenAI inference endpoint rejects tools arrays with a 400 error when authenticated via the sk- bearer key. The workshop works around this with a prompt protocol where the model emits JSON tool calls that the agent parses from response text.

What OCI values are required before the workshop is ready?

Three values must be set in .env: OCI_GENAI_ENDPOINT, OCI_GENAI_API_KEY starting with sk-, and OCI_COMPARTMENT_ID. Without them, Grok verification and smoke testing remain blocked, though local Oracle and data setup can still complete.

Why does vector embedding setup fail on Apple Silicon Macs?

The official Oracle container image is amd64-only, so Apple Silicon requires the ARM-native gvenzl/oracle-free image. The startup script detects arm64 automatically; if you forced the official image via ORACLE_IMAGE, unset it and re-run.