create-and-configure-database-cli.md

title	Azure CLI Example: Create a Single Database
description	Use this Azure CLI example script to create a single database.
author	WilliamDAssafMSFT
ms.author	wiassaf
ms.reviewer	wiassaf, mathoma
ms.date	06/10/2025
ms.service	azure-sql-database
ms.subservice	deployment-configuration
ms.topic	sample
ms.custom	sqldbrb=1 devx-track-azurecli
ms.devlang	azurecli

Create a single database and configure a firewall rule using the Azure CLI

[!INCLUDEappliesto-sqldb]

This Azure CLI script example creates a single database in Azure SQL Database and configures a server-level firewall rule. After the script has been successfully run, the database can be accessed from all Azure services and the allowed IP address range.

[!INCLUDE quickstarts-free-trial-note]

[!INCLUDE azure-cli-prepare-your-environment.md]

Sample script

[!INCLUDE cli-launch-cloud-shell-sign-in.md]

Run the script

:::code language="azurecli" source="~/../azure_cli_scripts/sql-database/create-and-configure-database/create-and-configure-database.sh" id="FullScript":::

Clean up resources

[!INCLUDE cli-clean-up-resources.md]

az group delete --name $resourceGroup

Sample reference

This script uses the following commands. Each command in the table links to command-specific documentation.

Command	Description
az sql server	Server commands
az sql server firewall	Server firewall commands.
az sql db	Database commands.

Related content

• Azure CLI documentation
• Azure CLI samples for Azure SQL Database