Environment-aware policies
Production can stay read-only by default while development allows faster iteration with explicit confirmation.
The modern database engineering workbench
Query data, explore schemas, compare environments, manage migrations, investigate performance and operate databases safely from one desktop engineering workspace.
Windows · macOS · Linux
Early bird $49 for the first 100 customers. Regular price $99. One year of updates.
SELECT
o.id,
o.status,
o.total,
c.email
FROM orders o
JOIN customers c
ON c.id = o.customer_id
WHERE o.store_id = 12
AND o.created_at >= now() - interval '7 days'
ORDER BY o.created_at DESC
LIMIT 50;| id | status | total | |
|---|---|---|---|
| 10482 | paid | 186.40 | ada@shop.io |
| 10481 | paid | 42.00 | lin@shop.io |
| 10480 | pending | 91.25 | kai@shop.io |
Supported databases
Built with Rust + Tauri · Windows · macOS · Linux
Capability depth varies by engine.
Writing SQL is only part of the job. You inspect schemas, edit data, analyze execution plans, compare environments, build migrations, investigate locks and move data between systems.
DBNox brings those workflows together in one database engineering workspace, so the context stays with the problem.
The usual stack
DBNox
Product overview
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.
Autocomplete
customer_id
created_at
customers
SQL IDE
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.
Autocomplete
customer_id
created_at
customers
Schema explorer
Navigate databases, schemas, tables, columns, relationships, indexes, views and routines from one structured explorer.
| Column | Type | Keys |
|---|---|---|
| id | uuid | PK |
| text | ||
| status | varchar(20) | |
| created_at | timestamptz |
Data grid
Browse large result sets without loading everything into memory. Filter, sort, inspect and safely edit records from a virtualized data grid.
3 changes pending
| id | status | total | store_id |
|---|---|---|---|
| 10482 | shipped | 186.40 | 12 |
| 10481 | paid → refunded | 42.00 | 12 |
| 10480 | pending | 91.25 | 8 |
Query profiler
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.
Findings
Potential indexorders(customer_id, created_at)
Production safety
Classify connections as local, development, staging or production. DBNox applies a central Safety Engine across the SQL editor, data grid, AI, MCP, compare, migrations and transfer workflows.
Production can stay read-only by default while development allows faster iteration with explicit confirmation.
Unbounded UPDATE and DELETE, DROP, TRUNCATE and other high-impact statements are classified before they execute.
Mutations can require review, typed confirmation, affected-row preview or a temporary safety token — not a silent run.
Reasoned, reviewable changes instead of accidental writes across editor, grid and agent workflows.
● PRODUCTION
DELETE FROM orders;
Blocked by Production Safety
DELETE has no WHERE clause.
DBNox Intelligence
PreviewDBNox AI writes and explains queries in the editor, reads execution plans, and can investigate with typed database tools. Writes wait for your approval. A local model can stay on the machine.
AI Assist and /ai turn a plain-language request into SQL, or into a Redis command on a Redis connection. Search engines are asked in that engine's query form.
Explain the statement under the cursor, or a notebook cell, without executing it.
Visual EXPLAIN can send the plan to the model and show the analysis beside the operators.
The investigator can call EXPLAIN, statistics, indexes, locks and sessions, then explain what those tools returned.
Describe what you want inside a container. DBNox asks the model for one shell command and shows the prompt before you run it.
Run Qwen through the bundled llama.cpp server, and start it when DBNox opens, or use Ollama. Cloud providers stay optional.
Why is this query taking 12 seconds?
Investigating
Finding
orders scans 8.7M rows while returning 214.
No existing index covers store_id + status + created_at
Production mode: Advisory only
Keep AI advisory, allow read-only investigation, or approve each write. AI activity records what was asked. Per-connection notes can carry schema conventions the assistant should follow.
API keys stay in the operating-system keychain. A local Llama or Ollama runtime needs no cloud key. Choosing a model does not grant it database permissions.
DBNox is not a pile of disconnected utilities. Compare, migrate, monitor, AI and MCP share connections, safety policies, jobs and audit infrastructure.
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.
Database, filesystem and system operations run through the native DBNox backend.
Store supported credentials through operating-system secure storage rather than plaintext application configuration.
DBNox connects from the desktop without requiring a mandatory DBNox database proxy.
Use supported local models when database context should remain in your environment.
Built with Tauri, Rust and modern web technologies for a lightweight cross-platform desktop experience.
A factual capability comparison. Unreleased DBNox workflows are marked instead of implied.
| Capability | Typical SQL client | DBNox |
|---|---|---|
| SQL editing | Yes | Yes |
| Data editing | Yes | Yes |
| Schema exploration | Yes | Yes |
| JSON and XML editors | Varies | Yes |
| Terminal and file transfer | Varies | Yes |
| Docker and Podman | Varies | Yes |
| REST API client | Varies | Yes |
| Visual EXPLAIN | Varies | Yes |
| Schema comparison | Varies | Yes |
| Data comparison | Varies | Yes |
| Migrations | Varies | Yes |
| Import / export / transfer | Varies | Yes |
| Live monitoring | Varies | Yes |
| Query diagnostics | Varies | Yes |
| Production safeguards | Varies | Yes |
| Permissioned AI | Varies | Preview |
| MCP for agents | Varies | Preview |
| Notebooks | Varies | Yes |
| SSH / SFTP | Varies | Yes |
| Background jobs | Varies | Yes |
| Environment drift detection | Varies | Coming Soon |
| Data sanitization pipelines | Varies | Coming Soon |
DBNox vs DBeaver leads with memory: DBNox is about 15 MB. DBNox vs Mongrel covers licensing.
DBNox is a desktop workbench for querying data, exploring schemas, comparing environments, migrations, monitoring and JSON and XML editing. It also includes a terminal, file transfer (SFTP, FTP/FTPS and S3), Docker and Podman containers, and a REST API client. Production safety and permissioned AI are included; a Kubernetes GUI and gRPC or GraphQL clients are not.
Validated engines currently include PostgreSQL, MySQL, MariaDB, SQLite, MongoDB, Redis, ClickHouse and DuckDB, with SQL Server in preview. Capability depth varies by engine and feature.
Yes. DBNox is built with Tauri and Rust for Windows, macOS and Linux. Windows is available now: 64-bit .exe and .msi installers on the download page, and the Microsoft Store listing at https://apps.microsoft.com/detail/xpfnwc91lzswht. macOS and Linux builds are not published yet.
Yes. Schema Compare diffs databases, schemas or snapshots and generates reviewable migration SQL. Data Compare finds missing, changed and equal rows between tables or query results with configurable keys and column mapping.
Connections can be classified by environment. A central Safety Engine applies policies across the SQL editor, data grid, AI, MCP, compare and migration workflows — blocking or requiring confirmation for dangerous statements like unbounded DELETE or DROP on production.
Yes, as Preview. In the editor, AI Assist and /ai generate SQL or a Redis command and can explain the statement under the cursor. Visual EXPLAIN can analyze a plan. The investigator uses EXPLAIN, statistics, indexes and locks before it explains a finding. Container exec can ask for one shell command. Providers include OpenAI, Anthropic, MiniMax, OpenRouter, Ollama, a bundled local Llama runtime, and OpenAI-compatible endpoints. Writes wait for approval.
Model Context Protocol lets compatible AI development tools access selected DBNox connections through a Safe MCP Gateway. Each connection can be schema-only, read-only, read + write or custom. Policies are enforced at the DBNox tool layer with audit logging.
Import, export and database-to-database copy are available today. Reusable sanitization pipelines that mask production data for development refresh are on the roadmap.
No. DBNox connects to your databases directly from the desktop and stores supported credentials in operating-system secure storage. Optional cloud AI only receives the context you explicitly allow — using a cloud model is not the same as keeping database context local.
No. You pay once per seat. Early bird is $49 USD for the first 100 customers. Regular price is $99 USD. The seat includes 12 months of major and minor updates and patches. After that year, the app keeps working and new updates stop.
DBNox’s memory footprint is about 15 MB. DBeaver is a Java client with a default maximum heap of 1 GB and a much wider set of databases. DBNox also includes compare, migrations, JSON and XML editors, a terminal, files, Docker and Podman, and a REST client. Early bird is $49 USD per seat for the first 100 customers. Regular price is $99 USD, paid once. See the comparison page.
Both are desktop workbenches. DBNox combines database engineering — SQL, schema and data compare, migrations, monitoring, JSON and XML editors — with a terminal, files (SFTP, FTP/FTPS and S3), Docker and Podman containers, and a REST API client. Early bird is $49 USD per seat for the first 100 customers. Regular price is $99 USD, paid once, with 12 months of updates. The app keeps working after that. Mongrel, from VisorCraft, is billed annually and markets a wider engine list plus gRPC/GraphQL and Kubernetes depth DBNox does not claim. See the dated comparison page.
Windows builds are on https://dbnox.com/download as a 64-bit .exe and .msi, and on the Microsoft Store at https://apps.microsoft.com/detail/xpfnwc91lzswht. macOS and Linux builds are not published yet.
Released features ship in current desktop builds. Preview features are usable but still evolving. Coming Soon features are on the public roadmap and not yet available — the site labels them explicitly rather than implying they exist today.
Query it. Understand it. Improve it. Change it safely.
Early bird $49 for the first 100 customers. Regular price $99.
Windows · macOS · Linux