- MongoDB Integration and Tools >
- Admin UIs
MongoDB does not include a GUI-style administrative interface. Instead most administration is done from command line tools such as the mongo shell. However some UI’s are available as separate community projects and are listed below. Some are focused on administration, while some focus on data viewing.
MongoDB Management Service¶
MongoDB Management Service (MMS) is a cloud-based suite of services for deploying and managing MongoDB instances with monitoring and backup capabilities.
Third-Party Open-Source Tools¶
Edda is a log visualizer. It takes logs as input and creates a timeline of notable events in the set. It can be installed via pip:
pip install edda
Fang of Mongo¶
Fang of Mongo is a web-based user interface for MongoDB build with django and jquery.
It will allow you to explore content of MongoDB with simple but (hopefully) pleasant user interface.
- field name autocompletion in query builder
- data loading indicator
- human friendly collection stats
- disabling collection windows when there is no collection selected
- twitter stream plugin
- many more minor usability fixes
- works well on recent chrome and firefox
- Track progress on twitter: @fangofmongo
UMongo (formerly JMongoBrowser)¶
UMongo is a GUI app that can browse and administer a MongoDB cluster. It is available for Linux, Windows and Mac OSX.
MongoHub is a native OSX GUI. It supports importing data through direct MySQL connections, CSV and JSON imports and exports.
- Extended JSON support
- Tabular view
- Click to sort
- Filter boxes to alter query
PHPMoAdmin is a MongoDB administration tool for PHP built on a stripped-down version of the Vork high-performance framework.
- Nothing to configure - place the moadmin.php file anywhere on your web site and it just works!
- Fast AJAX-based XHTML 1.1 interface operates consistently in every browser!
- Self-contained in a single 95kb file!
- Works on any version of PHP5 with the MongoDB NoSQL database installed & running.
- Super flexible - search for exact-text, text with * wildcards, regex or JSON (with MongoDB-operators enabled)
- Option to enable password-protection for one or more users; to activate protection, just add the username-password(s) to the array at the top of the file.
- E_STRICT PHP code is formatted to the Zend Framework coding standards + fully-documented in the phpDocumentor DocBlock standard.
- Textareas can be resized by dragging/stretching the lower-right corner.
- Free & open-source! Release under the GPLv3 FOSS license!
- Option to query MongoDB using JSON or PHP-array syntax
- Multiple design themes to choose from
- Instructional error messages - phpMoAdmin can be used as a PHP-MongoDB connection debugging tool
PHPMoAdmin can help you discover the source of connection issues between PHP and MongoDB. Download phpMoAdmin, place the moadmin.php file in your web site document directory and navigate to it in a browser. One of two things will happen:
- You will see an error message explaining why PHP and MongoDB cannot connect and what you need to do to fix it
- You will see a bunch of MongoDB-related options, including a selection of databases (by default, the admin and local databases always exist) - if this is the case your installation was successful and your problem is within the PHP code that you are using to access MongoDB, troubleshoot that from the MongoDB docs on php.net
RockMongo is a MongoDB management tool, written in PHP 5.
- easy to install, and open source
- multiple hosts, and multiple administrators for one host
- password protection
- query dbs
- advanced collection query tool
- read, insert, update, duplicate and remove single row
- query, create and drop indexes
- clear collection
- remove and change (only work in higher PHP-MongoDB version) criteria matched rows
- view collection statistics
Genghis is a single-file MongoDB admin app, which is available as either a Ruby or PHP script.
MongoDB ODA plugin for BIRT¶
The MongoDB ODA plugin for BIRT is an Eclipse-based plugin that enables you to connect to a MongoDB database and pull out data to display in your BIRT report. The interface is simple and an extensive user guide is provided with the release.
mongobird is an operations and administration management tool for MongoDB with dashboards, forecast warning, and various graphs.
- Packaged with an install script.
- Supports real-time monitoring. Captures information from the servers at 10 second intervals
- Provides a group for MongoDB replica sets.
- Dashboard of important information so that the state of MongoDB is visable at a glance.
- Graphs that display historical statistics for all data collected from MongoDB.
- Supports user-defined events for forecasting, warnings, and event notification,
- Open source. See the licensing page for more information.
mongoowl is a live monitoring and graphic visualization tool based on DHTML including HTML5.
- Free download.
- Live Monitoring: Provides monitoring information by 1 second intervals.
- Standalone: Runs without WAS.
- Animated Graphs: Supports user-defined graphs by smooth changes about monitoring items.
- Any Device: Supports all devices include mobile.
- Multiple Shells. Open as many shells as you need. Every tab in Robomongo is a MongoDB shell, fully isolated from each other.
- Multiple Results. Robomongo executes your code in statement by statement way. That means that you will receive as many result as many statements you have.
- Cross-platform, open source.
Opricot is a hybrid GUI/CLI/Scripting web frontend implemented in PHP to manage your MongoDB servers and databases. Use as a point-and-click adventure for basic tasks, utilize scripting for automated processing or repetitive things.
Opricot combines the following components to create a fully featured administration tool:
- Simple server-side AJAX interface for communicating with the MongoDB server (currently available for PHP).
Moa(db) is a new PHP MongoDB GUI. The project is focused on a very simple interface and a drag & drop setup. Helpful query validation, amazing lightweight UI , JSON imports & exports, SSL support, and much more in the box.
Third-Party Commercial Tools¶
3T Data Compare¶
3T Data Compare is a multi-platform data comparison tool for MongoDB, and includes the following features:
- Graphical side-by-side comparisons make it straightforward to understand the differences in your data.
- Easily visualise comparison results to help identify how critical data differs across environments.
- Highlight what new data and changes are required between different deployments of your systems.
- Examine which changes have occurred between current databases and previous backups.
- Quickly solve data-related setup problems in new deployments.
- Easily diagnose configuration problems in development, testing and production systems.
- Multi-platform: Mac OS X, Windows, Linux.
3T Data Manager¶
3T Data Manager is a multi-platform, in-place data browser and editor, and includes the following features:
- Edit any MongoDB data type directly in a tree-view, table-view or in a lossless JSON editor.
- Edit complex structures such as embedded documents or arrays-in-arrays-in-embedded-documents in both a tree-view or table-view effortlessly.
- See live evaluation of your data as you type (very handy for data types such as Date, Timestamp, etc).
- Seamlessly step into embedded objects, either for all documents simultaneously or for just individual documents.
- Visually add documents, fields and values of any MongoDB type with just a stroke of a key – anywhere in your document!
- Multi-platform: Mac OS X, Windows, Linux.
- Build JSON queries with simple drag-and-drop.
3T Schema Explorer¶
With the multi-platform 3T Schema Explorer, it’s easy to explore the schema of your MongoDB data:
Find structural outliers and anomalies in a single glance.
Quickly verify the “sanity” of your data. For example:
- Do all documents in my customer collection have an address field?
- How likely will an embedded address object contain a country code?
- Do my _id fields really all contain ObjectIDs? Where do those occasional String values come from?
Inspect documents containing certain keys or data types with just one click, all in the same application!
Multi-platform: Mac OS X, Windows, Linux.
- Database Master from Nucleon Software
- Tree view for databases and collections
- Create/Drop indexes
- View Server and database statistics
- Supports RDBMS (MySQL, postgres, ...)
MongoDBPumper for Oracle¶
MongoDBPumper is a tool that facilitates data transfer between Oracle and MongoDB databases, and includes the following features:
- Intuitive GUI wizard to facilitate data mapping and transfer operation.
- Support for all Oracle database versions including 8.1.7, 9.0.1, 9.2.0, 10.1.0, 10.2.0, 11.1.0, 11.2.0
- Support for all MongoDB database versions including 2.0, 2.2
- Support of two-way data transfer between Oracle and MongoDb databases.
- Supports most data types and performs data type conversions.
- Support of parallel data transfer operations for optimal performance.
- Support of loading MongoDb nested collections.
JSON Studio is a suite of data access applications enabling easy access to data stored in MongoDB using a high-level interface that does not require scripts, does not require writing JSON queries and can be used by both technical and less-technical people. Primary users include production/application support personnel, QA engineers, analysts, data scientists and developers.
- Run queries and searches without learning shell syntax and using an easy-to-use point-and-click interface.
- Build and run complex analytic queries and execute them without writing code and without learning new syntax.
- Sync data to and from Excel spreadsheets without scripts and in an interface accommodating analysts.
- A full visualization framework allowing you to build any chart on data in MongoDB including lines, bars, pies, columns, area charts, treemaps, scatter plots, parallel plots, and more.
- A robust suite of tools for QA including the ability to view collections and documents, differs for comparing collections, schema viewers, and more.
- Comprehensive profiling that extends system.profile capabilities with long-term retention, centralized storage and profiling analytics.
See the full demo of the finder application within the Studio.
Connect to your MongoDB databases directly from your iPhone with MongoMonitor.
- Connect to your MongoDB databases, supporting single hosts, Replica Sets and shards
- Check your database’s status, statistics and indexes
- Navigate through all collections, documents and sub-documents
- View and copy individual data in documents
- GridFS upload and preview (supports images, PDFs, and Office)
- Remove documents from your collections
- Handles mongodb:// links so you don’t have to type in long connections