MongoDB Compass
Parent: MongoDB Expert Knowledge · Published reference · snapshot 2026-09-08 · skill mongodb-expert/references/mongodb-compass.md
↓ Facts as markdownall context files
MongoDB Compass is the official, free, source-available GUI for MongoDB. It provides visual tools for querying, aggregating, analyzing, and managing MongoDB data without requiring command-line experti
These notes link each claim to its source. Some citations identify archived research reports that are no longer hosted on this site. A published reference means the content is available; it does not certify independent review or accuracy.Read the editorial policy and follow the sources before relying on a claim.
MongoDB Compass — Expert Reference
- MongoDB Compass is the official, free, source-available GUI for MongoDB. It provides visual tools for querying, aggregating, analyzing, and managing MongoDB data without requiring command-line expertise, while still exposing an embedded mongosh shell for power users. Current stable release: 1.49.8 (May 27, 2026). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#mongodb-compass-expert-reference]
When to Use This Skill
- User asks how to use, configure, or troubleshoot MongoDB Compass [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#when-to-use-this-skill]
- Questions about schema analysis, explain plans, aggregation pipeline building, or index management in a GUI context [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#when-to-use-this-skill]
- Advising on Compass editions for restricted or air-gapped environments [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#when-to-use-this-skill]
- Evaluating query performance visually via explain plan trees [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#when-to-use-this-skill]
- Using NLQ / AI-powered query generation in Compass [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#when-to-use-this-skill]
- Compass plugin development or extensibility questions [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#when-to-use-this-skill]
- Production safety guidance: what not to do with Compass against live clusters [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#when-to-use-this-skill]
- Data modeling ER diagrams in Compass [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#when-to-use-this-skill]
- Importing or exporting data via the Compass GUI [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#when-to-use-this-skill]
When NOT to Use This Skill
- Questions about the MongoDB driver API or programmatic query construction → use [[mongodb-expert]] or [[mongodb-developer]] [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#when-not-to-use-this-skill]
- Deep query optimization requiring profiler analysis or system.profile → use [[mongodb-query-performance]] [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#when-not-to-use-this-skill]
- Atlas-specific cluster configuration, networking, or billing → use [[mongodb-atlas-expert]] [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#when-not-to-use-this-skill]
- mongodump / mongorestore / mongoimport / mongoexport CLI tools (not Compass GUI) → use [[mongodb-backup-restore]] [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#when-not-to-use-this-skill]
- MongoDB shell (mongosh) scripting beyond what the embedded shell covers → use [[mongodb-expert]] [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#when-not-to-use-this-skill]
1.1 Editions
- Compass ships in two active editions (Readonly Edition is being deprecated): [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#11-editions]
- Compass (Full): The standard edition with all features including AI-powered NLQ, automatic updates, and telemetry. Free and source-available. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#11-editions]
- Compass Isolated Edition: Designed for air-gapped or high-security environments. All network connections except the MongoDB server are blocked - no telemetry, no AI features, no auto-update checks, no additional firewall configuration required. Use when data residency or network egress policies prohibit external calls. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#11-editions]
- Compass Readonly Edition (DEPRECATED): Historically limited to read operations. Will be removed in a future release. To achieve read-only behavior in the current edition: [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#11-editions]
- Assign users the built-in read role at the database level in MongoDB. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#11-editions]
- Enable the readOnly option in Compass Settings. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#11-editions]
- > Warning: The readOnly Compass setting only hides write-operation UI elements; it does not enforce restrictions at the driver level for shell commands typed in the embedded mongosh. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#11-editions]
1.2 Connection String Builder
- Compass provides a visual connection form that builds connection strings without manual URI syntax knowledge: [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#12-connection-string-builder]
- General tab: hostname, port, authentication (username/password, X.509, LDAP, Kerberos, AWS IAM, OIDC) [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#12-connection-string-builder]
- TLS/SSL tab: CA certificate, client certificate/key, allow invalid hostnames [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#12-connection-string-builder]
- Proxy/SSH tab: SOCKS5 proxy, SSH tunnel configuration [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#12-connection-string-builder]
- Advanced tab: replica set name, read preference, authentication database, server selection timeout, directConnection flag [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#12-connection-string-builder]
- The built connection string is displayed and editable directly for power users who prefer URI syntax. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#12-connection-string-builder]
1.3 Connection Favorites and Color Coding
- Save any connection as a favorite for quick access: [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#13-connection-favorites-and-color-coding]
- Favorites always appear at the top of the connections sidebar. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#13-connection-favorites-and-color-coding]
- Each favorite can be assigned a color label. When connected, that color becomes the background of all tabs belonging to that connection - making it immediately clear which environment (dev/staging/prod) you are on. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#13-connection-favorites-and-color-coding]
- Favorites can be edited (name, color, credentials) from the connections sidebar context menu (⋯ icon). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#13-connection-favorites-and-color-coding]
- Favorites are stored with credentials in the OS keychain (macOS Keychain / Windows Credential Manager / GNOME Keyring on Linux). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#13-connection-favorites-and-color-coding]
- Import/export favorites via JSON for team sharing or backup. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#13-connection-favorites-and-color-coding]
- As of v1.44.5, you can edit name, color, and favorite status while actively connected. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#13-connection-favorites-and-color-coding]
1.4 Multiple Simultaneous Connections
- Since Compass 1.36+, you can connect to multiple MongoDB deployments simultaneously in separate tabs, each color-coded by their favorite label. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#14-multiple-simultaneous-connections]
1.5 Key URI Parameters (Advanced Tab)
- The Advanced tab of the connection form exposes these commonly needed URI parameters: [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#15-key-uri-parameters-advanced-tab]
2.1 Overview
- The Schema tab infers the shape of a collection by sampling documents and presenting interactive visualizations of field types, value distributions, and cardinality - without writing any code. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#21-overview]
2.2 Sampling Mechanics
- Default sample size: 1,000 documents drawn using MongoDB's $sample aggregation operator. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#22-sampling-mechanics]
- Sampling works over the entire collection or a filtered subset when a query is entered in the query bar. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#22-sampling-mechanics]
- A random, non-replacement sample is used; results approximate full-dataset analysis for most distributions. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#22-sampling-mechanics]
- To increase the sample size beyond 1,000, go to Compass Settings → General and change the "Sample Size" field (default 1000). The query bar's Options → MAX TIME MS controls the query execution timeout (default 60,000 ms) - a separate setting that does not affect sample size. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#22-sampling-mechanics]
- Compass shows a warning when the collection has > 1,000 documents, indicating results reflect only the sampled subset. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#22-sampling-mechanics]
2.3 Field Type Distribution
- For each field, Compass shows: [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#23-field-type-distribution]
- Single data type: type name with min/max/mean statistics. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#23-field-type-distribution]
- Multiple data types: percentage breakdown pie/bar (e.g., 20% int32, 80% string) - useful for spotting type inconsistencies in schemaless collections. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#23-field-type-distribution]
- Missing/undefined: percentage of documents that do not contain the field at all - critical for identifying optional vs. required fields. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#23-field-type-distribution]
- Nested documents and arrays: expandable to show nested field analysis, plus min/max/average array lengths. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#23-field-type-distribution]
2.5 Interactive Query Building from Schema
- Clicking on chart values generates query filter predicates automatically: [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#25-interactive-query-building-from-schema]
- Click a bar in a string histogram → adds {"field": "value"} to the query bar. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#25-interactive-query-building-from-schema]
- Click+drag over a numeric histogram range → adds {"field": {$gte: X, $lte: Y}}. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#25-interactive-query-building-from-schema]
- Draw a circle on a geo map → adds a $geoWithin / $geometry polygon filter. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#25-interactive-query-building-from-schema]
- Shift+click for multi-select; multiple fields combine with $and. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#25-interactive-query-building-from-schema]
2.6 Use Cases
- Data quality assessment: spot missing fields, unexpected type mixing, outlier values. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#26-use-cases]
- Cardinality analysis: determine selectivity before creating indexes. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#26-use-cases]
- Range identification: find min/max for numeric bounds and TTL candidates. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#26-use-cases]
- Index candidate identification: high-cardinality fields with frequent query patterns. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#26-use-cases]
- Data modeling validation: verify that actual data conforms to intended schema. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#26-use-cases]
- Geographic data exploration: visualize point distributions for location-based collections. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#26-use-cases]
2.7 Schema Export
- Use the Schema Export feature (linked from the Schema tab) to export the inferred schema as JSON for documentation, sharing with teams, or importing into other tools. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#27-schema-export]
3.1 Overview
- The Aggregations tab provides a visual, stage-by-stage builder for MongoDB aggregation pipelines. Each stage displays a live preview of its output from sampled data, making it easy to iterate on complex transformations. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#31-overview]
3.2 Pipeline Creation Modes
- Stage View Mode (default): Visual pipeline editor. Each stage appears as a card with: [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#32-pipeline-creation-modes]
- Stage configuration editor with syntax highlighting and autocomplete [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#32-pipeline-creation-modes]
- Output preview panel showing up to 10 sampled documents from the stage's output [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#32-pipeline-creation-modes]
- Stage Wizard (within Stage View): Click the wand icon to get templates for common stages: $group, $lookup, $match, $project, $sort. The wizard generates boilerplate code to fill in. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#32-pipeline-creation-modes]
- Focus Mode (within Stage View): Edit one stage at a time with a full-height view showing Stage Input, editor, and Stage Output side by side. Ideal for complex or deeply nested stages. Keyboard shortcuts: Cmd+Shift+A (add stage after), Cmd+Shift+B (add stage before), Cmd+Shift+9/0 (navigate between stages). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#32-pipeline-creation-modes]
- Text View Mode: Raw text editor accepting full pipeline JSON/EJSON syntax with real-time linting. Toggle the </> switch to enter this mode. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#32-pipeline-creation-modes]
3.3 Stage Management
- Add stage: Click + Add Stage at the bottom, or + above any existing stage card. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#33-stage-management]
- Toggle stage on/off: Use the toggle switch on the stage card header to include/exclude a stage without deleting it - useful for A/B testing pipeline behavior. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#33-stage-management]
- Reorder stages: Drag the stage card header to a new position. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#33-stage-management]
- Delete stage: Click the trash icon on the stage card. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#33-stage-management]
- Resize stage editor: Drag the stage card border to adjust width. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#33-stage-management]
3.4 Stage Preview
- Each stage previews up to 10 randomly sampled documents from the stage output. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#34-stage-preview]
- Expand all fields with "Output Options" → "Expand all fields". [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#34-stage-preview]
- $merge and $out stages display a warning before execution since they modify collection data. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#34-stage-preview]
3.5 Atlas Search Stages
- When connected to a MongoDB Atlas cluster, additional stages become available in the stage dropdown: [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#35-atlas-search-stages]
- $search - Full-text Atlas Search [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#35-atlas-search-stages]
- $searchMeta - Search metadata aggregation [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#35-atlas-search-stages]
3.6 Export Pipeline to Language
- Click the Export to Language button to generate application-ready code in: [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#36-export-pipeline-to-language]
- JavaScript (Node.js), Python, Java, C# (.NET), Ruby, Go, Rust, PHP [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#36-export-pipeline-to-language]
- The generated code includes the driver boilerplate (collection reference, pipeline array, cursor iteration) so it can be dropped directly into an application. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#36-export-pipeline-to-language]
3.7 Saved Pipelines
- Save a pipeline: Click the Save button to name and save the pipeline for later use. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#37-saved-pipelines]
- Open saved pipelines: Load previously saved pipelines from the pipeline list. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#37-saved-pipelines]
- Saved pipelines are stored locally in Compass. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#37-saved-pipelines]
- Tip: save in-progress pipelines before closing Compass; unsaved pipelines are lost on exit. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#37-saved-pipelines]
3.8 Running and Exporting Results
- Click Run (top-right) to execute the pipeline against the collection. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#38-running-and-exporting-results]
- Use Export Aggregation Results to save results as JSON or CSV. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#38-running-and-exporting-results]
4.1 Overview
- The Explain Plan (accessible from both the Documents query bar and the Aggregation Pipeline Builder) visualizes how MongoDB executes a query or pipeline, helping identify performance bottlenecks. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#41-overview]
4.2 View Formats
- Visual Tree View (default): Each execution stage appears as a clickable node in a hierarchical tree. Click any node to see detailed execution statistics for that stage. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#42-view-formats]
- Raw Output View: The full explain document shown as formatted JSON - equivalent to running db.collection.explain("executionStats") in the shell. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#42-view-formats]
- > Note: Visual Tree view is not available for vector search queries; use Raw Output view instead. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#42-view-formats]
4.3 Summary Metrics
- Execution time (ms), Returned documents (nReturned), Examined documents (totalDocsExamined), Examined index keys (totalKeysExamined) [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#43-summary-metrics]
4.5 Sharded Cluster Plans
- For sharded collections: SHARD_MERGE node at top, per-shard sub-plans, winning plan per shard. Use Raw Output for the full shards array with per-shard executionStats. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#45-sharded-cluster-plans]
4.6 How Compass Explain Differs from Shell Explain
- Compass runs executionStats verbosity by default (executes the query). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#46-how-compass-explain-differs-from-shell-explain]
- Compass omits $merge and $out from pipeline explains. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#46-how-compass-explain-differs-from-shell-explain]
- Compass adds a maxTimeMS cap (configurable since v1.49.6). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#46-how-compass-explain-differs-from-shell-explain]
- The shell supports allPlansExecution verbosity; only available via Raw Output in Compass. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#46-how-compass-explain-differs-from-shell-explain]
4.7 Workflow: Explain-Driven Index Creation
- Run explain on a slow query. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#47-workflow-explain-driven-index-creation]
- Identify COLLSCAN (red) in the tree. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#47-workflow-explain-driven-index-creation]
- Note filter and sort fields. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#47-workflow-explain-driven-index-creation]
- Switch to Indexes tab (Section 5). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#47-workflow-explain-driven-index-creation]
- Create compound index: filter fields first, sort fields after. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#47-workflow-explain-driven-index-creation]
- Re-run explain → verify IXSCAN replaces COLLSCAN. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#47-workflow-explain-driven-index-creation]
- Check nReturned ≈ totalKeysExamined. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#47-workflow-explain-driven-index-creation]
5.1 Indexes Tab Overview
- > Usage statistics reflect only the connected node. For cluster-wide stats: db.collection.aggregate([{$indexStats: {}}]). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#51-indexes-tab-overview]
5.2 Creating Indexes
- Index types per field: Ascending (1), Descending (-1), 2dsphere, Text. Add fields with + for compound indexes. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#52-creating-indexes]
5.3 Hiding and Unhiding Indexes
- Hover → closed-eye icon → confirm. Hidden indexes exist and maintain writes but are invisible to the query planner - safe way to test impact before dropping. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#53-hiding-and-unhiding-indexes]
- > TTL indexes that are hidden continue to expire documents. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#53-hiding-and-unhiding-indexes]
5.4 Dropping Indexes
- Click trash icon → enter exact index name → Drop. The _id index cannot be dropped. Never drop indexes on live production without first hiding them (see Section 12, Anti-Patterns). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#54-dropping-indexes]
5.5 Index Usage Statistics and Redundant Index Detection
- Zero-usage: candidates for dropping (reset on every mongod restart - see §12.5). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#55-index-usage-statistics-and-redundant-index-detection]
- Redundant: use $indexStats or Atlas Performance Advisor for prefix-redundancy detection. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#55-index-usage-statistics-and-redundant-index-detection]
5.6 Index Build Progress
- Background operation on large collections; progress shown in Indexes tab. Do not disconnect or kill mongod during a build. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#56-index-build-progress]
5.7 Queryable Encryption Limitation
- Do not create regular indexes on encrypted fields. Use __safeContent__ for Queryable Encryption equality queries. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#57-queryable-encryption-limitation]
6.1 Performance Insights (Built-in Compass Feature)
- Automatic, no Atlas required: [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#61-performance-insights-built-in-compass-feature]
6.2 Atlas Performance Advisor
- When connected to Atlas: monitors queries >100ms, groups by query shape, calculates Impact score (AQT - docs scanned per doc returned; lower is better), detects prefix-redundant indexes. One-click index creation available in Atlas web UI. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#62-atlas-performance-advisor]
6.3 Workflow: Slow Query Remediation
- Performance Insights runs automatically. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#63-workflow-slow-query-remediation]
- Run typical queries via query bar or aggregation builder. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#63-workflow-slow-query-remediation]
- Observe Performance Insights banners. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#63-workflow-slow-query-remediation]
- Create recommended index in Indexes tab. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#63-workflow-slow-query-remediation]
- Re-run query and compare explain plan. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#63-workflow-slow-query-remediation]
- For Atlas: check Atlas UI Performance Advisor for cluster-wide analysis. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#63-workflow-slow-query-remediation]
7.1 Documents Tab Overview
- Query bar (filter, projection, sort, skip, limit, maxTimeMS, hint), three view modes, insert/export/count controls. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#71-documents-tab-overview]
7.2 Document View Modes
- List View (default): Key-value pairs, expandable nested objects/arrays. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#72-document-view-modes]
- JSON View: Full EJSON rendering. Editing performs findOneAndReplace - replaces the entire document. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#72-document-view-modes]
- Table View: Rows and columns; resizable columns (v1.49.0+). Editing performs findOneAndUpdate - modifies only changed fields. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#72-document-view-modes]
- > Critical: JSON view editing replaces the whole document. Use List or Table view for surgical field edits. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#72-document-view-modes]
7.3 In-Place Editing
- Double-click field → edit → checkmark to apply. List/Table view: findOneAndUpdate with $set. JSON view: findOneAndReplace. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#73-in-place-editing]
7.4 Document Insertion
- JSON Mode: paste array or single object. Field-by-Field Editor: interactive BSON type selection. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#74-document-insertion]
7.5 Array and Subdocument Expansion
- Expandable inline in List view. ObjectIds auto-wrap when pasted (v1.49.0+). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#75-array-and-subdocument-expansion]
7.6 Projection Support
- {field: 1} include / {field: 0} exclude. Reduces noise and load time for large documents. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#76-projection-support]
7.7 Multi-Select Delete
- Checkboxes → Delete Selected → runs deleteMany on selected _id values. Irreversible. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#77-multi-select-delete]
7.8 Schema Validation Rules (Validation Tab)
- The Validation tab (a separate tab adjacent to Documents, not inline editing) manages collection-level schema validation rules: [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#78-schema-validation-rules-validation-tab]
- Supports $jsonSchema and MQL query operator syntax [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#78-schema-validation-rules-validation-tab]
- validationLevel: strict (all inserts/updates) or moderate (new docs only) [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#78-schema-validation-rules-validation-tab]
- validationAction: error (reject) or warn (accept with warning) [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#78-schema-validation-rules-validation-tab]
- Generate Rules: auto-generates $jsonSchema from existing data [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#78-schema-validation-rules-validation-tab]
- Preview documents: shows sample docs matching the validation expression [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#78-schema-validation-rules-validation-tab]
8.1 Overview
- AI-powered interface generating MongoDB query syntax and aggregation pipelines from plain English. Remains labeled experimental in official documentation; v1.49.0 added tool-calling capability and removed the AI Assistant preview badge - always review generated queries before executing. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#81-overview]
8.2 Enabling NLQ
- Settings → Use Generative AI toggle. Requires internet; not available in Compass Isolated Edition. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#82-enabling-nlq]
8.3 Generating Queries
- Documents tab → Generate query button. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#83-generating-queries]
- Type prompt (e.g., "Which movies were released in 2000?"). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#83-generating-queries]
- Press Enter → filter populates in query bar. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#83-generating-queries]
- Review generated syntax carefully before executing. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#83-generating-queries]
8.4 Generating Aggregation Pipelines via NLQ
- Prompts requiring aggregation auto-redirect to the Aggregations tab with a generated pipeline. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#84-generating-aggregation-pipelines-via-nlq]
8.5 Privacy and Data Handling
- Prompt text and collection schema (field names/types - not document values) sent to Microsoft Azure OpenAI. Data not stored on third-party systems; not used to train AI models. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#85-privacy-and-data-handling]
8.6 Supported Input Types
- Natural language, pasted SQL (translated to MQL), application code snippets. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#86-supported-input-types]
8.7 Limitations and Caveats
- Experimental accuracy: always review before running. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#87-limitations-and-caveats]
- Complex queries: multi-stage pipelines may produce incorrect results. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#87-limitations-and-caveats]
- MAX TIME MS: increase for complex generated pipelines. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#87-limitations-and-caveats]
- Review before executing: NLQ generates filter queries; risk arises from running filters with destructive intent (e.g., Delete Selected after filtering). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#87-limitations-and-caveats]
- Schema required: works best when schema analysis has been run. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#87-limitations-and-caveats]
8.8 Compass AI Assistant
- Since v1.49.0: chat interface (mongodb-chat-2 model) for Compass feature questions, query optimization, pipeline debugging, schema design guidance. Accessible from the Assistant panel (speech bubble icon). Tool-calling allows the assistant to execute Compass operations directly. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#88-compass-ai-assistant]
9.1 Importing Data
- Documents tab → Add Data → Import File. Supported: JSON (array or NDJSON) and CSV (first row = field names; BSON type inference with manual override). For >10k documents, prefer mongoimport CLI - Compass import holds the full file in memory. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#91-importing-data]
9.2 Exporting Data
- Query results: filter → Export Collection → JSON or CSV [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#92-exporting-data]
- Aggregation results: Aggregations tab → Run → Export → JSON or CSV [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#92-exporting-data]
- Full collection: empty filter {} → Export Collection [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#92-exporting-data]
9.3 Import/Export Limitations
- No binary (BSON) GUI export - use mongodump/mongorestore [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#93-importexport-limitations]
- CSV export flattens nested docs (dot-notation); arrays serialized as strings [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#93-importexport-limitations]
- No progress tracking for large exports; Compass may appear frozen [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#93-importexport-limitations]
10.1 Architecture: Electron + React
- Electron app (Chromium + Node.js), React UI, multi-package monorepo at github.com/mongodb-js/compass. Each feature is a separate npm package: [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#101-architecture-electron-react]
- @mongodb-js/compass-crud, compass-schema, compass-indexes, compass-aggregations, compass-query-bar, compass-schema-validation, compass-collection, compass-instance [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#101-architecture-electron-react]
10.2 `@mongodb-js/compass-components`
- Shared UI library wrapping LeafyGreen (MongoDB's React design system). Ensures visual consistency; single dependency update propagates across all plugins. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#102-mongodb-jscompass-components]
10.3 Third-Party Plugin Development (Deprecated)
- Previously supported via compass-plugin khaos boilerplate (React + Reflux stores + Enzyme + Storybook). The external plugin API has been internalized; third-party development is no longer actively promoted. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#103-third-party-plugin-development-deprecated]
10.4 Custom Themes
- Light and dark mode supported. Custom theming beyond built-in modes is not officially supported. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#104-custom-themes]
10.5 Compass as a Development Platform
- Embed mongosh: @mongosh/node-mongosh-main [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#105-compass-as-a-development-platform]
- Driver layer: @mongodb-js/mongodb-data-service [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#105-compass-as-a-development-platform]
- Fork Compass (Apache 2.0 licensed) and customize [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#105-compass-as-a-development-platform]
10.6 Compass Shell (mongosh)
- Embedded mongosh access: click >_ next to connection name, or >_ Open MongoDB shell in any tab. Already connected; use for operations not available in GUI (db.adminCommand(), profiler control, etc.). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#106-compass-shell-mongosh]
11.1 Overview
- Since 2025, Compass includes Data Modeling - visual ER diagrams from existing collections for understanding, documenting, and planning schema structure. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#111-overview]
11.2 Generating a Diagram
- Open Data Modeling (top-level sidebar). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#112-generating-a-diagram]
- Enable Auto-infer relationships - analyzes indexed fields for cross-collection references. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#112-generating-a-diagram]
- Compass generates ER diagram with collection nodes and relationship arrows. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#112-generating-a-diagram]
11.3 Diagram Features
- Collapse/expand collections; Diagram Overview drawer (minimap) [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#113-diagram-features]
- Cardinality: one-to-one, one-to-many, many-to-many [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#113-diagram-features]
- Modify diagram without affecting data - planning artifact only [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#113-diagram-features]
- Sort persistence since v1.49.5 [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#113-diagram-features]
11.4 Export Formats
- Image (PNG/SVG), JSON (machine-readable), .mdm (Compass-native, reopenable in Compass) [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#114-export-formats]
12.1 Connecting to Primary in Production Without Read Preference
- Anti-pattern: Default primary read preference for schema analysis or explain plans on production. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#121-connecting-to-primary-in-production-without-read-preference]
- Why it's harmful: $sample and COLLSCAN explains compete with application workload on the primary. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#121-connecting-to-primary-in-production-without-read-preference]
- Fix: Set readPreference=secondaryPreferred in Advanced Connection Options. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#121-connecting-to-primary-in-production-without-read-preference]
12.2 Large Sample Sizes Causing OOM
- Anti-pattern: Sample size 100,000+ on limited-RAM machines. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#122-large-sample-sizes-causing-oom]
- Why it's harmful: Large $sample loads many documents into Compass's Electron renderer process memory. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#122-large-sample-sizes-causing-oom]
- Fix: Keep sample size 1,000–5,000; use query filters to narrow the subset instead. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#122-large-sample-sizes-causing-oom]
12.3 Running Explain on Large Collections Without a Query Filter
- Anti-pattern: Explain on unfiltered {} against multi-million document collections. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#123-running-explain-on-large-collections-without-a-query-filter]
- Why it's harmful: executionStats verbosity executes the query; COLLSCAN on large collections takes minutes. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#123-running-explain-on-large-collections-without-a-query-filter]
- Fix: Add a narrow filter first. For planning-only analysis: db.collection.explain("queryPlanner") in shell. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#123-running-explain-on-large-collections-without-a-query-filter]
12.4 Leaving Compass Connections Open (Connection Limit Impact)
- Anti-pattern: Idle Compass connections left open overnight or across weekends. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#124-leaving-compass-connections-open-connection-limit-impact]
- Why it's harmful: Each connection counts against Atlas connection limits. As a rough guide: M0 ~500, M10 ~1,500, M20/M30 ~3,000 - verify current limits in the Atlas connection limits documentation. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#124-leaving-compass-connections-open-connection-limit-impact]
- Fix: Disconnect when not in use; one connection per cluster per user. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#124-leaving-compass-connections-open-connection-limit-impact]
12.5 Relying on Compass Usage Stats Alone for Index Decisions
- Anti-pattern: Using only the Usage column to decide which indexes to drop. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#125-relying-on-compass-usage-stats-alone-for-index-decisions]
- Why it's harmful: Usage counters reset on every mongod restart. Monthly-use indexes show zero after a failover. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#125-relying-on-compass-usage-stats-alone-for-index-decisions]
- Fix: Use $indexStats (includes accesses.since); cross-reference with Atlas Performance Advisor. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#125-relying-on-compass-usage-stats-alone-for-index-decisions]
12.6 Editing Documents in JSON View Accidentally (findOneAndReplace)
- Anti-pattern: Using JSON view for routine field-value edits. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#126-editing-documents-in-json-view-accidentally-findoneandreplace]
- Why it's harmful: JSON view issues findOneAndReplace; accidentally removed fields are permanently deleted. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#126-editing-documents-in-json-view-accidentally-findoneandreplace]
- Fix: Use List or Table view for surgical edits (findOneAndUpdate). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#126-editing-documents-in-json-view-accidentally-findoneandreplace]
12.7 Using Compass on Encrypted Fields Without Understanding Queryable Encryption Limits
- Anti-pattern: Creating regular indexes on QE-encrypted fields. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#127-using-compass-on-encrypted-fields-without-understanding-queryable-encryption-limits]
- Why it's harmful: Leaks frequency information about encrypted data. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#127-using-compass-on-encrypted-fields-without-understanding-queryable-encryption-limits]
- Fix: Use __safeContent__ fields or the dedicated QE index workflow. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#127-using-compass-on-encrypted-fields-without-understanding-queryable-encryption-limits]
13.1 Performance Tab
- Access: connection context menu (⋯) → Performance. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#131-performance-tab]
13.2 Killing Slow Operations
- Slowest Operations panel → Operation Details → Kill Op. Requires killop privilege for operations you don't own. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#132-killing-slow-operations]
13.3 Pause and Resume
- Pause stops display refresh without stopping data collection. Play resumes. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#133-pause-and-resume]
13.4 Limitations
- Unavailable for Queryable Encryption collections. [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#134-limitations]
- Limited when connected to a mongos (sharded cluster). [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#134-limitations]
Official Documentation
- MongoDB Compass Overview [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- Compass Editions [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- Schema Analysis [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- Sampling [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- Aggregation Pipeline Builder [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- View Query Performance [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- Manage Indexes [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- Performance Insights [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- Analyze Slow Queries (Atlas) [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- View Documents [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- Modify Documents [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- NLQ Enable [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- NLQ Prompt Query [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- Set Validation Rules [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- Real-Time Performance [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- Data Modeling [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- Favorite Connections [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
- Release Notes [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#official-documentation]
Related Skills
- [[mongodb-expert]], [[mongodb-atlas-expert]], [[mongodb-indexes-deep]], [[mongodb-query-performance]], [[mongodb-aggregation-pipeline]], [[mongodb-schema-design]], [[mongodb-performance-troubleshooting]] [archived source: https://llms-explorer.com/sources/mdb-context-hub/mongodb-compass/#related-skills]
Where this helps
- Exploring an unfamiliar or schemaless collection's shape before writing application code, using the Schema tab's field-type distribution instead of manually sampling documents. [source] — AI-suggested, synthesized from this pack's existing facts — not extracted from a source document.
- Diagnosing a slow query visually via the Explain Plan tree when a COLLSCAN needs to become an IXSCAN, without hand-parsing raw explain JSON. [source] — AI-suggested, synthesized from this pack's existing facts — not extracted from a source document.
- Prototyping and iterating on an aggregation pipeline stage-by-stage with live output previews, before exporting the finished pipeline as driver-ready code. [source] — AI-suggested, synthesized from this pack's existing facts — not extracted from a source document.
- Giving analysts or teammates less fluent in MQL a safe, visual way to query and validate data without direct shell access. [source] — AI-suggested, synthesized from this pack's existing facts — not extracted from a source document.
Project ideas
- Build a schema-documentation workflow that runs Schema Analysis on key collections, exports the inferred schema as JSON, and checks it into a docs repo for onboarding. [source] — AI-suggested, synthesized from this pack's existing facts — not extracted from a source document.
- Use the Explain-Driven Index Creation workflow as a repeatable checklist: run explain, spot COLLSCAN, build the compound index in the Indexes tab, and re-verify IXSCAN replaces it. [source] — AI-suggested, synthesized from this pack's existing facts — not extracted from a source document.
- Prototype a data model review using the Data Modeling ER-diagram feature to visualize inferred collection relationships and cardinalities before finalizing a schema. [source] — AI-suggested, synthesized from this pack's existing facts — not extracted from a source document.
- Set up per-environment connection favorites with color coding (dev/staging/prod) as a team convention to prevent accidental production writes. [source] — AI-suggested, synthesized from this pack's existing facts — not extracted from a source document.
Antipatterns
- Editing documents in JSON view for routine single-field changes — JSON view issues findOneAndReplace, so an accidentally omitted field is permanently deleted, unlike the surgical findOneAndUpdate used by List/Table view. [source] — AI-suggested, synthesized from this pack's existing facts — not extracted from a source document.
- Running Explain on an unfiltered {} query against a multi-million-document collection — executionStats verbosity actually executes the query, so an unfiltered COLLSCAN can take minutes. [source] — AI-suggested, synthesized from this pack's existing facts — not extracted from a source document.
- Deciding which indexes to drop using the Usage column alone — usage counters reset on every mongod restart, so a monthly-use index can show zero usage right after a failover. [source] — AI-suggested, synthesized from this pack's existing facts — not extracted from a source document.
- Leaving idle Compass connections open across environments — each one counts against the cluster's Atlas connection limit, and idle sessions left overnight quietly eat into that budget. [source] — AI-suggested, synthesized from this pack's existing facts — not extracted from a source document.
Known issues
- Compass import and export load the entire dataset into the Electron renderer process's memory, so files or collections beyond roughly 10,000 documents should go through mongoimport/mongoexport/mongodump instead. [source] — AI-suggested, synthesized from this pack's existing facts — not extracted from a source document.
- Compass explain omits $merge and $out stages from pipeline explains and defaults to executionStats verbosity, which actually runs the query — behavior that diverges from running explain directly in the shell. [source] — AI-suggested, synthesized from this pack's existing facts — not extracted from a source document.
- The Visual Tree explain view is not available for vector search queries; only the Raw Output JSON view works there. [source] — AI-suggested, synthesized from this pack's existing facts — not extracted from a source document.
- Compass's NLQ feature remains labeled experimental and sends prompt text plus collection schema (field names and types, not document values) to Microsoft Azure OpenAI, so it requires internet access and is unavailable in the Isolated Edition. [source] — AI-suggested, synthesized from this pack's existing facts — not extracted from a source document.
Children
- Compass Editions (frontier, viability 2.25 / 5, below research gate)
- Compass Connection Management (frontier, viability 3.65 / 5)
- Compass Schema Analysis (frontier, viability 3.83 / 5)
- Compass Aggregation Pipeline Builder (frontier, viability 2.85 / 5, below research gate)
- Compass Index Management (frontier, viability 2.95 / 5, below research gate)
- Compass Performance Insights (frontier, viability 3.17 / 5, below research gate)
- Compass CRUD and Documents Tab (frontier, viability 3.20 / 5)
- Compass Natural Language Query (frontier, viability 2.85 / 5, below research gate)
- Compass Data Import Export (frontier, viability 3.75 / 5)
- Compass Plugins and Extensibility (frontier, viability 2.33 / 5, below research gate)
- Compass Data Modeling ER Diagrams (frontier, viability 3.40 / 5)
- Compass Anti-Patterns (frontier, viability 2.58 / 5, below research gate)
- Compass Real-Time Performance Monitoring (frontier, viability 3.52 / 5)
Frontier under this node: Compass Aggregation Pipeline Builder (2.85), Compass Anti-Patterns (2.58), Compass CRUD and Documents Tab (3.20), Compass Connection Management (3.65), Compass Data Import Export (3.75), Compass Data Modeling ER Diagrams (3.40), Compass Editions (2.25), Compass Explain Plan Visualizer (3.35), Compass Index Management (2.95), Compass Natural Language Query (2.85), Compass Performance Insights (3.17), Compass Plugins and Extensibility (2.33), Compass Real-Time Performance Monitoring (3.52), Compass Schema Analysis (3.83)