Where can I get this nice phpMyadmin features for mongodb In phpmyadmin

Say I browse a table, or do anything.

I will be told the actual sql command that I should run to execute the query.

Say I want to do a query and then I want to do something else similar. I can just run some query. Copy the SQL command, modify it, and move on. This is obviously less error prone than writing queries from scratch, see that it doesn't work, and not knowing what's wrong.

In rockmongo I don't have that feature.

Say I want to search for certain record. Then I want to modify the search with additional search. I can't do that.

So what other software to access mongodb that give that feature?

Another related feature is a feature to run any sql command I wish in phpmyadmin.

I do not have that feature in mongodb.
Technically you don't have this feature in MySQL either - PHPMyAdmin is a third part tool just like rockmongo, but basically rockmongo does not have the features you want.  I am sure there are features people would like in PHPMyAdmin too that are not there yet.  When that happens you basically have 3 options:


Request the feature from the people running the project
Write it yourself (if the current tool is open source you could fork and extend etc.)
Use another tool that does have the feature you want


The effectiveness of 1 and 2 will depend on the feature you want, how easy it is to implement, what your skills are, how active the project is etc.

For number 3, there are other options for a GUI interface to MongoDB.  MongoVUE seems to have the view option you want, for example - however it is Windows based:

http://www.mongovue.com/features/

There are others too, MongoHub, PHPMoAdmin etc. - you can find them listed here:

http://www.mongodb.org/display/DOCS/Admin+UIs

There is a comparison of several of the UIs (and more in the comments on this blog post also):

http://timgourley.com/2010/03/16/tuesday-night-tech-mongodb-ui-edition.html

Finally, you should also consider MongoHQ and MongoLab as potential solutions, I know that HQ at least will let you add your own databases, and they both provide excellent admin interfaces for MongoDB.