I have a collection with documents containing UUID fields (standard, not legacy). When I browse those documents in the extension, they are shown like this:

{
"id": "5e58eae46015f74c61dd6af0",
"myuuid": {
"$binary": {
"base64": "ILGr2eKZSmqkQX1OZsoICQ==",
"subType": "04"
}
}
}

I would have expected them to be shown as:

{
"id": "5e58eae46015f74c61dd6af0",
"myuuid": UUID("20b1abd9-e299-4a6a-a441-7d4e66ca0809")
}

Robot 3T (for example) does this well. I think it would greatly help to read such values.

It would be nice if MongoDB for VS Code had a built-in functionality to verify query syntax, best practices, etc.

Conceptually, this would work similarly to how ESLINT works for JavaScript.

Every time I want to check a doc, It opens it in a new tab Which makes it difficult to navigate across the workspace. I would recommend open docs in the same tab and maybe device some mechanism to open the docs in a new tab if the user wants to compare two or more of them.

Ability to delete individual records in a collection either using the "backspace" or the menu (delete record). Also, an "empty this collection" would help.

There's no way that I can find to format the code in a .mongodb playground file.

At present, I need to manually change the file suffix to js, then use a hot-key to run prettier, then rename it back.

If there is a better way, I'd love to know it!

Thanks,

Kim

The ability to write queries, with IntelliSense and see the results as JSON or Tables. The query language can be in MQL or SQL. The results can be exported as json, csv or excel.

Ability to edit existing connections.

As some others tools have, a way to view all documents from a collection in a table format with columns and lines. An 'click on header for sort' is well desirable.

Hi,

All our databases are secured using Kerberos authenticatoin. I do not see Kerberos/GSSAPI authentication option for this plugin. Looking forward to see this added to the plugin so that we can offer this to our developers. Compass supports Kerberos authentication so it should be an easy port to this plugin. I hope :)

Thanks

After executing use('db') we don't need to include the command with each run, especially when we want to run the selected line.

At present, if I run some selected lines to run from play ground it doesn't works if the lines doesn't includes the use('db') command.

I want to configure which connection should have a confirmation prompt before running a playground command. For ex., no prompt for the development database, yes prompt for the production database.

Executing the whole script or a selection with a shortcut key will be most useful.

Detailed Description

Option to disable comments for aggregation stages by default. I would assume that link to documentation website will make more sense, considering complexity of aggregation stage use cases. And even that should be optional.

Context

I run a lot of quick aggregations to get data insights, comments are just wasting 50% of playground's screen space and not too helpful for me.

After opening a few options of the tree sometimes I want to collapse all and explore a completely different path, having the option to expand/collapse all would be neat!

Currently, is kind of tedius to execute a targeted line. Other editors accept Ctl-Enter to execute the line, which is very convenient.

Be able to create aggregation pipeline or MapReduce with IntelliSense.

Add the ability to color code playground tab and/or editor's background color in the playground based on the connection that is active.

Eg: default background for my localhost connection and a more colorful one for staging environment or production ones even.

Allow to export to language within VSCode like what you have in compass.

It's much slower than other mongodb clients like Robo 3t every time I run a query, it seems that it create a new connection to the database and then executes the query. Is there any way to keep and reuse an existed connection so that to speed up the query executions?