Start Pro Trial

VisuaLeaf v1.0.2880 Release Notes

November 17, 2026

VisuaLeaf v1.0.2880 Release Notes

Release Date: November 17, 2026

Covers everything since v1.0.2714.


Headline: Our Biggest Release Yet — Connect to Anything, Every MongoDB from 3.4 to 9.0, and Editors That Know Your Database

This is our biggest release yet. VisuaLeaf now connects to more databases in more ways, works with every MongoDB from 3.4 to 9.0 in one app, and gives the SQL editor and the MongoDB shell the same help: suggestions, hover details, and mistakes underlined before you run. Dumps and restores now match MongoDB's own tools, you can query a CSV or Parquet file with SQL, and the desktop app starts in about half the time.

Highlights:

  • Connecting is far more forgiving. Paste a connection string from Compass, DBeaver, Studio 3T or a cloud console and VisuaLeaf reads it. New sign-in methods cover BigQuery, Google Cloud SQL, Snowflake, Oracle wallets and MongoDB OIDC.
  • A SQL editor that understands your schema. Join conditions are suggested, hovering shows a column's type, Cmd-click opens a table, and errors are underlined where they happen.
  • Explain draws a plan tree on every SQL database, not just PostgreSQL, MySQL, SQL Server and Oracle.
  • Query a file with SQL. Drop a CSV, TSV, Parquet or JSON file on the window and query it like a table, without importing it.
  • Dump and restore that match mongodump / mongorestore, with point-in-time dumps, users and roles, and a clear reason whenever something couldn't be restored exactly.
  • Shell and aggregation results that match mongosh exactly. Pipelines run as you wrote them, and the shell now underlines mistakes before you run, just like the SQL editor.
  • GridFS uploads up to 2 GB, with real progress and a redesigned file browser.
  • New engines: BigQuery, Google Cloud SQL, Valkey and Databricks, plus Table Management for Databricks.
  • AI agents ask before they change anything. Choose, per connection, what an AI agent may see and do.
  • Memory that sizes itself and a desktop download about 70 MB smaller.

Connections

Connecting used to mean translating another tool's settings into ours. Now VisuaLeaf reads what other tools write.

What you can see

  • One field to search or paste. In New Connection, type to find a database type (arrow keys, Enter and Esc work), or paste a connection string. You see the host, port, database, user, masked password and SSL setting before you continue. If VisuaLeaf guessed the wrong database type, Not PostgreSQL? lets you pick another and keeps your string.
  • Strings from other tools just work. Oracle descriptors and TNS aliases, SQL Server host\instance, Snowflake, BigQuery, H2/HSQLDB/Derby, SQLite and DuckDB paths, and jdbc:mysql:, jdbc:firebird: and jdbc:redshift: URLs are all understood. Redshift, Neon, Supabase, CockroachDB Cloud and Azure SQL hosts are recognized. Options VisuaLeaf can't use (such as Studio 3T's 3t.*) are listed and left out, so Save no longer fails. (SOZO-1739)
  • The "Connecting…" dialog is back, with Cancel and a clear error, including when you connect from the Connection Manager.

MongoDB

  • The same connection-string rules as Compass. Option names are read whatever their case, so Azure's retrywrites=false is no longer lost. Named write concerns reach the server, every readPreferenceTags is kept, and Atlas's tlsCertificateKeyFile / tlsInsecure are understood.
  • Certificates are verified by default on new connections and on a plain tls=true. Accepting any certificate is now something you choose on purpose. Saved connections keep the setting they had.
  • Connections saved with TLS 1.0, 1.1 or SSLv3 connect again. They now agree on a modern version with the server.
  • Atlas users who can't list every database can connect, and they see the databases they're allowed to use.
  • Sign in through your browser with your company account (OIDC) in the desktop app. Setups made for Compass and mongosh work unchanged.
  • SSH to replica sets and sharded clusters reaches every member, and switches automatically to another route when the first one can't be used.

SQL

  • A Read-only switch on every SQL connection. It blocks edits, table changes, imports, sync into the database, and changes by AI agents. The SQL editor runs only statements that read.
  • New ways to sign in:
  • BigQuery, with a guard against queries that would cost too much.
  • Google Cloud SQL without the Auth Proxy, with an instance picker and IAM sign-in.
  • SQL Server / Azure with Entra, NTLM or Kerberos.
  • AWS IAM for RDS and Redshift.
  • Snowflake with a key pair, SSO or OAuth, plus warehouse, role and schema fields.
  • A Databricks personal access token field. (SOZO-1756)
  • Oracle: VisuaLeaf finds tnsnames.ora by itself and lets you pick the alias from a list. A new Role field lets SYS connect (sys as sysdba works too), and wallet sign-in works.
  • Certificates, tunnels and proxies: paste a CA, client certificate or key straight into the form. A SOCKS5 proxy works with every database. SSH supports your SSH agent, up to 5 jump hosts, importing from ~/.ssh/config, and older SSH servers. Exports, dumps, transfers and sync now go through the connection's own SSH tunnel.
  • Change an expired password from the connection form on Oracle and MySQL/MariaDB. PgBouncer and Supabase pooler ports work.
  • Safer by default: a PAM or LDAP password is never sent unencrypted. If the app's encryption key changed, you're asked to re-enter the password instead of seeing a confusing login failure.
  • A tidier SQL connection form. It's split into tabs like the MongoDB form: General, SSL, SSH, Network and Advanced. Host, database, sign-in method, username and password all sit on General, so you can fill in and test a connection from one tab. Tabs that don't apply to a database are hidden. (SOZO-1793)
  • Save says what's missing. Saving with a required field blank names the field, the same way Test does. Database is marked required only where it really is, and switching away from BigQuery gives you your host field back.

Connection Manager

  • Deleting a SQL connection asks first. Test on a Redis connection tests Redis, and bulk delete skips SQL connections that are open.

One App for MongoDB 3.4 – 9.0

You no longer need a separate download for older MongoDB servers.

  • MongoDB 3.4, 3.6 and 4.0 servers just connect, in the same app as current servers. Database stats and the Drop Database size now show on 3.4 as well.
  • Features an old server can't do are switched off, with the reason shown. Live sync from servers older than 3.6 is refused up front. On those servers the visual JSON Schema editor is off and explains why. Data Sync can't read from a 3.4 or 4.0 server, and it says so instead of hiding the server.

SQL Editor

The SQL editor now knows the tables, columns and keys in your database.

What you can see

  • Smarter completion.
  • After JOIN … ON, the join condition is offered.
  • After JOIN, related tables come first, with a short alias.
  • INSERT (…) and UPDATE … SET offer only that table's columns.
  • Columns from CTEs and subqueries are known.
  • Procedures and functions complete with their parameters.
  • Inside col = '…, the column's real values are offered.
  • Hover a table, column or alias to see its columns, types and keys.
  • Errors underlined where they happen. When a statement fails, the failing spot is underlined in red, both in the script editor and in a table's SQL box.
  • "Not found" warnings. A misspelled table or column gets a yellow underline. It stays quiet when it isn't sure. Checked on all 29 SQL databases.

What you can do

  • Cmd/Ctrl-click a table to open it, or an alias to jump to where it's defined.
  • Turn on UPPER or lower keyword case as you type (optional).
  • Press Enter after BEGIN or CASE and the matching END is added.
  • Run a whole procedure, trigger or package on MariaDB, Oracle and SQLite. They used to be cut apart at their first END IF.
  • New run keys:
  • Run: ⌘Enter on macOS, Ctrl+Shift+Enter elsewhere. F5 still works.
  • Run whole script: ⌘⇧Enter.
  • Run to cursor: ⌘⌥Enter or Ctrl+F5.
  • Run buttons and tooltips show your current key.

Explain on Every SQL Database

What you can see

  • A plan tree everywhere. Explain now draws its plan as a tree on SQLite, DuckDB, CockroachDB, CrateDB, QuestDB, RisingWave, Materialize, H2, HSQLDB, Databricks, Snowflake, Firebird and Db2, instead of showing the database's raw text.
  • One look for every database. Every plan uses the same steps, icons, colors and Full Scan badge as PostgreSQL, MySQL, SQL Server and Oracle. The database's own name for each step is still shown in its details.
  • A Details section with what the database adds, such as CockroachDB's index recommendation, ClickHouse's parts and granules, Databricks statistics advice, and Db2's I/O and CPU cost. Row estimates are rounded.
  • BigQuery shows its dry run, since it has no Explain: the statement, the tables it reads and the bytes it would bill.

What you can do

  • Explain on Firebird and Db2. It used to fail on both. Firebird shows the plan without running the query. On Db2, if the database has no Explain tables yet, VisuaLeaf tells you and gives you the one command that creates them.
  • Pan and zoom around any plan, SQL or MongoDB, on the same canvas.

Query a File with SQL

What you can see

  • Drop a CSV, TSV, Parquet or JSON file on the desktop app and it opens as a table, without importing anything.
  • Your files are listed under a built-in "Files" connection.
  • Large JSON files open too, including a single JSON document bigger than 16 MB.

What you can do

  • Write SQL against the file by its name.
  • Open a file with Open Data File… in ⌘K, from a home page tile, by right-clicking empty space in the connection list, or by dropping it on a SQL editor. Typing "csv", "parquet" or "json" in New Connection also offers a Data file card.

This works in the desktop app.


MongoDB Shell, Aggregation & Explain

Shell

The MongoDB shell now gets the same help as the SQL editor: mistakes are marked before you run, and the editor knows your collections.

What you can see

  • Mistakes underlined as you type.
  • Red marks something MongoDB would refuse: a syntax error, db.users.fnd(), $mtch, or an update with no $set.
  • Yellow marks something that would run but probably not as meant: a collection that doesn't exist, or a misspelled field name.
  • A note tells you when an insert will create a new collection.
  • It stays quiet when it isn't sure, because MongoDB documents don't all have the same fields.
  • Errors underlined where they happen. When a command fails, the failing spot is underlined in red.
  • Hover a collection, method, operator or field to see what it is, with a link to MongoDB's docs.
  • Method hints. While you type a method's arguments, the shell shows what it takes and which argument you're on.

What you can do

  • Fix a typo in one click. For mistakes such as $mtch or a misspelled method, a quick fix offers the right spelling.
  • Cmd/Ctrl-click a collection to open it.
  • load('script.js') works in the desktop app, just like in mongosh. Whatever the file defines is available to the rest of your script.

Results

  • find() and aggregate() return exactly what mongosh returns. Sort, collation, hint, projection, let, read preference and read concern are all kept. The results matched mongosh in 208 of 208 cases, at the same speed.
  • Last page works with $where and $near queries. Chaining after .readPref() works, and UUIDs and very large numbers keep every digit.
  • Query and Shell tabs keep their results, with real types, across restarts.
  • Every run shows its results. A quick script no longer sometimes loses its result tabs and leaves the editor read-only. An error shows once, after the run's other output, and a new run replaces the last error dialog instead of stacking another.

Aggregation

  • Pipelines run as you wrote them. A $limit before $unwind, $unionWith or $group no longer hides results or offers a page that doesn't exist. They matched mongosh on 130 of 130 pipelines.
  • "Run to stage" says which stage you're seeing instead of fading out the stages after it.
  • Stage forms match the rest of the app and flag bad $bucket values. A blank Index field in $unwind no longer breaks the stage.
  • Cancel really stops the query on the server, on every MongoDB from 3.4 to 9.0, in collection views and aggregation. When the server won't allow it (for example Atlas shared tiers, or a user who can't stop operations), you're told the query is still running.
  • Stage preview search finds values as you type.

Query builder

  • Projection and sort operators: $slice, $elemMatch, $meta, renamed and computed fields in projection, and $meta: "textScore" in sort. Build them in the builder or type them; both stay in sync.

Explain

  • One Plan view replaces Classic and Visual. It opens with a verdict, a suggested index with a Create index button, a funnel of keys examined → documents examined → returned, and each stage's own time with flags like full scan or in-memory sort.
  • Per-shard view, and Compare plans, which shows why each rejected plan lost.
  • Pan and zoom around a plan the way you do in an ER diagram.

Dump & Restore (SOZO-1481)

BSON dumps and restores now behave like the real mongodump and mongorestore.

What you can see

  • Dumps are file-for-file the same as mongodump's, and native mongodump folders restore completely: every index, capped and clustered collection settings, collation, views, time-series collections, empty collections and stored functions.
  • Honest results. A dump that came up short, a database that doesn't exist, or a restore that couldn't bring something back exactly now ends Completed with errors and says why.
  • Faster index rebuilds on restore. A collection's indexes are built in one pass, the way mongorestore does it. If one index can't be built, the others still are and the job names the one that failed. (SOZO-1794)
  • Counts you can trust. A database copy shows the real number of documents copied ("14 / 14 documents", not "100 / 100") and ends with a Copy Summary per collection. JSON and CSV imports count documents, not file size.

What you can do

  • New dump options: point-in-time, include users and roles, a single archive file, a document-count check, views as collections, choose which member to read from, and leave out collections (by name prefix, or by clicking them in a list).
  • New restore options: replay the writes made during a point-in-time dump, restore users and roles, skip indexes, options or validation, stop at the first error, keep document order, keep collection IDs, and rename collections with a live preview.
  • Set a time limit on a job and it is respected.

GridFS

  • Upload files up to 2 GB in the desktop app. Big files go up in pieces with two progress bars, To server and GridFS. Cancelling removes what was already uploaded, and Clear done tidies the upload tray. (SOZO-1785)
  • GridFS works on MongoDB 3.4 – 4.0 servers.
  • A redesigned file browser: a list with a details panel you can resize, one preview window, filters by kind of file, a warning before you upload a duplicate name, a hex preview, and export of just the files you selected.

New & Improved Databases

Databricks

  • Table Management can change tables. Add, change, rename and drop columns, set NOT NULL, defaults and comments, rename the table, and add CHECK constraints. VisuaLeaf shows the statements before they run. If a change needs a Delta table feature that isn't on, it tells you which one and how to turn it on. (SOZO-1760)
  • Tables Info shows real row counts, not 0 for every table. (SOZO-1757)
  • Opening a table is faster, about as fast as SELECT 1. (SOZO-1758)
  • Compare, row sync, dump and restore, exports, mock data and copies work. You can insert rows into tables without a key, and timestamps are no longer shifted in exports.

Valkey

  • A Valkey card in New Connection, valkey:// URLs, and Test Connection reports the real Valkey version.
  • The key browser handles JSON keys, Bloom filters, editable lists, and adding or deleting stream entries, all with undo. New Key offers all 8 types.
  • The Server view shows Valkey's version and mode, plus the Large Requests and Large Replies logs.

Oracle

  • Materialized views have their own folder. You can create, refresh and drop them.
  • Synonyms, triggers, scheduler jobs and directories show in the tree. Triggers show what they fire on, and any trigger can be enabled or disabled.
  • The procedure editor shows the whole source, with Compile & Save, a VALID/INVALID badge, and compile errors you can click to jump to.
  • Table Management can enable or disable triggers and constraints, and shows the SQL before each change.

Other databases

  • Create Table on Db2, Firebird and Derby offers each database's own types. Before, 14 of the 26 types failed.
  • ClickHouse: Tables Info no longer lists other databases' tables. Create Table and native dumps handle JSON columns on servers where JSON is still experimental. (SOZO-1799)
  • Materialize: a VARCHAR without a length is caught before it runs.
  • ER diagrams show nested fields for every type the grid can expand.

AI Agents (MCP)

  • Decide per connection what an AI agent may do: Hidden, Read only, Read & ask before changes, or Read & write.
  • Any change waits for your OK. An in-app prompt shows the exact statement before it runs.

Plans & Licensing

  • Community covers MongoDB, SQL and Redis. You can save up to 3 connections in total across all three. The built-in demo connections don't count.
  • Nothing you already have is taken away. If you have more connections, saved queries, scripts, ER diagrams, schemas or tasks than your plan allows, each one still opens, runs, copies, exports and deletes. Only adding a new one, or saving a change while over the limit, asks you to upgrade. You can choose which items to keep whenever you like; VisuaLeaf offers a backup first and pre-selects your most recently used connections.
  • One-off CSV and JSON import and export on Community, from the grid's Import and Export buttons.
  • "Try it" before you buy. Data Transfer, Data Compare, User Management, Mock Data and the Query Profiler open on sample data in a Preview tab. Nothing in a preview is saved or sent anywhere.
  • The upgrade prompt names the right plan. It says "available in VisuaLeaf Basic" when Basic is enough. (SOZO-1743)
  • Calmer prompts and locks. Notices share one quiet style, and a locked option shows a single Basic or Pro tag.
  • Pro tabs stay locked after a licence lapses. Recent items, Reopen Closed Tab and restored workspaces show a lock, and unlock in place when the licence comes back. (SOZO-1751)
  • Importing a Task Manager backup no longer freezes the window. You get one progress card and one summary of what was imported, skipped or refused.

Improvements

Sidebar

  • Pin any right-click action to the sidebar's action bar. Actions that aren't available say why when you click them.
  • A view picker switches the sidebar to Saved Queries, Scripts, Charts, Dashboards or ER diagrams without leaving your tab, and + creates a new one. New Query works for MongoDB and SQL.
  • Show every action name at once with a new toggle (off by default). The first time you turn it on, a short tour shows how it works.
  • Drag to reorder the sidebar icons and right-sidebar shortcuts in Settings.
  • MongoDB views get their own right-click menu.

Dialogs & Look

  • 46 dialogs share one modern look, and 10 unused ones are gone.
  • 39 more dialogs restyled to match. Ten of them stayed dark in light mode (such as Add Field, Rename Field, Drop Database and File Explorer) and now follow your theme. (SOZO-1791)
  • DB Stats, Server Build Info and Data Sync are redesigned to match the app. Data Sync's connection and database pickers can be typed into.
  • Message boxes appear on top of the window that opened them, for example Revoke Role in User Details.
  • Every notification has a Copy button, so an error that disappears after a few seconds can still be pasted into a bug report.
  • The same alert shows once instead of stacking, for example when a connection drops while several tabs use it.

Grids, Charts & Visual Schema

  • Dragging a cell selection to the edge scrolls the columns.
  • Cell editors open on the first click, and dropdowns and menus no longer flicker on hover.
  • Custom SQL results say "Read-only results" or "Partly editable results", so it no longer looks like the query itself is read-only.
  • Charts redraw in the right colors when you switch between light and dark. Click a field again to take it off the chart, and dragging a field onto a box works again.
  • Visual Schema reuses the open tab, has a New diagram button, and lets you copy error messages. (SOZO-1755, SOZO-1754)
  • The JSON Schema editor: clicking Required right after renaming a field works.

Query Profiler

  • One layout for MongoDB and SQL. Drag across the chart to focus on a stretch of time. MongoDB 8 query shapes are grouped, and Clear works while profiling is on.
  • Fits a narrow pane. In a small window the list keeps the collection name readable instead of squeezing it.

Exports & Data Transfer

  • PostgreSQL arrays stay arrays in SQL, JSON and XML exports.
  • A SQL dump from a table uses that table's own SQL dialect.
  • Big numbers stay exact in JSON exports from SQL. Integers beyond 2^53 and decimals beyond 15 digits are written as exact text, so tools that read the file get the stored value. (SOZO-1797)
  • Adding or pasting documents that partly fail now says "Inserted 2 of 3 documents. 1 refused: …" and refreshes the grid, instead of "Paste failed" after the valid ones were saved.
  • Document copies keep each document as it was. Documents no longer gain null fields from other documents, whole numbers no longer become decimals, and UUIDs survive an Extended JSON export and re-import.
  • The export job editor builds its field mapping when opened from a query or pipeline, and the live preview keeps up while you type a SQL query. Data Compare opens SQL rows in SQL. (SOZO-1764)
  • Table Operations (Triggers…, Constraints…, Partitions…, Drop/Clear Table) are in the open table's menu, and "Open in" actions can be pinned. Table Management is pinned by default.

Keyboard

  • Your custom shortcuts work inside code editors, and ⌘/ opens the shortcut list. (GitHub #35)
  • "Open in" actions have keys: ⌘⌥ plus a letter, on both SQL tables and collections. If the action isn't available right now, the shortcut tells you why instead of doing nothing, and it works on German, Polish and French keyboards.
  • Shortcuts work on Windows. (SOZO-1792)
  • Ctrl+F jumps into the search box and searches for the selected cell, in SQL tables as well as MongoDB views. F3 / Shift+F3 step through matches while you're in the search box, and Ctrl/⌘+G / Ctrl/⌘+Shift+G do the same on laptops where F3 changes the brightness.
  • The editor command palette (F1) no longer opens empty. Laptops that take the F-keys get alternatives: Ctrl+Shift+P for the palette, Ctrl+B to go to a definition.
  • Ctrl/⌘+9 jumps to the last tab, and Ctrl+Alt shortcuts no longer get ignored.
  • More guided tours.

Desktop

  • Memory sizes itself. There's no memory profile to pick and no restart. VisuaLeaf uses memory as the work needs it and gives it back when idle, and the status bar shows how much is in use.
  • Quitting takes about 0.6 seconds instead of 2.8. The download is about 70 MB smaller.
  • Pages load faster over the network, in the browser and the desktop app.
  • ⌘R refreshes the table on macOS instead of reloading the app.
  • One failed workspace save no longer stops saving until you restart, and System Monitor tabs save with your workspace again.
  • Logging out keeps your workspace. The window no longer reports it as deleted after you log out. (SOZO-1798)
  • Moving a single-instance tab (such as Collection Stats) to a new window works, instead of saying it's already open.

Infrastructure

  • Moved to Angular 22 and TypeScript 6.
  • The desktop app ships with Java 25 and starts the backend from a prepared cache, so it starts nearly twice as fast (about 50% less time to start).
  • Expanded test coverage, and the end-to-end suite is back in line with the app.

Notes

  • Shell run keys changed. Ctrl+F5 in the shell now means "Run to cursor", which runs every statement from the top down to the cursor, not just the selection. ⌘Enter / Ctrl+Shift+Enter runs a query, and ⌘⇧Enter runs the whole script. If you used Ctrl+F5 to run a selection, check Keyboard Shortcuts.
  • MongoDB certificates: new connections now verify the server's certificate. If a new connection to a server with a self-signed certificate fails, add its CA, or turn on Allow invalid certificates if you trust it. Saved connections keep the setting they had.
  • PAM / LDAP sign-in on MySQL and MariaDB now requires TLS. Turn TLS on for those connections.
  • Server mode: an SSH key must be pasted into the connection, not given as a file path.
  • Memory settings and "Reset Memory Settings" are gone. Any memory size you set before is ignored.
  • Community now leaves out: batch insert, update and delete; applying or removing JSON Schema validators (you can still view and copy schemas); ER diagram export other than PNG and JSON; saved or scheduled tasks; and undo beyond 3 steps. The 3-connection limit now counts SQL and Redis connections too. Everything you already have keeps working.
  • Aggregation: a saved pipeline that relied on VisuaLeaf quietly fixing it, such as a $group with no _id or $limit: 0, now shows MongoDB's own error.
  • Dump jobs now check document counts by default, including jobs saved earlier. If a collection gets many writes while it is dumped, use the point-in-time option or turn the check off.

See the full release history