Cerulean

Azure Cosmos DB

SQL API (DocumentDB)

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)

Documents

  • List/Query: Query documents in a collection in your Azure Cosmos DB account.
  • Query Manager: Includes a query manager which makes managing your most used queries super simple.
    • Query Builder: Write SQL queries against your DocumentDB 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.
    • Export: Export saved queries in JSON format and save them in a file on your local computer.
    • Import: Import saved queries from a file on your local computer.
  • Create: Add documents to a collection.
  • Delete: Delete one or more documents from a collection.
  • Update: Edit documents in a collection.
  • Properties: View system properties of a document.
  • Tabular Format View: View JSON documents in tabular (rows/columns) format for easier comprehension.
  • JSON Format View: View documents in JSON (raw) format. You can either copy raw data to clipboard or save to disk.
  • Response Headers: View response headers in JSON format with the ability to copy that data to clipboard to save to disk.
  • Document Attachments
    • List: List attachments associated with a document in a collection in your Azure Cosmos DB account.
    • Create: Create attachments for a document. You can create an attachment either by specifying an external media URL or selecting a file from your local computer.
    • Delete: Delete one or more attachments from a document.
    • Properties: View system properties of an attachment.
    • Edit: Edit attachment by replacing attachment content.
View Documents (Tabular Format)
View Documents (Raw Format)
View Documents (Response Headers)
New Document
Document Properties
Saved Queries
Document Attachments
New Document Attachment

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