Cosmos Query Manager is a Windows based query manager for Azure DocumentDb/Cosmos DB
- Develop, run, edit your DocumentDb/Cosmos DB SQL commands
- Add, edit and delete documents
- Work with multiple database and multiple environments
- Transaction and Rollback support
If you want to install the application please grab the exe installer file from the releases folder in the project source
This is a C# application, requiring VS2017+
There are 3 ways to create a new query tab
- From File select
- From the File List View
- From double clicking in the tabs bar
You can open any directory folder to load all the .cSQL files. This also loads all children folders and files as well. This provides the easy of working across many files, but still being able to organize them.
To create the connections file view the Help Guide.
In the query options toolbar on the far right is a dropdown to change the connection string of where the query gets executed. Each connection string will color the current tab to a set color. This helps in keeping track of what environment a query has been ran against at a quick glance.
- Formats the query statement
- Selected text to lowercase
- Selected text to uppercase
- Indents LIne
- Outdents Line
- Controls word wrap of the query statement
- Changes the font size of the query statement
- Saves the query statement
- Runs the query statement
On selects we have options available to manipulate the results list
- Send all the selected documents to a New Query Update statement
- Send all the selected documents to a New Query Delete statement
- Formats the document
- Selected text to lowercase
- Selected text to uppercase
- Indents LIne
- Outdents Line
- Controls word wrap of the document
- Changes the font size of the document
- Deletes the document
- Saves the document
- Exports the results document
In the output tab we can see all information related to the executed query. On selects we output all the cosmos metrics and costs, on other queries information related to the success of the query are displayed.
The transaction cache is the storage location where rollback files are stored. The application never deletes from this folder so there is always a rollback history available as a data safety precaution. As this folder grows with backup data for transactions it may need to be cleaned out or have the files archived somewhere.