Microsoft SQL Server

A relational database management system developed by Microsoft for enterprise-scale data management and business intelligence solutions.

14 APIs 0 Features

CloudData ManagementDatabaseEnterpriseRelational DatabaseSQL

APIs

SQL Server Database Engine API

Core database engine APIs for querying, managing, and administering SQL Server databases.

SQL Server Management Objects (SMO) API

.NET API for managing and administering SQL Server programmatically.

Azure SQL Database REST API

REST API for managing Azure SQL Database resources and configurations.

SQL Server Reporting Services (SSRS) API

REST API for managing reports, subscriptions, and data sources in SQL Server Reporting Services.

SQL Server Integration Services (SSIS) Catalog API

API for managing SSIS packages, projects, and execution in the SSIS Catalog.

Azure SQL Managed Instance REST API

REST API for creating, configuring, and managing Azure SQL Managed Instances including databases, operations, and scheduling.

Data API Builder

Open source configuration-based engine that creates REST and GraphQL APIs for SQL Server, Azure SQL, Azure Cosmos DB, PostgreSQL, and MySQL databases.

Azure Analysis Services REST API

REST API for managing Azure Analysis Services resources and performing asynchronous data refreshes of tabular models.

Microsoft SqlClient Data Provider (ADO.NET)

ADO.NET data provider for .NET Framework and .NET Core used for connecting to SQL Server, executing commands, and retrieving results.

Microsoft JDBC Driver for SQL Server

Type 4 JDBC driver providing database connectivity to SQL Server through standard JDBC application program interfaces on the Java platform.

Microsoft ODBC Driver for SQL Server

ODBC driver providing native-code API connectivity to SQL Server and Azure SQL Database for applications on Windows, Linux, and macOS.

Microsoft OLE DB Driver for SQL Server

Stand-alone OLE DB data access API for low-level COM components requiring high-performance access to SQL Server.

Microsoft Python Driver for SQL Server (mssql-python)

Python driver using Direct Database Connectivity for direct connections to SQL Server without requiring an external driver manager, compliant with Python DB-API 2.0.

Node.js Driver for SQL Server (tedious)

Open-source JavaScript implementation of the TDS protocol for connecting to SQL Server from Node.js on Windows, Linux, or macOS.

Collections

Microsoft SQL Server - Azure SQL & Data API Builder HTTP APIs

OPEN

GraphQL

Microsoft SQL Server GraphQL API

Open source configuration-based engine that creates REST and GraphQL APIs for SQL Server, Azure SQL, Azure Cosmos DB, PostgreSQL, and MySQL databases.

GRAPHQL

Pricing Plans

Microsoft Sql Server Plans Pricing

3 plans

PLANS

Rate Limits

Microsoft Sql Server Rate Limits

5 limits

RATE LIMITS

FinOps

Microsoft Sql Server Finops

FINOPS

Resources

GitHubOrganization

Sources

opencollection: 1.0.0
info:
  name: Microsoft SQL Server - Azure SQL & Data API Builder HTTP APIs
  version: '2025-01-01'
request:
  auth:
    type: oauth2
    flow: client_credentials
    accessTokenUrl: https://login.microsoftonline.com/common/oauth2/v2.0/token
    credentials:
      clientId: '{{clientId}}'
      clientSecret: '{{clientSecret}}'
items:
- info:
    name: Azure SQL Databases
    type: folder
  items:
  - info:
      name: List databases on an Azure SQL Server
      type: http
    http:
      method: GET
      url: https://management.azure.com/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases
      params:
      - name: subscriptionId
        value: ''
        type: path
      - name: resourceGroupName
        value: ''
        type: path
      - name: serverName
        value: ''
        type: path
      - name: api-version
        value: ''
        type: query
    docs: List databases on an Azure SQL Server
  - info:
      name: Get a database
      type: http
    http:
      method: GET
      url: https://management.azure.com/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName
      params:
      - name: subscriptionId
        value: ''
        type: path
      - name: resourceGroupName
        value: ''
        type: path
      - name: serverName
        value: ''
        type: path
      - name: databaseName
        value: ''
        type: path
      - name: api-version
        value: ''
        type: query
    docs: Get a database
  - info:
      name: Create or update a database
      type: http
    http:
      method: PUT
      url: https://management.azure.com/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName
      params:
      - name: subscriptionId
        value: ''
        type: path
      - name: resourceGroupName
        value: ''
        type: path
      - name: serverName
        value: ''
        type: path
      - name: databaseName
        value: ''
        type: path
      - name: api-version
        value: ''
        type: query
      body:
        type: json
        data: '{}'
    docs: Create or update a database
  - info:
      name: Delete a database
      type: http
    http:
      method: DELETE
      url: https://management.azure.com/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName
      params:
      - name: subscriptionId
        value: ''
        type: path
      - name: resourceGroupName
        value: ''
        type: path
      - name: serverName
        value: ''
        type: path
      - name: databaseName
        value: ''
        type: path
      - name: api-version
        value: ''
        type: query
    docs: Delete a database
  - info:
      name: Failover a database
      type: http
    http:
      method: POST
      url: https://management.azure.com/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName/failover
      params:
      - name: subscriptionId
        value: ''
        type: path
      - name: resourceGroupName
        value: ''
        type: path
      - name: serverName
        value: ''
        type: path
      - name: databaseName
        value: ''
        type: path
      - name: api-version
        value: ''
        type: query
    docs: Failover a database
- info:
    name: Azure SQL Servers
    type: folder
  items:
  - info:
      name: List SQL servers in a resource group
      type: http
    http:
      method: GET
      url: https://management.azure.com/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers
      params:
      - name: subscriptionId
        value: ''
        type: path
      - name: resourceGroupName
        value: ''
        type: path
      - name: api-version
        value: ''
        type: query
    docs: List SQL servers in a resource group
- info:
    name: Data API Builder
    type: folder
  items:
  - info:
      name: List records from a DAB entity
      type: http
    http:
      method: GET
      url: https://management.azure.com/api/:entity
      params:
      - name: entity
        value: ''
        type: path
        description: Name of the entity exposed by Data API Builder.
      - name: $select
        value: ''
        type: query
      - name: $filter
        value: ''
        type: query
      - name: $orderby
        value: ''
        type: query
      - name: $first
        value: ''
        type: query
      - name: $after
        value: ''
        type: query
    docs: List records from a DAB entity
  - info:
      name: Create a new record
      type: http
    http:
      method: POST
      url: https://management.azure.com/api/:entity
      params:
      - name: entity
        value: ''
        type: path
        description: Name of the entity exposed by Data API Builder.
      body:
        type: json
        data: '{}'
    docs: Create a new record
  - info:
      name: Get a single record by primary key
      type: http
    http:
      method: GET
      url: https://management.azure.com/api/:entity/:pkColumn/:pkValue
      params:
      - name: entity
        value: ''
        type: path
        description: Name of the entity exposed by Data API Builder.
      - name: pkColumn
        value: ''
        type: path
      - name: pkValue
        value: ''
        type: path
    docs: Get a single record by primary key
  - info:
      name: Replace a record (or upsert when supported)
      type: http
    http:
      method: PUT
      url: https://management.azure.com/api/:entity/:pkColumn/:pkValue
      params:
      - name: entity
        value: ''
        type: path
        description: Name of the entity exposed by Data API Builder.
      - name: pkColumn
        value: ''
        type: path
      - name: pkValue
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Replace a record (or upsert when supported)
  - info:
      name: Update a record
      type: http
    http:
      method: PATCH
      url: https://management.azure.com/api/:entity/:pkColumn/:pkValue
      params:
      - name: entity
        value: ''
        type: path
        description: Name of the entity exposed by Data API Builder.
      - name: pkColumn
        value: ''
        type: path
      - name: pkValue
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Update a record
  - info:
      name: Delete a record
      type: http
    http:
      method: DELETE
      url: https://management.azure.com/api/:entity/:pkColumn/:pkValue
      params:
      - name: entity
        value: ''
        type: path
        description: Name of the entity exposed by Data API Builder.
      - name: pkColumn
        value: ''
        type: path
      - name: pkValue
        value: ''
        type: path
    docs: Delete a record
bundled: true