Everything you need to master MongoDB
From visual query building to AI-powered assistance MongoPilot gives you the tools that MongoDB Compass doesn’t.
Visual Aggregation Pipeline Builder
Build complex aggregation pipelines visually with drag-and-drop stages. See results at each step, detach the results window, and export pipeline code. No more guessing JSON syntax.
AI Query Assistant
Describe what you need in plain English and get a MongoDB query instantly. Supports OpenAI, Google Gemini, and local Ollama models your data never has to leave your machine.
Index Management & Usage Statistics
View all indexes, create new ones, and see exactly which indexes are used and which are wasting resources. One-click access to $indexStats data without writing a single pipeline.
Index Performance Experiments
Test index impact on a cloned collection before touching production. Run before/after comparisons, measure execution time, and apply winning indexes with confidence.
Query Explain Plan Visualizer
Understand how MongoDB executes your queries with a visual explain plan tree. Spot collection scans, missing indexes, and slow stages at a glance.
Visual Query Builder
Build MongoDB filters by dragging column headers or picking fields from a menu. Supports equals, contains, regex, greater than, and more — zero syntax required.
Data Explorer
Browse documents in a resizable table view or a collapsible JSON tree view. Sort by any column, paginate large collections, and switch views with one click.
Document Operations
View, edit, copy, and delete documents with right-click context menus. Bulk-select rows to delete or export multiple documents at once.
Export & Import
Export entire collections or filtered results to JSON or CSV with streaming — even million-document collections won’t crash. Import JSON files or use mongoimport for large datasets.
Query History
Every query you run is saved automatically. Search past queries, mark favorites, and re-run them instantly — across visual filters and aggregation pipelines.
Multi-Collection Tabs
Open multiple collections side by side in tabs. Middle-click to close, right-click for options — work the way you work in your code editor.
Connection Manager
Connect to localhost, Atlas, replica sets, and sharded clusters. Supports URI strings and an advanced mode with authentication (SCRAM, X.509, Kerberos, LDAP, AWS IAM) and TLS/SSL.
Database & Collection Management
Create databases and collections from the sidebar tree. Organize connections in folders, search by name, and navigate large clusters without friction.
Cross-Platform Desktop App
Native app for macOS, Windows, and Linux. Auto-updates keep you current. Your connection credentials stay local — nothing is stored in the cloud.
