Opricot web-based MongoDB administation tool

Opricot is a web-based administration tool for MongoDB servers and databases. Use as a point-and-click adventure for basic tasks, utilize scripting for automated processing or repetitive things.

Our aim is to provide a snappy, fully featured alternative to the native MongoDB shell for database management tasks.

In addition to GUI functionality, it provides a Javascript environment for automated processing / db management / analytics. The Javascript is executed directly in the browser, and the included MongoDB API and syntax is, while not identical, very similar to the native MongoDB shell.

Integrated script library allows you store often-used scripts in the database, and share them with all users. By Using stored scripts the application can be customized to match your schemas and style of using MongoDB.

Download

Opricot works under Apache & PHP. It is released under the GNU General Public License, version 3.

v0.9.3a	2010-02-13	readme	license	download (zip, ~40k)
v0.9.2a	2010-02-01	readme	license	download (zip, ~40k)
v0.9a	2010-01-21	readme	license	download (zip, ~40k)

Features

Opricot supports the following interactive commands (most of them being also available via GUI):

connect(host, [port], [user], [pw])
showDatabases()
selectDatabase(dbname)
createDatabase([name])
show(what)
use(dbname, [collname])

showDatabase()
dropDatabase([silent])
repairDatabase()
showCollections()
selectCollection(dbname, collname)
createCollection([name])
execute(code, [scope])

showCollection()
dropCollection([silent])
collectionCount()
find(query, [fields])
findOne(query, [fields])
insert(data, [safe])
update(criteria, data, [options])
remove(criteria, [justone])
showIndexes()
ensureIndex(field)
deleteIndex(key)
deleteIndexes()
indexInfo()

showCursor([cursor])
results([cursor])
count([cursor])
limit(value, [cursor])
skip(value, [cursor])
sort(keys, [cursor])
validate([cursor])
explain([cursor])

There is also an (mostly undocumented) object-oriented Javascript driver for MongoDB, which can be used for automated processing (all the interactive commands are built on top of it).

Design & Development

Opricot combines the following components to create a fully featured administration tool:

An interactive browser console that allows you to either work with the database through the UI, or by using custom Javascript.
A set of simple commands that wrap the Javascript driver, and provide an easy way to complete the most common tasks.
Javascript driver for Mongo that works on the browser and talks with the AJAX interface.
Simple server-side AJAX interface for communicating with the MongoDB server (currently available for PHP).

While it currently works on web servers with the MongoDB PHP driver installed, Opricot can be easily made to run on other server environments by porting the simple AJAX interface to your preferred language; if you are interested in implementing the AJAX interface (comm.php) to another platform (Ruby/JAVA/whatever), please contact us!