Changelog

What's new in Comet.

Release notes and version history.

v1.19.0 October 2026 Latest

Connect with your AWS IAM role

  • -Sign in to MongoDB Atlas as yourself, using the AWS identity you already have — there is no database password to create, share, or store
  • -Pick any profile from your AWS config. Assume-role, AWS SSO / IAM Identity Center, and credential-process profiles all work
  • -Temporary credentials renew themselves in the background, so a long session never drops out from under you
  • -If your AWS sign-in lapses, Comet tells you which profile to refresh instead of failing with a cryptic connection error
  • -Choose AWS IAM Role under Authentication when adding a connection. Requires an Atlas M10+ cluster with a database user for your IAM identity
v1.18.0 July 2026

Backup & Restore Pro

  • -Back up your whole setup in one action — connections with their passwords and SSH keys, workspaces, saved queries, settings, and your sidebar and tab layout
  • -Restore on a second machine and everything works immediately, with no credentials to re-enter
  • -End-to-end encrypted with a passphrase only you know — your backup is sealed on your Mac before it goes anywhere, so nobody at Comet can read it
  • -Back up to Comet Cloud, or to iCloud Drive, Dropbox, or any folder you choose
  • -Restore shows you exactly what will change first — merge into your current setup, or replace it wholesale
  • -A snapshot of your previous configuration is saved automatically before every restore, so it can always be undone
  • -Find it under Settings → Backup & Restore
v1.17.0 June 2026

Copy Database Pro

  • -Copy an entire database from one connection to another — pick any source and target connection
  • -Two modes: Full replacement mirrors the target exactly, or Replace matching only overwrites shared collections and leaves the rest untouched
  • -Copies documents and recreates secondary indexes, with a review step that shows exactly what will change before you commit
  • -Live per-collection progress, and a single bad index is reported as a warning instead of failing the whole copy
  • -Start it from the database right-click menu or the command palette

Organize Connection Groups

  • -Reorder your connection groups up and down in Manage Connections
  • -Give each group its own color to tell them apart at a glance — in both the connection manager and the sidebar
v1.16.0 June 2026

Organize Connections

  • -Manage Connections now shows your groups as sections with headers and counts
  • -Drag and drop connections to reorder them or move them between groups
  • -Assign a group right from the list with an inline picker — choose an existing group or create a new one on the spot
  • -New Alphabetize action sorts connections A→Z within each group
  • -Tidier, more compact connection rows

Bug Fixes

  • -Fixed the Group field sitting misaligned above the other fields in the connection editor
v1.15.0 May 2026

Connection Groups

  • -Organize connections into named groups like dev, staging, prod — each group shows as a collapsible header inline in the sidebar with a count
  • -Right-click any connection → Set Group: pick from existing groups, create a new one, or move back to Ungrouped
  • -Group field added to the connection edit modal with autocomplete from existing groups
  • -The group containing your active connection auto-expands; collapsed state is remembered per workspace
v1.14.3 May 2026

Bug Fixes

  • -Projection argument in find() and findOne() is now honored — db.coll.find({}, {name: 1, _id: 0}) returns only the requested fields instead of silently dropping the projection
  • -Projection flows through pagination, refresh, and tab navigation; also included when explaining a projected find
v1.14.2 May 2026

Bug Fixes

  • -.explain() now works on any explainable operation — count, distinct, deleteOne/Many, updateOne/Many, findOneAndUpdate/Delete/Replace, and replaceOne — not just find and aggregate
  • -Honors the verbosity argument: .explain("queryPlanner"), .explain("executionStats"), .explain("allPlansExecution")
  • -Query input is no longer overwritten with a default find after running write operations (delete, update, insert) — your typed query stays put
v1.14 April 2026

AI Pipeline Builder

AI
  • -Describe what you want in plain English — AI generates a complete multi-stage aggregation pipeline
  • -Each generated stage is individually editable, previewable, and reorderable
  • -Schema-aware — AI samples your collection fields before generating
  • -Works alongside the per-stage AI generator and all existing pipeline intelligence features
v1.13 April 2026

Real-Time Change Streams

Unique
  • -Right-click any collection → "Watch Changes" to open a live stream tab
  • -See inserts, updates, deletes, and replaces as they happen in real time
  • -Push-based architecture — events streamed from backend via Tauri, not polling
  • -Color-coded operation badges: INS UPD DEL REP
  • -Expand any event to see the full document or updated fields
  • -Filter by operation type, pause/resume, clear events
  • -Graceful cleanup — stream stops automatically when tab closes
v1.12 April 2026

Staged Changes

  • -"Staged" toggle in collection toolbar — queue edits locally instead of saving immediately
  • -Review all pending changes in a collapsible panel with old → new values
  • -Apply All to commit changes in batch, or Discard All to revert
  • -Supports field edits, full document edits, deletes, and duplicates
  • -Visual indicators: amber border for modified rows, amber cell highlights in table view, faded strikethrough for staged deletes
  • -Partial failure handling — failed changes remain in queue for retry

Bug Fixes

  • -Vault-stored connection URLs now display correctly when editing (was showing empty placeholder)
  • -Edit modal defaults to Connection URL tab for vault connections instead of Manual
  • -Fixed Rust ↔ JavaScript serialization mismatch for connection secrets
v1.11 April 2026

Document Diff

  • -Side-by-side document comparison powered by Monaco DiffEditor with automatic line-level highlighting
  • -Select two documents → Compare button in selection bar
  • -Right-click → "Compare with…" pins a document, then click another to diff
  • -Diff summary showing added/removed line counts

Unsaved Work Warnings

  • -Confirmation dialog before closing shell or pipeline tabs with unexecuted changes
  • -Warning dot indicator on dirty tab headers
  • -Intercepts all close paths: ⌘W, middle-click, X button, context menu, and app quit
  • -Toggle in Settings → General (on by default)
v1.10 March–April 2026

Table View

  • -Tree/Table toggle in the collection toolbar with per-tab persistence
  • -Spreadsheet grid with auto-extracted columns, sticky header, and pinned _id column
  • -Client-side column sorting and draggable column resizing
  • -Compact nested object previews (name: "John", age: 30) instead of generic field counts
  • -Click nested cells to expand full tree view in a popover
  • -Inline editing, context menus, keyboard navigation, and multi-select
  • -Default view mode preference in Settings → General

Connection Reliability

  • -Reconnect and Disconnect options now available for error-state connections
  • -Double-click error connections to reconnect (was silently ignored)
  • -30-second connection timeout prevents stuck "connecting" spinner
  • -Stale database lists cleared when connection errors out
  • -Guard against concurrent connection attempts from rapid clicks
  • -Auto-append $limit to aggregation pipelines without one
v1.9.0 March 2026

Smart Pipeline Builder

  • -Per-stage intermediate results — inline preview of sample documents below each stage, auto-preview toggle with debounced execution
  • -Document flow funnel — color-coded bars between stages showing document count flow (green passthrough, amber reduction, red heavy filter, blue expansion)
  • -Schema-forward autocomplete — field names in stage N+1 are inferred from stage N's output, not just the original collection schema
  • -AI stage generator — describe what a stage should do in plain English and AI generates the stage body with full schema context
  • -"Refresh Counts" button to populate document counts across all pipeline stages in parallel

Saved Queries

  • -Bookmark any query from history, shell, or collection view with a name and optional description
  • -"Saved" tab in Query History modal with edit, delete, insert, and copy actions
  • -Per-collection saved queries dropdown in the query bar for quick access
  • -Searchable in Command Palette (⌘K)
  • -⇧⌘S keyboard shortcut to save from shell or collection view
  • -Cross-device sync for Pro users
v1.8.0 March 2026

Light Theme

  • -System / Light / Dark theme toggle in Settings → General
  • -Respects OS color scheme preference when set to "System"
  • -Full light theme across all panels, modals, dropdowns, context menus, and Monaco editors
  • -Theme-aware BSON syntax highlighting — colors automatically adjust for readability
  • -Theme persists across app restarts with no flash on launch

Semantic Color Architecture

  • -Migrated entire UI from hardcoded colors to CSS custom property tokens
  • -Consolidated Monaco editor theme — removed duplicate definition, shared across all 5 editor instances
  • -Dedicated comet-light and comet-dark Monaco themes with brand-consistent syntax colors
v1.7.1 March 2026

Credential Visibility

  • -Connection URLs with vault-stored credentials now display the full string with obfuscated password instead of "(stored in keychain)"
  • -Reveal/hide toggle for connection URL and password fields in the connection editor
  • -On-demand vault decryption — credentials are only fetched when explicitly revealed
v1.7.0 March 2026

Cross-Device Sync

Pro
  • -Opt-in sync for connections, query history, AI conversations, and app preferences across devices
  • -Manual "Sync Now" button with optional auto-sync intervals (5/15/30/60 minutes)
  • -Credentials (passwords, SSH keys, connection URLs) never leave your device
  • -Last-write-wins conflict resolution — newer changes always take priority
  • -New Sync section in Settings with status indicator and error reporting

Slow Query Profiler Improvements

  • -Slow Query section now always visible in the Monitoring panel with a database selector dropdown
  • -Previously hidden when no database was pre-selected — now fully self-contained
v1.6.1 March 2026

Connection Modal Improvements

  • -Auto-suggest connection name from URL — hostname is extracted as you type or paste a connection string
  • -Disabled autocorrect, autocapitalize, and spellcheck on all form fields — no more unwanted substitution suggestions
v1.6.0 March 2026 Latest

Slow Query Analyzer

  • -New Slow Queries section in the Monitoring panel — queries system.profile for profiled operations
  • -Adjustable threshold slider (default 100ms) with color-coded rows: red >1s, orange >500ms, yellow >100ms
  • -Click any row to expand the full profiler document in tree view
  • -Shows timestamp, duration, operation type, namespace, and plan summary

Atomic findOneAnd* Operations

  • -findOneAndUpdate() — atomically find and update, returns the original document
  • -findOneAndDelete() — atomically find and delete, returns the deleted document
  • -findOneAndReplace() — atomically find and replace, returns the original document
  • -replaceOne() — replace a single document matching a filter
  • -Full autocomplete support, org policy enforcement, and query history tracking

Query Comparison Tool

  • -Compare button in the Explain panel — enter a second query and see side-by-side explain plans
  • -Comparison summary bar with deltas: time, docs examined, and plan type changes
  • -Green/red color coding for improvements vs regressions

AI Explain Optimization

Pro
  • -New "AI Optimize" button in the Explain panel — sends your explain plan to AI for analysis
  • -Get 1-3 specific, actionable optimization suggestions (index creation, query rewrites)
  • -Gated to Pro plan — uses your AI credits
v1.4.1 March 2026

AI Query Refinement

  • -⌘I now refines your existing query instead of replacing it — AI sees your current query and modifies it based on your instructions
  • -Prompt bar adapts: shows "Describe how to modify..." when editor has content
  • -Release notes now shown in the update dialog with a link to the full changelog

8 New Pipeline Stages

  • -$setWindowFields — running totals, moving averages, rank functions
  • -$geoNear — geospatial proximity queries
  • -$unionWith — combine results from multiple collections
  • -$densify, $fill — time-series gap filling
  • -$bucketAuto, $replaceWith, $documents
v1.4.0 March 2026

Editor & Tab Improvements

  • -Editor state and hotkeys now persist across tab switches — no more lost work
  • -Bracket pair colorization enabled in all editors
  • -⌘I now correctly triggers AI prompt instead of Monaco's suggest menu
  • -Double-clicking a collection always opens a fresh tab

Database Management

  • -Rename collections from the sidebar context menu
  • -Drop databases with confirmation dialog
  • -Index sizes displayed in the Indexes panel via $collStats
  • -Duplicate documents from the right-click context menu

Shell & BSON

  • -New shell methods: getIndexes(), stats(), drop(), estimatedDocumentCount()
  • -UUID/BinData fields now display as UUID("...") instead of BinData(...)
  • -New BSON types: DBRef, MinKey, MaxKey, Code, Symbol
  • -Copy field path and value from document tree view context menu
v1.3.0 March 2026

Real-Time Monitoring Dashboard

  • - Live server stats — version, uptime, memory usage, active connections
  • - Operation counters with per-second rate calculation between refreshes
  • - Current operations list with duration highlighting and kill capability
  • - Replica set status with member state badges and replication lag
  • - Configurable auto-refresh interval (5s / 10s / 30s / manual)

UX Improvements

  • - Default Database field — scope connections to a single database without URL hacking
  • - Shell result export — save query results to JSON file via native save dialog
  • - Workspace colors — assign colors to workspaces for quick visual identification
  • - Drop collection from sidebar context menu with confirmation dialog
v1.2.0 March 2026

Workspaces

Pro
  • - Organize connections into named workspace groups (Personal, Work, Dev, Prod)
  • - Workspace switcher in sidebar filters connections — only see what's relevant
  • - "Show in all workspaces" flag for shared connections like auth databases
  • - Quick workspace assignment via dropdown in connection manager

SSH Tunnels & Multi-Window

  • - Connect to MongoDB through SSH tunnels — password or private key authentication
  • - Open multiple windows (free, ungated) — each window has its own tabs and state
  • - Sidebar context menu — right-click connections to connect, edit, or disconnect

Polish

  • - Redesigned connection modal — compact layout with tidied tab hierarchy
  • - Renamed from Comet to CometDB
  • - Auto-reconnect when recalling queries from history
v1.1.0 March 2026

AI Credit System

  • - Quality tiers — Fast, Standard, Advanced, Premium — with transparent credit costs
  • - Dual-provider backend — Gemini free tier with Anthropic fallback for reliability
  • - Credit top-up packs via Stripe one-time payments
v1.0.2 March 2026

Data Masking

  • - Configure field patterns to mask sensitive data — values display as "••••••" in tree views and row summaries
  • - Exact match (field name or dotted path) and glob patterns with * and ? wildcards
  • - Masked fields are protected from inline editing — double-click is disabled
  • - New Data Masking section in Settings to enable/disable and manage field patterns

Custom AI Provider

  • - Connect any OpenAI-compatible API endpoint — Ollama, LM Studio, vLLM, and more
  • - Configurable endpoint URL, optional API key, and model name
  • - Full tool-use loop support for both query generation and AI conversation mode

Stability & Reliability

  • - Atomic file writes — all persisted data (state, connections, history, credentials) uses crash-safe write-to-temp-then-rename
  • - Corrupted state recovery — graceful fallback to defaults if JSON is malformed, instead of crashing
  • - Graceful shutdown — workspace state is flushed to disk before window close
  • - Connection health monitoring — automatic detection of lost connections with toast warnings and error state after 3 consecutive failures
  • - Query history limits enforced by subscription tier (anonymous/free: 50, pro/team: unlimited)

Performance

  • - Faster connection flow — databases and collections now load in parallel, with an early "connected" state shown immediately
  • - Reduced connection timeouts from 5s to 3s for snappier feedback on unreachable servers
  • - API fetch timeout (15s) prevents the app from hanging on unresponsive network calls

Safety & Limits

  • - Aggregation result cap — pipelines exceeding 10,000 documents are stopped with a clear error suggesting $limit
  • - Server-side query timeout (30s) for find and aggregate operations — prevents long-running queries from blocking indefinitely
v0.12.0 March 2026

Connection Colors

  • - Assign a color to any connection — 8 preset colors to visually distinguish dev, staging, and production environments
  • - Colored tab indicator — active tab bottom border reflects the connection color
  • - Tinted comet icon — the connection logo in the sidebar, switcher, and manager adopts the assigned color with full gradient shading
  • - Color persists across sessions and syncs with existing connection settings

Index Usage Stats

  • - Indexes panel now shows per-index operation counts from MongoDB's $indexStats
  • - Index Advisor uses server-side stats for more accurate used/unused classification — works even without query history

Bug Fixes

  • - Fixed editing connections with keychain-stored URLs failing with "connection string contains no scheme"
v0.11.0 March 2026

Index Advisor

  • - Dedicated Index Advisor tab — batch-analyzes your query history to suggest missing indexes
  • - ESR rule-based recommendations: equality fields first, then sort, then range for optimal compound indexes
  • - Inline suggestions in the Explain panel — see index recommendations right where you spot a COLLSCAN
  • - One-click index creation from any recommendation
  • - Existing index usage audit — see which indexes are used and which are unused across your query patterns
  • - Impact ratings (high/medium/low) and reason labels (Collection Scan, Inefficient Scan, In-Memory Sort)
v0.10.0 February 2026

Schema Overview

  • - Schema tab per collection — samples documents and displays field names, types, and frequency
  • - Type distribution badges showing how often each type appears per field
  • - Nested field expansion — explore subdocument and array structures
  • - Adjustable sample size (100, 500, 1000, 5000 documents)

Keyboard Navigation

  • - Focus zones: ⌘1 sidebar, ⌘2 content, ⌘3 shell
  • - Arrow keys to navigate sidebar tree, Enter to open, Tab to cycle tabs
  • - ⌘W close tab, Ctrl+Tab / Ctrl+Shift+Tab cycle tabs
v0.9.0 February 2026

Command Palette

  • - ⌘K to open — fuzzy search across collections, tabs, and actions
  • - Quick-open any collection, shell, pipeline, schema, or index tab
  • - Action commands: new shell, manage connections, open settings, and more

Collection Stats Bar

  • - Live stats in the collection tab header: document count, index count, average document size, total storage size
  • - Refreshes automatically when switching collections
v0.8.0 February 2026

SSO / Single Sign-On

Team
  • - OIDC-based single sign-on for Team plan — Google Workspace, Okta, Azure AD
  • - Admin-configured SSO with automatic team member provisioning
  • - Enforce SSO-only login for your organization
v0.7.0 February 2026

Team Plan

Team
  • - Organizations — create a team, invite members via email, manage roles
  • - Shared connections — team connection library synced across all members
  • - Shared saved queries — collaborate on frequently used queries
  • - Organization permission policies — read-only mode, restrict destructive operations, shell access, import/export
  • - Centralized billing with minimum 3-seat requirement
v0.6.1 February 2026

Workspace Manager

  • - New workspace manager modal — view, rename, open, and delete workspaces from Connections > Manage Workspaces
  • - Each workspace runs in its own window with independent tabs, connections, and layout state
  • - Live status badges — see which workspaces are active, open, or closed at a glance
  • - Inline rename with live window title updates
  • - Smart window detection — opening an already-open workspace focuses it instead of creating a duplicate
v0.6.0 February 2026

Visual Pipeline Builder

  • - Drag-and-drop aggregation pipeline composer — build complex pipelines without writing raw syntax
  • - Searchable stage catalog with 22 stages across 6 categories: filter, transform, group, sort, join, output
  • - Stage-by-stage preview — click any stage to see results up to that point with document counts
  • - Inline Monaco editors per stage with autocomplete for collection names and aggregation operators
  • - Toggle stages on/off without deleting, reorder by drag-and-drop
  • - Export to shell or clipboard — build visually, refine in shell
  • - Opens as a tab — right-click any collection and select "Open Pipeline"
  • - Keyboard shortcut ⌘Enter to run full pipeline or preview up to current stage
v0.5.0 February 2026

Query Explain Visualizer

  • - Interactive execution plan tree for find and aggregate queries
  • - Color-coded stages: green (IXSCAN), red (COLLSCAN), yellow (SORT), blue (FETCH)
  • - Summary bar with execution time, docs/keys examined, efficiency percentage
  • - Index usage detection — shows index name or "Collection Scan" warning
  • - Rejected plans viewer for comparing alternative query plans
  • - Raw JSON toggle with Monaco editor
  • - Keyboard shortcut ⇧⌘E and Explain button in query bar and shell panel
  • - Auto-detection of .explain() in query text
v0.3.0 February 2026

AI Conversation Mode

  • - Full chat panel for conversing with your database in natural language (⌘I)
  • - 9 specialized database tools: schema inspection, query execution, index analysis, collection stats, document sampling, field enumeration, database listing, and more
  • - AI autonomously inspects your data before answering — no manual context needed
  • - Copy or run generated queries directly from the conversation
  • - Demo mode for trying AI features without an API key

Query History

  • - Searchable log of all executed queries
  • - Filter by query type (find, aggregate, update, etc.) and AI-generated flag
  • - Time-grouped entries (Today, Yesterday, This Week, Older)
  • - Click to re-run any previous query

Multi-Provider AI Support

  • - Anthropic (Claude) and OpenAI-compatible API providers
  • - Codex CLI and Gemini CLI as local AI providers
  • - Claude CLI support for Anthropic users with Max subscriptions
v0.2.5 January 2026
  • - AI-powered query generation from natural language descriptions
  • - Multi-select documents with ⌘+Click and bulk actions (copy, delete)
  • - Field name autocomplete sampled from actual collection data
  • - In-app updates with one-click install — no re-download needed
  • - Index management — view and manage collection indexes
v0.2.0 December 2025

Initial Release

  • - Native macOS app built with Tauri and Rust
  • - Shell syntax query bar — find, aggregate, update, delete with chaining
  • - BSON-native display — ObjectId, ISODate, regex in shell syntax
  • - Monaco editor for document editing with full round-trip BSON support
  • - Multi-connection support with tabbed interface
  • - State persistence — tabs, layout, connections saved to disk