name: Microsoft SQL Server APIs
description: >-
  A collection of APIs and interfaces for interacting with Microsoft SQL Server.
url: https://www.microsoft.com/sql-server
type: Index
tags:
  - Azure SQL
  - Cloud Database
  - Data Management
  - Database
  - Microsoft
  - Relational Database
  - SQL
created: '2024'
modified: '2026-04-18'
specificationVersion: '0.19'
access: 3rd-Party
apis:
  - name: SQL Server Database Engine API
    description: >-
      Native database engine APIs for connecting and executing queries against SQL
      Server.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://docs.microsoft.com/en-us/sql/sql-server/
    baseURL: ''
    tags:
      - Database Engine
      - Query Execution
      - T-SQL
    properties:
      - type: Documentation
        url: https://docs.microsoft.com/en-us/sql/connect/
      - type: GettingStarted
        url: https://learn.microsoft.com/en-us/sql/sql-server/educational-sql-resources
      - type: OpenAPI
        url: ''
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: SQL Server REST API
    description: >-
      REST API for managing SQL Server resources in Azure.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://docs.microsoft.com/en-us/rest/api/sql/
    baseURL: https://management.azure.com
    tags:
      - Azure
      - Cloud
      - Management
      - REST
    properties:
      - type: Documentation
        url: https://docs.microsoft.com/en-us/rest/api/sql/
      - type: OpenAPI
        url: https://raw.githubusercontent.com/Azure/azure-rest-api-specs/main/specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/sql.json
      - type: Swagger
        url: https://github.com/Azure/azure-rest-api-specs/tree/main/specification/sql
    contact:
      - FN: Azure Support
        email: azuresupport@microsoft.com
  - name: SQL Server Management Objects (SMO)
    description: >-
      .NET API for programmatically managing SQL Server instances and databases.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://docs.microsoft.com/en-us/sql/relational-databases/server-management-objects-smo/
    baseURL: ''
    tags:
      - .NET
      - Automation
      - Management
      - SMO
    properties:
      - type: Documentation
        url: https://docs.microsoft.com/en-us/sql/relational-databases/server-management-objects-smo/
      - type: NuGet Package
        url: https://www.nuget.org/packages/Microsoft.SqlServer.SqlManagementObjects/
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: SQL Server Reporting Services (SSRS) API
    description: >-
      REST API for managing and accessing SQL Server Reporting Services.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://docs.microsoft.com/en-us/sql/reporting-services/
    baseURL: http://localhost/reports/api/v2.0
    tags:
      - Business Intelligence
      - Reporting
      - REST
      - SSRS
    properties:
      - type: Documentation
        url: https://docs.microsoft.com/en-us/sql/reporting-services/developer/rest-api
      - type: OpenAPI
        url: ''
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: ODBC Driver for SQL Server
    description: >-
      ODBC driver API for connecting applications to SQL Server.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://docs.microsoft.com/en-us/sql/connect/odbc/
    baseURL: ''
    tags:
      - Connectivity
      - Cross-Platform
      - Driver
      - ODBC
    properties:
      - type: Documentation
        url: https://docs.microsoft.com/en-us/sql/connect/odbc/microsoft-odbc-driver-for-sql-server
      - type: Download
        url: https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: JDBC Driver for SQL Server
    description: >-
      JDBC driver for connecting Java applications to SQL Server.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://docs.microsoft.com/en-us/sql/connect/jdbc/
    baseURL: ''
    tags:
      - Connectivity
      - Driver
      - Java
      - JDBC
    properties:
      - type: Documentation
        url: https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server
      - type: Download
        url: https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server
      - type: GitHub
        url: https://github.com/microsoft/mssql-jdbc
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: SQL Server Analysis Services (SSAS) API
    description: >-
      APIs for managing and querying SQL Server Analysis Services.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://docs.microsoft.com/en-us/analysis-services/
    baseURL: ''
    tags:
      - Analysis
      - Business Intelligence
      - OLAP
      - SSAS
    properties:
      - type: Documentation
        url: https://docs.microsoft.com/en-us/analysis-services/instances/analysis-services-instance-management
      - type: PowerShellModule
        url: https://docs.microsoft.com/en-us/analysis-services/instances/install-windows/install-analysis-services
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: Azure SQL Database REST API
    description: >-
      REST API for managing Azure SQL Database resources.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://docs.microsoft.com/en-us/azure/azure-sql/database/
    baseURL: https://management.azure.com
    tags:
      - Azure
      - Cloud
      - PaaS
      - REST
    properties:
      - type: Documentation
        url: https://docs.microsoft.com/en-us/rest/api/sql/
      - type: OpenAPI
        url: https://raw.githubusercontent.com/Azure/azure-rest-api-specs/main/specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/databases.json
    contact:
      - FN: Azure Support
        email: azuresupport@microsoft.com
  - name: Azure SQL Managed Instance REST API
    description: >-
      REST API for creating, configuring, and managing Azure SQL Managed Instances.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/
    baseURL: https://management.azure.com
    tags:
      - Azure
      - Cloud
      - Managed Instance
      - PaaS
      - REST
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/rest/api/sql/managed-instances
      - type: APIReference
        url: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/api-references-create-manage-instance
    contact:
      - FN: Azure Support
        email: azuresupport@microsoft.com
  - name: SQL Server External REST Endpoint Invocation
    description: >-
      Native T-SQL stored procedure sp_invoke_external_rest_endpoint for calling external
      HTTPS REST endpoints directly from SQL Server 2025 and Azure SQL.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-invoke-external-rest-endpoint-transact-sql
    baseURL: ''
    tags:
      - External Endpoints
      - Integration
      - REST
      - SQL Server 2025
      - T-SQL
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-invoke-external-rest-endpoint-transact-sql
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: Data API Builder for SQL Server
    description: >-
      Open-source tool that generates REST and GraphQL endpoints for SQL Server and
      Azure SQL databases from configuration, without writing custom API code.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://learn.microsoft.com/en-us/azure/data-api-builder/
    baseURL: ''
    tags:
      - Azure
      - Data API
      - GraphQL
      - Open Source
      - REST
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/azure/data-api-builder/overview
      - type: GitHub
        url: https://github.com/Azure/data-api-builder
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: ADO.NET Provider for SQL Server (Microsoft.Data.SqlClient)
    description: >-
      The official .NET data provider for Microsoft SQL Server and Azure SQL databases,
      providing ADO.NET access to SQL Server.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://learn.microsoft.com/en-us/sql/connect/ado-net/microsoft-ado-net-sql-server
    baseURL: ''
    tags:
      - .NET
      - ADO.NET
      - Connectivity
      - Driver
      - SqlClient
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/sql/connect/ado-net/introduction-microsoft-data-sqlclient-namespace
      - type: NuGetPackage
        url: https://www.nuget.org/packages/Microsoft.Data.SqlClient
      - type: Download
        url: https://learn.microsoft.com/en-us/sql/connect/ado-net/download-microsoft-sqlclient-data-provider
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: OLE DB Driver for SQL Server
    description: >-
      Stand-alone OLE DB data access API for connecting applications to SQL Server.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://learn.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server
    baseURL: ''
    tags:
      - Connectivity
      - Driver
      - OLE DB
      - Windows
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server
      - type: Download
        url: https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: SQL Server Integration Services (SSIS) API
    description: >-
      Programmable object model for building, managing, and executing ETL data integration
      packages in SQL Server.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services
    baseURL: ''
    tags:
      - Automation
      - Data Integration
      - ETL
      - SSIS
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: Node.js Driver for SQL Server
    description: >-
      Node.js driver (tedious/mssql) for connecting JavaScript and TypeScript applications
      to SQL Server and Azure SQL Database.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://learn.microsoft.com/en-us/sql/connect/node-js/node-js-driver-for-sql-server
    baseURL: ''
    tags:
      - Connectivity
      - Driver
      - JavaScript
      - Node.js
      - Npm
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/sql/connect/node-js/node-js-driver-for-sql-server
      - type: GitHub
        url: https://github.com/tediousjs/node-mssql
      - type: npmPackage
        url: https://www.npmjs.com/package/mssql
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: Python Drivers for SQL Server
    description: >-
      Python drivers for connecting to SQL Server including the first-party mssql-python
      driver, pyodbc, and pymssql.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://learn.microsoft.com/en-us/sql/connect/python/python-driver-for-sql-server
    baseURL: ''
    tags:
      - Connectivity
      - Driver
      - Pymssql
      - Pyodbc
      - Python
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/sql/connect/python/python-driver-for-sql-server
      - type: Documentation
        url: https://learn.microsoft.com/en-us/sql/connect/python/pyodbc/python-sql-driver-pyodbc
      - type: Documentation
        url: https://learn.microsoft.com/en-us/sql/connect/python/mssql-python/python-sql-driver-mssql-python
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: Go Driver for SQL Server
    description: >-
      Microsoft Go driver (go-mssqldb) for connecting Go applications to SQL Server
      and Azure SQL Database using the TDS protocol.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://learn.microsoft.com/en-us/sql/connect/golang/microsoft-go-mssqldb-driver
    baseURL: ''
    tags:
      - Connectivity
      - Driver
      - Go
      - Golang
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/sql/connect/golang/microsoft-go-mssqldb-driver
      - type: GitHub
        url: https://github.com/microsoft/go-mssqldb
      - type: GoPackage
        url: https://pkg.go.dev/github.com/microsoft/go-mssqldb
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: PHP Drivers for SQL Server
    description: >-
      Microsoft Drivers for PHP for SQL Server providing SQLSRV and PDO_SQLSRV extensions
      for connecting PHP applications to SQL Server.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://learn.microsoft.com/en-us/sql/connect/php/microsoft-php-driver-for-sql-server
    baseURL: ''
    tags:
      - Connectivity
      - Driver
      - PDO
      - PHP
      - SQLSRV
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/sql/connect/php/microsoft-php-driver-for-sql-server
      - type: GitHub
        url: https://github.com/microsoft/msphpsql
      - type: Download
        url: https://learn.microsoft.com/en-us/sql/connect/php/download-drivers-php-sql-server
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: Ruby Driver for SQL Server
    description: >-
      Ruby driver (TinyTDS) for connecting Ruby applications to SQL Server using FreeTDS
      DB-Library bindings.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://learn.microsoft.com/en-us/sql/connect/ruby/step-3-proof-of-concept-connecting-to-sql-using-ruby
    baseURL: ''
    tags:
      - Connectivity
      - Driver
      - Ruby
      - TinyTDS
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/sql/connect/ruby/step-3-proof-of-concept-connecting-to-sql-using-ruby
      - type: GitHub
        url: https://github.com/rails-sqlserver/tiny_tds
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: Entity Framework Core SQL Server Provider
    description: >-
      Entity Framework Core database provider enabling .NET object-relational mapping
      with SQL Server and Azure SQL databases.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://learn.microsoft.com/en-us/ef/core/providers/sql-server/
    baseURL: ''
    tags:
      - .NET
      - Driver
      - Entity Framework
      - ORM
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/ef/core/providers/sql-server/
      - type: NuGetPackage
        url: https://www.nuget.org/packages/Microsoft.EntityFrameworkCore.SqlServer
      - type: GitHub
        url: https://github.com/dotnet/efcore
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
  - name: SQL Server PowerShell Module
    description: >-
      PowerShell cmdlets for managing SQL Server instances, databases, and resources
      from the command line.
    image: https://www.microsoft.com/sql-server/images/sql-server-logo.png
    humanURL: https://learn.microsoft.com/en-us/powershell/module/sqlserver/
    baseURL: ''
    tags:
      - Automation
      - CLI
      - Management
      - PowerShell
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/powershell/module/sqlserver/
      - type: Download
        url: https://learn.microsoft.com/en-us/powershell/sql-server/download-sql-server-ps-module
      - type: GitHub
        url: https://github.com/microsoft/SQLServerPSModule
      - type: PowerShellGallery
        url: https://www.powershellgallery.com/packages/SqlServer
    contact:
      - FN: Microsoft Support
        email: support@microsoft.com
integrations:
  - name: Microsoft
  - name: Two people looking at a computer.
  - name: This is placeholder text for
  - name: IDC
  - name: Nationwide
  - name: RSA company
  - name: Teleperformance
  - name: A woman smiling at a laptop
  - name: A man holding a laptop.
maintainers:
  - FN: Kin Lane
    email: kin@apievangelist.com
    url: https://apievangelist.com
common:
  - type: LinkedIn
    url: https://www.linkedin.com/showcase/msft-sql-server
  - type: GettingStarted
    url: https://docs.microsoft.com/en-us/sql/sql-server/
  - type: Pricing
    url: https://www.microsoft.com/en-us/sql-server/sql-server-2022-pricing
  - type: Support
    url: https://support.microsoft.com/sql
  - type: Download
    url: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
  - type: Blog
    url: https://cloudblogs.microsoft.com/sqlserver/
  - type: Community
    url: https://techcommunity.microsoft.com/t5/sql-server/ct-p/SQLServer
  - type: Portal
    url: https://portal.azure.com
  - type: StatusPage
    url: https://azure.microsoft.com/en-us/status/
  - type: Drivers
    url: https://learn.microsoft.com/en-us/sql/connect/sql-connection-libraries
  - type: Learning
    url: https://learn.microsoft.com/en-us/sql/sql-server/educational-sql-resources
  - type: Training
    url: https://learn.microsoft.com/en-us/training/modules/introduction-to-sql-server-2022/
  - type: Certification
    url: https://learn.microsoft.com/en-us/credentials/certifications/azure-database-administrator-associate/
  - type: GitHubRepository
    url: https://github.com/Azure/azure-rest-api-specs/tree/main/specification/sql
  - type: ChangeLog
    url: https://learn.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2022
  - type: TermsOfService
    url: https://www.microsoft.com/en-us/legal/terms-of-use
  - type: PrivacyPolicy
    url: https://privacy.microsoft.com/en-us/privacystatement
  - type: Features
    data:
      - name: T-SQL Query Engine
        description: Full-featured relational database engine with comprehensive T-SQL support for queries, stored procedures, and functions.
      - name: Always On Availability Groups
        description: High availability and disaster recovery with automatic failover for mission-critical databases.
      - name: In-Memory OLTP
        description: Memory-optimized tables and natively compiled stored procedures for high-throughput transaction processing.
      - name: PolyBase
        description: Query external data sources including Hadoop, Azure Blob Storage, and Oracle using T-SQL.
      - name: SQL Server Reporting Services
        description: Enterprise reporting platform for creating, managing, and delivering paginated reports.
      - name: SQL Server Integration Services
        description: ETL platform for building data integration and transformation packages.
      - name: Data API Builder
        description: Generate REST and GraphQL endpoints from database tables and views without custom code.
      - name: External REST Endpoint Invocation
        description: Call external HTTPS REST APIs directly from T-SQL using sp_invoke_external_rest_endpoint.
  - type: UseCases
    data:
      - name: Enterprise Data Management
        description: Store and manage enterprise data with ACID compliance, security, and high availability.
      - name: Business Intelligence
        description: Build BI solutions with reporting services, analysis services, and data integration.
      - name: Cloud Database Migration
        description: Migrate on-premises SQL Server databases to Azure SQL Database or Managed Instance.
      - name: Application Backend
        description: Use SQL Server as the data tier for web, mobile, and enterprise applications.
      - name: Data Warehousing
        description: Build data warehouses with columnstore indexes, partitioning, and ETL pipelines.
  - type: Integrations
    data:
      - name: Azure SQL Database
        description: Cloud-hosted managed SQL database service with automatic backups and scaling.
      - name: Power BI
        description: Connect Power BI to SQL Server for interactive dashboards and reports.
      - name: Azure Data Factory
        description: Orchestrate data movement and transformation pipelines with SQL Server as source or destination.
      - name: Entity Framework Core
        description: Object-relational mapping for .NET applications with the SQL Server provider.
      - name: Visual Studio
        description: Develop and manage SQL Server databases with integrated tools in Visual Studio.
      - name: Azure Synapse Analytics
        description: Extend SQL Server data into cloud-scale analytics with Azure Synapse.
  - type: Integrations
    url: https://www.microsoft.com/en-us/marketplace