An encyclopaedia of capabilities, pillar by pillar.

macOS (separate Apple Silicon and Intel builds), Windows x86_64, Linux x86_64 (.deb + AppImage). Single-instance lock and drag-drop disabled by default for safety.

A PyInstaller-compiled FastAPI backend runs on a dynamic port per launch, handles every MongoDB I/O locally, and shuts down cleanly when you close the window or quit.

Locks the desktop UI behind an Argon2id hash stored in the OS app-data dir. No cloud round-trip to unlock the desktop app.

The app checks the signed release manifest at downloads.mongoqui.com and shows an in-app banner. You choose when to download and install.

Register once, open any saved connection, report or team invite straight from a browser link.

App menu with About, Check for Updates, Settings, Hide and Quit, plus Edit, Window and Help menus.

Per-tab query and view state. Free keeps 3 open tabs, Basic 10, Pro 25, Ultimate is unlimited.

Every action recorded in the command-history store, keyboard-first navigation across connections, tabs and queries.

System-aware theme switcher. Dark mode ships on every paid plan.

Construct find queries without writing code. Live result preview and basic projections on every plan, including Free.

Switch between tree, JSON and table views on the same result set, in one keystroke.

Sidebar navigation across databases and collections, with inline stats and one-click copy of document _id.

Full-text search within the active result set. No round-trip to the server.

Inspect any document in a dedicated viewer with type-aware formatting.

Raw query editor with MongoDB shell-aware syntax highlighting, IntelliSense and multi-line paste support.

Covers $match, $group, $project, $sort, $limit, $skip, $unwind, $lookup, $addFields, $count, $replaceRoot, $merge, $out, $facet, $bucket, $bucketAuto, $sortByCount, $unionWith, $set, $unset, $redact, $sample, $geoNear, $graphLookup, $densify, $fill and $setWindowFields. Drag to reorder. Basic allows 20 stages per pipeline, Pro and Ultimate are unlimited.

Emit the current query for Node.js, Node.js (Mongoose), Python, Python (Motor), Java, C#, Go or Rust.

Create, edit, test and delete saved connections. One on the Free plan, unlimited on every paid plan.

Group connections into folders, nested trees, per-folder colour tagging. Synced across devices on Pro and Ultimate.

Complex conditions including $lookup and $graphLookup joins, nested logic, advanced projections.

Drag stages, swap operators, preview intermediate results per stage.

Describe the query in plain English. Get a MongoDB find back, validated against the real schema.

Same flow for multi-stage pipelines. Stage ordering, joins and group keys suggested from sampled data.

Attach a schema summary per connection so the AI references real field names, types and cardinality, not guesses.

Deduplicated by hash. Basic keeps 50. Pro and Ultimate are unlimited.

Name, organise, share with a team. Basic keeps 25. Pro and Ultimate are unlimited.

Basic tops out at 20 stages per pipeline. Pro and Ultimate are unlimited.

Core import and export formats on every paid plan. Delimiter support for comma, tab, semicolon and pipe.

Native BSON round-trips for Mongo-to-Mongo workflows.

BSON.gz, .archive.gz and mongodump-style archives, plus nested compressed formats.

Map incoming columns to target fields before a single document lands. Type coercion per field.

Row counts, type inference and conflicts visible before anything runs. Modes: override, skip, create new, merge.

Export only the active query result-set, not the whole collection.

Dump an entire collection on every paid plan.

Pick the exact subset of fields to emit.

Stream straight from an open cursor without buffering the whole result in memory.

Basic: 100 MB / 5k docs in / 10k docs out. Pro: 1 GB / 100k / unlimited out. Ultimate: unlimited.

Create and drop databases. Every paid plan.

Create, drop and rename collections. Every paid plan.

Add, edit and delete individual documents with inline validation. Every paid plan; the Free plan is read-only.

Delete many documents in one operation.

Design MongoDB validation schemas for collections in a visual editor.

Clone a single collection into the same or another database.

Multi-select collections and copy or drop as one transaction.

Create, edit and drop indexes on any collection.

Partial, TTL, hidden, unique and compound indexes.

Auto-inferred schema from sampled documents. Shows type drift, optionality and cardinality per field.

The import planner suggests fields worth indexing for the data you are importing.

Long-running imports, exports, copies and drops run with live progress and cancellation.

Read preference, write concern, read concern, pool size, timeouts, retries and compression flags exposed in-app.

Topology-aware connections with configurable read and write concerns.

SRV record discovery on every paid plan.

Client certificates, custom certificate authorities and standard system trust store. Every paid plan.

Full-fidelity topology awareness across shards and mongos nodes.

No separate shell install. mongosh (pinned, SHA-256 verified) downloads from MongoDB's official host the first time you enable the shell.

Organise dozens or hundreds of clusters into named folders. Colour tags, drag to reorder.

No seat-level quota on any paid plan.

Commands execute inside the bundled py-backend using the compiled mongosh binary.

A persistent shell session that keeps variables and cursors across commands. Used by scripts and long investigations.

In the browser there is no local mongosh, so shell commands run on a managed mongosh function. The desktop app runs mongosh locally.

Auto-routes find, insert, update, delete and admin commands to the right execution path with post-processing detection.

Transparent next-page prefetching for large result-sets. No manual skip/limit tuning.

SELECT, INSERT, UPDATE, DELETE and multi-table joins. Output is idiomatic MongoDB aggregation stage ordering.

Python, Python (Motor), Node.js, Node.js (Mongoose), Java, C#, Go, Rust. Powered by @mongoqui/query-to-language.

Run arbitrary shell commands directly inside the app. No separate terminal, no context switch.

Refresh any report against live MongoDB. Charts, KPIs and shared links update atomically. Pro refreshes each report up to once an hour; Ultimate refreshes on demand.

Columnar snapshots in object storage, in-memory SQL engine on a 2 GB serverless function with a 60-second timeout.

Table, bar, line, pie, doughnut, KPI, text and image on a 12-column grid canvas. Chart.js under the hood with themed colours.

Schema-aware BI suggestions. Drafts the SQL query, picks the chart type, writes the narrative.

No install, no account required for viewers. Runs in any browser.

Grant access to internal users, external emails, signed links or a fully public page, all revocable.

Salted PBKDF2-SHA256 password hash, expiry timestamp, instant revoke. Only the hash and salt are stored.

Share-link edit actions (AI suggestions, data refresh) need edit permission plus a password unlock or signed-in session. Only the report owner can delete a report.

Share links can carry an expiry timestamp, and the report owner can turn a link off at any time.

Report queries cache to object storage for fast repeat loads, with manual invalidation on re-run.

AES-256-encrypted credentials (ENCRYPTION_KEY). Teammates use the connection without seeing the secret.

Plan seats, ownership, per-org settings and billing from a single place.

Pro: up to 10 seats. Ultimate: unlimited. Accept-invite flow handled via verify-invite route.

Built-in roles plus custom role creation. Per-connection scoping covers database, collection, read and write.

Backed by otplib 12.0.1 in the auth service. QR enrolment handled inside the desktop app.

Account and team events recorded with actor, organisation, category and timestamp: invites, role and seat changes, 2FA changes and shared-connection edits.

Saved queries and connection folders sync across teammates once shared.

Share-link edit actions such as AI suggestions and data refresh need edit permission plus a password unlock or signed-in session.

Create and edit MongoDB users and roles directly on your cluster. No mongosh round-trip. Ultimate only.

Find and aggregation queries from plain English, grounded in your collection schema.

Included with the plan. No API keys to set up and no separate AI bill.

10 requests per minute per user.

Pro: 100,000 AI tokens per user per month. Ultimate: 1,000,000. Both reset on the first of the month and are enforced server-side.

3,600-second cache on identical prompts to keep repeat costs down.

Ships the connection's schema summary so the AI references real fields, not hallucinated ones.

Generated queries and pipelines land in the editor for review. Nothing runs until you press Run.

Locks the desktop app behind an Argon2id-hashed master password. Saved connection credentials are encrypted at rest on your machine, never stored in plaintext.

Team-shared connection credentials are encrypted with AES-256-GCM at rest in the control plane. Teammates use the connection without ever seeing the raw secret.

Every cloud API call carries Authorization: Bearer plus x-organization-id. Verified at the edge.

Enrolment inside the app. Backed by otplib in the auth service.

Service-to-service calls use authenticated headers. No anonymous internal traffic.

Rate limits on sign-in and account routes, AI generation and report suggestions.

Explicit origin allow-list on every authenticated API. Only public blog images use a wildcard origin.

Account and team events (invites, role, seat and 2FA changes, shared-connection edits) recorded with actor, category and timestamp.

Salted PBKDF2-SHA256 hash, expiry timestamp, instant revoke. Per-share, not per-workspace.

Designed to comply. Data subject access, export and deletion requests via privacy@mongoqui.com. DPA on request. No third-party attestation.

Type II engagement underway. Contact for current status. Do not treat as certified yet.

Single entry point (api.mongoqui.com) that fans out to every backend service.

Users, organisations, seats, roles, devices, audit logs, user settings, shared connections, verify-invite.

Cloud-synced connections, folders, query history, saved queries and cached responses.

Provider-aware generate-query endpoint with per-provider model config and cache.

Transactional email templates for verification, invitation, password reset, payment, subscription, report share and public report.

File upload, presigned URLs, reports CRUD, cached responses and share management (user, email, link, public).

The same FastAPI sidecar packaged as a single-instance container with 5-minute sleep, for users who need the backend in the cloud.

AI-powered report suggestions with primary and fallback models, validator stage and cache.

Serverless analytics with in-memory SQL engine. 2 GB memory, 60-second timeout. Backs the Report Builder and shared-report viewer.

Per-seat yearly pricing. Reserve, assign and activate flow. A 30-day trial on any paid plan when the first purchase is a single seat.

Self-serve plan changes at license.mongoqui.com. In-app upgrade modal on any paywalled action.

downloads.mongoqui.com ships per-architecture macOS DMGs (Apple Silicon and Intel, both notarised), Windows x64 and Linux .deb/AppImage, with published SHA-256 checksums for every artifact.