Mongodb ui client linux

What is a good MongoDB GUI client?

I’ve been using Rockmongo on Windows — it’s a php based web tool. But on Ubuntu (12.04) it’s behaving funny — queries timing out often — and I’m looking for better clients. Does anyone know anything good for MongoDB on Ubuntu?

I’ve been maintaining an up-to-date wiki-style list of MongoDB admin UIs, including cross-platform open-source ones, in this SO answer.

13 Answers 13

Robo 3T (formerly known as RoboMongo)

Shell-centric cross-platform open source MongoDB management tool (i.e. Admin GUI).

[It] embeds the same JavaScript engine (based on Mozilla SpiderMonkey), that powers MongoDB’s mongo shell. It means that you can reuse your existing skills of MongoDB Shell in Robomongo.

• It’s available for Linux, OSX and Windows.
• Regarding Linux, there are packages available in the .rpm (Fedora, CentOS, openSUSE), .deb (Debian, Ubuntu) and .tar.gz formats.
• It is free (as in Speech); you can access its GitHub repository here.

Be sure to check View -> Explorer once the program is launched for the first time — or you will be lost looking for the list of databases, like I was.

This app is badly written. Doesn’t work on Windows 7 as of today (build 0.8.5). First I thought it can’t connect to local server. Then I googled and found here I need to open Explorer. And now it shows I have no collections in db.

@ruslan RoboMongo doesn’t work with Mongo 3.0 and above. We recently had to switch to MongoChef because of that.

Regarding MongoDB 3 support: «Robomongo 0.9.0 RC2 supports MongoDB 3.x and WiredTiger engine. For any found issues, please report to github.com/paralect/robomongo/issues/520 «.

One thing I know of (but don’t like the interface very much) is UMongo, which is a desktop, not browser-based application. Here’s a screenshot:

So far I’ve been using MonjaDB — it’s an Eclipse plug-in, and Eclipse is my IDE anyway. I like it; it seems to have all the features I used to use in RockMongo.

Here’s a screenshot from MonjaDB (there are more on his website, as well as some instructions):

To install it, you obviously need Eclipse (which you can get from the Ubuntu repositories). Once you’ve done that you need to go to the Help-> Install New Software. and then add this update site. Although I like it, I don’t think many people will switch IDE’s just for a GUI for Mongo (although I could be mistaken).

Both UMongo and MonjaDB have their source code is on GitHub.

Источник

11 Best MongoDB GUI Client (2023)

There are many MongoDB management tools available in the market. These tools can improve the productivity of your MongoDB development and admin tasks.

Here is the list of most popular MongoDB GUI tools for your business with it’s top features, use, and download link.

MongoDB GUI Tools for Windows & Mac

Name	Supported Platforms	Free Trial	Link
Studio 3T	Windows, macOS and Linux	30-Day Free Trial	Learn More
Robo 3T	Windows, macOS and Linux	Free Download	Learn More
HumongouS.io	Web Desktop, Web Mobile	14-Day Free Trial	Learn More
DbSchema	Windows, macOS and Linux	15-Day Free Trial️	Learn More
NoSQL Manager	Windows	14-Day Free Trial	Learn More

#1) Studio 3T

Studio 3T is a GUI and IDE built for teams working with MongoDB. Now shipping with AI-Helper, for Natural Language Querying.

Effortlessly compare and synchronize data

Visual Query Builder: Yes

Supported Platforms: Windows, macOS and Linux

Free Trial: 30-Day Free Trial

• AI Helper – write queries in your native language, let AI do the rest
• Visual Query Builder – drag-and-drop fields to build queries even faster than AI can
• Write SQL queries, with INNER and OUTER joins, to query MongoDB direct
• Intellishell, with fast, intelligent auto-completion and Query Assist
• Accelerate your queries – with the all new Index Performance Manager
• Generate unlimited driver-code from SQL or mongo shell into PHP, Python, Javascript, Ruby and More
• Collections History – for undeleting those lost documents
• Easily manage unlimited secure connections with one-click Connections Manager
• Copy and paste documents across servers and databases
• Effortlessly compare and synchronise data
• Build complex and powerful aggregation queries stage by stage
• Explore multiple ways to import & export, including full Migration from SQL to MongoDB, and back again
• Automate and schedule repetitive MongoDB tasks like imports, using Task Manager

#2) Robo 3T

Robo 3T (formerly Robomongo) is the popular free GUI for MongoDB enthusiasts. This lightweight, open-source tool has cross-platform support and also embeds the mongo shell within its interface to provide both shell and GUI-based interaction. It is developed by 3T Software, the team behind Studio 3T, the IDE for MongoDB.

Embedded shell environment

Visual Query Builder: Yes

Supported Platforms: Windows, macOS and Linux

Free Trial: Free Download

Key features

#3) HumongouS.io

HumongouS.io is a powerful online MongoDB GUI with an intuitive UI even for non-technical users.

Integrated Charts and Dashboards creation tool

Visual Query Builder: Yes

Supported Platforms: Web Desktop, Web Mobile

Free Trial: 14-Day Free Trial

• The widget system lets you define how you want your collections to be displayed (clickable urls, formatted numbers, image previews…)
• Invite your colleagues directly from the app. No need to share database credentials anymore.
• You can access your data from anywhere as it works on Web and Mobile.
• The Smart Filters buttons can be configured to quickly filter your collections
• The Smart Search feature lets you search your database with just keywords.
• And it comes with an integrated Charts and Dashboards creation tool.
• Supported platform: Web Desktop, Web Mobile

#4) DbSchema

DbSchema is a MongoDb visual designer for MongoDB. It enables you to design the MongoDB validation rules, for defining a clear way how the data is organized. The validation rules model can be shared in a team and deployed on different databases. It allows documenting the validation schema and output HTML5 documentation, explore data visually, build native MongoDB queries, generate random data, build reports, etc.

• Allows you to design MongoDB validation schema and share the design in a team.
• Offers visual database data explorer.
• You can compare the validation schema between two databases.
• Create HTML5 database documentation.
• Enables you to create native queries using the mouse.
• It can automate your schema management.
• Generate random data.
• Build database reports with tables and charts

#5) NoSQL Manager

This MongoDB GUI tool merges friendly UI and Shell power. It offers high performance with support for all the MongoDB and MongoDB Enterprise latest features. It also saves time for database developers and administrators.

• Fully featured MongoDB GUI Shell with code autocompletion, and syntax highlighting
• It offers support for replica sets, standalone hosts and sharded clusters connections
• Editor comes with three views Tree, Table, and JSON view modes
• Easy-to-use document viewer
• File Manager Tool to work with GridFS
• Simple view and management option for all types of MongoDB objects
• Import tables from MySQL and SQL Server databases
• Multiple Mongo host database connections
• Export documents to CSV, XML, XLSX, and JSON file formats

#6) Nucleon Database Master

Nucleon Database Master is one of the most powerful and easy to use MongoDB database administration, and management tool. It is one of the best mongodb tools that simplifies managing, monitoring, querying, editing, visualizing relational NoSQL DBMS.

• This mongodb client supports for JSON/LINQ/SQL Query Editor
• It offers powerful and intuitive SQL, LINQ and JSON query editor
• This mongodb ui tool provides notable features like code highlighting, code completion and text find and replace
• The users can export data into file formats like XML, HTML, MS Office, CSV, OpenOffice, RTF, PDF, XPS, JSON, dBase, and PNG
• It provides dynamic C# Scripting query editor which supports Linq to MongoDB and Linq to Dataset
• This mongodb editor allows importing data from XML, CSV, and SQL Script files without any size limit.

#7) MongoDB Compass

MongoDB Compass is another effective tool. It is one of the best mongodb gui tools which provides users with a graphical view of their MongoDB schema without the need of query language. It also analyses documents and displays rich structures inside this intuitive GUI.

• This mongodb ui tool allows to explore data visually
• MongoDB Compass analyzes documents and displays rich structures within one collection using Run ad-hoc queries in seconds
• This mongodb editor supports quick insight into server status and query performance
• Allows to view query performance
• A better approach to CRUD makes it easier to interact
• It helps users to take decisions about indexing, document validation, and more
• No need to write command line

#8) Mongo Management Studio

Mongo Management Studio is another effective tool for MongoDB management. It is possible to execute all the regular MongoDB commands without using the MongoDB shell.

• Mongo Management Studio is cross-platform, so it runs on all major systems
• It is one of the best mongodb tools that offers support for MongoDB 3.0 / 3.2 / 3.4
• The app allows connecting to remote MongoDB databases using an SSH tunnel
• With Mongo Management Studio, it is possible to read and write to GridFS collections
• This mongodb ide offers a complete documentation of all features by explaining MongoDB related topics
• With its inline edit feature, it is possible to do data manipulation on the fly

#9) Aqua Data Studio

Simplify working with MongoDB via Aqua Data Studio. Use MongoDB-specific features, including aggregation stages, and operators for type conversion, strings, and arrays. Edit JavaScript with autocomplete and syntax highlighting, and display results as a tree, grid, and text via the MongoJS Query Analyzer. The MongoShell combines a Unix shell with a native MongoDB shell. Display JSON results with MongoJS Pretty Print JSON.

• Build, debug, and analyze SQL queries.
• Edit data and result sets, import and export data, and protect sensitive data.
• Run visual data analytics.
• Manage objects, and compare and synchronize databases.
• Model entity relationships and manage version control repositories.
• Supported platforms: Windows, Linux, and macOS.
• Pricing: From $499 per user per year.
• Free Trial: 14-days.

#10) Cluster control

ClusterControl offers fully automated security, maintaining the integrity of the database infrastructure. In this MongoDB tool, it is possible to deploy and manage various open source database technologies from a single console.

• This mongodb client tool allows users to customize solutions for their own MongoDB deployments
• Easily add and remove nodes, resize instances, and clone production clusters with the help of this tool
• It provides single interface to automate mixed MongoDB and MySQL database environments
• It provides management features that repair and recover broken nodes, and test and automate upgrades

FAQ

MongoDB is a document-oriented NoSQL database used for high volume data storage. Instead of using tables and rows as in the traditional relational databases, MongoDB makes use of collections and documents.

Learn MongoDB in simple and easy steps using this beginner’s tutorial – Learn MongoDB in 7 Days.

Источник