Overview
Azure SQL Database is Microsoft's managed SQL Server in the cloud. The Automize Azure SQL connector covers server + database management, firewall rules, elastic pools, and start/pause for serverless databases.
- Regions: Each server lives in one Azure region. Geo-replication for read replicas + failover.
- Plans: DTU model or vCore model. Serverless tier auto-pauses when idle.
Setting up the connection
Auth type: OAuth 2.0 (Authorization Code).
- Entra ID → App registration → SQL DB Contributor / SQL Server Contributor.
- For data-plane queries (SELECT/INSERT), set up an Entra-authenticated SQL user.
- In Automize → Settings → Connectors → Azure SQL. Paste credentials + subscription + resource group.
Find your credentials at https://entra.microsoft.com/.
Rate limits
Control-plane (this connector's surface): per-subscription API limits. Data-plane is sized by tier (DTU/vCore).
Data model
SQL hierarchy:
SQL Server (logical instance) ─┬─ Databases ─── Tables (etc.)
├─ Firewall Rules
├─ Elastic Pools (shared compute)
└─ Failover GroupsAvailable operations
12 operations available. Click any row to jump to its detail.
| Operation | Category | What it does |
|---|---|---|
| Create Database | General | Create a new database |
| Create Firewall Rule | General | Create a firewall rule |
| Delete Database | General | Delete a database |
| Delete Firewall Rule | General | Delete a firewall rule |
| Get Database | General | Get database details |
| Get Server | General | Get SQL server details |
| List Databases | General | List databases on a server |
| List Elastic Pools | General | List elastic pools on a server |
| List Firewall Rules | General | List server firewall rules |
| List Servers | General | List all SQL servers in the subscription |
| Pause Database | General | Pause a serverless database |
| Resume Database | General | Resume a paused database |
Operations
Create Database
Create a new database
| Parameter | Required | Type | Description |
|---|---|---|---|
Subscription Id subscription_id | Yes | text | |
Resource Group resource_group | Yes | text | |
Server Name server_name | Yes | text | |
Database Name database_name | Yes | text |
Tips
- Database name + sku (DTU or vCore spec). Long-running – poll status.
Create Firewall Rule
Create a firewall rule
| Parameter | Required | Type | Description |
|---|---|---|---|
Subscription Id subscription_id | Yes | text | |
Resource Group resource_group | Yes | text | |
Server Name server_name | Yes | text | |
Rule Name rule_name | Yes | text |
Tips
- name + startIpAddress + endIpAddress. Or 0.0.0.0/0.0.0.0 for 'Allow Azure services'.
Delete Database
Delete a database
| Parameter | Required | Type | Description |
|---|---|---|---|
Subscription Id subscription_id | Yes | text | |
Resource Group resource_group | Yes | text | |
Server Name server_name | Yes | text | |
Database Name database_name | Yes | text |
Delete Firewall Rule
Delete a firewall rule
| Parameter | Required | Type | Description |
|---|---|---|---|
Subscription Id subscription_id | Yes | text | |
Resource Group resource_group | Yes | text | |
Server Name server_name | Yes | text | |
Rule Name rule_name | Yes | text |
Get Database
Get database details
| Parameter | Required | Type | Description |
|---|---|---|---|
Subscription Id subscription_id | Yes | text | |
Resource Group resource_group | Yes | text | |
Server Name server_name | Yes | text | |
Database Name database_name | Yes | text |
Get Server
Get SQL server details
| Parameter | Required | Type | Description |
|---|---|---|---|
Subscription Id subscription_id | Yes | text | |
Resource Group resource_group | Yes | text | |
Server Name server_name | Yes | text |
List Databases
List databases on a server
| Parameter | Required | Type | Description |
|---|---|---|---|
Subscription Id subscription_id | Yes | text | |
Resource Group resource_group | Yes | text | |
Server Name server_name | Yes | text |
Tips
- Per-server. Returns databases + their tier + status (Online, Paused, Deleting).
List Elastic Pools
List elastic pools on a server
| Parameter | Required | Type | Description |
|---|---|---|---|
Subscription Id subscription_id | Yes | text | |
Resource Group resource_group | Yes | text | |
Server Name server_name | Yes | text |
Tips
- Pools share DTU/vCore across multiple databases for cost efficiency.
List Firewall Rules
List server firewall rules
| Parameter | Required | Type | Description |
|---|---|---|---|
Subscription Id subscription_id | Yes | text | |
Resource Group resource_group | Yes | text | |
Server Name server_name | Yes | text |
Tips
- IP allowlist at server level. Required to connect from outside Azure.
List Servers
List all SQL servers in the subscription
| Parameter | Required | Type | Description |
|---|---|---|---|
Subscription Id subscription_id | Yes | text |
Tips
- Returns SQL servers in the subscription/resource group.
Pause Database
Pause a serverless database
| Parameter | Required | Type | Description |
|---|---|---|---|
Subscription Id subscription_id | Yes | text | |
Resource Group resource_group | Yes | text | |
Server Name server_name | Yes | text | |
Database Name database_name | Yes | text |
Tips
- Serverless tier only. Pauses compute, billing for storage only.
Resume Database
Resume a paused database
| Parameter | Required | Type | Description |
|---|---|---|---|
Subscription Id subscription_id | Yes | text | |
Resource Group resource_group | Yes | text | |
Server Name server_name | Yes | text | |
Database Name database_name | Yes | text |
Tips
- Wakes a paused database. First connection after pause incurs cold-start latency.
FAQ
- Why can't I connect from my IP?
- Firewall blocks by default. Add Create Firewall Rule for your IP. Or use Private Endpoint for VNet-only access.
- Single vs Pool vs Managed Instance?
- Single: per-DB sizing. Pool: shared DTUs across DBs (cheaper for variable workloads). Managed Instance: full SQL Server compat (cross-DB queries, SQL Agent, etc.).