# Microsoft SQL Server APIs

**Canonical:** https://apis.io/providers/sql-server/  
**Website:** https://portal.azure.com  
**APIs profiled:** 21

A collection of APIs and interfaces for interacting with Microsoft SQL Server.

## Kin Score — 41.0 / 100 (developing)

Scored 2026-08-21 under rubric 0.12.0. Trend: flat (+0.0 from 41.0).

| Facet | Score |
|---|---|
| Discoverability | 81.5 |
| Contract Quality | 28.2 |
| Governance | 4.5 |
| Contract Governance | 4.5 |
| Operational Transparency | 39.5 |
| Developer Ergonomics | 45.2 |
| Commercial Clarity | 55.3 |
| Access Clarity | 55.3 |

## Agent readiness — 33.6 (agent-aware)

| Dimension | Value |
|---|---|
| Spec Presence | yes |
| Agentic Access | no |
| Reversibility Documented | no |
| MCP Server | documented |
| Auth Clarity | yes |
| Idempotency | no |
| Error Semantics | no |
| OpenAPI Examples | no |
| Rate Limit Signal | documented |
| Event Surface Described | no |
| Agent Skills | no |
| Well Known Catalog | no |
| Consent Identity | yes |
| Agent Card | no |
| Dry Run Mode | no |

## Access

Freemium · Self-serve signup — onboarding: self-serve, pricing: freemium, trial: no (confidence: high).

## APIs (21)

- **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.

## MCP servers (1)

- **SQL MCP Server** — Microsoft's official open-source MCP server for SQL Server, Azure SQL and other databases. Built into Data API builder (DAB) 1.7+ (latest capabilities in DAB 2.0). Self-hosted; ...

## Security (4)

- **Sql Server Authentication** — sql-login/windows-integrated/oauth2/mutualTLS · 0 schemes
- **Sql Server Domain Security** — TLSv1.3 · HSTS · DMARC
- **Sql Server Vulnerability Disclosure** — security.txt · contact published
- **Sql Server Trust Center** — SOC 1, SOC 2, SOC 3, ISO 27001, ISO 27017, ISO 27018, PCI DSS, HIPAA / HITRUST, FedRAMP, GDPR, CSA STAR

## Plans (1)

- **Sql Server Plans Pricing**

## Use cases (5)

- **Enterprise Data Management** — Store and manage enterprise data with ACID compliance, security, and high availability.
- **Business Intelligence** — Build BI solutions with reporting services, analysis services, and data integration.
- **Cloud Database Migration** — Migrate on-premises SQL Server databases to Azure SQL Database or Managed Instance.
- **Application Backend** — Use SQL Server as the data tier for web, mobile, and enterprise applications.
- **Data Warehousing** — Build data warehouses with columnstore indexes, partitioning, and ETL pipelines.

## Tags

Azure SQL, Cloud Database, Data Management, Database, Microsoft, Relational Database, SQL

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/providers/sql-server/). Scores are computed from the provider's own public artifacts under a published rubric.