DAB Config Builder

An Angular application for creating and managing Azure Data API Builder (DAB) configuration files. Azure Data API Builder generates REST and GraphQL APIs from your database without writing backend code.

Example: https://white-coast-0bb2b5d1e.4.azurestaticapps.net/

Features

• Configure database connections (SQL Server, PostgreSQL, MySQL, Cosmos DB)
• Define entities from database tables and views
• Set up role-based permissions
• Configure REST/GraphQL endpoints, CORS, and authentication
• Import database schema automatically
• Live JSON preview with download/copy functionality

Tech Stack

• Angular 21
• TypeScript 5.9
• Bootstrap 5.3
• RxJS 7.8
• Vitest

Prerequisites

• Node.js (v20 or later)
• npm 11.6.4 or compatible package manager

Getting Started

Installation

1. Clone the repository:

   git clone https://github.com/danOIntellitect/IntelliTect-Sql-Mcp-Configuration.git
   cd IntelliTect-Sql-Mcp-Configuration

2. Install dependencies:

   npm install

Development Server

Start the local development server:

npm start
# or
ng serve

Navigate to http://localhost:4200/.

Build

npm run build

Build artifacts are stored in the dist/ directory.

Project Structure

src/
├── app/
│   ├── components/
│   ├── pages/
│   │   └── config-wizard/
│   ├── services/
│   ├── models/
│   ├── utils/
│   └── interceptors/
├── environments/
└── styles/

Schema Import

The application supports importing database schemas to automatically generate entity configurations.

JSON Schema Format

{
  "tables": [
    {
      "name": "Users",
      "schema": "dbo",
      "columns": [
        {
          "name": "Id",
          "type": "int",
          "nullable": false,
          "isPrimaryKey": true
        },
        {
          "name": "Email",
          "type": "string",
          "nullable": false,
          "isPrimaryKey": false,
          "description": "User's email address"
        },
        {
          "name": "CreatedAt",
          "type": "datetime",
          "nullable": false,
          "isPrimaryKey": false,
          "description": "Account creation timestamp"
        }
      ]
    }
  ]
}

Field Descriptions: Optional descriptions can be added to individual columns for documentation purposes. These descriptions help document the schema and are visible in the entity editor for reference.

Testing

npm test

Resources

• Azure Data API Builder Documentation
• DAB Configuration Reference
• Angular Documentation

License

Developed by IntelliTect.