Azure Synapse Analytics SQL Pools API
Manage dedicated SQL pools
Work with this as data
Every API here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for apis
7 MCP tools reach this
find_apisBrowse and filter every API in the catalog.get_api_artifactsOne API's artifacts, grouped by type.get_openapiThe primary OpenAPI for this API.find_similar_apisAPIs that look like this one.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This API
curl "https://apis.io/api/v1/apis/azure-synapse-sql-pools-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.
OpenAPI Specification
openapi: 3.2.0
info:
title: Azure Synapse Analytics Spark Pools SQL Pools API
description: REST API for managing Azure Synapse Analytics workspaces, SQL pools, Apache Spark pools, and data integration pipelines.
version: '2021-06-01'
x-generated-from: documentation
servers:
- url: https://management.azure.com
description: Azure Resource Manager
security:
- azure_auth:
- user_impersonation
tags:
- name: SQL Pools
description: Manage dedicated SQL pools
paths:
? /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools
: get:
operationId: SqlPools_ListByWorkspace
summary: Azure Synapse List SQL Pools
description: List SQL pools in a workspace.
tags:
- SQL Pools
parameters:
- name: subscriptionId
in: path
required: true
schema:
type: string
example: 00000000-0000-0000-0000-000000000000
- name: resourceGroupName
in: path
required: true
schema:
type: string
example: my-resource-group
- name: workspaceName
in: path
required: true
schema:
type: string
example: my-synapse-workspace
- name: api-version
in: query
required: true
schema:
type: string
example: '2021-06-01'
responses:
'200':
description: List of SQL pools
content:
application/json:
schema:
$ref: '#/components/schemas/SqlPoolInfoListResult'
examples:
SqlPools_ListByWorkspace200Example:
summary: Default SqlPools_ListByWorkspace 200 response
x-microcks-default: true
value:
id: example-id
name: example
provisioningState: Succeeded
x-microcks-operation:
delay: 0
dispatcher: FALLBACK
components:
schemas:
SqlPool:
type: object
description: A SQL pool resource.
properties:
id:
type: string
readOnly: true
name:
type: string
readOnly: true
location:
type: string
tags:
type: object
additionalProperties:
type: string
sku:
type: object
properties:
tier:
type: string
name:
type: string
capacity:
type: integer
properties:
type: object
properties:
provisioningState:
type: string
readOnly: true
status:
type: string
readOnly: true
restorePointInTime:
type: string
format: date-time
SqlPoolInfoListResult:
type: object
properties:
value:
type: array
items:
$ref: '#/components/schemas/SqlPool'
nextLink:
type: string
securitySchemes:
azure_auth:
type: oauth2
flows:
implicit:
authorizationUrl: https://login.microsoftonline.com/common/oauth2/authorize
scopes:
user_impersonation: Impersonate your user account