DWDataWorxGet DataWorx ↗

BETA · BUILD 454

Try the DataWorx beta

The beta is free to try.

New: DataWorx keeps itself up to date. From build 441 on, DataWorx checks for a new build when it starts and every few hours. When one is out, it shows you what’s new, and Install and Restart puts it in place. Help › Check for Updates… checks any time. If you have an earlier build, download this one once; new builds come to you after that. Also new: make an edited query a table’s default, so opening that table always starts with your query.

Recently added: Amazon Athena, Firebird and SurrealDB. Connect to an Athena workgroup with an AWS profile or access keys, find workgroups with Add from Cloud, and see what each query scanned and about what it cost. Connect to Firebird 3, 4 or 5 with nothing to install, run PSQL with or without SET TERM, and read the profiler’s measured plans. Connect to SurrealDB over WebSocket or HTTP, run SurrealQL with each statement’s rows as a table, and edit records by their IDs. Each comes with Explain, Server Activity, import, copy, design, dump, compare and search.

Also new recently: disk space for Amazon RDS, Aurora and DocumentDB in Database › Storage; Trino, Presto and SAP HANA; Compare for every database; Users and Roles, and Dump and Restore, for nearly every database; editing in nearly every database; Microsoft Entra ID sign-in and Microsoft Fabric. See every database and what it supports ↗

Download DataWorx

DataWorx-0.1.0-454.dmg · 96 MB · macOS 11 or later on an Apple silicon Mac (M1 or newer). This build doesn't run on Intel Macs. Experimental Windows builds are below.

What installing looks like

  1. Open the downloaded disk image and drag DataWorx into Applications.
  2. The first time you open it, macOS asks whether to open an app downloaded from the internet. Click Open. DataWorx is signed and notarized by Apple, so that’s the only question.
  3. DataWorx keeps saved connection passwords in your keychain. The first time it opens a saved connection, macOS asks for your keychain password. Enter it and click Always Allow.
  4. After that, DataWorx updates itself. When a new build is out, it appears in the corner with what’s new; click Install and Restart.

Windows: Experimental Windows builds are below, in Windows & Linux testing. A Linux build may follow.

THE DESKTOP DATABASE WORKBENCH

Your databases.
Your workflow.

Serious database work. One complete workspace.
Write SQL, design schemas, debug routines, chart results, and work with AI.

FAAAASSSST by design. DataWorx opens instantly and stays responsive with large results, so your database workflow never waits.

Built by a software developer with four decades of database and software development experience.

● ● ●DataWorx / a clearer view of your dataDESKTOP APP
DataWorx running a customer revenue query on a PostgreSQL store, with the explorer, formatted SQL and results grid visible
Broad database support ↗339 documented capabilities$50 perpetual release license

AT HOME WITH YOUR DATABASES

PostgreSQLCockroachDBAmazon RedshiftMaterializeCrateDBRisingWaveClickHouseMySQLMariaDBStarRocksApache DorisSQLiteSQL ServerOracleDuckDBSnowflakeGoogle BigQueryDatabricksMongoDBApache CassandraAmazon DynamoDBRedisElasticsearchOpenSearchNeo4jInfluxDBApache Spark SQLApache HiveMicrosoft FabricPGliteODBC
See every database and its level of support ↗

INTEGRATED NOW / DUCKDB

Local files.
Connected data.
One SQL workspace.

DuckDB is already integrated into DataWorx. Its embedded analytics engine turns your database workbench into a place to work with data wherever it lives.

Query files directly.

Explore local CSV, Parquet, and JSON files with SQL, right inside DataWorx.

Bring results together.

Join PostgreSQL results with Snowflake results or a file on your machine through the integrated DuckDB engine.

Stay in your workflow.

Work with files and database results in the same workspace, with DuckDB built in and ready for analysis.

NEW NOW / MONGODB

Native queries.
Guided pipelines.
Real documents.

MongoDB is now part of DataWorx: write MQL just as you would in the MongoDB shell, with an editor that knows your collections and fields and helps you build every stage of an aggregation.

Write MQL, not workarounds.

find, aggregate, inserts, updates and indexes, exactly as the shell takes them. Autocomplete suggests collections, the fields in your documents, and the $ operators that fit where you are.

Pipelines that guide you.

Choose a stage and get its whole phrase with placeholders to Tab through. See every form of the operator you're writing. After a $group or $lookup, the fields offered are the ones that exist at that point.

Documents, your way.

Results open as MongoDB JSON, or as a table with a column per field. Edit sub-documents as JSON, without drilling down; types are kept and conflicting changes are never overwritten.

DATABASE CONNECTIONS

Every database you use.
The same DataWorx focus.

Relational, analytics, NoSQL, graph and time series databases, each with a connection of its own: its own catalog, types, plans and sign-in. Databases that speak their protocols work too, and more are on the way. See every database ↗

AVAILABLE NOW

01 / RELATIONAL

Familiar roots.
Every flavor.

  • PostgreSQL
  • MySQL and MariaDB
  • Microsoft SQL Server
  • Oracle
  • SQLite and PGlite
  • CockroachDB
  • …and more YugabyteDB, TimescaleDB, AlloyDB Omni, TiDB and OceanBase as PostgreSQL or MySQL, and anything with an ODBC driver

Purpose-built connections, with each database’s own dialect, catalog and plans, and its own sign-in and connection options.

AVAILABLE NOW

02 / ANALYTICS & CLOUD

Go where the
analysis takes you.

  • Snowflake
  • Google BigQuery
  • Amazon Redshift
  • ClickHouse
  • StarRocks and Apache Doris
  • Materialize and RisingWave streaming databases
  • CrateDB
  • DuckDB built into DataWorx
  • Databricks
  • Apache Spark SQL and Apache Hive
  • Microsoft Fabric with Entra ID sign-in

Dedicated connections for interactive analytics and cloud-scale queries, with each warehouse’s own plans in Explain.

AVAILABLE NOW

03 / A DEDICATED NOSQL TRACK

Native queries.
Native data panels.

  • MongoDB
  • FerretDB and Microsoft DocumentDB as MongoDB; DocumentDB is the engine of Azure Cosmos DB for MongoDB vCore
  • Apache Cassandra and Amazon DynamoDB
  • Redis and Valkey
  • Elasticsearch and OpenSearch
  • Neo4j graph
  • InfluxDB 3 time series

Document and collection explorers, native query consoles, and native data display panels designed around each store’s own query language and data model.

Explore collections. Write native queries. View documents in purpose-built panels.

WINDOWS & LINUX / IN TESTING

Help shape DataWorx
on your platform.

Windows and Linux versions are in testing, and we’re actively seeking testers. Put DataWorx through your everyday database workflows and help us refine the desktop experience on both platforms.

Experimental Windows builds. These are untested: they haven’t been run on Windows yet, so expect rough edges, and please tell us what breaks. They aren’t signed yet either, so Windows will warn you before installing. Choose More info, then Run anyway.

Experimental and untested · Build 454 · x86 (53 MB) for most Windows 10 and 11 PCs with Intel or AMD chips · Arm (47 MB) for Windows 11 on Snapdragon PCs like the Surface Pro 11. ODBC connections aren’t available on Arm yet. From this build on, Windows builds update themselves too.

TESTERS WANTED

Use Windows or Linux?
We’d love your feedback.

Test real queries, connections, and workflows on the platform you use.

Become a tester ↗

BUILT FOR THE WORK YOU DO

A workbench with
serious depth.

A complete workflow, from connecting to a database to sharing the answer.

⌘

SQL that keeps up with you

Contextual completion, dialect-aware highlighting, formatting, and name inspections keep your thoughts moving. Save reusable queries with tags and Git-backed folders.

Completion · Formatting · Saved queries
▦

Get hands-on with your data

Explore results in a flexible grid. Sort, search, transpose, and inspect JSON or XML. Stage edits, review them, then submit the batch with transactional conflict detection.

Editable grids · Value viewer · Search
◇

See the structure behind it

Design tables visually, preview the SQL, and compare table structures across connections. Explore foreign-key relationships in interactive ER diagrams.

Table designer · Compare · ER diagrams
↗

Turn results into answers

Chart query results as bars, lines, scatter plots, or pies. Inspect execution plans and actual query timings to understand how your SQL runs.

Charts · Explain plans · Analyze
✳

AI, on your terms.

AI is available, but DataWorx will never force it on you. Use it when it helps, or work entirely with the database tools you know. Chat with your choice of AI engine using SQL and schema context. Connect external AI clients through MCP, with explicit connection access and read-only defaults.

OpenAI · Anthropic · Gemini · Ollama
⇄

Move data with purpose

Import CSV, JSON, Excel and Parquet, dump and restore with database-native tools, generate realistic test data, and export to Excel, JSON, SQL, Markdown, HTML, XML, or custom delimited formats.

Import · Export · Dump/restore · Test data
◉

Run the server with confidence

Watch every session live with blocking chains drawn as a tree, cancel or kill with the SQL shown first, manage users, roles and permissions, and see table and index sizes with unused indexes flagged.

Server Activity · Users & Roles · Table Statistics
⛨

Protection before every change

Dry Run any change and see exactly which rows it would touch. Production guards catch a missing WHERE, manual transactions wait for your Commit, and grid edits land all together or not at all.

Dry Run · Production guards · Transactions
⌕

Find anything, instantly

Search every table, column and routine by name, or search inside the code of views, functions and triggers across a whole server. Every query you have run is a keystroke away in History.

Search Database · Query history · Go to related rows
◈

Your connections, thoughtfully handled.

System keychain credentials, SSH tunnels, TLS settings, and connection colors that help you know exactly where you’re working.

THE FULL PICTURE

Depth in every direction.

339 documented capabilities across 15 areas. Explore the complete DataWorx feature catalogue.

Browse all 339 capabilities below. Use your browser’s Find command to locate a feature.

01

Database connectivity

40
  • PostgreSQL
  • MySQL
  • MariaDB

    MySQL protocol adapter

  • Oracle

    Direct client, with no Instant Client to install; service names, SIDs and tnsnames.ora aliases.

  • Microsoft SQL Server

    TDS client

  • CockroachDB

    Self-hosted or CockroachDB Cloud, with its own plans in Explain and its system databases kept out of the way.

  • Amazon Redshift

    Serverless workgroups and provisioned clusters; distribution and sort keys in table details, and Redshift’s plans in Explain.

  • ClickHouse

    Self-hosted or ClickHouse Cloud over HTTP or HTTPS; results in ClickHouse’s own types, and Cancel stops the query on the server.

  • Google BigQuery

    A project’s datasets, tables, views and routines, signing in with your Google account or a service account key; whole scripts run as one job.

  • BigQuery cost controls

    See what a query would process before it runs and what each one billed after, and set a maximum bytes billed per connection.

  • Materialize

    Sources listed apart from tables, definitions with their clusters, its plans in Explain, and storage and indexes in Table Statistics.

  • RisingWave

    Tables, sources and materialized views from its own catalog; rows you write are there for your next query.

  • StarRocks and Apache Doris

    Each table’s key model, distribution and partitioning; their plans in Explain; StarRocks primary-key tables editable in the grid.

  • CrateDB

    Keys, checks and sharding in table details, shard sizes in Table Statistics, and rows you write there at once.

  • Databricks

    SQL warehouses with Unity Catalog’s catalogs, schemas, tables, views and functions; exact numbers, physical plans in Explain, and the warehouse’s queries in Server Activity.

  • Apache Cassandra

    Keyspaces, partition and clustering keys, indexes, types and functions; CQL with paging and consistency levels, grid edits saved as one batch, and query traces in Explain.

  • Amazon DynamoDB

    A region’s tables with their keys and indexes; PartiQL with items as columns and the capacity used, and grid edits saved as one transaction.

  • Redis

    Each database’s keys by type, a key’s value as rows, the commands that make it again, replies as tables, and clients in Server Activity.

  • Elasticsearch and OpenSearch

    Indices, aliases and data streams with their fields; SQL or Kibana-style requests with hits as rows, the query DSL in Explain, and tasks in Server Activity.

  • Add from Cloud

    Find databases in AWS, Google Cloud and Azure and add them with everything filled in; refresh a connection’s endpoint from the cloud.

  • Tested with compatible databases

    YugabyteDB, TimescaleDB and AlloyDB Omni as PostgreSQL; TiDB and OceanBase as MySQL; FerretDB and Microsoft DocumentDB as MongoDB.

  • SQLite files

    open existing or create missing file

  • Snowflake

    HTTPS SQL API

  • MongoDB

    Official driver; host and port or mongodb+srv:// connection strings, TLS and SSH tunnels.

  • Generic ODBC connections

    DSN, driver, or connection string

  • Discover installed ODBC drivers and data sources

    configuration-file discovery

  • Save, edit, duplicate, delete, and test connections

    every database type

  • Connection names and identifying colors
  • PostgreSQL connection URL import

    fills dialog from a PostgreSQL URL

  • SQLite lock timeout and create-if-missing controls
  • Snowflake account, warehouse, database, and role settings

    Choose the context for your cloud data workflow.

  • SQLite attached-database browsing

    Explore main and attached schemas.

  • DuckDB

    Embedded analytics engine with Parquet and JSON readers built in.

  • Local database

    A built-in DuckDB database that’s always there, for querying files and keeping results.

  • Docker containers recognized automatically

    A database running in Docker on your Mac is matched by its port, with its state shown beside the connection.

  • Start and stop Docker containers

    One click from the connection’s menu; a refused connection offers to start its container and connects the moment the database is ready.

  • Docker Desktop, OrbStack, Colima and Podman

    Works with each, and opens Docker Desktop for you when it isn’t running.

  • Development, Staging and Production environments

    Tag each connection; Production switches on the Production guards and marks its consoles.

  • Connection details at a glance

    Hover a connection for its user, host, database, SSL mode or file path.

  • A smooth move from the original DataWorx

    Connections, settings, saved queries, themes and keychain passwords come straight over.

02

Authentication, networking, and session settings

29
  • AWS IAM for RDS and Aurora

    PostgreSQL, MySQL and MariaDB on RDS and Aurora sign in with a fresh IAM token from your AWS profile.

  • Databricks config profiles

    Sign in with a profile of the Databricks CLI’s ~/.databrickscfg, host and token included.

  • AWS IAM sign-in for Amazon Redshift

    Temporary credentials from your AWS CLI profile, SSO included, so there’s no database password to keep.

  • Store passwords outside connection JSON

    system keychain

  • PostgreSQL .pgpass authentication

    default, environment, or chosen file

  • MySQL/MariaDB option-file authentication

    .my.cnf and applicable option groups

  • MySQL encrypted login-path authentication

    .mylogin.cnf

  • Snowflake token, key-pair, and OAuth authentication

    token/key passphrase can be stored securely

  • Read/import Snowflake connections.toml profiles
  • Oracle tnsnames.ora aliases
  • SQL Server Kerberos sign-in

    macOS GSSAPI ticket

  • Retrieve connection passwords from your password manager or secrets service

    includes a Test action

  • Passwordless connection option

    Use database trust or certificate authentication.

  • SSL/TLS configuration

    Configure secure connections using your database driver’s TLS options.

  • PostgreSQL CA and client certificate/key settings
  • PostgreSQL direct TLS, channel binding, and target-session controls
  • PostgreSQL Unix sockets and multiple failover hosts
  • SSH jump-host tunnel

    PostgreSQL, CockroachDB, Redshift, Materialize, CrateDB, RisingWave, ClickHouse, MySQL, MariaDB, StarRocks, Apache Doris, Oracle, SQL Server and MongoDB

  • SSH agent, private key, or password authentication

    agent can include 1Password

  • SSH host-key verification

    known_hosts

  • Read-only sessions

    Select read-only session settings for supported database backends.

  • SQL initialization on new sessions
  • Configurable row limits

    table-open and maximum-fetch limits

  • Show/hide system schemas and additional databases

    template-database option for PostgreSQL

  • Application name, connection timeout, keepalives, startup options

    principally PostgreSQL settings

  • SSH secrets from keychain or password commands

    Resolve jump-host passwords and key passphrases securely.

  • Connection testing with tunnel diagnostics

    Identify jump-host and database connection status separately.

  • Ask for a password when needed

    Asked on first connect and again if the server turns it down; keep it for the session only if you prefer.

  • Sessions named for your DBAs

    PostgreSQL, MySQL and Oracle sessions carry the connection’s application name.

03

Safety and data protection

10
  • Production guards

    An UPDATE or DELETE without a WHERE asks first, and schema changes need the database name typed.

  • Dry Run (⇧⌘↵)

    Run an INSERT, UPDATE, DELETE or MERGE in a rolled-back transaction and see exactly which rows it would affect.

  • Before-and-after rows

    On PostgreSQL and SQLite, Dry Run shows the rows before and after; Make Change then runs it for real.

  • Dry-run schema changes

    On PostgreSQL, SQLite and SQL Server.

  • Manual transactions

    Nothing is committed until you say so; the toolbar shows when a transaction is open.

  • Commit and Roll Back with isolation levels

    The database name is required on Production.

  • Grid edits join your transaction

    In Manual mode, submitted edits go into the console’s transaction behind a savepoint.

  • All-or-nothing edits

    Every update must match exactly one row, or the whole batch is rolled back.

  • Guarded administration

    Kills, grants and user changes show their SQL first and are refused on read-only connections.

  • Passwords masked everywhere

    Shown as ******** in generated SQL, history, logs and error messages.

04

Explorer, metadata, and SQL consoles

31
  • Hierarchical connection/database/schema/object explorer

    loads on expansion

  • Tables, views, materialized views, foreign tables, sequences, routines, and types

    Explore the objects provided by each database backend.

  • Inspect columns, keys, indexes, and CHECK constraints

    grouped under tables

  • Explorer filtering, refresh, and collapse
  • Choose which databases a connection lists

    Tick the ones to show, or hide one from its menu; a count like (2 of 5) by the connection opens the choice again. Oracle connections choose schemas.

  • Open table rows and count rows
  • Copy object name or qualified name
  • Show generated/retrieved object DDL

    Inspect database-specific object definitions.

  • New SQL consoles and multiple query tabs

    can start without a connection

  • Switch console connection/database
  • Execute selected SQL or entire buffer
  • Multi-statement scripts

    final result set displayed

  • SQL Server GO and Oracle PL/SQL script delimiters

    dialect-aware splitting

  • Cancel a running query

    Server-side cancellation through the database adapter.

  • Statement row counts, elapsed time, and server messages

    Execution feedback and supported server notices in the Output tab.

  • Close current/other/left/right tabs and switch tabs by keyboard
  • Trigger browsing and detailed column metadata

    Inspect identity/computed attributes and database comments.

  • Connect and disconnect from explorer menus

    Manage your sessions alongside database objects.

  • Reorder connections

    Drag a connection into place, or use Move Up / Move Down; the order is kept.

  • Generated table queries

    Open tables with dialect-appropriate SELECT SQL and configurable row limits.

  • Persistent query-session state

    Keep SQL Server temporary tables, SET settings, and USE context between runs.

  • Standard editor commands

    Undo, redo, cut, copy, paste, and select all.

  • Search Database (⌥⇧⌘F)

    Find tables, views, columns, indexes, constraints, sequences, routines, triggers and types by name.

  • Search inside code

    Find text in views, functions, procedures, triggers, packages, checks, column defaults and MongoDB validators.

  • Contains, whole-word or regex search

    Optionally case sensitive, in one schema, one database or every database on a connection.

  • Live, grouped search results

    Matches stream in with numbered, highlighted definition lines; double-click to jump straight there.

  • Edit Definition

    Open views, routines, triggers and Oracle packages as ready-to-run CREATE OR REPLACE statements.

  • Multi-select tables

    ⌘-click tables to compare two of them or diagram your selection.

  • Count a query’s rows without fetching them

    One click on any SELECT.

  • Go to related rows (⌘B)

    Follow a foreign key to the row it refers to, or to the rows that refer to it.

  • Informative status bar

    Rows, run time, a live timer while a query runs, and totals of selected cells.

05

SQL editing and saved queries

30
  • SQL syntax highlighting

    dialect-aware

  • Contextual schema/table/column/alias completion

    automatic or explicit invocation

  • Keyword and common-function completion
  • Refresh completion metadata after schema changes
  • Format selection or entire console
  • Configure formatter keyword case and indentation
  • Preserve literal/comment content and support formatting undo

    token validation before replacement

  • Flag unresolved tables, columns, and aliases

    conservative scope-aware checks

  • Resolve CTEs, aliases, nested queries, and correlated references

    Scope-aware name resolution across SQL statements.

  • Highlight symbol usages

    aliases, CTEs, tables in statement

  • Rename aliases and CTEs with usage updates

    F2/context menu

  • Disable name inspections
  • Save and reopen SQL associated with a connection
  • Named query library with tags, descriptions, search, and tag filters
  • Open a saved query with or without execution; update or save as new
  • Saved queries as individual SQL files

    Choose a folder; names, tags, descriptions, and connection context travel in comment headers. Individual SQL files make Git versioning straightforward: track changes, review diffs, and restore earlier versions of your queries.

  • Move between folder and local-library storage

    Migrate your query library in either direction.

  • Discover existing and newly added SQL files

    Bring your own query collection into the sidebar.

  • Live reload of external SQL changes

    Pick up edits and Git pulls within seconds.

  • Portable connection matching

    Match saved-query connections by name on another computer.

  • Git branch and file status in the sidebar

    See new and modified queries alongside their branch.

  • Commit query changes from DataWorx

    Keep query work in version control without leaving the app.

  • Copy, edit, and organize saved queries

    Manage SQL and query metadata from the sidebar.

  • Syntax highlighting for each database

    PostgreSQL function bodies, MySQL # comments, SQL Server [names], Oracle q-quoted strings and more.

  • Expand SELECT *

    Turn * into the real column names, qualified per table.

  • 27 database-aware snippets

    sel, ins, upd, cte, join and more, with Tab-through placeholders; add, edit and reset your own.

  • Query parameters

    :name, ?, ${name} and $1 recognized automatically, asked once each, with last time’s values remembered.

  • Query history (⌥⌘H)

    Every statement you’ve run, grouped by day, with connection, rows, outcome and parameter values.

  • Search, filter and reuse history

    Open in a new console, insert at the cursor, run again or copy.

  • Typing stays yours

    No auto-capitalization or autocorrect in any text box.

06

Results, value viewing, and data editing

29
  • Scrollable result grid, cell selection, keyboard navigation

    virtual scrolling

  • Resize/auto-fit result columns and sort by header

    client-side sorting

  • Distinct NULL display and typed value presentation
  • Find result text with case, whole-word, and regex options
  • Filter visible columns by name

    case/whole-word/regex options

  • Transpose rows and columns

    selection/editing follows layout

  • Copy cells, rows, or all fetched rows

    TSV/CSV options

  • Full-value viewer/editor

    floating or docked

  • Detect, format, and color JSON/XML values
  • Inline result-grid editing

    Edit single-table query results containing the full primary key, or columns you choose with Identify Rows By. Neo4j nodes, Elasticsearch and OpenSearch documents, Redis values and InfluxDB fields are edited in their own terms. On Apache Doris, its UNIQUE KEY tables; on ClickHouse, saved as mutations it waits for.

  • Stage inline edits, submit together, or revert

    Review highlighted pending changes before submitting the batch.

  • Multiline editing, Set NULL, and revert in value viewer

    Work with full values in editable table results.

  • Match updates using primary-key or chosen columns

    the full key, or columns chosen with Identify Rows By, must be in the results

  • Transactional updates with conflict detection

    Every update must match exactly one row; conflicting batches roll back together.

  • Table/alphabetical column order and primary-key-first option

    grid, copy/export, explorer

  • Configurable value-type colors, numeric alignment, local timestamp display

    separate light/dark colors

  • Refresh while preserving your grid layout

    Retain sorting, column widths, and scroll position on eligible read queries.

  • Clear displayed results

    Reset the result area from its toolbar.

  • Data-aware initial column widths

    Fit headers and values automatically with practical limits for long text.

  • Database-aware edit targeting

    Save edits to the database identity associated with the result.

  • Case-aware table matching

    Respect the database’s identifier case rules.

  • Pending-edit protection

    Keep pending changes intact when using refresh and clear controls.

  • Result tabs with pinning

    One tab per result set, each with its own edits, sort and chart; pin a tab to keep it across runs.

  • Filter a column by its values

    Tick values with their counts, match text, or Filter by This Value, instantly and without rerunning.

  • Totals of selected cells

    Count, sum, average, minimum and maximum in the status bar.

  • Results as JSON (⌥⌘J)

    Syntax colors, Beautify and Compact, and editing.

  • Edit join results

    On PostgreSQL and SQLite each column saves back to its own table.

  • Add, delete and paste rows

    New rows in green, deleted rows struck through, pasted rows added as needed.

  • Tab through editable cells

    Tab and ⇧Tab move to the next or previous editable cell.

07

Schema design and comparison

19
  • Visual create/modify table designer

    database-specific SQL

  • Edit column names/types/nullability/defaults/comments

    Generate SQL appropriate for the connected database.

  • Primary keys and auto-numbering for new columns
  • Unique and foreign keys, referenced columns, referential actions

    Configure database-specific keys and ON DELETE / ON UPDATE actions.

  • Indexes and CHECK constraints
  • Quick add-column/index/key dialogs from explorer
  • Unique/partial indexes; PostgreSQL method and concurrent creation

    Database-specific index options

  • Preview generated CREATE/ALTER SQL before applying

    execute or open in console

  • Drop table/column/index/key with SQL confirmation

    Review the database-specific SQL before applying the change.

  • Transactional SQLite table rebuilding

    Copy rows and swap the rebuilt table in a transaction.

  • Compare two tables' columns, indexes, and keys

    side-by-side differences

  • Compare tables across connections
  • Match differently named indexes/keys by their columns
  • Preserve SQLite triggers during rebuilding and renaming

    Recreate triggers transactionally with the updated table.

  • Trigger-aware schema change guidance

    Plan related column and trigger changes in the table designer.

  • Refresh metadata after schema changes

    Keep explorer and SQL completion current.

  • Compare whole schemas

    Across connections, with a migration script in either direction and destructive steps safely commented out.

  • Compare table data

    Rows matched by key, changed cells highlighted, differences exported as CSV or a sync script.

  • Copy tables between any databases

    Keys, indexes, checks and rows, with types translated, even to and from MongoDB.

08

Execution plans and PostgreSQL debugging

13
  • Explain selected statement or statement at cursor
  • Plan tree with operations, relation/index names, rows, costs

    PostgreSQL, MySQL/MariaDB, SQLite, Oracle, SQL Server, Snowflake

  • Highlight expensive operations and show condition details

    cost/time-share bars and tooltips

  • Explain Analyze with actual rows, loops, timings

    PostgreSQL, CockroachDB, MySQL/MariaDB, SQL Server and Babelfish, Oracle, DuckDB, BigQuery, ClickHouse, StarRocks, CrateDB, Neo4j, InfluxDB, Elasticsearch, OpenSearch and MongoDB

  • Flag cardinality estimates off by more than 10×
  • Transactional PostgreSQL Explain Analyze

    Run analysis inside a transaction and roll it back afterwards.

  • View raw database plan output
  • Interactive PostgreSQL PL/pgSQL debugger

    Step through routines with the PostgreSQL debugger extension configured.

  • Debug arguments, breakpoints, step into/over, continue
  • View/change variables and inspect call-stack frames
  • Show debugger call result, messages, and setup guidance

    can create extension after server prerequisites

  • Explain on seventeen databases

    PostgreSQL, CockroachDB, Redshift, Materialize, CrateDB, RisingWave, ClickHouse, MySQL, MariaDB, StarRocks, Apache Doris, SQLite, DuckDB, Oracle, SQL Server, Snowflake and BigQuery (a dry run, with what a query would process).

  • Dry Run for any data change

    Preview the effect of a change before making it.

09

Server administration

11
  • Server Activity

    Every session on the server, live: user, client, state, query and transaction age, waits and query text.

  • Blocking chains at a glance

    Blocked sessions and their blockers highlighted and drawn as a tree, with each session’s locks.

  • Calm live refresh

    Every 2, 5 or 10 seconds, pausing while you work; filter, hide idle sessions or DataWorx’s own.

  • Cancel Query and Kill Session

    On PostgreSQL, MySQL, MariaDB, StarRocks, Apache Doris, SQL Server, Oracle, Snowflake and MongoDB; Cancel on Materialize, CrateDB, RisingWave and BigQuery’s running jobs. The statement is shown first.

  • Users and Roles

    Every user, login and role with attributes, memberships and privileges, held directly or through a role.

  • Grant options, column grants and DENYs

    The complete privilege picture, including SQL Server DENYs.

  • Object permissions

    See who can do what on any table, view, sequence, routine or schema, and grant or revoke right there.

  • User and role dialogs

    New User, Role and Login, Edit, Add to Role and Drop, each with editable SQL before it runs.

  • Table Statistics

    Rows and table, index and TOAST/LOB sizes, index use with unused indexes flagged, and maintenance details.

  • Table Sizes

    Every table in a schema, largest first, with the total and each table’s share.

  • Works with the access you have

    Without full privileges, every view shows what it can and explains what’s missing.

10

ER diagrams and result charts

13
  • ER diagrams for schema, table and related tables, or selected tables
  • Show columns, key markers, and foreign-key relationships
  • Include referenced tables from other schemas

    distinguished with dashed outlines

  • Automatic layout and draggable table positions

    orthogonal relationship routing

  • Pan/zoom, find table, control displayed columns
  • Highlight relationships and open table data from diagram
  • Export ER diagram to SVG/PNG
  • Chart query results

    separate Chart tab

  • Bar, line, scatter, and pie chart types
  • Choose X column and multiple numeric series
  • Automatic chart choice and sum repeated categories
  • Hover values and navigate chart by zoom/pan
  • Save chart as PNG or copy image
11

Import, export, and generated test data

41
  • Import CSV/TSV into existing table or create a new table
  • Copy a table under a new name, here or to another connection

    columns, keys, indexes, and rows; types translated between databases; undone if it fails

  • Detect/configure delimiter, header, and encoding

    UTF-8, UTF-16, Latin-1 fallback

  • Map or skip source columns and infer new-table types
  • Prevalidate values and NOT NULL, report file line numbers, skip bad rows
  • Import transaction and progress display

    Transactions handled by the connected database

  • Export CSV/TSV and custom delimited formats
  • Export typed JSON
  • Export SQL INSERT and primary-key-based UPDATE statements
  • Export Excel .xlsx

    typed cells, frozen header, filters, fitted widths

  • Export Markdown and HTML tables
  • Export XML
  • Preview export and choose file or clipboard

    Format-appropriate clipboard output

  • Copy HTML as rich table and Excel output as TSV
  • Save custom CSV formats with quoting, escaping, NULL, row/value separators

    add/duplicate/reorder/delete presets

  • Database dump and restore

    PostgreSQL, MySQL, MariaDB, SQLite, SQL Server via SqlPackage, and Oracle via Data Pump.

  • Generate realistic test rows through a table UI

    up to 100,000 rows/run

  • Per-column generators chosen from names/types and editable by user
  • Names, emails, phone, username, company, address, country, postal code
  • Numeric/date/time ranges, booleans, UUIDs, URL, words, titles, codes
  • Sequence, fixed, list, NULL, and database-default generators
  • Reuse foreign-key values and generate distinct key values

    references existing rows

  • CHECK-aware generation and configurable NULL proportions

    Generate values for supported lists, ranges, and length rules.

  • Preview generated rows and insert transactionally
  • Open generated INSERT statements in SQL console

    up to 1,000 rows

  • Database, schema, and table dump scopes

    Choose supported scopes in the database dump workflow.

  • Structure-only, data-only, or combined dumps

    Select supported output content options.

  • PostgreSQL archive formats

    Custom, plain SQL, directory, and tar formats.

  • Database-native restore tools

    Use pg_restore/psql, mysql/mariadb, sqlite3, SqlPackage, or Oracle impdp as appropriate.

  • Tool discovery and configurable tool folders

    Choose the database command-line tools for your installation.

  • Dump and restore progress, output, and cancellation

    Manage long-running operations from a dedicated window.

  • Import JSON, JSON Lines, Excel and Parquet

    Excel and Parquet keep their types.

  • Fast streaming import

    Large files stream in; a 400,000-record file imports in about two seconds.

  • Up to 100,000 generated rows a run

    Realistic values chosen from each column’s name and type.

  • Dates for date-like text columns

    Columns such as ordered_at stored as text still get real dates and timestamps.

  • Query files by dropping them on the window

    CSV, Parquet or JSON files, or whole folders read as one table.

  • Pin any result into Local

    Keep it as a typed table and join it with files and other results.

  • Refresh from Source

    Rerun a pinned table’s query on its original connection.

  • Restore anywhere

    Into the same or another database, created for you on PostgreSQL and MySQL, or another schema on Oracle.

  • SqlPackage and Oracle Data Pump

    Dump and restore SQL Server and Oracle with their own tools.

  • Passwords kept off the command line

    Dump and restore tools receive passwords securely.

12

AI assistants, MCP, and file access

24
  • Integrated AI chat with SQL/schema context
  • OpenAI and OpenAI-compatible endpoints
  • Anthropic, Gemini, and Ollama configuration

    dedicated choices, Gemini/Ollama use compatible APIs

  • Multiple configured engines and model selection

    one chat tab per enabled engine

  • AI inspect console/schema, write SQL, execute, and inspect results
  • AI switch the target connection
  • Optional confirmation before AI SQL execution
  • AI key storage in system keychain
  • Resizable prompt box and prompt-history navigation

    up/down history

  • Expose database access to external AI clients using MCP

    Connect through DataWorx --mcp using stdio.

  • Explicitly enable individual connections for MCP

    hidden otherwise

  • MCP read-only default, optional write permission, bounded results

    per connection, max 5,000 rows and bounded response

  • MCP list connections/databases/schemas/objects, describe tables, retrieve DDL
  • MCP run SQL and compare tables
  • MCP list/read saved queries
  • AI list/read/search explicitly shared local folders

    internal chat and MCP

  • Optional AI write/move/delete permission per shared folder

    off by default, paths resolved inside allowed roots

  • Dedicated AI console context

    Give assistant SQL work its own console context.

  • Shared-folder metadata and folder creation

    Inspect files and create folders within explicitly writable shared locations.

  • Symlink-aware shared-folder boundaries

    Keep file operations inside the roots you share.

  • Connection password protection in AI responses

    Keep connection passwords out of assistant output.

  • Reload MCP connection settings on each call

    Pick up shared connection changes without restarting the server.

  • One-step MCP setup

    The connection dialog shows the claude mcp add command to copy.

  • VS Code extension

    The DataWorx extension for Visual Studio Code runs on the same engine.

13

Appearance and desktop workflow

27
  • Light, dark, or system appearance
  • Comfortable/condensed interface spacing
  • Select interface and editor/grid fonts and sizes

    installed-font search

  • Keyboard font zoom/reset
  • Built-in SQL editor color themes

    17 including Pastel Night

  • Independently select light/dark editor themes
  • Import VS Code color-theme JSON directly

    persisted locally

  • Color wheel and named-color palette

    connection and data colors

  • macOS native menu bar and standard platform shortcuts

    in-window menus on other platforms

  • Separate settings/connection windows and native destructive alerts
  • Start page with connection/query actions and recent saved queries
  • In-app What's New with unread release tracking
  • About/build information and issue/feature-report actions

    version, build, commit, email actions

  • Persist local settings, connections, formats, and query library

    JSON and environment-variable path overrides

  • Theme previews and imported-theme management

    Preview editor palettes and remove imported themes in Settings.

  • Workspace panel shortcuts

    Toggle explorer, saved queries, AI, value viewer, and transposed results.

  • PostgreSQL documentation from Help

    Open database documentation from the app.

  • Searchable third-party license notices

    View bundled component licenses and copyright details in About.

  • Atomic configuration saves

    Save connections, preferences, query JSON, and themes using temporary-file replacement.

  • Automatic configuration backups

    Keep the previous configuration version in a .bak file.

  • Configuration recovery at startup

    Preserve damaged configuration and restore an available backup.

  • 17 editor themes

    Chosen separately for light and dark mode, with a live preview.

  • Your value colors

    Choose the colors for strings, numbers, booleans and dates.

  • Opens at full size, without a flicker

    Window size and position, panel widths and layout restored exactly.

  • DataWorx Help (F1)

    Every feature in one searchable page.

  • Keyboard Shortcuts reference

    Every command with a shortcut, for your computer.

  • Panels that recover in place

    If a panel ever hits a problem it offers Try Again while the rest of the app keeps working.

14

Engineering and release foundation

9
  • Fast native desktop app

    A compiled desktop application with native platform integration.

  • macOS app bundles and DMG packaging

    Drag-to-Applications distribution.

  • Apple silicon and optional universal builds

    Build tooling for Apple silicon and Intel.

  • Developer ID signing and notarization workflow

    Release tooling supports signing, hardened runtime, notarization, and stapling when configured.

  • Embedded build and release metadata

    Version, build, commit, and release-note stamping.

  • Database integration, UI, and module tests

    A test suite spanning application rendering, adapters, and workflow logic.

  • Sample databases and SQL examples

    SQLite samples, container-based database setup, and mock AI/Snowflake services.

  • Database adapter compatibility work

    Native drivers for every database, tested against real servers.

  • Bundled dependency license notices

    License-generation tooling and searchable attribution inside the app.

15

MongoDB

13
  • MQL consoles

    Query MongoDB as you would in the MongoDB shell: find, aggregate, inserts, updates, indexes, show and use.

  • MQL autocomplete

    Collections, methods, fields sampled from your documents, and the $ operators that fit where you are.

  • Whole phrases with placeholders

    Choosing an operator inserts its complete phrase; Tab moves from one placeholder to the next.

  • Syntax at a glance

    Every form of the operator or method you're writing, with the key you're on explained.

  • Guided aggregation pipelines

    Fields follow the pipeline through $group, $project and $lookup; $lookup offers the other collection's fields.

  • MQL formatting and error marks

    Beautify long queries and see where a statement stops making sense.

  • Documents as JSON or a table

    Results open as MongoDB JSON; the table view shows sub-documents as JSON to edit in place.

  • ObjectId times

    Hover over an ObjectId in results, the JSON view or your query to see when it was created.

  • Type-safe document edits

    Edits keep each value's BSON type, are written by _id, and never overwrite someone else's change.

  • Collections, views, fields and indexes

    Browse each database's collections with the fields found in their documents.

  • Copy collections to SQL tables, and tables to collections

    a row per document, typed values, _id as the key, indexes kept

  • MongoDB Production guards

    updateMany({}), deleteMany({}), drops and index changes ask first; read-only connections refuse every write, $out and $merge included.

  • MongoDB administration

    Current operations in Server Activity with Kill, users and roles, and collection and index statistics.

Database-specific capabilities are named in the catalogue. This is the DataWorx product feature inventory; edition licensing is shown below.

DEPTH YOU CAN PUT TO WORK

Powerful tools.
Thoughtful safeguards.

Robustness lives in the details: how changes are applied, how credentials are handled, and how your workspace is preserved.

TRANSACTIONAL DATA WORK

Review. Submit. Commit together.

Stage grid changes before saving. Each update must match exactly one row, and conflicting or failed batches roll back together. Primary-key matching and database-aware result identity keep updates grounded in the data you read.

SCHEMA CHANGES WITH CONTEXT

See the SQL before it runs.

The table designer previews database-specific CREATE and ALTER statements. SQLite rebuilds copy rows and swap tables transactionally, preserving triggers as part of the change. Explorer and completion metadata refresh afterwards.

CONNECTION SECURITY

Use the credentials you already trust.

System keychain storage, external password commands, pgpass, MySQL login paths, Snowflake tokens and keys, AWS IAM for Redshift, RDS and Aurora, your Google account or a service account key for BigQuery, Databricks CLI profiles, Oracle aliases, and SQL Server Kerberos support meet existing authentication workflows. SSH tunnels verify jump-host keys.

CONTROLLED AI ACCESS

Share exactly the context you choose.

Enable MCP per connection, start with read-only access, and choose write permission explicitly. Results are bounded. Shared folders have separate permissions and symlink-aware root boundaries. Optional confirmation puts you in charge of assistant SQL execution.

A WORKSPACE THAT STAYS YOURS

Configuration with a recovery path.

Connections, settings, saved-query JSON, and imported themes use atomic saves. Previous versions are backed up automatically. Startup recovery preserves damaged files and restores available backups.

REAL WORKFLOW ENGINEERING

Built and tested as a desktop app.

A fast native desktop shell and a dedicated database engine power the application. Engine tests, database integration scenarios, and mock service tests exercise its workflows. The screenshots on this page come from running the actual application against sample data.

Broaddatabase support
100,000generated test rows per run
17built-in editor themes
$50perpetual release license

BUILT TO STAND ALONGSIDE THE BIG NAMES

Choose DataWorx.
Depth, control, and value.

Database development, visualization, debugging, data generation, and AI in one $50 perpetual release license.

01 / DEVELOPMENT

Beyond the query editor

Table design, cross-connection structure comparison, ER diagrams, execution plans, and interactive PostgreSQL debugging sit alongside your SQL.

02 / DATA WORK

From raw rows to real insight

Transactional grid editing, charts, typed Excel exports, native dump/restore workflows, and realistic test-data generation belong in the same workspace.

03 / YOUR AI

Control the connection

Choose your provider or local Ollama model, give AI SQL/schema context, and share connections through MCP with per-connection permissions.

See where DataWorx stands out

DataWorx brings advanced database workflows together for $50. Yes = available in the named product or edition. No = absent from that edition. ? = availability unverified. Comparable capabilities can differ in implementation.

Detailed feature comparison of DataWorx, DataGrip, DBeaver Community, and DBeaver Enterprise
WorkflowDataWorxDataGripDBeaver CommunityDBeaver Enterprise
Dry run for changes, plus environment tagging✓ Dry run changes and tag environments???
SQL completion & formatting✓ Context-aware, dialect-awareYesYesYes
Environment tagging & production guards✓ Mark connections as production; block UPDATE/DELETE without a WHERE; require the database name before DDL; show a PRODUCTION tag on its consoles???
Database connectionsBroad native SQL and NoSQL support + ODBCBroad JDBC database supportBroad JDBC database supportBroad database support + ODBC
Built-in DuckDB engine✓ Query local CSV, Parquet, and JSON files directly; join PostgreSQL results with Snowflake results or local filespartial - no cross connection joinspartial - no cross connection joinspartial - no cross connection joins
MongoDB with native MQL✓ Shell-syntax consoles, pipeline-aware autocomplete, operator phrases and syntax help, JSON and table resultsYesNoYes
Native ODBC connections✓ DSN, driver or connection string; installed drivers found for youNoNoYes
Cross-connection SQL joins✓ Join PostgreSQL results, Snowflake results, and local files through DuckDB?NoNo
Editable data grids✓ Most database types; stage & submitYesYesYes
JSON/XML value viewing✓ Format, color, dock, or floatYesYesYes
Native Excel (.xlsx) export✓ Typed cells, filters & frozen headerYes?Yes
Visual table design✓ Columns, keys, indexes & CHECKsYesYesYes
ER diagrams✓ Auto-layout, cross-schema links, SVG/PNGYesYesYes
Schema-aware test-data generator✓ Up to 100,000 rows per run?NoYes
Execution plans✓ Plan trees, cost highlights & AnalyzeYesYesYes
PostgreSQL routine debugging✓ Breakpoints, stepping, variables & stackNo?Yes
Query-result charts✓ Bar, line, scatter & pieYesNoYes
CSV/TSV import & rich exports✓ Mapping, validation & typed outputYesYesYes
AI-assisted database work✓ Multiple providers, SQL/schema toolsYesYesYes
External AI access through MCP✓ Built-in stdio server; explicit opt-inYes??
Native desktop implementation✓ Fast native Mac app, a 69 MB downloadNoNoNo
Free offering✓ Community editionNon-commercial useCommunity editionTrial offerings
Paid release license$50 USD · perpetual for the release$109 USD / first year for individuals
2.18× DataWorx’s one-time price
Free Community product$255 USD / year
5.1× DataWorx’s one-time price
Comparison sources and scope

Additional checks: DBeaver cross-database joins; DataGrip runtime; DBeaver runtime. Native desktop implementation means a native compiled application rather than a Java runtime application. DuckDB JDBC connections are documented by both competitors; their bundled engine and combined file/result workflow remain unverified here. DBeaver cross-database joins are documented for Ultimate and Team Edition, outside the Enterprise column. An undocumented feature stays ? rather than being assumed absent.

Checked October 7, 2026 against official product documentation. The DataWorx column describes the product inventory. PostgreSQL debugging uses the server debugger extension; editable results use single-table data with a primary key or chosen identifying columns. The comparison uses DataGrip, DBeaver Community, and DBeaver Enterprise. No means the capability is absent from the named product or edition; ? means it is unverified. MCP availability is assessed for the current release, separately from documentation for upcoming releases.

Where DataWorx fits across the market

VS. DATAGRIP

IDE depth, your own workspace.

DataGrip offers a database IDE with JetBrains tooling. DataWorx brings completion, inspections, plans, diagrams, charts, and MCP together with PostgreSQL routine debugging and a $50 perpetual release license.

Official product overview ↗

VS. DBEAVER

Advanced workflows, together.

DataWorx brings query-result charts, native ODBC, and schema-aware test-data generation into its product toolkit. DBeaver Community does not include these workflows. Add PostgreSQL debugging and AI/MCP, and DataWorx offers substantial depth at $50.

Official edition comparison ↗

VS. TABLEPLUS

Desktop focus with a broad toolkit.

TablePlus emphasizes native database editing and SQL workflows. DataWorx pairs a fast native desktop app with schema design, ER diagrams, plans, test-data generation, charts, and integrated AI/MCP.

Official product overview ↗

VS. PGADMIN

PostgreSQL depth. More databases.

pgAdmin focuses on PostgreSQL administration, including plans, ERD, and debugging. DataWorx combines PostgreSQL development workflows with MySQL, MariaDB, SQLite, SQL Server, Oracle, Snowflake, and ODBC in the same app.

Official feature overview ↗

VS. NAVICAT PREMIUM

A substantial workbench at $50.

Navicat Premium covers multi-database development, modeling, AI, and data generation. DataWorx offers its own integrated combination of schema tools, diagrams, charts, test data, AI/MCP, and a $50 perpetual release license.

Official product overview ↗

These comparisons describe product positioning and documented functionality. Explore the full catalogue above to see the depth of the DataWorx workflow.

SIMPLE BY DESIGN

Find your edition.
Make it yours.

Start with Community, or buy a perpetual license for the release. Your workspace, your choice.

FOR THE COMMUNITY

Community

Freecommunity edition

A welcoming way to get started with DataWorx and put your data to work.

  • Free Community edition
  • The DataWorx desktop experience
  • A place to start your database workflow
Ask about Community ↗

Prices checked October 7, 2026, in USD before tax: DataGrip individual commercial pricing and DBeaver Enterprise annual pricing. DataGrip renewal discounts apply, and annual subscriptions include a perpetual fallback license. DataGrip also offers free non-commercial use; DBeaver Community is free.

Perpetual licensing applies to the purchased release. AI provider services are configured separately with your own account or local model.

A FEW GOOD QUESTIONS

Good to know.

What does a perpetual release license mean?

You pay $50 once and can continue using the release you purchase. Future release offers and upgrade terms are announced separately.

Which databases can I connect to?

PostgreSQL, MySQL, MariaDB, Microsoft SQL Server, Oracle, SQLite, DuckDB, Snowflake, MongoDB, and generic ODBC connections.

Do I have to use AI?

No. AI is available, but DataWorx will never force it on you. Use the SQL editor, data grids, schema tools, charts, and other database workflows independently. Enable an AI assistant only when you want one.

Can I use my own AI provider?

Yes. DataWorx supports OpenAI and compatible endpoints, Anthropic, Gemini, and Ollama. You configure your own provider credentials or local model.

Can I bring my existing SQL queries?

Yes. Store saved queries as SQL files, organize them with tags and descriptions, and use a Git-backed query folder to keep your work together.

How does DataWorx fit into a macOS workflow?

DataWorx includes macOS native menus, standard shortcuts, system keychain integration, and light, dark, or system appearance.

MAKE ROOM FOR YOUR NEXT IDEA

Let your data get to work.

Get started with DataWorx ↗