Features

Alpaqa Studio for Cosmos DB provides carefully designed and tested tools and features to help you work with Cosmos DB smarter and faster.

Full Data Visibility

  • Connect to Cosmos DB accounts, databases, and containers
  • Query and page through Cosmos DB containers  show me how
  • Use Table, Tree, and JSON View to explore your Cosmos DB
  • Discover field frequencies and data type distributions in your documents and containers  show me how

Ensuring consistent team coding standards as your team grows is hard. With full statistical analysis of all your data types and field names, mistakes and inconsistencies are immediately visible.
New starters on your team get up to speed in minutes instead of days.

Live Data Editing

  • Edit your data everywhere in-place with just one double-click  show me how
  • Easily add new fields or update existing ones  show me how
  • Simple editing and deleting for single or multiple documents

Querying Data

  • Support for Cosmos DB SQL API
  • Full CRUD support (Create, Read, Update
    and Delete)
  • Page-through your result sets, with intelligent data caching
  • Visual Query Builder (in preview)
  • Smart auto-completion of advanced SQL queries (collating requests)

Import Data

This feature is currently in development

  • Import from JSON and CSV files​
  • Pre-import data preview​
  • Monitor import progress with real-time cancellation option​
  • Copy-and-paste containers across accounts and databases (currently in test)​

We will soon be adding support for other data import sources, both offline and online. As a member of the EAP you can let us know directly what data import sources you’d like to see added next.

Export Data

This feature is currently in development

  • JSON and CSV options for exporting
    containers and databases​
  • Pre-export data preview​
  • Monitor export progress with real-time cancellation option​

We will soon be adding support for other data import sources, both offline and online. As a member of the EAP you can let us know directly what data import sources you’d like to see added next.

Professional Interface

  • Full hotkey support
  • Theme support with optional dark mode
  • See containers and documents side-by-side

DevOps Ready & Cloud Native Solution

  • Connects to your Cosmos DB seamlessly within the Microsoft Azure network at full speed
  • Connect to all your Cosmos DB accounts from one GUI
  • Long-running operations can execute with computer turned off (currently in test)
  • Command Line Interface (CLI) for task automation (in design)
  • Run schema analysis faster than on a local instance (in design)

As a cloud-native application we will enable offline operations and allow you to schedule jobs to be executed while you’re away from your computer. These operations will include long-running imports, exports and migrations and also the ability to run full schema analysis of your containers and databases. This feature set is currently in the design phase.

A Command Line Interface (CLI) will offer Cosmos DB job configuration, scheduling, and querying for DevOps task automation. This feature is currently in the design phase.

What Are the Future Plans for Alpaqa Studio?

The Alpaqa Studio for Cosmos DB roadmap will deliver robust productivity tools and
features to save your team time and money when working with Cosmos DB.

Discover And Optimize Performance Bottlenecks

This feature is currently in design

  • Analyze and understand query performance issues​
  • Discover hot partitions and slow queries​
  • Monitor performance of your Cosmos DB​
  • Optimize Request Unit (RU) costs of your Cosmos DB queries​

Full Support For Data Exploration And Management

This feature is currently in design

  • Explore and understand the structure of your Cosmos DB
  • Fine-tune every detail of your data model
  • Inspect the overall structure and individual properties and their values

Get Your Data In And Out at a Click

This feature is currently in development

  • Easily import and export your data
  • JSON, CSV, Excel, SQL and more
  • Immediate and scheduled periodic tasks

Easy Data Migration

This feature is currently in development

  • Moving data between Cosmos DB containers?​
  • Moving data between database systems?​
  • Alpaqa Studio will guide you during the setup, provide a meaningful preview, and simply perform the migration for you, even with your computer turned off.​

The Future is Up to You

The above list is a broad-brush view of our roadmap plans. New key features will come from you, the user. Join Alpaqa Studio for Cosmos DB and with your feedback and feature suggestions, you can be a key part of delivering a world-class visual environment for controlling your own Cosmos DB.

Sign up for Alpaqa Studio for Cosmos DB

Become a member of the Alpaqa Studio Early Access Program (EAP). Membership is currently by invitation, with a limited number of new seats added each week.
Don’t miss out!

Request early access and enjoy the benefits within minutes.