원클릭으로 Manus에서 모든 스킬 실행

data-api-builder-cli

Use Data API Builder CLI to initialize, add/update entities, validate config, and run DAB. Use when asked to create or modify dab-config.json via CLI commands.

Manus에서 실행

개요

Use Data API Builder CLI to initialize, add/update entities, validate config, and run DAB. Use when asked to create or modify dab-config.json via CLI commands.

설치 명령

npx skills add https://github.com/JerryNixon/dab-quickstarts --skill data-api-builder-cli

이 명령을 Claude Code에 복사하여 붙여넣어 스킬을 설치하세요

출처

JerryNixon/dab-quickstarts

스타0

포크0

업데이트2026년 3월 31일 19:01

SKILL.md

readonly

name	data-api-builder-cli
description	Use Data API Builder CLI to initialize, add/update entities, validate config, and run DAB. Use when asked to create or modify dab-config.json via CLI commands.
license	MIT

Data API Builder CLI

Use this skill for command-driven DAB setup and changes. Keep flows short: init → add/update → validate → start.

Companion config assets

Pair CLI commands with these examples from the config skill:

Auto-config note: CLI terminology uses auto-config while runtime JSON uses the autoentities section name.

When to use

Create a new dab-config.json
Add or modify entities from tables/views/stored procedures
Change runtime settings (REST/GraphQL/MCP/auth/CORS)
Validate and run DAB locally

Workflow

Initialize config: dab init
Add entities: dab add
Adjust entities/runtime: dab update / dab configure
Validate: dab validate
Run: dab start

Always recommend env vars for secrets with @env('VAR').

Command quick reference

`dab init`

Create/overwrite config.

dab init --database-type mssql --connection-string "@env('DATABASE_CONNECTION_STRING')"

`dab add`

Add table/view/stored procedure entity.

# table
dab add Product --source dbo.Products --permissions "anonymous:read"

# view (requires key fields)
dab add ProductSummary --source dbo.vw_ProductSummary --source.type view --source.key-fields "ProductId" --permissions "anonymous:read"

# stored procedure
dab add GetProducts --source dbo.usp_GetProducts --source.type stored-procedure --permissions "authenticated:execute" --graphql.operation query

`dab update`

Update existing entity.

# add role
dab update Product --permissions "admin:*"

# relationship
dab update Category --relationship "products" --cardinality many --target.entity Product --relationship.fields "CategoryId:CategoryId"

# field mapping (replaces existing mappings)
dab update Product --map "ProductName:name,UnitPrice:price"

`dab configure`

Change runtime/global settings.

dab configure --runtime.mcp.enabled true --runtime.mcp.path "/mcp"
dab configure --cors-origin "https://app.example.com"

`dab validate`

Validate config before running.

dab validate --config dab-config.json

`dab start`

Start DAB runtime.

dab start --config dab-config.json

Decision points

Entity change? use dab add/dab update
Runtime/global change? use dab configure
View source? require --source.key-fields
Stored procedure? use execute permission (not read)

Troubleshooting (syntax gotchas)

View entity missing key fields

# WRONG
dab add ProductSummary --source dbo.vw_ProductSummary --source.type view --permissions "anonymous:read"

# CORRECT
dab add ProductSummary --source dbo.vw_ProductSummary --source.type view --source.key-fields "ProductId" --permissions "anonymous:read"

Stored procedure permission type

# WRONG
dab add RunReport --source dbo.usp_RunReport --source.type stored-procedure --permissions "authenticated:read"

# CORRECT
dab add RunReport --source dbo.usp_RunReport --source.type stored-procedure --permissions "authenticated:execute"

Policy syntax must be OData, not SQL

# WRONG
dab update Order --policy-database "Status = 'Active'"

# CORRECT
dab update Order --policy-database "@item.Status eq 'Active'"

`--map` replaces all mappings

# Include all desired mappings every time
dab update Product --map "ProductName:name,UnitPrice:price,UnitsInStock:stock"

Consistency rules

Use @env(...) for secrets.
Run dab validate before dab start.
Keep .gitignore entries for .env, **\bin, **\obj.
For Azure, use custom image with embedded dab-config.json (no Azure Files mount).

Completion checks

Config exists and validates
Entities and permissions match user intent
Runtime endpoints enabled as requested
DAB starts and /health returns success

References

이 저장소의 다른 Skills

같은 저장소

aspire-data-api-builder

JerryNixon/dab-quickstarts

Guide for .NET Aspire orchestration of SQL Server + Data API Builder + SQL Commander + MCP Inspector. Use when asked to create an Aspire-based DAB environment.

2026-05-290

azure-data-api-builder

JerryNixon/dab-quickstarts

Deploy Data API Builder to Azure Container Apps with Azure SQL, ACR, and azd. Use when asked to deploy DAB to Azure, create Bicep for DAB, or set up cloud API hosting.

2026-05-290

docker-data-api-builder

JerryNixon/dab-quickstarts

Docker Compose orchestration of SQL Server, Data API Builder, SQL Commander, and MCP Inspector. Use when asked to create docker-compose.yml, set up local containers, or run DAB without Aspire.

2026-05-290

aspire-mcp-inspector

JerryNixon/dab-quickstarts

Add MCP Inspector to a .NET Aspire AppHost for debugging MCP servers such as Data API Builder.

2026-03-310

azure-mcp-inspector

JerryNixon/dab-quickstarts

Deploy MCP Inspector to Azure Container Apps using an nginx same-origin proxy so UI and proxy work behind a single ingress port.

2026-03-310

creating-agent-skills

JerryNixon/dab-quickstarts

Create and audit GitHub Copilot Agent Skills with clear discovery descriptions, correct SKILL.md frontmatter, and reusable multi-step workflows.

2026-03-310

출처

JerryNixon

JerryNixon/dab-quickstarts

GitHub 저장소 열기 Creator 저장소 보기

설치 명령

다운로드

Manus에서 실행

유용한 대상SOC

소프트웨어 개발자컴퓨터 및 수학직15-1252L4

name	data-api-builder-cli
description	Use Data API Builder CLI to initialize, add/update entities, validate config, and run DAB. Use when asked to create or modify dab-config.json via CLI commands.
license	MIT

Data API Builder CLI

Use this skill for command-driven DAB setup and changes. Keep flows short: init → add/update → validate → start.

Companion config assets

Pair CLI commands with these examples from the config skill:

Auto-config note: CLI terminology uses auto-config while runtime JSON uses the autoentities section name.

When to use

Create a new dab-config.json
Add or modify entities from tables/views/stored procedures
Change runtime settings (REST/GraphQL/MCP/auth/CORS)
Validate and run DAB locally

Workflow

Initialize config: dab init
Add entities: dab add
Adjust entities/runtime: dab update / dab configure
Validate: dab validate
Run: dab start

Always recommend env vars for secrets with @env('VAR').

Command quick reference

`dab init`

Create/overwrite config.

dab init --database-type mssql --connection-string "@env('DATABASE_CONNECTION_STRING')"

`dab add`

Add table/view/stored procedure entity.

# table
dab add Product --source dbo.Products --permissions "anonymous:read"

# view (requires key fields)
dab add ProductSummary --source dbo.vw_ProductSummary --source.type view --source.key-fields "ProductId" --permissions "anonymous:read"

# stored procedure
dab add GetProducts --source dbo.usp_GetProducts --source.type stored-procedure --permissions "authenticated:execute" --graphql.operation query

`dab update`

Update existing entity.

# add role
dab update Product --permissions "admin:*"

# relationship
dab update Category --relationship "products" --cardinality many --target.entity Product --relationship.fields "CategoryId:CategoryId"

# field mapping (replaces existing mappings)
dab update Product --map "ProductName:name,UnitPrice:price"

`dab configure`

Change runtime/global settings.

dab configure --runtime.mcp.enabled true --runtime.mcp.path "/mcp"
dab configure --cors-origin "https://app.example.com"

`dab validate`

Validate config before running.

dab validate --config dab-config.json

`dab start`

Start DAB runtime.

dab start --config dab-config.json

Decision points

Entity change? use dab add/dab update
Runtime/global change? use dab configure
View source? require --source.key-fields
Stored procedure? use execute permission (not read)

Troubleshooting (syntax gotchas)

View entity missing key fields

# WRONG
dab add ProductSummary --source dbo.vw_ProductSummary --source.type view --permissions "anonymous:read"

# CORRECT
dab add ProductSummary --source dbo.vw_ProductSummary --source.type view --source.key-fields "ProductId" --permissions "anonymous:read"

Stored procedure permission type

# WRONG
dab add RunReport --source dbo.usp_RunReport --source.type stored-procedure --permissions "authenticated:read"

# CORRECT
dab add RunReport --source dbo.usp_RunReport --source.type stored-procedure --permissions "authenticated:execute"

Policy syntax must be OData, not SQL

# WRONG
dab update Order --policy-database "Status = 'Active'"

# CORRECT
dab update Order --policy-database "@item.Status eq 'Active'"

`--map` replaces all mappings

# Include all desired mappings every time
dab update Product --map "ProductName:name,UnitPrice:price,UnitsInStock:stock"

Consistency rules

Use @env(...) for secrets.
Run dab validate before dab start.
Keep .gitignore entries for .env, **\bin, **\obj.
For Azure, use custom image with embedded dab-config.json (no Azure Files mount).

Completion checks

Config exists and validates
Entities and permissions match user intent
Runtime endpoints enabled as requested
DAB starts and /health returns success

data-api-builder-cli

Data API Builder CLI

Companion config assets

When to use

Workflow

Command quick reference

dab init

dab add

dab update

dab configure

dab validate

dab start

Decision points

Troubleshooting (syntax gotchas)

View entity missing key fields

Stored procedure permission type

Policy syntax must be OData, not SQL

--map replaces all mappings

Consistency rules

Completion checks

References

이 저장소의 다른 Skills

이 저장소의 다른 Skills

Data API Builder CLI

Companion config assets

When to use

Workflow

Command quick reference

dab init

dab add

dab update

dab configure

dab validate

dab start

Decision points

Troubleshooting (syntax gotchas)

View entity missing key fields

Stored procedure permission type

Policy syntax must be OData, not SQL

--map replaces all mappings

Consistency rules

Completion checks

References

`dab init`

`dab add`

`dab update`

`dab configure`

`dab validate`

`dab start`

`--map` replaces all mappings

`dab init`

`dab add`

`dab update`

`dab configure`

`dab validate`

`dab start`

`--map` replaces all mappings