oracle-axi

July 10, 2026 ยท View on GitHub

Agent-facing Oracle Database operations AXI for discovering, creating, inspecting, querying, exporting, importing, maintaining, diagnosing, and safely operating Oracle databases through token-efficient CLI workflows.

The project follows the AXI creation guidelines installed with npx skills add kunchenguid/axi.

Goals

  • Show useful live Oracle context with oracle-axi, not help text.
  • Use compact TOON-style stdout for agent parsing.
  • Keep every command non-interactive.
  • Fail loudly on unknown flags before side effects.
  • Default to read-only discovery, inspection, query, planning, or dry-run behavior.
  • Require --execute for mutations.
  • Require --confirm <exact-name> for destructive operations.
  • Truncate long SQL, inspect, export, import, and log output by default.
  • Redact passwords, connect strings, wallets, tokens, secret-like env vars, and secret-like result columns.

Usage

npm test
./bin/oracle-axi.js
./bin/oracle-axi.js doctor
./bin/oracle-axi.js services
./bin/oracle-axi.js discover
./bin/oracle-axi.js recommend --goal inspect
./bin/oracle-axi.js list --kind tables --schema APP
./bin/oracle-axi.js inspect --kind table --schema APP --name USERS
./bin/oracle-axi.js query --sql "select * from dual"
./bin/oracle-axi.js create --kind table --schema APP --name USERS
./bin/oracle-axi.js export --schema APP --file app.dmp

Mutating operations are dry-run by default. Add --execute only after reviewing the generated SQL or command. Destructive operations also require --confirm <exact-name>.

Oracle Domains

  • Connection: connect identifiers, TNS, Easy Connect, wallets, env vars
  • Schemas and objects: users, schemas, tables, views, indexes, tablespaces, sequences, synonyms
  • PL/SQL: packages, procedures, functions, triggers, invalid objects
  • Roles and security: users, roles, grants, profiles, password redaction
  • Querying: capped reads, write guards, result truncation
  • Data movement: Data Pump export/import, SQL spool planning
  • Storage: tablespaces, datafiles, segments
  • Operations: sessions, waits, locks, jobs, stats gathering
  • Maintenance: compile invalids, rebuild indexes, purge recycle bin
  • Performance: session/activity/stat views
  • Local dev: Docker Compose Oracle XE/Free services and migration directories
  • Cloud/managed Oracle: OCI Autonomous Database and hosted Oracle detection and guidance

Custom Targets

oracle-axi.config.json can define project-specific workflows:

{
  "targets": [
    {
      "id": "autonomous-wallet-refresh",
      "type": "custom",
      "detail": "provider-managed wallet refresh workflow",
      "provider": "oci-autonomous",
      "commands": {
        "plan": ["echo", "review wallet refresh plan for ${environment}"],
        "apply": ["echo", "run wallet refresh for ${environment}"]
      }
    }
  ]
}

Provider lifecycle operations are opt-in through custom targets or a future provider-specific command group with stronger guards. Core oracle-axi commands operate through Oracle client tools such as SQL*Plus, SQLcl, Data Pump, and TNS utilities.

Hooks and Skill

Install ambient session context hooks after explicit opt-in:

oracle-axi hooks install --agent all --scope project --execute

Generate or verify installable skill guidance:

oracle-axi skill generate
oracle-axi skill generate --check

AXI Catalog Entry

The upstream kunchenguid/axi community catalog entry should be:

  • AXI: oracle-axi
  • Author: thatdudealso
  • Domain: Oracle Database
  • Description: Discover, create, inspect, query, export, import, maintain, and diagnose Oracle databases through safe token-efficient CLI workflows.
  • Link: https://github.com/thatdudealso/oracle-axi