Cerulean

Azure Cosmos DB

Cosmos DB SQL (Core) API

Databases

Using Cerulean you can list the databases that are there in your Cosmos DB account.

Using Cerulean you can create new database in your Cosmos DB account. When creating a database, you can assign a dedicated throughput for that database (and all containers in that database will share that throughput).

Please note that you can either create a database with throughput or without throughput. While you can change the throughput on the database created with a provisioned throughput anytime, what you can't do is remove the throughput (assuming the database is created with throughput) or assign throughput (assuming the database is created without throughput) after a database is created.

Using Cerulean you can delete one or more databases from your Cosmos DB account.

Cerulean is the only tool that will let you view the system properties (_rid, _self, _ts, and _etag etc.) of a database in your Cosmos DB account.

If a database is created with a provisioned throughput, using Cerulean you can change the throughput of that database on the fly.

Containers

Using Cerulean you can list the containers that are there in a database in your Cosmos DB account.

Using Cerulean you can create a new container in a database in your Cosmos DB account. Cerulean provides a comprehensive set of features for creating a container.

  • If a container is being created in a database with a provisioned throughput, it gives you an option of using either database throughput (i.e. container will share database's throughput) or specify a throughput at the container level. If a container is being created in a database without a provisioned throughput, then you will be asked to specify a throughput for the container.
  • While all other tools expect you to specify indexing policy on a container in JSON format, Cerulean gives you an easy-to-use interface to specify indexing policy. Using Cerulean's interface you can specify indexing mode (consistent, lazy or none), included and excluded index paths, composite indexes and spatial indexes. No other tool gives you this feature.
  • Using Cerulean you can specify unique key policy on a container at the time of container creation. Please note that it is not possible to modify unique key policy once a container is created.
  • Using Cerulean you can specify container's time-to-live policy at the time of creation. This policy essentially controls if the documents in the container should expire automatically (if so, then after what time) or not.

Using Cerulean you can delete one or more containers from a database from your Cosmos DB account.

Cerulean is the only tool that will let you view the system properties (_rid, _self, _ts, and _etag etc.) of a container in a database in your Cosmos DB account.

If a container is created with a provisioned throughput, using Cerulean you can change the throughput of that container on the fly.

Cerulean enables you to manage indexing policy on a container using an easy-to-use interface. It enables you to change indexing mode (consistent, lazy or none), included paths and excluded indexing paths, composite indexes and spatial indexes.

Using Cerulean you can view the unique key policy defined on a container. Please note that it is not possible to update unique key policy on an existing container.

Documents

Cerulean provides robust querying capabilities using which you can query the documents that are present in a container in your Cosmos DB account. It also includes a "validate query" feature using which you can validate the query before executing it.

While the documents are stored in JSON format, Cerulean is the only tool that displays them in tabular format for easier comprehension. It also displays them in JSON format as well. As part of query result display, Cerulean also shows the response headers returned by the service. It also shows you the throughput you consumed for executing a query.

Cerulean enables you to specify additional query options like number of records / page, whether you want to force query plan or not, if or not you wish to populate query metrics in the response headers and much more.

Pagination to view query result (documents) is supported by default and you can easily navigate from one page of results to another page using Cerulean.

This is a nifty productivity feature in Cerulean which enables you to save your commonly used queries inside the application so that you don't have to type the query over and over again. You can assign a friendly name to a query (e.g. "Show All Documents" for "SELECT * from Root r" query) and all you have to do is select that friendly name to bring up that query. You can also set a query as default query and that query will be selected by default whenever you open documents tab.

Using the query manager, you can edit any saved query by simply changing the query text and/or parameters. It's that simple. Furthermore you can delete saved queries as well.

You can export queries in JSON format and import them back. This becomes quite handy when you wrote queries against a container in one account and want to use the same queries against another container in same or different account.

Using Cerulean you can add a document to a container in your Cosmos DB account.

Using Cerulean you can update a document in a container in your Cosmos DB account. While updating a document, you can either merge changes to the parent document (in case you fetched partial document via query) or replace the document completely.

Cerulean is the only tool that will let you select multiple documents and delete them together.

Cerulean is the only tool that will let you view the system properties (_rid, _self, _ts, and _etag etc.) of a document in a container in your Cosmos DB account.

Stored Procedures

Using Cerulean you can list the stored procedures that are there in a container in your Cosmos DB account.

Using Cerulean you can create a stored procedure in a container in your Cosmos DB account.

Cerulean is the only tool that will let you view the system properties (_rid, _self, _ts, and _etag etc.) of a stored procedure in a container in your Cosmos DB account.

Using Cerulean you can delete one or more stored procedures from a container in your Cosmos DB account.

Using Cerulean you can update a stored procedure in a container in your Cosmos DB account. Updating a stored procedure includes changing the body of a stored procedure.

Using Cerulean you can execute a stored procedure from the application itself. For executing a stored procedure, Cerulean provides an easy to use interface to define input parametes. Cerulean also enables you to choose the type of partition key (string, numeric, object, undefined etc.) and specify value of the partition key accordingly.

Cerulean not only displays the output of the stored procedure but also shows you any console.log statements you have put in the procedure. It also shows you the request units you have consumed for executing a stored procedure.

Triggers

Using Cerulean you can list the triggers that are there in a container in your Cosmos DB account.

Using Cerulean you can create a trigger in a container in your Cosmos DB account. When creating a trigger, you can specify trigger operation (all, create, delete or replace), trigger type (pre or post) and trigger body.

Cerulean is the only tool that will let you view the system properties (_rid, _self, _ts, and _etag etc.) of a trigger in a container in your Cosmos DB account.

Using Cerulean you can delete one or more triggers from a container in your Cosmos DB account.

Using Cerulean you can update a trigger in a container in your Cosmos DB account. Updating a trigger includes changing the body, operation, and/or type of a trigger.

User Defined Functions

Using Cerulean you can list the user defined functions that are there in a container in your Cosmos DB account.

Using Cerulean you can create a user defined function in a container in your Cosmos DB account.

Cerulean is the only tool that will let you view the system properties (_rid, _self, _ts, and _etag etc.) of a user defined function in a container in your Cosmos DB account.

Using Cerulean you can delete one or more user defined functions from a container in your Cosmos DB account.

Using Cerulean you can update a user defined function in a container in your Cosmos DB account. Updating a user defined function includes changing the body of a user defined function.

Users

Using Cerulean you can list the users that are there in a database in your Cosmos DB account.

Using Cerulean you can create a user in a database in your Cosmos DB account.

Using Cerulean you can view system defined properties (e.g. _rid, _self, _ts, and _etag etc.) of a user and also update the name of the user.

Using Cerulean you can delete one or more users from a database in your Cosmos DB account.

More Cosmos DB Features