Microsoft SQL Server APIs

SQL Server Database Engine API

Native database engine APIs for connecting and executing queries against SQL Server.

SQL Server REST API

REST API for managing SQL Server resources in Azure.

SQL Server Management Objects (SMO)

.NET API for programmatically managing SQL Server instances and databases.

SQL Server Reporting Services (SSRS) API

REST API for managing and accessing SQL Server Reporting Services.

ODBC Driver for SQL Server

ODBC driver API for connecting applications to SQL Server.

JDBC Driver for SQL Server

JDBC driver for connecting Java applications to SQL Server.

SQL Server Analysis Services (SSAS) API

APIs for managing and querying SQL Server Analysis Services.

Azure SQL Database REST API

REST API for managing Azure SQL Database resources.

Azure SQL Managed Instance REST API

REST API for creating, configuring, and managing Azure SQL Managed Instances.

SQL Server External REST Endpoint Invocation

Native T-SQL stored procedure sp_invoke_external_rest_endpoint for calling external HTTPS REST endpoints directly from SQL Server 2025 and Azure SQL.

Data API Builder for SQL Server

Open-source tool that generates REST and GraphQL endpoints for SQL Server and Azure SQL databases from configuration, without writing custom API code.

ADO.NET Provider for SQL Server (Microsoft.Data.SqlClient)

The official .NET data provider for Microsoft SQL Server and Azure SQL databases, providing ADO.NET access to SQL Server.

OLE DB Driver for SQL Server

Stand-alone OLE DB data access API for connecting applications to SQL Server.

SQL Server Integration Services (SSIS) API

Programmable object model for building, managing, and executing ETL data integration packages in SQL Server.

Node.js Driver for SQL Server

Node.js driver (tedious/mssql) for connecting JavaScript and TypeScript applications to SQL Server and Azure SQL Database.

Python Drivers for SQL Server

Python drivers for connecting to SQL Server including the first-party mssql-python driver, pyodbc, and pymssql.

Go Driver for SQL Server

Microsoft Go driver (go-mssqldb) for connecting Go applications to SQL Server and Azure SQL Database using the TDS protocol.

PHP Drivers for SQL Server

Microsoft Drivers for PHP for SQL Server providing SQLSRV and PDO_SQLSRV extensions for connecting PHP applications to SQL Server.

Ruby Driver for SQL Server

Ruby driver (TinyTDS) for connecting Ruby applications to SQL Server using FreeTDS DB-Library bindings.

Entity Framework Core SQL Server Provider

Entity Framework Core database provider enabling .NET object-relational mapping with SQL Server and Azure SQL databases.

SQL Server PowerShell Module

PowerShell cmdlets for managing SQL Server instances, databases, and resources from the command line.

Full-featured relational database engine with comprehensive T-SQL support for queries, stored procedures, and functions.

High availability and disaster recovery with automatic failover for mission-critical databases.

Memory-optimized tables and natively compiled stored procedures for high-throughput transaction processing.

Query external data sources including Hadoop, Azure Blob Storage, and Oracle using T-SQL.

Enterprise reporting platform for creating, managing, and delivering paginated reports.

ETL platform for building data integration and transformation packages.

Generate REST and GraphQL endpoints from database tables and views without custom code.

Call external HTTPS REST APIs directly from T-SQL using sp_invoke_external_rest_endpoint.

Store and manage enterprise data with ACID compliance, security, and high availability.

Build BI solutions with reporting services, analysis services, and data integration.

Migrate on-premises SQL Server databases to Azure SQL Database or Managed Instance.

Use SQL Server as the data tier for web, mobile, and enterprise applications.

Build data warehouses with columnstore indexes, partitioning, and ETL pipelines.

Cloud-hosted managed SQL database service with automatic backups and scaling.

Connect Power BI to SQL Server for interactive dashboards and reports.

Orchestrate data movement and transformation pipelines with SQL Server as source or destination.

Object-relational mapping for .NET applications with the SQL Server provider.

Develop and manage SQL Server databases with integrated tools in Visual Studio.

Extend SQL Server data into cloud-scale analytics with Azure Synapse.