Cerulean

Azure Cosmos DB

Cosmos DB Gremlin (Graph) 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.

Graph 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 items 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.

Graph

Cerulean provides robust querying capabilities using which you can query the vertices and edges that are present in a container in your Cosmos DB account. Using Cerulean, you can make multiple queries (e.g. g.V();g.E()) against your container.

Cerulean displays the data in graphical format. Apart from that, it 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 also provides the capability of exporting the graph in an image (png, gig, jpg) format. It also provides you the capability of copying the raw data to clipboard or save it as a file.

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 Data" for "g.V();g.E()" 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 queries 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 vertex to a container in your Cosmos DB account. When adding a vertex, you can define a label for that vertex and specify custom attributes for that vertex.

Using Cerulean you can update a vertex in a container in your Cosmos DB account. Updating vertex includes changing (adding, updating and/or removing) the custom properties of a vertex.

Using Cerulean, you delete a vertex from a container in your Cosmos DB account.

Using Cerulean you can connect two vertices by adding an edge. When adding an edge, you can define a label for that edge and specify custom attributes for that edge.

Using Cerulean you can update an edge in a container in your Cosmos DB account. Updating an edge includes changing (adding, updating and/or removing) the custom properties of an edge.

Using Cerulean, you delete an edge from a container in your Cosmos DB account.

Using Cerulean you can customize how you want vertices and edges in your graph to look. You can change the shape, color, size & display label of a vertex. Similarly, you can change the thickness, color and more of an edge as well. Furthermore when changing the look and feel of a vertex and an edge, you can apply the same settings to vertices and edges in bulk.

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