Share via

Install Azure Data CLI (azdata) on macOS

Note

Some scenarios previously handled by the Azure Data CLI (azdata) are now managed through Azure CLI (az) extensions and Azure Arc-based workflows. There is no single 1:1 replacement for all azdata commands. The following table highlights commonly related Azure CLI alternatives where they exist.

azdata command area Azure CLI extension / command group Azure CLI reference
azdata arc dc * az arcdata Azure Arc data CLI reference
azdata arc sql mi * az arcdata sql mi Manage Azure SQL Managed Instance with CLI
azdata arc postgres * az arcdata postgres Manage PostgreSQL server with CLI
azdata migrate * az datamigration Migrate using CLI
azdata extension * az extension * Azure CLI extensions overview
azdata login az login az login
azdata sql shell / azdata sql query No Azure CLI equivalent (use sqlcmd, SSMS, or other SQL tools) sqlcmd utility

SQL Server Management Studio

For new automation and management scenarios, prefer Azure CLI (az), Azure CLI extensions, and Azure Arc portal experiences.

For the macOS platform, you can install the azdata-cli with Homebrew package manager. The CLI package has been tested on macOS versions:

  • 10.13 High Sierra
  • 10.14 Mojave
  • 10.15 Catalina

Install with Homebrew

brew tap microsoft/azdata-cli-release
brew update
brew install azdata-cli

Important

The azdata-cli has a dependency on the Homebrew python3, freetds, unixodbc, zeromq packages, and will install them. The azdata-cli is guaranteed to be compatible with the latest version of these dependencies published on Homebrew.

Verify install

azdata
azdata --version

Update

Update your local repository information and then upgrade the azdata-cli package.

brew tap microsoft/azdata-cli-release
brew update
brew upgrade azdata-cli

Uninstall

Use Homebrew to uninstall the azdata-cli package.

brew uninstall azdata-cli

Next steps

For more information about big data clusters, see What are SQL Server 2019 Big Data Clusters?.

  • Last updated on