oracle-aidb-docker-setup

What problem does it solve?

Setting up a local Oracle 26ai Free database for development is often slow, fragile, and forces you to work as SYSTEM, which can break Oracle JSON validation for required objects like OracleVS; this Skill reliably provisions a containerized Oracle 26ai environment and creates a project-scoped application user tailored for downstream build-paths skills.

Core Features & Use Cases

• Idempotent Docker Compose Provisioning: Creates or reuses a safe local Docker environment without clobbering an existing Oracle Free compose setup, preventing accidental overwrites.
• Project-Scoped Credentials & DSN Output: Generates an .env with DB_DSN for FREEPDB1 and dedicated APP user credentials so other skills can connect without manual edits.
• Correct App User for OracleVS & ONNX-Friendly Grants: Creates a non-SYSTEM user in the ASSM-enabled USERS tablespace and grants the required privileges, including EXECUTE on SYS.DBMS_VECTOR via a SYSDBA connection for the ONNX-friendly in-database vector path.
• Use Case: When building a local agentic RAG, chat, or in-DB embeddings workflow that depends on OracleVS JSON columns and vector embedding support, this Skill is the one-time bootstrap that prepares the database to accept those objects.

Quick Start

Use the oracle-aidb-docker-setup skill to scaffold Docker Compose and a ready-to-use Oracle 26ai Free database in your project directory.