Frequently Asked Questions About MongoDB GUI

The Query Profiler is a real-time performance analysis tool that captures detailed metrics for every MongoDB query executed. It provides scatter plot visualizations, identifies slow queries, analyzes scan efficiency, generates EXPLAIN plans, and recommends index optimizations. You can filter by time ranges (30 min to 30 days), operation types, and namespaces to pinpoint performance bottlenecks.

The Visual Schema Designer provides a drag-and-drop canvas interface where you can visualize your MongoDB collections and their relationships. It features auto-generation from existing databases, intelligent relationship detection using graph theory, auto-arrangement algorithms, color coding for collections, and export/import capabilities. You can create, edit, and maintain complex schema designs visually without writing code.

Yes! Our AI Query Assistant translates natural language into MongoDB queries. Simply describe what you want in plain English (e.g., "find all users created last month with active subscriptions"), and the AI generates the corresponding MongoDB query. It uses your collection schema and sample data for context-aware suggestions, making it perfect for both beginners and experienced developers.

This feature allows you to compare collections side-by-side across databases or servers. It identifies missing documents, modified documents, and identical records. You can then generate sync plans to synchronize data bidirectionally (source to target or vice versa), with selective synchronization and progress tracking. Perfect for migrations, backups, or keeping environments in sync.

Absolutely! The Aggregation Pipeline Builder provides a complete visual interface for constructing MongoDB aggregation pipelines. It includes a full stage palette ($match, $group, $project, $lookup, etc.), drag-and-drop pipeline construction, live data preview at each stage, and the ability to export pipelines to code. You can build complex aggregations without memorizing syntax.

VisuaLeaf Charts (full release in Q2 2026) will support multiple chart types including bar charts, line charts, pie charts, scatter plots, and more. You can visualize query results and aggregation outputs in real-time, with interactive charts that update as your data changes. Charts can be exported as images for reports and presentations.

VisuaLeaf supports MongoDB 4.0 and above, including MongoDB 4.x, 5.x, 6.x, and 7.x. It works with MongoDB Community Edition, Enterprise Edition, and MongoDB Atlas (cloud). All MongoDB features including replica sets, sharded clusters, and transactions are fully supported.

Yes! VisuaLeaf fully supports MongoDB Atlas connections. Simply use your Atlas connection string with proper authentication credentials. All Atlas features including serverless instances, dedicated clusters, and shared clusters are supported. The connection manager securely stores your Atlas credentials.

VisuaLeaf is a cross-platform desktop application available for Windows, macOS, and Linux. It's built with modern web technologies ensuring consistent performance across all operating systems. Minimum requirements: 4GB RAM, 500MB disk space.

Yes! VisuaLeaf supports SSH tunneling for secure connections to remote MongoDB servers behind firewalls. It also supports SSL/TLS encrypted connections, client certificate authentication, and MongoDB authentication mechanisms including SCRAM and X.509. LDAP and Kerberos support coming in Q2 2026.

Currently supported: JSON, CSV, and SQL exports. You can also export to mongodump format, directly into other collections, or into SQL tables. The Task Manager handles all import/export operations and is currently in beta (mostly functional). All exports support streaming for large datasets, ensuring memory-efficient operations. You can also import/export GridFS files directly.

Absolutely! VisuaLeaf fully supports MongoDB replica sets and sharded clusters. You can connect to the primary or any secondary node, view replication lag, monitor shard distribution, and execute read preferences. The Query Profiler works seamlessly across sharded environments.

VisuaLeaf includes an integrated MongoDB Shell that provides full command-line access within the application. You can execute JavaScript, use all MongoDB shell commands, save scripts, and access command history. The shell provides syntax highlighting, auto-completion, and error detection.

SQL Mode allows you to query your MongoDB documents using familiar SQL syntax. If you're coming from a relational database background, you can use SELECT, WHERE, ORDER BY, and other SQL keywords to query your collections without learning MongoDB's query syntax. VisuaLeaf translates your SQL queries into MongoDB queries behind the scenes.

Absolutely! VisuaLeaf lets you save queries and aggregations with names and descriptions, browse your query history with search and filtering, maintain a script library for MongoDB shell scripts, and load or modify saved queries anytime.

Yes! VisuaLeaf supports keyboard shortcuts for common operations to improve productivity. The editors also include autocomplete for MongoDB syntax, collection names, and field names.

It's easy! Launch VisuaLeaf, click "New Connection", enter your MongoDB connection URI or configure manually, test the connection, and click Connect. You'll be browsing your data in seconds.

Yes! We start you off with the Community Edition completely free, and you can use it for as long as you like without an account. On top of that, the Pro version comes with a 14-day free trial: create a free account with just your email — no credit card — and you get 14 days of full Professional access, starting the moment you sign up.

Yes. All our paid licenses are perpetual — one-time payment and you keep the app forever. Every license includes 1 year of updates from the purchase date. After that year, the app keeps working exactly as-is, but if you want to keep receiving new features and updates, you can renew for another year.

Yes! Each license includes multiple device activations. Pro licenses typically allow 2 concurrent activations. You can deactivate a device and activate on a new one anytime through the license management dashboard.

We accept all major credit cards (Visa, Mastercard, Amex) and PayPal, processed securely through our payment provider.

Yes! We offer a 30-day money-back guarantee on all paid plans. If you're not satisfied for any reason, contact support within 30 days of purchase for a full refund. No questions asked.

Free tier: Community support via forums. Pro tier: Email support with 24-48 hour response time. All tiers have access to comprehensive documentation and video tutorials.

Absolutely! We actively encourage feature requests from our community. You can submit requests via email (feedback@visualleaf.com), our feedback portal, or GitHub discussions. Check our Roadmap page to see what's coming.

We follow a quarterly release cycle with major feature updates every 3 months. Bug fixes and minor improvements are released bi-weekly. Security patches are released immediately as needed. All updates are automatic and seamless - you'll always have the latest version.

When a new version is available, you'll see a notification at the bottom of the app. Click it to be redirected to the download section of our landing page where you can download the latest version. Simply install the new version and uninstall the old one. Don't worry - your local data (previous jobs, connections, saved queries, etc.) will not be lost during the update process.

All connection credentials are encrypted using AES-256 encryption and stored locally on your machine. Credentials never leave your computer and are never sent to our servers.

No! VisuaLeaf operates entirely locally on your machine. Your database data never passes through our servers. All connections are direct from your computer to your MongoDB server. We only collect anonymous usage analytics (which features you use, not what data you access) to improve the product.

Parts of VisuaLeaf are open source and available on GitHub. The core engine and certain components are proprietary to maintain product quality and sustainability. However, we support custom plugins and extensions, and publish our plugin API openly.

Yes! VisuaLeaf works completely offline once installed. License activation requires one-time internet access, but after that, you can use all features without internet connectivity.

Yes! VisuaLeaf includes comprehensive Role-Based Access Control (RBAC) allowing you to define user roles with specific permissions. The audit logging feature tracks all operations (queries, modifications, connections) with timestamps, user information, and detailed action logs for compliance and security monitoring.

Yes. Alongside MongoDB, VisuaLeaf connects to PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite, ClickHouse, DuckDB, CockroachDB, and TiDB, plus the MongoDB-compatible Amazon DocumentDB and Azure Cosmos DB. You can browse schemas, run queries, and build ER diagrams for all of them from one workspace. See the full list of supported databases.

Yes. Both expose a MongoDB-compatible API, so VisuaLeaf connects over the MongoDB wire protocol using a standard connection string. For Amazon DocumentDB, clusters live inside a VPC, so you point VisuaLeaf at the cluster or reader endpoint through an SSH tunnel or VPC peering and add the DocumentDB CA certificate. For Azure Cosmos DB, VisuaLeaf works with both RU-based accounts and vCore, and surfaces Cosmos-specific details like the partition key and the request unit (RU) charge per operation. Note that both are compatibility subsets rather than 100% of MongoDB — commands they have not implemented return the same errors they would from any Mongo client.

Yes. VisuaLeaf renders JSONB and json columns as an expandable tree so you can inspect nested keys and arrays inline and edit values without hand-writing jsonb_set. It also recognizes GIN-indexed columns you filter with the ->, ->> and @> operators. The same tree view applies to MySQL JSON columns and SQL Server JSON data. More on the PostgreSQL GUI page.

Yes. VisuaLeaf can migrate databases from SQL to MongoDB and from MongoDB back to SQL, running transformation functions during the migration. The Task Manager can schedule those jobs to run on a recurring basis.

Yes. Both are serverless, single-file databases, so there is no connection string — you open the .sqlite, .db, or .duckdb file directly. That includes embedded SQLite databases shipped inside mobile and desktop apps, browsers, and edge devices, plus test fixtures copied from a build. With DuckDB you can also query Parquet and CSV files directly. See the SQLite and DuckDB pages.

Yes. VisuaLeaf reads the foreign keys defined on your tables and draws them as an ER diagram automatically, showing primary keys, referenced columns, and one-to-many relationships from your live schema. This works across PostgreSQL, MySQL and MariaDB (InnoDB), SQL Server, Oracle, SQLite, CockroachDB, and TiDB.

Yes. VisuaLeaf renders EXPLAIN output as a visual plan rather than raw text, so you can see join order, index usage, and full table or sequential scans at a glance, then review index candidates to tune performance. Supported for PostgreSQL, MySQL, MariaDB, and SQL Server execution plans. There is also a free browser-based SQL explain plan visualizer and a MongoDB explain plan tool.

Yes. The visual query builder composes real SQL — including JOINs, CTEs, window functions, and grouping — and exports the generated statement so you can see exactly what runs. For MongoDB it produces queries and aggregation pipelines instead. SQL Mode goes the other direction, letting you query MongoDB collections with familiar SELECT / WHERE / ORDER BY syntax.

Yes. VisuaLeaf keeps everything Compass does well — browsing, schema analysis, aggregation, and mongosh — and adds SQL Mode, Charts & Dashboards, a GridFS viewer, the Task Manager, RBAC, and Collection Compare. The Community Edition is free, much like Compass. Read the full VisuaLeaf vs MongoDB Compass comparison.

Yes, especially if you want a modern MongoDB workspace focused on visual queries, aggregation building, schema diagrams, charts, dashboards, split views, and performance checks. Studio 3T remains a mature professional IDE with strong SQL, import/export, profiling, and enterprise features. On price, Studio 3T Professional starts at $499/user/year and Ultimate at $699/user/year at the time of writing; VisuaLeaf is positioned as a lower-cost alternative with a free Community Edition. See the side-by-side comparison.

Robo 3T has seen minimal updates since Studio 3T acquired Robomongo. VisuaLeaf is designed for that successor role: it keeps Robo 3T's simple, tree-based feel and adds the modern tooling Robo 3T never got — an aggregation builder, schema designer, AI assistant, charts, and a query profiler. Your existing connection strings work directly. See the Robo 3T comparison.

Yes. VisuaLeaf covers the shell-first workflow NoSQLBooster users rely on — IntelliSense with full autocomplete against your schema, chainable methods, inline docs, and ES6+ syntax — plus a visual query builder, aggregation editor, and profiler. It adds Charts & Dashboards, an AI assistant, split panels, and RBAC. See the NoSQLBooster comparison.

Yes. VisuaLeaf covers Navicat for MongoDB's core surface — visual query builder, aggregation, charts, and scheduler-style tasks — and adds SQL Mode, the AI query assistant, split panels, and a free tier. On price, there is no separate MongoDB SKU stacked on top of an already-premium base product. See the Navicat comparison.

DBeaver and TablePlus are both strong general-purpose SQL clients where MongoDB support is adapted rather than native. In VisuaLeaf the aggregation builder, GridFS, schema designer, and charts are first-class. Startup is instant with no JVM warm-up. If MongoDB is a meaningful part of your work, VisuaLeaf is worth switching to; if you mostly use Postgres or another SQL engine, the two can happily coexist. See the DBeaver and TablePlus comparisons.

Yes. VisuaLeaf supports standard MongoDB connection URIs, so connection strings from Compass, Robo 3T, Studio 3T, NoSQLBooster, or any other client work directly. Both the mongodb:// and mongodb+srv:// forms are supported, and you can also build the connection visually in the Connection Manager. There is a free MongoDB connection string builder if you need to construct one.

Yes. VisuaLeaf ships a dedicated arm64 build for Apple Silicon Macs, so it runs natively without Rosetta translation. Intel Macs get their own x64 build, and the download page detects your architecture and offers the right installer. macOS 11 (Big Sur) and later are supported. More on the MongoDB client for Mac page.

On Windows, VisuaLeaf supports Windows 10 and Windows 11 via a standard .exe installer. On Linux, it ships a .deb package for Ubuntu, Debian, and derivatives (Mint, Pop!_OS, elementary, and others) and an .rpm package for Fedora and RPM-based distributions. An arm64 .deb is also published for ARM machines such as ARM servers and 64-bit single-board computers. See the Windows and Linux pages.

No. VisuaLeaf is a client — it connects to a MongoDB server wherever that server runs: MongoDB Atlas in the cloud, a local server on your machine, a Docker container, or a remote deployment. There is nothing to install server-side.

Yes. The Task Manager schedules exports, imports, backups, migrations, and custom scripts on cron-style intervals, so recurring jobs run without you opening the app. The Task Manager is currently in beta.