Backend API reference
The local service exposes the following endpoints on http://localhost:5020. This is provided for support and diagnostics; the endpoints are not a documented integration surface and may change between versions.
Connection and session — POST /api/oracle/test-connection, containers, pdb-operation, execute-query, commit, rollback, close-session, sessions, kill-session
Metadata — schemas, list-objects, get-ddl, resolve-object, get-object-columns, compile-plsql, drop-object, schema/relationships
Analysis — explain-plan, profile-sql, index-advisor, health-check, admin/metrics
Storage and infrastructure — storage/tablespaces, storage/segments, storage/datafiles, asm/overview, rac/overview
Schema tools — schema/compare, schema/sync-script, schema/export-ddl
Data movement — export/csv, export/excel, export/data, import/csv, import/excel, import/json, export-tables, import-tables
Debugger — POST /api/oracle/debug/start, step, stop, watch, breakpoint/toggle
Testing — /api/testing/sets, cases, cases/reorder, session/open, run
Reports — /api/reports and /api/reports/templates (full CRUD)
Version history — /api/versions/capture, objects/{id}, history, item/{id}/label, rollback
Load testing — /api/loadtest/tests, run, run/{id}/status, run/{id}/stop, run/{id}/export
Automation — /api/automation/workflows and workflows/{id}/run
Licensing — /api/license/status, challenge, activate, activate-online, deactivate
Diagnostics — /api/diagnostics/status, tail, log, crash, session/start, session/end, bug-report