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.

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.

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.

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.

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

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.

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.

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.

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.

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

Be able to create aggregation pipeline or MapReduce with IntelliSense.

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!

Automatically set up a connection via the MongoDB Extension instead of pasting the connection string manually every time.

Either by
1. detecting a running mongo session
2. Loading default connections, from a place on the system

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.

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

make button to export collection to xls or any other spreadsheet file. And also make a button to remove collection items