data-api-builder-cli

Guide Data API Builder CLI configuration for REST, GraphQL, and MCP endpoints.

5|1|Updated Feb 9, 2026
One-click install
npx skills add https://github.com/JerryNixon/github-copilot-sql-dab-azure-mcp --skill data-api-builder-cli
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-api-builder-cli
Source: https://github.com/JerryNixon/github-copilot-sql-dab-azure-mcp/tree/main/.github/skills/data-api-builder-cli
Command: npx skills add https://github.com/JerryNixon/github-copilot-sql-dab-azure-mcp --skill data-api-builder-cli

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides guidance for using the Data API Builder (DAB) CLI to efficiently create, configure, and manage APIs that expose database objects as REST, GraphQL, and MCP endpoints.

Core Features & Use Cases

  • Configuration Management: Initialize, add, and update DAB configurations for databases.
  • API Generation: Expose tables, views, and stored procedures as discoverable API endpoints.
  • Use Case: You need to quickly expose a SQL Server table named Customers as a REST API endpoint that allows authenticated users to read and update customer data.

Quick Start

Use the data-api-builder-cli skill to initialize a new DAB configuration for a SQL Server database.

Frequently Asked Questions about data-api-builder-cli

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I expose a SQL database as REST and GraphQL endpoints?

You can expose a SQL database as REST and GraphQL endpoints by using the Data API Builder CLI to initialize a configuration, add database entities, and start the runtime to generate the APIs.

What is the best way to generate a data API from an existing database schema?

Generating a data API from an existing schema is done by configuring the Data API Builder CLI to map tables, views, and stored procedures into discoverable REST and GraphQL endpoints.

Can I configure role-based access policies for a GraphQL API?

Yes, you can configure role-based access policies for a GraphQL API by defining permissions and policies within the Data API Builder CLI configuration for each exposed database entity.

Does Data API Builder support complex relationships between database tables?

Data API Builder supports complex relationships between database tables, allowing you to define associations in the configuration so related data can be queried through the generated REST or GraphQL endpoints.

How do I add caching to a REST API generated from a database?

You add caching to a generated REST API by configuring caching rules in the Data API Builder CLI, which improves data access layer performance for read-heavy database operations.

Can I expose stored procedures as API endpoints?

Yes, you can expose stored procedures as API endpoints by adding them as entities in the Data API Builder CLI configuration, making them accessible via REST and GraphQL protocols.