CODEWITHSUNDEEP
mongodbmongodb-compass
Jabongg
Jabongg

Reputation: 2235

How to run Native mongo query in mongoDB Compass?

I'm trying to find data using native Mongo queries, but can't do it. It seems mongoDB Compass only provides filter property for fetching data.

As in case of SQL's (say phpmyadmin, mysqlWorkbench, toad), we can easily execute native queries directly in the QueryEditor. Similarly Is there any console (query editor) in mongodb compass where I can execute direct queries? If yes, then tell me the breadcrumb.

Note: I don't want to use robomongo, robo3T and other mongo UI tools.

Upvotes: 29

Views: 38320

Answers (5)

viveksharma
viveksharma

Reputation: 715

Compass provide the console at very bottom to run your query as you can run in the command line - you can just write your query after clicking on the mongosh console

something like - db.yourcollection.find({id: {$eq: "00"}}).pretty()

Upvotes: 24

JosephScript
JosephScript

Reputation: 344

Looks like they're adding a shell to Compass:

https://www.mongodb.com/blog/post/new-compass-comes-with-shell

"In Compass 1.22 Beta we are introducing the integrated MongoDB Shell, which allows you to run database commands and scripts directly from Compass."

Upvotes: 8

rlpatrao
rlpatrao

Reputation: 575

I like to use Robo3T (https://robomongo.org/), which has a nice interface and is not as restrictive as the Compass Query bars

Upvotes: 8

mfkvfn
mfkvfn

Reputation: 11

Unable to do this in Mongodb Compass, you can use other tools,such as "NoSQLBooster for MongoDB"

Upvotes: 1

Arpan Arora
Arpan Arora

Reputation: 119

Yes, Mongo compass provides only filter option(Query Bar) to do queries on specific collection.

To get better understanding about how to do queries in query bar refer this

Compass Documentation : Schema-Query Bar

Also have a look at this tutorial MongoDB Compass Query Building

Upvotes: 1

Related Questions