Cosmos DB

Cosmos DB is a multi-model database service which supports many APIs. Cosmos DB is supported in our Cerulean product.

Overview

 

Simply put, Azure Cosmos DB is all things NoSQL from Microsoft Azure. Cosmos DB is a multi-model database service which supports many APIs. Cerulean enables you to manage data in your Azure Cosmos DB accounts from the convenience of your desktop and the platform of your choice. Using Cerulean, you can connect to your Azure Cosmos DB accounts and manage data in there. Azure Cosmos DB offers DocumentDB, Graph API (Gremlin), MongoDB API and Premium Table API currently. Currently Cerulean enables you to manage DocumentDB.


Loaded with features like CRUD operations on collections, stored procedures etc., strong querying support, built-in query manager, and export/import etc. plus support for other Azure services like Azure Service Bus, Search Service, Redis Cache and more, you don't have to look for any other tool to manage data in your Azure Cosmos DB accounts.

Cosmos DB Accounts

 
  • Connect: Connect to one or more Cosmos DB accounts using account name and key.
  • Emulator: On Windows platform you can also connect to Cosmos DB Emulator.
  • Multi-Region Support: You can manage Cosmos DB accounts hosted in all Azure regions where this service is supported.
  • Friendly Name: Assign a friendly name to your Cosmos DB accounts e.g. "Development", "Production", "Staging" etc. for easier identification.
  • Resource Category: Assign a category e.g. "Development", "Production", "QA" to your Cosmos DB accounts for resource categorization.
  • Permissions: Open an account in "Read Only" or "Read Write" mode to prevent accidental deletes and updates.

Document DB

 

DocumentDB API of Cosmos DB provides SQL-like querying capability over your JSON documents collection. Cerulean provides the most comprehensive set of features for managing your DocumentDB resources in a Cosmos DB account.


Databases

  • List: List databases in your Cosmos DB accounts.
  • Create: Create databases in your Cosmos DB accounts.
  • Delete: Delete one or more databases from your Cosmos DB accounts.
  • Properties: View system properties of a database.

Collections

  • List: List collections in a database.
  • Create: Create collection in a database. You can configure indexing policies, throughtput, TTL etc. using easy to use UI when creating a collection.
  • Delete: Delete one or more collections from a database.
  • Properties: View system properties of a collection.
  • Throughput: Change throughput for a collection on the fly. You can also enable/disable Request Units/Minute (RUPM) setting for that collection.
  • TTL: Change default time-to-live (TTL) policies for documents in a collection.
  • Statistics: View various statistics about a collection e.g. storage space used, number of resources in that collection etc.
  • Documents Count: Find count of documents in a collection based on certain criteria (e.g. for a particular partition key value).
  • Export Schema: Export one or more collections and save the collection schema as a JSON file on your local computer.
  • Import Schema: Create new collection by importing collection schema from a JSON file.

Documents

  • Query: Query documents in a collection.
  • 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.
  • 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.
  • Multiple Views: View query results in either tabular format or 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.
  • 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.

Stored Procedures

  • List: List stored procedures in a collection.
  • Create: Create stored procedure in a collection.
  • Delete: Delete one or more stored procedures from a collection.
  • Edit: Edit stored procedure by changing either its name or body. Cerulean is the only tool that allows you to edit a stored procedure in a partitioned collection.
  • Properties: View system properties of a stored procedure.
  • 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.
  • Export: Export one or more stored procedures and save the stored procedure schema as a JSON file on your local computer.
  • Import: Create new stored procedure by importing stored procedure schema from a JSON file.

Triggers

  • List: List triggers in a collection.
  • Create: Create trigger in a collection.
  • Delete: Delete one or more triggers from a collection.
  • Edit: Edit trigger by changing either its name, trigger criteria or body. Cerulean is the only tool that allows you to edit a trigger in a partitioned collection.
  • Properties: View system properties of a trigger.
  • Export: Export one or more triggers and save the trigger schema as a JSON file on your local computer.
  • Import: Create new trigger by importing trigger schema from a JSON file.

User Defined Functions

  • List: List user defined functions in a collection.
  • Create: Create user defined function in a collection.
  • Delete: Delete one or more user defined functions from a collection.
  • Edit: Edit user defined function by changing either its name or body. Cerulean is the only tool that allows you to edit a user defined function in a partitioned collection.
  • Properties: View system properties of a user defined function.
  • Export: Export one or more user defined functions and save the user defined function schema as a JSON file on your local computer.
  • Import: Create new user defined function by importing user defined function schema from a JSON file.

Users

  • List: List users in a database.
  • Create: Create user in a database.
  • Delete: Delete one or more users from a database.
  • Edit: Edit user by changing user's name.
  • Properties: View system properties of a user.

Graph (Gremlin)

 

Graph API of Cosmos DB provides support for managing property graph model which essentially is a data structure composed of vertices and edges. Cerulean provides the most comprehensive set of features for managing all your graph resources in a Cosmos DB account.


Databases

  • List: List databases in your Cosmos DB accounts.
  • Create: Create databases in your Cosmos DB accounts.
  • Delete: Delete one or more databases from your Cosmos DB accounts.
  • Properties: View system properties of a database.

Graph Collections

  • List: List graph collections in a database.
  • Create: Create graph collection in a database. You can configure indexing policies, throughtput, TTL etc. using easy to use UI when creating a graph collection.
  • Delete: Delete one or more graph collections from a database.
  • Properties: View system properties of a graph collection.
  • Throughput: Change throughput for a graph collection on the fly. You can also enable/disable Request Units/Minute (RUPM) setting for that graph collection.
  • TTL: Change default time-to-live (TTL) policies for graph documents in a graph collection.
  • Statistics: View various statistics about a graph collection e.g. storage space used, number of resources in that graph collection etc.
  • Export Schema: Export one or more graph collections and save the graph collection schema as a JSON file on your local computer.
  • Import Schema: Create new collection by importing graph collection schema from a JSON file.

Graph Documents

  • 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.

Stored Procedures

  • List: List stored procedures in a collection.
  • Create: Create stored procedure in a collection.
  • Delete: Delete one or more stored procedures from a collection.
  • Edit: Edit stored procedure by changing either its name or body. Cerulean is the only tool that allows you to edit a stored procedure in a partitioned collection.
  • Properties: View system properties of a stored procedure.
  • 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.
  • Export: Export one or more stored procedures and save the stored procedure schema as a JSON file on your local computer.
  • Import: Create new stored procedure by importing stored procedure schema from a JSON file.

Triggers

  • List: List triggers in a collection.
  • Create: Create trigger in a collection.
  • Delete: Delete one or more triggers from a collection.
  • Edit: Edit trigger by changing either its name, trigger criteria or body. Cerulean is the only tool that allows you to edit a trigger in a partitioned collection.
  • Properties: View system properties of a trigger.
  • Export: Export one or more triggers and save the trigger schema as a JSON file on your local computer.
  • Import: Create new trigger by importing trigger schema from a JSON file.

User Defined Functions

  • List: List user defined functions in a collection.
  • Create: Create user defined function in a collection.
  • Delete: Delete one or more user defined functions from a collection.
  • Edit: Edit user defined function by changing either its name or body. Cerulean is the only tool that allows you to edit a user defined function in a partitioned collection.
  • Properties: View system properties of a user defined function.
  • Export: Export one or more user defined functions and save the user defined function schema as a JSON file on your local computer.
  • Import: Create new user defined function by importing user defined function schema from a JSON file.

Users

  • List: List users in a database.
  • Create: Create user in a database.
  • Delete: Delete one or more users from a database.
  • Edit: Edit user by changing user's name.
  • Properties: View system properties of a user.

MongoDB

 

Support for MongoDB API is coming soon!

Table

 

Support for Table API is coming soon!

What Our Users Are Saying About Cerulean