Feature availability for Data API builder

These tables list the features available in Data API builder (DAB).

Database version

Database	Abbreviation	Min. Version
SQL Server	SQL Family	Version 2016
Azure SQL	SQL Family	N/A (PaaS)
Microsoft Fabric SQL	SQL Family	N/A (PaaS)
Azure Cosmos DB for NoSQL	Cosmos DB	N/A (PaaS)
PostgreSQL	PGSQL	Version 11
MySQL	MySQL	Version 8
Azure Synapse Analytics (Dedicated SQL pool)	SQLDW¹	N/A (PaaS)

Cloud and hosting environments

The key to this table is that Data API builder can run in any environment with container support.

Environment	Supported
Microsoft Azure	✅ Yes
Amazon Web Services (AWS)	✅ Yes
Google Cloud Platform (GCP)	✅ Yes
Oracle Cloud Infrastructure (OCI)	✅ Yes
IBM Cloud	✅ Yes
Alibaba Cloud	✅ Yes
On-premises	✅ Yes

GraphQL

Feature	SQL Family	Cosmos DB	PGSQL	MySQL	SQLDW¹
Pagination	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Throttling	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Filtering	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Aggregation	✅ Yes	✖️ No	✖️ No	✖️ No	✅ Yes
Sorting	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
Selection	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Query-type	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Mutation-type	✅ Yes	⚠️ Partial	✅ Yes	✅ Yes	✅ Yes
Multi-Mutation	✅ Yes	✖️ No	✖️ No	✖️ No	✖️ No
Advanced GroupBy	✅ Yes	✖️ No	✖️ No	✖️ No	✅ Yes
Advanced Having	✅ Yes	✖️ No	✖️ No	✖️ No	✅ Yes
Schema Generation	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Schema Attribute (@model)	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No
Schema Attribute (@authorize)	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No
User Provided Schema	✖️ No	✅ Yes	✖️ No	✖️ No	✖️ No
Subscription	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No
Nitro	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Cache Headers	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
Level 1 Cache: Memory	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
Level 2 Cache: Redis	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes

GraphQL Relationship Navigation

Feature	SQL Family	Cosmos DB	PGSQL	MySQL	SQLDW¹
One-To-Many / Query	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
One-To-Many / Mutation	✅ Yes	✖️ No	✖️ No	✖️ No	✅ Yes
Many-To-Many / Query	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
Many-To-Many / Mutation	✅ Yes	✖️ No	✖️ No	✖️ No	✅ Yes
Cross-Source Relationships	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No
Cross-Source Joins	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No

REST

Feature	SQL Family	Cosmos DB²	PGSQL	MySQL	SQLDW¹
PUT	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
POST	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
PATCH	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
DELETE	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
GET	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
Pagination	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
OData-like $Select	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
OData-like $Filter	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
OData-like $Count	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No
OData-like $OrderBy	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
OData-like $First	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
$After (Cursor paging)	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
OpenAPI Document	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
Swagger UI	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
Cache Headers	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
Level 1 Cache: Memory	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
Level 2 Cache: Redis	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
POCO-ready Payload	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
OpenAPIReference	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No

Supported Database Objects

Feature	SQL Family	Cosmos DB	PGSQL	MySQL	SQLDW¹
Tables	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
Views	✅ Yes	✖️ No	✅ Yes	✖️ No	✅ Yes
Stored Procedures	✅ Yes	✖️ No	✖️ No	✖️ No	✅ Yes
Proc Parameters	✅ Yes	✖️ No	✖️ No	✖️ No	✅ Yes
Functions	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No
Collections	✖️ No	✅ Yes	✖️ No	✖️ No	✖️ No
Field Mapping	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes

Entity Permissions

Feature	SQL Family	Cosmos DB	PGSQL	MySQL	SQLDW¹
Create	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Read	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Update	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Delete	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Execute	✅ Yes	✖️ No	✖️ No	✖️ No	✅ Yes
Include Fields	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Exclude Fields	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes

Database Policy

Feature	SQL Family	Cosmos DB	PGSQL	MySQL	SQLDW¹
Create	✅ Yes	✖️ No	✖️ No	✖️ No	✅ Yes
Read	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
Update	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
Delete	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
Execute	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No
Single-Table Policies	✅ Yes	✖️ No	✖️ No	✖️ No	✅ Yes
Multi-Table Policies	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No
Request Policy	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No

Authentication Features

Feature	SQL Family	Cosmos DB	PGSQL	MySQL	SQLDW¹
UAMI (Entra ID)⁴	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
SAMI (Entra ID)⁴	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Azure EasyAuth	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Pass-through security	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No
API-key security	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No

Other Features

Feature	SQL Family	Cosmos DB	PGSQL	MySQL	SQLDW¹
Native JSON Support	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No
Native XML Support	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No
Native Vector Support	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No
Application Insights	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Log Analytics	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
File Logging	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Session Context	✅ Yes	✖️ No	✖️ No	✖️ No	✖️ No
Multiple Data Sources	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Cross-Source Join	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No
OpenTelemetry	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Health Endpoints	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Custom Log Levels	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
.NET Aspire	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
MCP³	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes

MCP Server

Note

MCP Server features require Data API builder version 1.7 or later.

Feature	SQL Family	Cosmos DB	PGSQL	MySQL	SQLDW¹
DML-tool: CREATE	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
DML-tool: READ	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
DML-tool: UPDATE	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
DML-tool: DELETE	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
DML-tool: EXECUTE	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
DML-tool: DESCRIBE	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Stored Procedure as Tool	✅ Yes	✖️ No	✖️ No	✖️ No	✅ Yes
Server Instructions	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Object metadata	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Field metadata	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Parameter metadata	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
READ: Pagination	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
READ: $Select	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
READ: $Filter	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
READ: $Count	✖️ No	✖️ No	✖️ No	✖️ No	✖️ No
READ: $OrderBy	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
READ: $First	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes
READ: $After	✅ Yes	✖️ No	✅ Yes	✅ Yes	✅ Yes

Azure Support (containers)

Feature	SQL Family	Cosmos DB	PGSQL	MySQL	SQLDW¹
Azure Container Apps	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Azure Container Instances	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Azure Kubernetes Services	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Azure Web App for Containers	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Azure Red Hat OpenShift	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Azure Spring Apps	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Azure Service Fabric	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes
Azure Virtual Machine	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes

Unsupported data types

Data API builder doesn't support some data types for each database platform. These limitations are typically due to serialization constraints or lack of native support in the underlying database driver.

SQL Server and Azure SQL

Data type	Description
geography	Geospatial data representing Earth's surface.
geometry	Planar spatial data using Cartesian coordinates.
hierarchyid	Hierarchical data management.
json	JSON formatted data (currently in preview).
rowversion	Row versioning for concurrency control.
sql_variant	Values of various SQL Server-supported data types.
vector	Vector data (currently in preview).
xml	XML formatted data.

PostgreSQL

Data type	Description
bytea	Binary string storage.
date	Calendar dates (year, month, day).
smalldatetime	Less precise date and time storage.
datetime2	Not native; typically handled by timestamp.
timestamptz	Dates and times with time zone.
time	Time of day without date.
localtime	Current time based on system clock.

MySQL

Data type	Description
UUID	Universally Unique Identifiers.
DATE	Calendar dates.
SMALLDATETIME	Less precise date and time storage.
DATETIME2	Not native; typically handled by datetime.
DATETIMEOFFSET	Dates and times with time zone.
TIME	Time of day without date.
LOCALTIME	Current time based on system clock.

Azure Cosmos DB for NoSQL

Azure Cosmos DB for NoSQL is schema-agnostic, so data type restrictions don't apply in the same way as relational databases.

Footnotes

¹ SQLDW reflects support for Dedicated SQL pool only. Serverless SQL pool isn't supported.

² Cosmos DB is supported in DAB via GraphQL. DAB doesn't generate REST endpoints for Cosmos DB because the API for NoSQL provides a native REST API. For more information, see Azure Cosmos DB: REST API Reference.

³ MCP (Model Context Protocol) is an endpoint-level capability, not database-specific.

⁴ Managed identity support uses Azure DefaultAzureCredential, which supports both System-Assigned (SAMI) and User-Assigned (UAMI) managed identities. UAMI requires setting the AZURE_CLIENT_ID environment variable.

⚠️ Partial for Cosmos DB mutations means basic create, update, and delete operations are supported, but not all mutation types (such as multi-mutation) are available.