Azure SQL Server API spec

azure · Cloud

Cloud No Auth Free & Open cloud

The Azure SQL Server management API provides a RESTful set of web services that interact with Azure SQL Server services to manage your databases. The API enables users update server connection policy.

Authentication

No authentication requiredFree to use with no key needed.

Sample Requests

GET ServerConnectionPolicies_Get

Gets the server's secure connection policy.

https://api.apis.guru/v2/specs/azure.com/sql-connectionPolicies/2014-04-01/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/connectionPolicies/{connectionPolicyName}?api-version=v1

Hover any highlighted part to learn what it does

curl -X GET "https://api.apis.guru/v2/specs/azure.com/sql-connectionPolicies/2014-04-01/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/connectionPolicies/{connectionPolicyName}?api-version=v1"

import requests
params = {
    "api-version": "v1"
}
response = requests.get(
    "https://api.apis.guru/v2/specs/azure.com/sql-connectionPolicies/2014-04-01/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/connectionPolicies/{connectionPolicyName}",
    params=params,
)
print(response.json())

const url = new URL('https://api.apis.guru/v2/specs/azure.com/sql-connectionPolicies/2014-04-01/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/connectionPolicies/{connectionPolicyName}');
url.searchParams.set('api-version', 'v1');

const response = await fetch(url); 
const data = await response.json();
console.log(data);

package main

import (
	"fmt"
	"io"
	"net/http"
	"net/url"
)

func main() {
	baseURL, _ := url.Parse("https://api.apis.guru/v2/specs/azure.com/sql-connectionPolicies/2014-04-01/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/connectionPolicies/{connectionPolicyName}")
	q := baseURL.Query()
	q.Set("api-version", "v1")
	baseURL.RawQuery = q.Encode()
	targetURL := baseURL.String()
	req, _ := http.NewRequest("GET", targetURL, nil)

	client := &http.Client{}
	resp, _ := client.Do(req)
	defer resp.Body.Close()
	body, _ := io.ReadAll(resp.Body)
	fmt.Println(string(body))
}

require "net/http"
require "json"

uri = URI("https://api.apis.guru/v2/specs/azure.com/sql-connectionPolicies/2014-04-01/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/connectionPolicies/{connectionPolicyName}")
uri.query = URI.encode_www_form({
  "api-version" => "v1"
})

http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = uri.scheme == "https"

req = Net::HTTP::Get.new(uri)

res = http.request(req)
puts JSON.parse(res.body)

<?php
$url = "https://api.apis.guru/v2/specs/azure.com/sql-connectionPolicies/2014-04-01/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/connectionPolicies/{connectionPolicyName}?" . http_build_query([
    "api-version" => "v1"
]);
$opts = ["http" => [
    "method" => "GET",
]];
$ctx = stream_context_create($opts);
$res = file_get_contents($url, false, $ctx);
print_r(json_decode($res, true));

PUT ServerConnectionPolicies_CreateOrUpdate

Creates or updates the server's connection policy.

Hover any highlighted part to learn what it does

curl -X PUT "https://api.apis.guru/v2/specs/azure.com/sql-connectionPolicies/2014-04-01/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/connectionPolicies/{connectionPolicyName}?api-version=v1"

import requests
params = {
    "api-version": "v1"
}
response = requests.put(
    "https://api.apis.guru/v2/specs/azure.com/sql-connectionPolicies/2014-04-01/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/connectionPolicies/{connectionPolicyName}",
    params=params,
)
print(response.json())

const url = new URL('https://api.apis.guru/v2/specs/azure.com/sql-connectionPolicies/2014-04-01/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/connectionPolicies/{connectionPolicyName}');
url.searchParams.set('api-version', 'v1');

const response = await fetch(url, {
  method: 'PUT',
}); 
const data = await response.json();
console.log(data);

package main

import (
	"fmt"
	"io"
	"net/http"
	"net/url"
)

func main() {
	baseURL, _ := url.Parse("https://api.apis.guru/v2/specs/azure.com/sql-connectionPolicies/2014-04-01/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/connectionPolicies/{connectionPolicyName}")
	q := baseURL.Query()
	q.Set("api-version", "v1")
	baseURL.RawQuery = q.Encode()
	targetURL := baseURL.String()
	req, _ := http.NewRequest("PUT", targetURL, nil)

	client := &http.Client{}
	resp, _ := client.Do(req)
	defer resp.Body.Close()
	body, _ := io.ReadAll(resp.Body)
	fmt.Println(string(body))
}

require "net/http"
require "json"

uri = URI("https://api.apis.guru/v2/specs/azure.com/sql-connectionPolicies/2014-04-01/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/connectionPolicies/{connectionPolicyName}")
uri.query = URI.encode_www_form({
  "api-version" => "v1"
})

http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = uri.scheme == "https"

req = Net::HTTP::Put.new(uri)

res = http.request(req)
puts JSON.parse(res.body)

<?php
$url = "https://api.apis.guru/v2/specs/azure.com/sql-connectionPolicies/2014-04-01/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/connectionPolicies/{connectionPolicyName}?" . http_build_query([
    "api-version" => "v1"
]);
$opts = ["http" => [
    "method" => "PUT",
]];
$ctx = stream_context_create($opts);
$res = file_get_contents($url, false, $ctx);
print_r(json_decode($res, true));

Postman Setup Guide

Get Postman ↗

See official documentation for authentication and setup.

What can you build with Azure SQL Server API spec?

Azure SQL Server API spec is a Cloud API. Developers commonly use cloud APIs for:

provisioning and managing cloud infrastructure
automating deployments and container orchestration
monitoring uptime and performance metrics
managing storage buckets and databases
setting up auto-scaling and load balancing

No authentication required. This API is open — no signup or key needed. Ideal for quick prototypes and public-facing features. Azure SQL Server API spec is free to use, making it a low-risk choice to experiment with.

New to APIs? Read our beginner's guide · Learn about API keys · What is REST?

Open documentation ↗