Getting Started with NoSQLBooster: Install, Connect, Query

Getting Started with NoSQLBooster: Install, Connect, Query

What NoSQLBooster is

NoSQLBooster is a cross-platform MongoDB IDE that simplifies writing queries, managing data, and automating tasks with a rich UI, intelligent code completion, and a powerful JavaScript-based shell.

1. System requirements & download

  • OS: Windows 10+, macOS 10.13+, Linux (modern distributions)
  • MongoDB: Compatible with MongoDB 3.0+ (use latest MongoDB for full feature support)
  • Download: Get the installer from the official NoSQLBooster website and choose the package for your OS.

2. Installation

  1. Run the downloaded installer (exe/dmg/appimage) and follow prompts.
  2. On first run grant necessary permissions.
  3. Optionally enable automatic updates.

3. Create a connection

  1. Open NoSQLBooster and click New Connection.
  2. Enter a friendly Connection Name.
  3. Provide Connection Type:
    • Standalone: host and port (default 27017)
    • Replica Set: list of members and replica set name
    • SRV: paste your MongoDB connection string (mongodb+srv://…)
  4. Authentication:
    • None for unauthenticated local instances
    • Username/Password with appropriate Auth DB (often admin or the database name)
    • SCRAM-SHA-⁄256, X.509 or other methods supported by your server
  5. SSL/TLS:
    • Toggle and provide certificates if required by your server.
  6. Click Test Connection; then Save & Connect.

4. Workspace overview

  • Connection Tree: left pane lists servers, databases, collections.
  • Editor Tabs: open multiple JavaScript/SQL editors and visual explain plans.
  • Result Pane: displays documents, charts, and execution stats.
  • Shell Console: run JavaScript commands with auto-complete and snippets.

5. Run basic queries

NoSQLBooster supports both MongoDB shell JavaScript and a SQL-like query language.

Examples using JavaScript shell (type in editor and run):

  • Find documents:

javascript

db.users.find({ status: “active” }).limit(20).pretty();
  • Insert a document:

javascript

db.products.insertOne({ name: “Coffee Mug”, price: 9.99, tags: [“kitchen”,“drinkware”] });
  • Update documents:

javascript

db.orders.updateMany({ status: “pending” }, { \(set</span><span class="token" style="color: rgb(57, 58, 52);">:</span><span> </span><span class="token" style="color: rgb(57, 58, 52);">{</span><span> </span><span class="token literal-property" style="color: rgb(255, 0, 0);">status</span><span class="token" style="color: rgb(57, 58, 52);">:</span><span> </span><span class="token" style="color: rgb(163, 21, 21);">"processing"</span><span> </span><span class="token" style="color: rgb(57, 58, 52);">}</span><span> </span><span class="token" style="color: rgb(57, 58, 52);">}</span><span class="token" style="color: rgb(57, 58, 52);">)</span><span class="token" style="color: rgb(57, 58, 52);">;</span><span> </span></code></div></div></pre> <ul> <li>Delete documents:</li> </ul> <pre><div class="XG2rBS5V967VhGTCEN1k"><div class="nHykNMmtaaTJMjgzStID"><div class="HsT0RHFbNELC00WicOi8"><i><svg width="16" height="16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill="currentColor" fill-rule="evenodd" clip-rule="evenodd" d="M15.434 7.51c.137.137.212.311.212.49a.694.694 0 0 1-.212.5l-3.54 3.5a.893.893 0 0 1-.277.18 1.024 1.024 0 0 1-.684.038.945.945 0 0 1-.302-.148.787.787 0 0 1-.213-.234.652.652 0 0 1-.045-.58.74.74 0 0 1 .175-.256l3.045-3-3.045-3a.69.69 0 0 1-.22-.55.723.723 0 0 1 .303-.52 1 1 0 0 1 .648-.186.962.962 0 0 1 .614.256l3.541 3.51Zm-12.281 0A.695.695 0 0 0 2.94 8a.694.694 0 0 0 .213.5l3.54 3.5a.893.893 0 0 0 .277.18 1.024 1.024 0 0 0 .684.038.945.945 0 0 0 .302-.148.788.788 0 0 0 .213-.234.651.651 0 0 0 .045-.58.74.74 0 0 0-.175-.256L4.994 8l3.045-3a.69.69 0 0 0 .22-.55.723.723 0 0 0-.303-.52 1 1 0 0 0-.648-.186.962.962 0 0 0-.615.256l-3.54 3.51Z"></path></svg></i><p class="li3asHIMe05JPmtJCytG wZ4JdaHxSAhGy1HoNVja cPy9QU4brI7VQXFNPEvF">javascript</p></div><div class="CF2lgtGWtYUYmTULoX44"><button type="button" class="st68fcLUUT0dNcuLLB2_ ffON2NH02oMAcqyoh2UU MQCbz04ET5EljRmK3YpQ CPXAhl7VTkj2dHDyAYAf" data-copycode="true" role="button" aria-label="Copy Code"><svg viewBox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill="currentColor" fill-rule="evenodd" clip-rule="evenodd" d="M9.975 1h.09a3.2 3.2 0 0 1 3.202 3.201v1.924a.754.754 0 0 1-.017.16l1.23 1.353A2 2 0 0 1 15 8.983V14a2 2 0 0 1-2 2H8a2 2 0 0 1-1.733-1H4.183a3.201 3.201 0 0 1-3.2-3.201V4.201a3.2 3.2 0 0 1 3.04-3.197A1.25 1.25 0 0 1 5.25 0h3.5c.604 0 1.109.43 1.225 1ZM4.249 2.5h-.066a1.7 1.7 0 0 0-1.7 1.701v7.598c0 .94.761 1.701 1.7 1.701H6V7a2 2 0 0 1 2-2h3.197c.195 0 .387.028.57.083v-.882A1.7 1.7 0 0 0 10.066 2.5H9.75c-.228.304-.591.5-1 .5h-3.5c-.41 0-.772-.196-1-.5ZM5 1.75v-.5A.25.25 0 0 1 5.25 1h3.5a.25.25 0 0 1 .25.25v.5a.25.25 0 0 1-.25.25h-3.5A.25.25 0 0 1 5 1.75ZM7.5 7a.5.5 0 0 1 .5-.5h3V9a1 1 0 0 0 1 1h1.5v4a.5.5 0 0 1-.5.5H8a.5.5 0 0 1-.5-.5V7Zm6 2v-.017a.5.5 0 0 0-.13-.336L12 7.14V9h1.5Z"></path></svg>Copy Code</button><button type="button" class="st68fcLUUT0dNcuLLB2_ WtfzoAXPoZC2mMqcexgL ffON2NH02oMAcqyoh2UU MQCbz04ET5EljRmK3YpQ GnLX_jUB3Jn3idluie7R"><svg fill="none" viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"><path fill="currentColor" fill-rule="evenodd" d="M20.618 4.214a1 1 0 0 1 .168 1.404l-11 14a1 1 0 0 1-1.554.022l-5-6a1 1 0 0 1 1.536-1.28l4.21 5.05L19.213 4.382a1 1 0 0 1 1.404-.168Z" clip-rule="evenodd"></path></svg>Copied</button></div></div><div class="mtDfw7oSa1WexjXyzs9y" style="color: var(--sds-color-text-01); font-family: var(--sds-font-family-monospace); direction: ltr; text-align: left; white-space: pre; word-spacing: normal; word-break: normal; font-size: var(--sds-font-size-label); line-height: 1.2em; tab-size: 4; hyphens: none; padding: var(--sds-space-x02, 8px) var(--sds-space-x04, 16px) var(--sds-space-x04, 16px); margin: 0px; overflow: auto; border: none; background: transparent;"><code class="language-javascript" style="color: rgb(57, 58, 52); font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace; direction: ltr; text-align: left; white-space: pre; word-spacing: normal; word-break: normal; font-size: 0.9em; line-height: 1.2em; tab-size: 4; hyphens: none;"><span>db</span><span class="token" style="color: rgb(57, 58, 52);">.</span><span>sessions</span><span class="token" style="color: rgb(57, 58, 52);">.</span><span class="token" style="color: rgb(57, 58, 52);">deleteMany</span><span class="token" style="color: rgb(57, 58, 52);">(</span><span class="token" style="color: rgb(57, 58, 52);">{</span><span> </span><span class="token literal-property" style="color: rgb(255, 0, 0);">lastActive</span><span class="token" style="color: rgb(57, 58, 52);">:</span><span> </span><span class="token" style="color: rgb(57, 58, 52);">{</span><span> </span><span class="token literal-property" style="color: rgb(255, 0, 0);">\)lt: new Date(Date.now() - 302460601000) } });

Examples using SQL query (NoSQLBooster translates to MongoDB queries):

sql

SELECT name, price FROM products WHERE price > 20 ORDER BY price DESC LIMIT 10;

6. Use code snippets & auto-completion

  • Access built-in snippets from the editor to scaffold common operations.
  • Auto-completion suggests collection names, field names, aggregation stages, and shell helpers.

7. Aggregation and visual explain

  • Build aggregations with an interactive pipeline builder.
  • View execution plans and visualized explain output to optimize queries.

8. Data editing and import/export

  • Edit documents directly in the result grid.
  • Import CSV/JSON to a collection.
  • Export query results to JSON, CSV, or SQL formats.

9. Tasks & automation

  • Create scheduled tasks or use scripts to run repetitive jobs.
  • Use JavaScript to combine database operations and file I/O for automation.

10. Tips for productivity

  • Use snippets and keyboard shortcuts for faster coding.
  • Leverage SQL query mode for quick reporting.
  • Regularly use explain plans on expensive queries.
  • Keep connection profiles for different environments (dev/stage/prod).

11. Troubleshooting

  • If connection fails, verify host/port, credentials, firewall, and MongoDB bindIp.
  • Check TLS settings and provide CA/client certs if required.
  • Use the Test Connection button and view logs for details.

12. Further resources

  • Official NoSQLBooster documentation and tutorials on their website.
  • MongoDB manual for server-side features and authentication details.

Happy querying — NoSQLBooster speeds up working with MongoDB by combining a friendly UI, powerful shell, and automation features.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *