azure-mgmt-sql

What it is and what it does

azure-mgmt-sql is the official Azure SDK client library for managing SQL resources in Microsoft Azure. It exposes a large API surface covering databases, servers, elastic pools, failover groups, vulnerability assessments, and related infrastructure through the SqlManagementClient class. The package handles authentication via Microsoft Entra and abstracts the underlying REST API calls.

Typically used in infrastructure-as-code workflows, CI/CD pipelines, and automation scripts where you need to create, configure, monitor, or delete Azure SQL resources programmatically. Version 4.0.0 adds support for new resource types (distributed availability groups, IPv6 firewall rules, managed instance DTCs, and others) and extends existing models with system metadata and identity properties. The package requires Python 3.10+ and depends on azure-mgmt-core for common SDK patterns and isodate for date/time handling.

Use it for:

• Automate provisioning of Azure SQL databases and servers in infrastructure-as-code deployments.
• Build CI/CD pipelines that create test databases on demand and clean them up after test runs.
• Manage firewall rules, elastic pools, and failover groups across multiple Azure SQL instances.
• Query and configure vulnerability assessment baselines and security settings at scale.
• Monitor and update database encryption protectors and advanced threat protection policies.

Worth the install?

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

Provides programmatic management of Azure SQL resources—databases, servers, elastic pools, and related infrastructure—through the Azure SDK for Python.

Yes. The package is actively maintained, has no known vulnerabilities, low install friction, and is the official Microsoft client for Azure SQL management. Install it if you need to programmatically manage Azure SQL resources; skip it if you only use the Azure Portal or CLI for SQL operations.

Install

azure-mgmt-sql on PyPI

pip install azure-mgmt-sql

uv add azure-mgmt-sql

poetry add azure-mgmt-sql

Installing azure-mgmt-sql

Before you install

Low install friction; pure Python wheel with three lightweight runtime dependencies (isodate, azure-mgmt-core, typing-extensions). Actively maintained with recent release (44 days old) and ongoing repository activity.

License in practice

MIT license permits commercial and private use with minimal restrictions; suitable for most deployment contexts.

Quickstart

pip install azure-mgmt-sql

from azure.mgmt.sql import SqlManagementClient
import os

sub_id = os.getenv("AZURE_SUBSCRIPTION_ID")
client = SqlManagementClient(credential=DefaultAzureCredential(), subscription_id=sub_id)

Requires Python 3.10+; Azure subscription and environment variables (AZURE_CLIENT_ID, AZURE_TENANT_ID, AZURE_CLIENT_SECRET, AZURE_SUBSCRIPTION_ID) must be configured for authentication.

Verify before relying

• Whether the package supports all Azure SQL resource types or if some operations require separate SDKs.
• Performance characteristics when managing large numbers of resources or complex multi-region deployments.
• Backward compatibility guarantees between major versions given the 4.0.0 release.
• Authentication setup requirements beyond environment variable configuration.

Package facts

Evidence: azure_mgmt_sql-4.0.0-py3-none-any.whl

Keywords: azure, azure sdk

Tags

More Database packages