DBKraft For Oracle
Modernise your Oracle development and administration — in one workspace, on your own machine
Oracle teams lose hours to tool-switching: one application for the editor, another for the debugger, a third for session monitoring, a spreadsheet for the health report. DBKraft For Oracle puts all of it in a single Windows workspace — and connects straight to your database with no Oracle client to install and no repository objects to create in your database.
Everything runs on your own machine. The application talks to a local service on your PC, which connects directly to your Oracle listener. There is no cloud component, no account server and no telemetry. The only outbound call the product ever makes is a one-off licence activation — and there is an offline path for machines with no internet at all.
AI is there where it saves real time — generating and explaining SQL, suggesting optimisations, interpreting index recommendations — running on your provider and your API key. The rest of the product is fully functional without it.
Capabilities
- Develop — multi-tab SQL and PL/SQL editor with autocomplete, formatting, explain plans, snippets, a visual query builder and real manual-commit transactions.
- Debug and test — breakpoints, stepping, watches and a call stack driven by Oracle's own
DBMS_DEBUG; PL/SQL test suites with expected outputs and performance thresholds. - Administer — session browser with a blocking-lock tree, tablespace and datafile browsing, ASM and RAC overviews, Multitenant (CDB/PDB) switching.
- Diagnose and tune — live metrics, a scored health scan, a statement profiler, an index advisor and concurrent-session load testing.
- Model and document — reverse-engineer a schema to an ER diagram and forward-engineer DDL back out; run parameterised reports and export them branded.
- Automate and extend — scheduled workflows, DDL and data import/export, extensions, and fully offline language packs.
Covers the database lifecycle, end to end
One product spans the work a database team actually does — from the first model of a schema to the tuning of a statement already running in production.
DBKraft For Oracle supports the database lifecycle, end to end.
| Stage | What DBKraft does |
|---|---|
| Design | The ER diagram modeler reverse-engineers an existing schema, lets you edit the model visually, and forward-engineers the DDL back out. |
| Build | Multi-tab editor, autocomplete, formatter, snippet library, visual query builder, explain plan, and a results grid that edits cells and generates the matching UPDATE script. |
| Test | DBMS_DEBUG debugger with breakpoints, stepping, watches and call stack; unit test manager with suites, expected results and per-test performance thresholds. |
| Deploy | Schema compare and synchronise, DDL export, data import/export, and object version history with diffs and one-click restore. |
| Administer | Session browser with blocking tree and kill, storage and tablespace browser, ASM and RAC panels, PDB open/close, and scheduled automation workflows. |
| Optimise | Live metrics, scored health scan, statement profiler, index advisor, and a concurrent-session load tester. |
DBKraft keeps its own feature data — saved reports, test suites, load tests, object version history — in local files on your workstation. There are no repository tables, no packages and no schema objects to deploy into Oracle: nothing to review, nothing to patch, and nothing left behind when you uninstall.
Development modules
SQL Editor
Multiple tabs, schema-aware autocomplete, one-click formatting, explain plans and a snippet library. The editor runs in manual-commit mode — it holds a real, long-lived Oracle transaction across requests, so COMMIT and ROLLBACK mean what they mean in SQL*Plus, and pending state is read back from the database rather than guessed at in the interface. Query history, file open/save and a visual query builder are built in.
Results grid and data editing
Search, filter, page and export results; edit cells in place and have DBKraft generate the matching UPDATE script for review before you run it. Any result set can be charted straight from the grid.
Object Browser and Object Viewer
Navigate schemas and object types, generate DDL, compare two objects side by side, and import data into a table — all from a context menu on the object itself.
PL/SQL Debugger
A real debugging session driven by Oracle's DBMS_DEBUG: line breakpoints, step in / over / out, live variable inspection, watches, a call stack and a debug console. Debug logs export for sharing, and an offline simulator lets you rehearse the workflow without a target database.
Unit Test Manager
Author PL/SQL test suites with setup and teardown, expected outputs and performance thresholds, then read pass/fail results per test. Suites live locally with DBKraft — nothing is installed into your database.
Reports
A catalogue of parameterised reports with bind variables, CSV and Excel export, and formatted document generation from editable HTML templates you can brand.
SQL Terminal
A SQL*Plus-style terminal with its own login sequence, built-in commands, output and history — with terminal groups and splits in the bottom dock.
DBA modules
DBA Dashboards
Live Metrics polls the database every five seconds for CPU, memory, active sessions and the top wait events. The Health Scan scores the database out of 100 across performance, objects, storage, security and configuration — buffer cache hit ratio, active sessions, invalid objects, per-tablespace usage, DBA role grants and archive log mode — each result carrying a measured value and, where relevant, a specific recommendation. Missing privileges never break a scan: the affected check names the exact grant it needs. Exports to CSV.
Session Browser
Summary tiles, an all-sessions view with auto-refresh, a blocking-lock tree showing exactly who is waiting on whom, full session details, and session termination.
Storage Browser
Tablespace summary tiles, per-tablespace usage and datafile detail.
Schema Tools and Version History
Schema compare and synchronise, DDL export and data import/export. Object DDL is captured automatically as it changes, with a three-pane diff view and one-click restore of an earlier version.
Performance Profiler and Index Advisor
Profile a statement and ask your configured AI provider for optimisation suggestions. Analyse SQL in estimate or measure mode, review ranked index recommendations, and use Explain with AI for the reasoning in plain language.
Load Tester
Build a workflow of statements, run it across concurrent sessions with configurable options, and read throughput and error results — scalability testing without a separate product.
Automation and Jobs
A workflow designer with multi-step definitions, cron scheduling and execution history for recurring maintenance and release tasks.
Multitenant aware, RAC and ASM aware, privilege aware. Where an account lacks a grant, DBKraft names the exact privilege required and keeps the rest of the panel working, instead of failing the whole screen.
AI on your terms
Bring your own provider — OpenAI, Anthropic, Google Gemini, Azure OpenAI, Mistral, Groq or any OpenAI-compatible endpoint — and your own API key, stored locally on the device and sent only to that provider. Generate, Explain, Optimize, Fix and Review actions are available in the editor and debugger; any code block in a reply inserts straight into the active tab. The same configuration powers the Performance Profiler and Index Advisor suggestions.
Editions and licensing
DBKraft For Oracle is licensed per seat, in Professional and Enterprise editions, time-limited terms.
- Online activation — paste the
DBCK-…licence key and click Activate. The application generates a machine-specific challenge, exchanges it with the licensing authority and verifies the signed response locally. Internet access is needed for those few seconds only. - Offline activation — for air-gapped workstations: generate an activation code, redeem it in the licensing portal from any browser, and paste the signed response back. Verification is cryptographic and entirely local.
- Seat management — deactivating a machine releases its seat automatically, so a licence moves between workstations without contacting support.
- Full visibility — the in-app licence dialog shows the licensee, edition, licence ID, seat number, issue and expiry dates, and the machine code.
System requirements
| Operating system | Windows 10 or Windows 11 (64-bit) |
|---|---|
| Disk | ~500 MB, plus space for logs and local feature data |
| Memory | 4 GB minimum; 8 GB recommended for the ER modeler or load tester |
| Network | TCP access to your Oracle listener (default port 1521); internet once, for activation |
| Oracle client | Not required — the driver is built in. No Instant Client, no tnsnames.ora, no ORACLE_HOME. |
| Database | Oracle Database, including Multitenant (CDB/PDB), RAC and ASM |
Security and data handling
- Connecting is authenticating. DBKraft has no user accounts of its own and stores no directory of users. Your Oracle account decides what the application can do; connecting as
syselevates toSYSDBAautomatically and is badged in red throughout the interface, so the privilege level is never ambiguous. - Passwords are opt-in and encrypted. “Remember password” is off by default. When enabled, the password is stored only as ciphertext from the Windows credential vault (DPAPI). If the OS vault is unavailable it is simply not saved — there is deliberately no plaintext fallback. Clear saved credentials performs a deep erase that leaves no recoverable remnant.
- Credentials never reach a log file. Records are redacted before they are written and request bodies are never logged. Passwords and SQL are excluded from diagnostic bundles.
- No repository objects. Your Oracle database is never modified to make the product work.
- Diagnostics stay local until you send them. Application, session, error, performance and debug logs are written locally with per-session retention, crash reports are captured automatically, and a bug report is transmitted only when you choose to send it.
The one outbound call DBKraft makes is licence activation — and even that has an offline path.
About DBKraft
DBKraft builds developer and DBA tooling for Oracle teams that want capability without complexity — a single installer, no server-side footprint, and no dependency on anyone else's cloud.
Support
Kaustubh@amal.aeDwij@amal.ae
© 2026 DBKraft. All rights reserved. DBKraft and DBKraft For Oracle are trademarks of DBKraft. Oracle, Oracle Database, PL/SQL, SQL*Plus, Oracle RAC and Oracle ASM are registered trademarks of Oracle Corporation. Microsoft, Windows and Outlook are trademarks of Microsoft Corporation. All other trademarks are the property of their respective owners. Specifications are subject to change without notice.