Product
Query, explore, compare, migrate, monitor and investigate from one workspace — with production safety, jobs and permissioned AI built on shared infrastructure.
Write SQL with schema-aware autocomplete, syntax highlighting and database-aware assistance. Run a statement, selection or complete script and keep results attached to the query that produced them.
Navigate databases, schemas, tables, columns, relationships, indexes, views and routines from one structured explorer.
Browse large result sets without loading everything into memory. Filter, sort, inspect and safely edit records from a virtualized data grid.
Turn complex execution plans into something you can investigate. DBNox visualizes query plans, highlights expensive operations and connects findings back to the tables and indexes involved.
Daily query, explore and edit workflows in one workspace.
Combine SQL, Markdown, parameters, results and charts in reusable notebooks for analysis, troubleshooting and documentation.
Open XML from files or grid cells. Source and tree views, with a structural compare that ignores indentation.
Open JSON and JSONB from files, query results or database cells. Tree, table, form and source views with diff, patch and schema inference.
Save, export, chart and compare result sets instead of treating every grid as disposable output.
Search databases, schemas, tables, columns, views, routines, saved queries and snippets from one index — even across hundreds of schemas.
Compare, migrate, transfer and verify environment changes.
Compare databases, schemas or saved snapshots. See structural differences and generate reviewable migration SQL before deployment surprises.
Find records that are missing, changed or different between environments, then inspect field-level differences before synchronizing.
Create and apply versioned migrations with checksums, execution history and explicit rollback SQL when available.
Import, export and copy data between supported databases with mapping, type conversion, validation and progress tracking.
Capture schema metadata, DDL, relationships and selected statistics for offline inspection, drift baselines and support diagnostics.
Persist production ↔ staging relationships, compare schema snapshots on demand and review drift history before it becomes an incident.
Copy production into development with masking, deterministic transforms and referential consistency across related tables.
Save source, target, filters, mappings and masking rules as named pipelines you can rerun from Job Center or CLI.
Evidence-based diagnostics and permissioned assistants.
AI Assist and /ai write SQL, or a Redis command, from plain language and can explain the statement under the cursor or in a notebook cell.
Ask why a query is slow and let DBNox inspect plans, statistics, indexes and locks — then explain findings with evidence links back to the workspace.
Send the captured execution plan to the selected model and read the analysis next to the operators.
Describe a task inside a container. DBNox asks the model for a single shell command and shows the prompt before you run it.
Run Qwen with the bundled llama.cpp server, including start-on-open, or use Ollama. Cloud keys stay optional and live in the OS keychain.
Attach DBNOX.md or custom markdown notes per connection so assistants inherit schema conventions, deprecated tables and query guardrails.
Track normalized query fingerprints, plan changes and latency over time so slowdowns surface before users complain.
Surface unused, duplicate or missing-index candidates with query frequency, scan counts and reviewable migration drafts — not fabricated percentages.
Inspect null rates, distinct counts, type anomalies, top values and sensitive-field candidates using sampling where tables are large.
Navigate ER diagrams with declared foreign keys plus optional inferred links labeled with confidence and evidence.
Manage roles, grants and ownership across schemas, tables and functions with SQL preview before execution.
Answer why a user can SELECT a table by tracing role membership, grants, PUBLIC, ownership and row-level security.
Monitor live systems, run background work and connect agents.
Investigate sessions, active queries, locks, waits, table statistics, indexes and database health without leaving the workspace.
Keep working while DBNox handles imports, exports, comparisons, backups and transfers. Track progress, cancel operations and inspect failures.
Expose selected connections to MCP clients with per-connection policies — schema only, read only, read + write or custom — enforced at the DBNox tool layer.
Open a local shell or an SSH session next to the database you are working on.
Browse local files, SFTP from an SSH connection, and FTP, FTPS or S3 profiles, then transfer between panes.
List and inspect Docker and Podman containers, and run a command inside one. DBNox does not claim a Kubernetes GUI.
Keep REST and HTTP endpoint profiles in the same workbench. DBNox does not claim gRPC or GraphQL parity.
Run schema diff, data compare, transfer and snapshot commands from scripts with JSON output and CI-friendly exit codes.
