dbDBCraftDocs
Overview
IGetting started
About this guideWhat DBCraft AI Studio isInstallationActivating your licenceConnecting to a databaseA tour of the workspace
IIThe workspace
The menu barThe icon toolbarThe connection chip and container switcherThe docking railThe left panel (cluster drawer)The bottom dockThe status barThe command paletteExtra windows
IIIDevelopment modules
SQL EditorResults grid and data editingGraphsObject Browser and Object ViewerPL/SQL DebuggerUnit Test ManagerReports
IVDBA modules
Schema ToolsVersion HistorySession BrowserDBA Dashboards (Health)Storage BrowserPerformance Profiler and SQL OptimizerIndex AdvisorER Diagram ModelerAutomation and JobsLoad Tester
VTools and utilities
SQL TerminalAI AssistantExport Tables and Import Tables
VIConfiguration and reference
Settings referenceKeyboard shortcutsLicence managementLogging, diagnostics and bug reportsSecurity and data handlingTroubleshootingFile and folder locationsBackend API referenceGlossary
Documentation/Configuration and reference
Appendix B

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