Cerulean

Azure Cosmos DB

Graph API (Gremlin)

Databases

  • List: List databases in your Azure Cosmos DB account.
  • Create: Create database in your Azure Cosmos DB account.
  • Delete: Delete one or more databases from your Azure Cosmos DB account.
  • Properties: View properties of a database in your Azure Cosmos DB account.
Add Database
Database Properties

Collections

  • List: List collections in a database in your Azure Cosmos DB account.
  • Create: Create collection in a database in your Azure Cosmos DB account. When creating a collection:
    • Partitioned/single partition type collection can be created.
    • Unlimited/fixed size collection can be created.
    • Throughput for the collection can be specified.
    • Time-to-Live (TTL) policies on documents in the collection can be specified.
    • Custom indexing policies can be specified including but not limited to specifying indexing type, included paths and excluded paths.
  • Throughput: Change throughput for a collection on the fly.
  • Indexing Policies: Conveniently change indexing policies on a collection including but not limited to specifying indexing type, included paths and excluded paths.
  • Document Time-to-Live (TTL): Easily change document TTL policies on a collection.
  • Delete: Delete one or more collections from a database in your Azure Cosmos DB account.
  • Properties: View properties of a collection in a database in your Azure Cosmos DB account.
  • Export Schema: Export collection schema in JSON format and save in a file on your local computer.
  • Import Schema: Create a collection by using a local file containing collection schema in JSON format.
Add Collection
Collection Properties
Collection Throughput (Configure RU/s)
Document TTL (Time-to-Live)
Indexing Policy
Indexing Policy (Included Path)
Indexing Policy (Excluded Path)

Graph

  • Query: Query documents (vertices & edges) in a graph collection.
  • Query Manager: Includes a query manager which makes managing your most used queries super simple.
    • Query Builder: Write graph (Gremlin) queries against your graph collection using an easy to use query builder.
    • Save: Save most used queries so that you don't have to type them over and over again. You can assign a friendly name to these queries for remembering them easily. Switching from one saved query to another is as simple as selecting an option from a dropdown list.
    • Edit: Edit any saved query. Simply change the query text or parameters and you're good to go.
    • Delete: Delete any saved query that you don't need going forward.
  • Multiple Views: View query results in either graphical format (vertices & edges) or JSON (raw) format. You can either copy raw data to clipboard or save to disk.
  • Highly Customizable: Customize the settings of a graph. You can change the shape, color, size & display label of the vertices and the color, thickness & display label of the edges.
  • Export: Export graph as an image (PNG/JPG/GIF formats are supported).
  • Vertices:
    • List: List vertices in a graph collection.
    • Create: Create vertex in a graph collection.
    • Delete: Delete one or more vertices from a graph collection.
    • Properties: View properties of a vertex.
    • Edit: Edit vertex by adding, deleting or updating properties of a vertex.
    • Connect: Connect a vertex to another vertex or self.
    • Customize: Customize the settings of a vertex. While changing the settings you can change the shape, color, size & display label of a vertex.
  • Edges:
    • List: List edges in a graph collection.
    • Create: Create edge in a graph collection.
    • Delete: Delete one or more edges from a graph collection.
    • Properties: View properties of a edge.
    • Edit: Edit edge by adding, deleting or updating properties of a edge.
    • Customize: Customize the settings of a edge. While changing the settings you can change the color, thickness & display label of a edge.
View Graph
View Graph Data (Raw Format)
New Vertex
Customize Vertex
New Edge
Customize Edge

Stored Procedures

  • List: List stored procedures in a collection in your Azure Cosmos DB account.
  • Create: Create stored procedure in a collection in your Azure Cosmos DB account.
  • Update: Update a stored procedure in a collection in your Azure Cosmos DB account. Using Cerulean, you can update a stored procedure in a partitioned collection as well.
  • Delete: Delete one or more stored procedures from a collection in your Azure Cosmos DB account.
  • Properties: View properties of a stored procedure in a collection in your Azure Cosmos DB account.
  • Execute: Execute stored procedure from inside the application by specifying input parameters and other attributes like partition key value. You can view the result of the stored procedure execution from inside the application as well.
  • Export: Export one or more stored procedures schema in JSON format and save in a file on your local computer.
  • Import: Create new stored procedure by importing stored procedure schema from a JSON file.
Stored Procedures
New Stored Procedure
Stored Procedure Properties
Execute Stored Procedure (Parameters)
Execute Stored Procedure (Result)
Execute Stored Procedure (Response Headers)

Triggers

  • List: List triggers in a collection in your Azure Cosmos DB account.
  • Create: Create trigger in a collection in your Azure Cosmos DB account.
  • Update: Update a trigger in a collection in your Azure Cosmos DB account. Using Cerulean, you can update a trigger in a partitioned collection as well.
  • Delete: Delete one or more triggers from a collection in your Azure Cosmos DB account.
  • Properties: View properties of a trigger in a collection in your Azure Cosmos DB account.
  • Export: Export one or more triggers schema in JSON format and save in a file on your local computer.
  • Import: Create new trigger by importing trigger schema from a JSON file.
Triggers
New Trigger
Trigger Properties

User Defined Functions

  • List: List user defined functions in a collection in your Azure Cosmos DB account.
  • Create: Create user defined function in a collection in your Azure Cosmos DB account.
  • Update: Update a user defined function in a collection in your Azure Cosmos DB account. Using Cerulean, you can update a user defined function in a partitioned collection as well.
  • Delete: Delete one or more user defined functions from a collection in your Azure Cosmos DB account.
  • Properties: View properties of a user defined function in a collection in your Azure Cosmos DB account.
  • Export: Export one or more user defined functions schema in JSON format and save in a file on your local computer.
  • Import: Create new user defined function by importing user defined function schema from a JSON file.
User Defined Functions
New User Defined Function
User Defined Function Properties

Users

  • List: List users in a database in your Azure Cosmos DB account.
  • Create: Create user in a database in your Azure Cosmos DB account.
  • Update: Update a user in a database in your Azure Cosmos DB account.
  • Delete: Delete one or more users from a database in your Azure Cosmos DB account.
  • Properties: View properties of a user in a database in your Azure Cosmos DB account.
Add User
User Properties

More Cosmos DB Features