Cerebrata

Cerulean (Preview)

Microsoft Azure Cosmos DB

Accounts

  • Connect to one or more Cosmos DB accounts using account name and key.
  • On Windows platform you can also connect to Cosmos DB Emulator.
  • You can manage Cosmos DB accounts hosted in Azure Germany region.
  • Assign a friendly name to your Cosmos DB accounts e.g. "Development", "Production", "Staging" etc. for easier identification.
  • Open an account in "Read Only" or "Read Write" mode to prevent accidental deletes and updates.
  • Currently the application has support for DocumentDB API only. Support for other APIs (Graph, Azure Tables etc.) will be added very soon.

Back to top

DocumentDB

Cosmos DB is a multi-model database service which supports many APIs. Currently the application supports DocumentDB API.

Microsoft Azure Cosmos DB

Databases

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

Back to top

Microsoft Azure Cosmos DB

Collections

  • List collections in a database.
  • Create collections in a database. When creating collections,
    • Define indexing policies for that collection.
    • Set collection throughput (Request Units/Second) as well as enable Request Units/Minute (RUPM) for that collection.
    • Set default time-to-live (TTL) policies for documents in that collection.
  • Delete one or more collections from a database.
  • View properties of a collection.
  • Change collection throughput on the fly. You can also enable/disable Request Units/Minute (RUPM) setting for that collection.
  • Change default time-to-live (TTL) policies for documents in that collection.
  • View collection statistics (storage space used, number of resources in that collection etc.).
  • Find documents count based on certain criteria (e.g. for a particular partition key value).

Back to top

Microsoft Azure Cosmos DB

Documents

  • List documents in a collection.
  • Add documents to a collection.
  • Delete one or more documents from a collection.
  • Edit documents in a collection.
  • Execute queries against your collection to filter the list of documents. When querying collections,
    • For partitioned collection, you can either tell Cosmos DB service to search across partitions.
    • For partitioned collection, you can also specify a specific partition key. Other than "string" type partition key, application also supports "numeric", "boolean", and "object" type partition keys as well.
  • Includes a basic query manager that lets you save the queries so that you don't have to type these queries over and over again. You can
    • Save queries in query manager. You can assign a friendly name to a query.
    • Edit saved queries.
    • Delete saved queries.
    • Mark a saved query as "default" that gets executed by default when documents tab is opened.
  • View query results in JSON format with the ability to copy that data to clipboard to save to disk.
  • View response headers in JSON format with the ability to copy that data to clipboard to save to disk.

Back to top

Microsoft Azure Cosmos DB

Document Atttachments

  • List attachments associated with a document.
  • Add attachment to a document. The new attachment could be
    • A publicly accessible web resource.
    • A file from local computer.
  • Delete one or more attachments associated with a document.
  • View attachment properties.

Back to top

Microsoft Azure Cosmos DB

Stored Procedures

  • List stored procedures in a collection.
  • Create stored procedures from a collection.
  • Delete one or more stored procedures in a collection.
  • Edit stored procedure. When a stored procedure is edited,
    • If the collection is non-partitioned, the stored procedure is saved as is.
    • If the collection is partitioned, the application first deletes the stored procedure and recreates it. This is done because Cosmos DB natively does not support this functionality.
  • Execute stored procedure. For partitioned collections, you also have an option of specifying partition key.

Back to top

Microsoft Azure Cosmos DB

Triggers

  • List triggers in a collection.
  • Create triggers in a collection.
  • Delete one or more triggers from a collection.
  • Edit trigger.
  • View properties of a trigger.

Back to top

Microsoft Azure Cosmos DB

User Defined Functions

  • List user defined functions in a collection.
  • Create user defined functions in a collection.
  • Delete one or more user defined functions from a collection.
  • Edit user defined function.
  • View properties of a user defined function.

Back to top

Microsoft Azure Cosmos DB

Users

  • List users in a database.
  • Create users in a database.
  • Delete one or more users from a database.
  • View user properties and edit users.

Back to top