Azure SQL Database Database Operations API

The DatabaseOperations API from Azure SQL Database — 2 operation(s) for databaseoperations.

GitHub OpenAPI

Operations 2

GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/operations Database operations list by database #
POST /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/operations/{operationId}/cancel Database operations cancel #

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.
All 92 tools →

Call it yourself

curl for this page
This API
curl "https://apis.io/api/v1/apis/microsoft-azure-sql-database:microsoft-azure-sql-database-databaseoperations-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

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

microsoft-azure-sql-database-databaseoperations-api-openapi.yml Raw ↑
openapi: 3.2.0
info:
  title: SqlManagementClient Database Operations API
  version: '2025-01-01'
  description: The Azure SQL Database management API provides a RESTful set of web APIs that interact with Azure SQL Database services to manage your databases. The API enables users to create, retrieve, update, and delete databases, servers, and other entities.
  x-typespec-generated:
  - emitter: '@azure-tools/typespec-autorest'
servers:
- url: https://management.azure.com
security:
- azure_auth:
  - user_impersonation
tags:
- name: DatabaseOperations
paths:
  ? /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/operations
  : get:
      operationId: DatabaseOperations_ListByDatabase
      tags:
      - DatabaseOperations
      description: Gets a list of operations performed on the database.
      parameters:
      - $ref: '#/components/parameters/ApiVersionParameter'
      - $ref: '#/components/parameters/SubscriptionIdParameter'
      - $ref: '#/components/parameters/ResourceGroupNameParameter'
      - name: serverName
        in: path
        description: The name of the server.
        required: true
        schema:
          type: string
      - name: databaseName
        in: path
        description: The name of the database.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: Azure operation completed successfully.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DatabaseOperationListResult'
        default:
          description: An unexpected error response.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
      x-ms-pageable:
        nextLinkName: nextLink
      summary: Database operations list by database
      x-summary-source: derived
  ? /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/operations/{operationId}/cancel
  : post:
      operationId: DatabaseOperations_Cancel
      tags:
      - DatabaseOperations
      description: Cancels the asynchronous operation on the database.
      parameters:
      - $ref: '#/components/parameters/ApiVersionParameter'
      - $ref: '#/components/parameters/SubscriptionIdParameter'
      - $ref: '#/components/parameters/ResourceGroupNameParameter'
      - name: serverName
        in: path
        description: The name of the server.
        required: true
        schema:
          type: string
      - name: databaseName
        in: path
        description: The name of the database.
        required: true
        schema:
          type: string
      - name: operationId
        in: path
        description: The operation identifier.
        required: true
        schema:
          type: string
          format: uuid
      responses:
        '200':
          description: The request has succeeded.
        default:
          description: An unexpected error response.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
      summary: Database operations cancel
      x-summary-source: derived
components:
  schemas:
    PhaseDetails:
      type: object
      description: The phase details properties of a database operation.
      properties:
        phase:
          $ref: '#/components/schemas/Phase'
          description: The operation phase.
          readOnly: true
        phaseInformation:
          type: object
          description: The operation phase information.
          additionalProperties:
            type: string
          readOnly: true
    DatabaseOperationProperties:
      type: object
      description: The properties of a database operation.
      properties:
        databaseName:
          type: string
          description: The name of the database the operation is being performed on.
          readOnly: true
        operation:
          type: string
          description: The name of operation.
          readOnly: true
        operationFriendlyName:
          type: string
          description: The friendly name of operation.
          readOnly: true
        percentComplete:
          type: integer
          format: int32
          description: The percentage of the operation completed.
          readOnly: true
        serverName:
          type: string
          description: The name of the server.
          readOnly: true
        startTime:
          type: string
          format: date-time
          description: The operation start time.
          readOnly: true
        state:
          $ref: '#/components/schemas/ManagementOperationState'
          description: The operation state.
          readOnly: true
        errorCode:
          type: integer
          format: int32
          description: The operation error code.
          readOnly: true
        errorDescription:
          type: string
          description: The operation error description.
          readOnly: true
        errorSeverity:
          type: integer
          format: int32
          description: The operation error severity.
          readOnly: true
        isUserError:
          type: boolean
          description: Whether or not the error is a user error.
          readOnly: true
        estimatedCompletionTime:
          type: string
          format: date-time
          description: The estimated completion time of the operation.
          readOnly: true
        description:
          type: string
          description: The operation description.
          readOnly: true
        isCancellable:
          type: boolean
          description: Whether the operation can be cancelled.
          readOnly: true
        operationPhaseDetails:
          $ref: '#/components/schemas/PhaseDetails'
          description: The operation phase details.
          readOnly: true
    DatabaseOperation:
      type: object
      description: A database operation.
      properties:
        properties:
          $ref: '#/components/schemas/DatabaseOperationProperties'
          description: Resource properties.
          x-ms-client-flatten: true
      allOf:
      - $ref: '#/components/schemas/ProxyResource'
    ProxyResource:
      type: object
      title: Proxy Resource
      description: The resource model definition for a Azure Resource Manager proxy resource. It will not have tags and a location
      allOf:
      - $ref: '#/components/schemas/Resource'
    Phase:
      type: string
      description: The operation phase.
      enum:
      - LogTransitionInProgress
      - Copying
      - BuildingHyperscaleComponents
      - Catchup
      - WaitingForCutover
      - CutoverInProgress
      x-ms-enum:
        name: Phase
        modelAsString: true
        values:
        - name: LogTransitionInProgress
          value: LogTransitionInProgress
          description: LogTransitionInProgress
        - name: Copying
          value: Copying
          description: Copying
        - name: BuildingHyperscaleComponents
          value: BuildingHyperscaleComponents
          description: BuildingHyperscaleComponents
        - name: Catchup
          value: Catchup
          description: Catchup
        - name: WaitingForCutover
          value: WaitingForCutover
          description: WaitingForCutover
        - name: CutoverInProgress
          value: CutoverInProgress
          description: CutoverInProgress
    ErrorResponse:
      type: object
      title: Error response
      description: Common error response for all Azure Resource Manager APIs to return error details for failed operations. (This also follows the OData error response format.).
      properties:
        error:
          $ref: '#/components/schemas/ErrorDetail'
          description: The error object.
    DatabaseOperationListResult:
      type: object
      description: The response of a DatabaseOperation list operation.
      properties:
        value:
          type: array
          description: The DatabaseOperation items on this page
          items:
            $ref: '#/components/schemas/DatabaseOperation'
        nextLink:
          type: string
          format: uri
          description: The link to the next page of items
      required:
      - value
    ManagementOperationState:
      type: string
      description: The operation state.
      enum:
      - Pending
      - InProgress
      - Succeeded
      - Failed
      - CancelInProgress
      - Cancelled
      x-ms-enum:
        name: ManagementOperationState
        modelAsString: true
        values:
        - name: Pending
          value: Pending
          description: Pending
        - name: InProgress
          value: InProgress
          description: InProgress
        - name: Succeeded
          value: Succeeded
          description: Succeeded
        - name: Failed
          value: Failed
          description: Failed
        - name: CancelInProgress
          value: CancelInProgress
          description: CancelInProgress
        - name: Cancelled
          value: Cancelled
          description: Cancelled
  parameters:
    ResourceGroupNameParameter:
      name: resourceGroupName
      in: path
      description: The name of the resource group. The name is case insensitive.
      required: true
      x-ms-parameter-location: method
      schema:
        type: string
        maxLength: 90
        minLength: 1
    SubscriptionIdParameter:
      name: subscriptionId
      in: path
      description: The ID of the target subscription. The value must be an UUID.
      required: true
      schema:
        type: string
        format: uuid
    ApiVersionParameter:
      name: api-version
      in: query
      description: The API version to use for this operation.
      required: true
      schema:
        type: string
        minLength: 1
  securitySchemes:
    azure_auth:
      type: oauth2
      flows:
        implicit:
          scopes:
            user_impersonation: impersonate your user account
          authorizationUrl: https://login.microsoftonline.com/common/oauth2/authorize
      description: Azure Active Directory OAuth2 Flow.