#167167th of 204 in Backends, databases and hosting
data-api-builder
Generates REST, GraphQL and MCP endpoints from SQL and Cosmos DB schemas
- Stars
- 1.5k
- License
- MIT
- Last commit
- Nov 2026
- Last release
- Oct 2026
- Language
- C#
1,370 on 25 Apr 20261,546 on 14 Nov 2026
From GitHub's daily star counts.
Checked on GitHub.
Overview
Data API builder (DAB) reads a JSON config and exposes tables, views and stored procedures as REST, GraphQL and MCP endpoints, translating requests to SQL at runtime. It supports Azure SQL, SQL Server, SQLDW, Cosmos DB, PostgreSQL and MySQL, and installs as a .NET global tool (`dab`) that needs .NET 8 or later. In production it runs as a container.
Who it is for: Developers who want a REST, GraphQL or MCP API over an existing database
Strengths
- No-code: endpoints come from dab-config.json, with CLI commands `dab init` and `dab add`
- Covers Azure SQL, SQL Server, SQLDW, Cosmos DB, PostgreSQL and MySQL
- Serves REST, GraphQL and MCP from one config, with per-role entity permissions
- Development mode enables Swagger and Nitro UIs plus a /health endpoint
Weaknesses
- Exposes existing database objects only; no auth, storage or hosting beyond the data API
- CLI needs .NET 8 or later installed
- Default config uses the AppService auth provider, so other providers need extra setup
- Branded for Azure databases, so some docs and samples assume Azure
What it needs
- no GPU
- Docker
- Needs NET 8 runtime or later, One of: Azure SQL, SQL Server, SQLDW, Cosmos DB, PostgreSQL, MySQL
- port 5000
What changed
From the release notes. No flag means the note does not say so, not that the upgrade is safe.
Known problems
Open now, reported in the last 90 days
- [Bug]: Two relationships to the same target entity return null in 2.0.12 ↗ (opens in a new tab)1 reactions
- [Documentation] Missing documentation on Microsoft.DataApiBuilder.Core usage and extension possibilities ↗ (opens in a new tab)1 reactions
- Mark MCP tools as readonly for M365 federated connector support. ↗ (opens in a new tab)1 reactions
- Complete PostgreSQL Concurrent Upsert Support for All Primary Key Types ↗ (opens in a new tab)1 reactions
Reported, then fixed by a linked change
- [Bug]: Special characters in filter clause ↗ (opens in a new tab)9 reactions · closed 25 Feb 2026Fixed by Fix: URL-encoded special characters in $filter and $orderby break OData parsing ↗ (opens in a new tab)
- [Bug]: `autoentities` in a child configuration file (referenced via `data-source-files`) is not recognized — validation fails with "No entities found" ↗ (opens in a new tab)4 reactions · closed 30 Sept 2026Fixed by Fix: child-config `autoentities` fails validation with "No entities found" when using `data-source-files` ↗ (opens in a new tab)
- [Bug]: KeyNotFoundException when querying multiple nested relationships ↗ (opens in a new tab)4 reactions · closed 14 Jan 2026Fixed by Bug fix for pagination nested entities resulting key not found error. ↗ (opens in a new tab)
- --mcp-stdio blocks initialize response until all schema introspection completes, causing MCP reconnect timeouts ↗ (opens in a new tab)3 reactions · closed 29 Sept 2026Fixed by [MCP] Respond to stdio initialize before metadata inference ↗ (opens in a new tab)
- [Bug]: Swagger/OpenAPI fails with Custom Auth in DAB 1.7.93: No authentication handler is registered for OAuthAuthentication ↗ (opens in a new tab)2 reactions · closed 29 Sept 2026Fixed by Resolve Custom JWT auth provider to the registered Bearer scheme ↗ (opens in a new tab)
Titles are the reporters' own words, taken from the project's GitHub issues and ranked by reactions. We have not tried to reproduce any of them.
Also in Backends, databases and hosting
See all 204| Rank | Project | Score |
|---|---|---|
| 1 | bunJavaScript and TypeScript runtime with bundler, test runner and package manager | 94 out of 100 |
| 2 | coolifySelf-hosted Heroku and Vercel alternative that deploys apps and databases over SSH | 93 out of 100 |
| 3 | strapiHeadless CMS that generates REST and GraphQL APIs from content models | 92 out of 100 |
| #4 | traefikHTTP reverse proxy and load balancer that auto-discovers routes from orchestrators | 92 out of 100 |
| #5 | appwriteBackend with auth, databases, storage, functions and an MCP server for agents | 92 out of 100 |