IntelliShell

Prerequisites

First and foremost, let’s download Studio 3T and choose the right version for your particular platform and bit size.

IntelliShell requires the mongo shell executable, one of the mongo client tools bundled when downloading MongoDB.

Windows and Mac

No additional configuration is needed for Windows and Mac installations. The mongo shell executable is bundled with Studio 3T on these systems.

Linux

Linux requires the manual installation of the mongo shell executable.

To install the mongo client tools, download the latest MongoDB version here.

Once the mongo client tools are installed:

1. Go to Studio 3T > Preferences.
2. Click on the IntelliShell tab.
3. Insert the path of where the mongo shell executable is located.
   On Linux, this will be a binary file called mongo located in the ‘bin’ directory where the distribution was unpacked.
4. Click OK.

Basics

There are three ways to open IntelliShell:

• Button – Click on the IntelliShell button in the global toolbar
• Right-click – Right-click on a target collection and choose Open IntelliShell
• Hotkey -Press Ctrl + L (⌘+ L)

IntelliShell has two main sections: the Editor where queries are written in a standard command line interface, and the Result Tab where results can be viewed and edited.

Write a query

If you know the MongoDB query language, you can write queries directly in the Editor area.

Autocomplete a query

IntelliShell detects and autosuggests JavaScript standard library functions, shell-specific types and methods, operators, collection names, field names and shell helper commands as they are typed:

Autocompletion should be automatic, but it can also be triggered manually:

• Right-click – Right-click anywhere in the Editor and choose Open Autocompletion
• Hotkey – Press Ctrl + Space (^ + Space)

Execute a query

Queries can be executed entirely, at cursor, or as selected.

To execute an entire script:

• Button – Click on the Run (play) button
• Right-click – Right-click anywhere in the Editor and choose Execute Entire Script
• Hotkey – Press F5

To execute a script at cursor, place the cursor at the target query and:

• Button – Click on the second Run (play) button
• Right-click – Right-click anywhere in the Editor and choose Execute Statement at Cursor
• Hotkey – Press F6

To execute a selection, highlight the part of the query to be executed and:

• Button – Click on the third Run (play) button
• Right-click – Right-click anywhere in the Editor and choose Execute Selection
• Hotkey – Press F9

Check query results

Results can be viewed in the Result Tab in either raw shell mode or the standard three views (Table, Tree, and JSON).

Enable raw shell mode

Raw shell mode displays query results in the usual mongo shell format.

To enable raw shell mode, click on the shell icon in the toolbar:

View multiple tabs

The Result Tab can display either a single tab, which means results from previous queries are replaced by new ones, or multiple tabs, which is similar to how a browser works.

To view multiple tabs, click on the Retain button in the toolbar. Unclick it to revert to a single tab view.

Clear all result tabs

To close all result tabs:

• Button – Click on the Clear button in the toolbar
• Right-click – Right-click anywhere in the Editor and choose Clear Result Tabs

Insert and remove comments

It is also possible to comment and uncomment with a line comment.

Place the cursor on the line to be made into a comment and:

• Right-click – Right-click anywhere in the Editor and choose Comment with Line Comment. Repeat to remove the comment.
• Hotkey – Press Ctrl + / (⌘+ /). Repeat to remove the comment.

Open and save queries

To save your MongoDB query as a JavaScript file:

• Button – Click on the Save icon. Alternatively, click on the arrow to find the Save As function.
• Right-click – Right-click anywhere in the Editor and choose Save Script (As)
• Hotkeys – Save Script – Ctrl + S (⌘+ S), Save Script As – Shift + Ctrl + S (Shift + ⌘+ S)

To open saved queries:

• Button – Click on the Open icon
• Right-click – Right-click anywhere in the Editor and choose Open Script
• Hotkey – Press Ctrl + O (⌘+ O)

Use IntelliShell and Visual Query Builder side by side

With Studio 3T 2018.5, you can use Visual Query Builder – our drag-and-drop MongoDB query builder – alongside our smart mongo shell.

Simply click on the Visual Query Builder button on the toolbar:

This way, you can skip the command line writing and simply build queries visually.  This will likely come in handy as your MongoDB queries grow more complex.

Preferences

Code reformatting

You can define your Editor tab width preferences under Studio 3T > Preferences > General:

The default editor tab width setting is 4 spaces.

You can apply your chosen setting to reformat your IntelliShell code simply by:

• Right-click: Choose Format code
• Hotkey: Ctrl + Alt + L (or ⌥ + ⌘ + L on Mac)