MongoQUI pairs a keyboard-first desktop GUI with an AI query assistant, a BI-grade Report Builder, team sharing and RBAC. Works fully offline for local work. Backed by a cloud control plane for identity, billing and collaboration.
- Pillars
- 12
- Capabilities
- 120+
- Availability
- Across every plan
Desktop runtime & workspace
A real native app, not a browser wrapper. MongoQUI ships as a Tauri 2.1 shell that launches a compiled Python sidecar per install, so every MongoDB call stays on your machine. Deep-link URLs, auto-update and a master-password vault come as standard across macOS, Windows and Linux.
Tauri 2.1 native shell
macOS (universal), Windows x86_64, Linux x86_64 AppImage. Single-instance lock and drag-drop disabled by default for safety.
Offline Python sidecar
A PyInstaller-compiled FastAPI backend runs on a dynamic port per launch, handles every MongoDB I/O locally, and shuts down cleanly on tray exit.
Argon2id master password
Local credential vault gated by an Argon2id hash stored in the OS app-data dir. No cloud round-trip to unlock the desktop app.
Auto-update channel
Silent updates via updates.mongoqui.com signed with a minisign public key. Stable channel, opt-in manual install.
Deep-link protocol (mongoqui://)
Register once, open any saved connection, report or team invite straight from a browser link.
System tray and native menu
Native OS menubar integration on macOS, notification area on Windows and Linux. Quit, refocus, check-for-updates.
Tab workspace
Per-tab query and view state. Basic keeps 10 open tabs, Pro keeps 25, Ultimate is unlimited.
Command history and keyboard shortcuts
Every action recorded in the command-history store, keyboard-first navigation across connections, tabs and queries.
Dark and light themes
System-aware theme switcher. Dark mode ships on every paid plan.
Core querying & document workspace
The basics, done properly. Every plan ships with a full MongoDB workspace. Visual query builder, three document viewers, Monaco editor, connection management and an 18-stage aggregation pipeline builder. No paywall between you and your data.
db.orders.aggregate([
{ $match: { status: "paid", createdAt: { $gt: ISODate("2026-03-20") } } },
{ $group: { _id: "$customerId", total: { $sum: "$amount" }, orders: { $sum: 1 } } },
{ $lookup: { from: "customers", localField: "_id",
foreignField: "_id", as: "customer" } },
{ $sort: { total: -1 } },
{ $limit: 25 }
])Visual Query Builder
Construct find queries without writing code. Live result preview and basic projections on every plan.
Document viewers · tree · JSON · table
Switch between tree, JSON and table views on the same result set, in one keystroke.
Database and collection browsers
Sidebar navigation across databases and collections, with inline stats and one-click copy of document _id.
In-result search
Full-text search within the active result set. No round-trip to the server.
Per-document detail pane
Inspect any document in a dedicated viewer with type-aware formatting.
IntelliShell (Monaco)
Raw query editor with MongoDB shell-aware syntax highlighting, IntelliSense and multi-line paste support.
18-stage aggregation pipeline
Covers $match, $group, $project, $sort, $limit, $skip, $unwind, $lookup, $addFields, $count, $replaceRoot, $merge, $out, $facet, $bucket, $bucketAuto, $sortByCount, $unionWith. Drag to reorder.
Export query as code
Emit the current query for Node.js, Node.js (Mongoose), Python, Python (Motor), Java, C#, Go or Rust.
Connection management
Create, edit, test and delete saved connections. Unlimited on every paid plan.
Folder organisation
Group connections into folders, nested trees, per-folder colour tagging. Synced across devices on Pro and Ultimate.
Advanced querying & AI generation
Go from find to production pipeline without leaving the editor. Pro unlocks a drag-and-drop aggregation designer, schema-aware AI generation for find and aggregation queries, a dry-run validator using $explain, and unlimited history.
“Show me the top 25 customers by revenue in the last 30 days, joined with their contact email from the customers collection.”
[
{ $match: { status: "paid",
createdAt: { $gt: ISODate("2026-03-20") } } },
{ $group: { _id: "$customerId",
total: { $sum: "$amount" } } },
{ $lookup: { from: "customers", localField: "_id",
foreignField: "_id", as: "c" } },
{ $sort: { total: -1 } },
{ $limit: 25 }
]Advanced Visual Query Builder
Complex conditions including $lookup and $graphLookup joins, nested logic, advanced projections.
Visual Aggregation Designer
Drag stages, swap operators, preview intermediate results per stage.
AI Query Generator · find
Describe the query in plain English. Get a MongoDB find back, validated against the real schema.
AI Query Generator · aggregation
Same flow for multi-stage pipelines. Stage ordering, joins and group keys suggested from sampled data.
Per-connection AI context
Attach a schema summary per connection so the AI references real field names, types and cardinality, not guesses.
Query Validator
Dry-run any query with $explain. Surface cost, index usage and plan warnings before execution.
Query history
Deduplicated by hash. Basic keeps 50. Pro and Ultimate are unlimited.
Saved queries
Name, organise, share with a team. Basic keeps 25. Pro and Ultimate are unlimited.
Max aggregation stages
Basic tops out at 20 stages per pipeline. Pro and Ultimate are unlimited.
Data import and export
Move data in and out on your terms. JSON, CSV, Excel and JSONL on every plan. BSON, gzipped archives, mongodump archives, field mapping, import preview and streaming cursor export unlock on Pro.
JSON · JSONL · CSV · Excel
Core import and export formats on every plan. Delimiter support for comma, tab, semicolon and pipe.
BSON import and export
Native BSON round-trips for Mongo-to-Mongo workflows.
Gzipped and archive formats
BSON.gz, .archive.gz and mongodump-style archives, plus nested compressed formats.
Source-to-target field mapping
Map incoming columns to target fields before a single document lands. Type coercion per field.
Pre-import plan and preview
Row counts, type inference and conflicts visible before anything runs. Modes: override, skip, create new, merge.
Query-scoped export
Export only the active query result-set, not the whole collection.
Full-collection export
Dump an entire collection on every plan.
Field selection on export
Pick the exact subset of fields to emit.
Active cursor export
Stream straight from an open cursor without buffering the whole result in memory.
File-size and document limits
Basic: 100 MB / 5k docs in / 10k docs out. Pro: 1 GB / 100k / unlimited out. Ultimate: unlimited.
Database, collection & index administration
The admin surface your platform team actually wants. Create and drop databases and collections, rename, perform single and bulk copy or drop, design validation schemas visually, and get index suggestions from real workload.
Database DDL
Create and drop databases. Every plan.
Collection DDL
Create, drop and rename collections. Every plan.
Document CRUD
Add, edit and delete individual documents with inline validation.
Batch document delete
Multi-document cleanup with dry-run preview before commit.
Schema Builder
Design MongoDB validation schemas for collections in a visual editor.
Copy collection
Clone a single collection into the same or another database.
Bulk copy and bulk drop
Multi-select collections and copy or drop as one transaction.
Basic index management
Create, edit and drop indexes on any collection.
Advanced index management
Partial, TTL, hidden, unique and compound indexes.
Schema Analyzer
Auto-inferred schema from sampled documents. Shows type drift, optionality and cardinality per field.
Dynamic index recommendations
Watches recent workload and suggests indexes that actually affect query plans.
Task progress with abort
Long-running imports, exports, copies and drops run with live progress and cancellation.
Connections & advanced MongoDB support
Connect to any MongoDB, anywhere. Atlas, self-hosted, replica sets, sharded clusters, SRV discovery and TLS with X.509 client certificates. Connections are unlimited on every paid plan, the bundled mongosh ships on Pro.
Full MongoDB URI options
Read preference, write concern, read concern, pool size, timeouts, retries and compression flags exposed in-app.
Replica set support
Topology-aware connections with configurable read and write concerns.
DNS seedlist (mongodb+srv://)
SRV record discovery on every plan. Not a paywall feature.
TLS 1.3 · X.509 · CA bundles
Client certificates, custom certificate authorities and standard system trust store. Every plan.
Sharded cluster support
Full-fidelity topology awareness across shards and mongos nodes.
Bundled mongosh on desktop
No separate shell install. The compiled mongosh binary ships inside the desktop app.
Folder tree for connections
Organise dozens or hundreds of clusters into named folders. Colour tags, drag to reorder.
Unlimited saved connections
No seat-level quota on any paid plan.
Shell workflow & SQL translator
A real shell, not a toy. Three execution modes (in-process, persistent session and cloud fallback), automatic command classification, prefetched pagination. Plus a SQL to MongoDB translator that accepts joins and emits idiomatic aggregations in eight target languages.
Normal mode (in-process)
Commands execute inside the bundled py-backend using the compiled mongosh binary.
Realtime mode (persistent session)
A persistent shell session that keeps variables and cursors across commands. Used by scripts and long investigations.
Lambda mode (cloud fallback)
Falls back to the managed mongo_lambda AWS function when the local mongosh binary is unavailable.
Command classifier
Auto-routes find, insert, update, delete and admin commands to the right execution path with post-processing detection.
Keyset and offset pagination
Transparent next-page prefetching for large result-sets. No manual skip/limit tuning.
SQL to MongoDB translator
SELECT, INSERT, UPDATE, DELETE and multi-table joins. Output is idiomatic MongoDB aggregation stage ordering.
8-language driver snippets
Python, Python (Motor), Node.js, Node.js (Mongoose), Java, C#, Go, Rust. Powered by @mongoqui/query-to-language.
Execute mongosh commands
Run arbitrary shell commands directly inside the app. No separate terminal, no context switch.
Report Builder
BI that understands MongoDB documents. Turn any aggregation into a pixel-perfect dashboard, share it read-only with colleagues or clients, password-protect and expire it, and re-run on fresh data with one click. No Looker, no separate warehouse, no Compass export dance.
One-click re-run
Refresh any report against live MongoDB. Charts, KPIs and shared links update atomically.
Serverless analytics
Columnar snapshots in object storage, in-memory SQL engine on a 2 GB serverless function with 60-second timeout. 50M-doc aggregations finish in seconds.
Nine block types
Table, bar, line, pie, doughnut, KPI, text, image, grid. Chart.js under the hood with themed colours.
AI Report Assistant
Schema-aware BI suggestions. Drafts the SQL query, picks the chart type, writes the narrative. AI inference with primary Llama 3.3 70B and 3.1 8B fallback.
Shareable read-only viewer
No install, no account required for viewers. Runs in any browser.
Share by user, email, link or public
Grant access to internal users, external emails, signed links or a fully public page, all revocable.
Password-protected share links
Bcrypt-hashed password, expiry timestamp, instant revoke. Passwords never leave the edge.
Action-level permissions
Export, delete, re-run and configuration edits are gated behind elevated role checks per report.
Viewer watermark and expiry
Every share URL is stamped with viewer email and expiry, recorded in the audit log.
Cached response store
Report queries cache to object storage for fast repeat loads, with manual invalidation on re-run.
Teams, RBAC & collaboration
A workspace, not just an app. Invite teammates, share connections safely, run TOTP 2FA, scope roles per connection, and manage MongoDB users and roles directly on Ultimate. Every action is logged.
Shared connections
AES-256-encrypted credentials (ENCRYPTION_KEY). Teammates use the connection without seeing the secret.
Organisation management
Plan seats, ownership, per-org settings and billing from a single place.
Invite and remove team members
Pro: up to 10 seats. Ultimate: unlimited. Accept-invite flow handled via verify-invite route.
Admin / Editor / Viewer roles
Built-in roles plus custom role creation. Per-connection scoping covers database, collection, read and write.
TOTP two-factor auth
Backed by otplib 12.0.1 in the auth service. QR enrolment handled inside the desktop app.
Per-device session tokens
Each logged-in device holds a revocable session. Release a device to log it out remotely.
Org-scoped audit log
Every sensitive action recorded with actor, organisation, category, timestamp and IP address.
Shared saved queries and folders
Saved queries and connection folders sync across teammates once shared.
Elevated-permission gating
Sensitive actions (share edits, exports, deletes, report re-run) require a role check before execution.
MongoDB RBAC management
Create and edit MongoDB users and roles directly on your cluster. No mongosh round-trip. Ultimate only.
AI assistant & rate limits
Schema-aware, provider-agnostic, rate-limited for cost sanity. Dry-run before any pipeline with write-equivalent side effects. BYOK on every paid plan, so the cost surface is yours to control.
Natural language to MongoDB
Find and aggregation generation, plus explain optimisation and index recommendations.
Provider choice
OpenAI (default gpt-3.5-turbo), Anthropic (default claude-3-opus-20240229), Google Gemini (default gemini-pro). Pick per request.
Bring your own key
Plug in your own API key for any provider. Ours by default, yours if you want full control.
Rate limit · requests
10 requests per minute per user across every provider.
Rate limit · tokens
Pro: 100,000 AI tokens per month. Ultimate: unlimited.
Per-query cache
3,600-second cache on identical prompts to keep repeat costs down.
Schema context injection
Ships the connection's schema summary so the AI references real fields, not hallucinated ones.
Safe mode
Any generated pipeline with write-equivalent side effects is surfaced as a dry-run preview before commit.
Security, privacy & compliance
Every control you would expect from a database client handling production credentials, plus the ones most of our competitors skip. Documented, enforced and audited.
Argon2id master password
Local desktop encryption of the credential vault. Argon2id v19 defaults, per-install salt.
AES-256 shared credentials
Team-shared connections encrypt credentials at rest before they ever leave your device.
JWT with org scope
Every cloud API call carries Authorization: Bearer plus x-organization-id. Verified at the edge.
TOTP 2FA
Enrolment inside the app. Backed by otplib in the auth service.
Per-device sessions
Each device is tracked and revocable independently.
Internal service auth
Service-to-service calls use authenticated headers. No anonymous internal traffic.
Rate limiting
Per-endpoint rate limiting buckets on every public-facing route.
CORS allow-list
Explicit origin allowlist. No wildcard origins in production.
Org-wide audit log
/api/v1/audit-logs captures every sensitive action with actor, category and IP.
Password-protected share links
Bcrypt hash, expiry timestamp, instant revoke. Per-share, not per-workspace.
GDPR, UK GDPR, CCPA, UAE PDPL
Data subject rights honoured via support@mongoqui.com. EU data residency available.
SOC 2 audit in progress
Type II engagement underway. Contact for current status. Do not treat as certified yet.
Cloud control plane & billing
The desktop app does the local work. The cloud control plane runs identity, billing, collaboration and analytics. Eight purpose-built services behind one gateway, with a cloud backend when you need it.
API gateway
Single entry point (api.mongoqui.com) that fans out to every backend service.
Authentication
Users, organisations, seats, roles, devices, audit logs, user settings, shared connections, verify-invite.
Connection sync
Cloud-synced connections, folders, query history, saved queries and cached responses.
AI assistant
Provider-aware generate-query endpoint with per-provider model config and cache.
Email service
Transactional email templates for verification, invitation, password reset, payment, subscription, report share and public report.
Reports storage
File upload, presigned URLs, reports CRUD, cached responses and share management (user, email, link, public).
Cloud backend
The same FastAPI sidecar packaged as a single-instance container with 5-minute sleep, for users who need the backend in the cloud.
Report AI
AI-powered report suggestions with primary and fallback models, validator stage and cache.
Analytics engine
Serverless analytics with in-memory SQL engine. 2 GB memory, 60-second timeout. Backs the Report Builder and shared-report viewer.
Billing
Per-seat yearly pricing. Reserve, assign and activate flow. 14-day trial with every Pro feature unlocked.
Plan management
Self-serve plan changes at license.mongoqui.com. In-app upgrade modal on any paywalled action.
Downloads
updates.mongoqui.com ships macOS universal, Windows x64 and Linux AppImage, signed and notarised where applicable.
Which pillars
light up on your plan.
The matrix below is pillar-level, not feature-level. For the exact line-by-line split, see the pricing page.
Before you
download.
For the full controls list, see /security. For the plan-by-plan grid, see /pricing.
Try every pillar on
your own data.
Download the desktop app, connect a cluster in under a minute, and spend the 14-day trial with every Pro feature unlocked.