azure-cli-sql

What it is and what it does

This package is a command module for the Azure CLI that extends the `az` command-line tool with SQL database and server management capabilities. It wraps the Azure SQL management APIs (via azure-mgmt-sql and azure-mgmt-storage) to provide CLI commands for creating, updating, listing, and deleting SQL servers, databases, managed instances, elastic pools, and data warehouses.

The module is designed for developers and system administrators who manage Azure SQL resources from the command line. It integrates directly into the Azure CLI ecosystem and depends on azure-cli-core for command registration and execution. The package has a low install footprint (pure Python wheel) and no external system dependencies, but it is tightly coupled to the Azure CLI framework and cannot be used as a standalone library.

Use it for:

• Automate SQL server and database provisioning in Azure infrastructure-as-code scripts.
• Manage elastic pools and database scaling from CI/CD pipelines without writing custom Python code.
• List and restore deleted databases or manage in-progress database operations via CLI.
• Configure SQL server firewall rules, virtual network rules, and connection policies from the command line.
• Create and manage Azure SQL managed instances and managed databases in bulk operations.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

A command-line module for the Azure CLI that provides SQL database and server management commands, including operations on managed instances, elastic pools, databases, and data warehouses.

Yes, if you use the Azure CLI and need to manage SQL resources from the command line. Install friction is low and the module integrates seamlessly into the `az` tool. However, note that the latest release dates to 2019 and targets Python 2.7–3.6; verify compatibility with your current Azure CLI version and Python environment before adopting. No known security vulnerabilities.

Install

azure-cli-sql on PyPI

pip install azure-cli-sql

uv add azure-cli-sql

poetry add azure-cli-sql

Installing azure-cli-sql

Before you install

Low install friction with a pure-Python wheel distribution. The package is actively maintained with recent commits and depends on stable Azure SDK components (azure-cli-core, azure-mgmt-sql, azure-mgmt-storage), though the latest release dates to 2019 and the package targets older Python versions (2.7, 3.4–3.6).

License in practice

MIT license permits commercial and private use with minimal restrictions; you may use, modify, and distribute this package freely provided you include the license notice.

Quickstart

# Install as part of Azure CLI
pip install azure-cli-sql

# Use via Azure CLI (requires azure-cli-core)
az sql server list
az sql db create --resource-group mygroup --server myserver --name mydb

Requires Azure CLI (azure-cli-core) to be installed and configured; commands execute through the `az` CLI tool, not as a standalone Python library.

Verify before relying

• Whether this module is still actively maintained or has been superseded by newer Azure CLI versions.
• Compatibility with Python versions beyond 3.6 (classifiers list only up to 3.6).
• Current state of dependencies (azure-mgmt-sql, azure-mgmt-storage) and whether they support modern Azure features.

Package facts

Evidence: azure_cli_sql-2.2.5-py2.py3-none-any.whl

Tags

More Database packages