microsoft / microsoft/vscode-mssql

[Bug]: DAB configuration properties not available via MCP

Open
#22,113 0 comments 0 reactions 1 assignee Claimed by @aasimkhan30 View on GitHub
Area - Application QuickStart Area - Data API Designer Bug Team-filed (internal) Triage: Needed
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

### Description

The following properties have no corresponding MCP change type. They cannot be viewed or modified through the tool. Paths reference the [v2.0.1-rc schema](https://github.com/Azure/data-api-builder/releases/download/v2.0.1-rc/dab.draft.schema.json).

#### Data source
- `data-source.connection-string`
- `data-source.database-type` (mssql, postgresql, mysql, cosmosdb_nosql, dwsql)
- `data-source.options` (e.g. `set-session-context` for mssql, `database`/`container`/`schema` for cosmosdb_nosql)
- `data-source.health.enabled` / `.name` / `.threshold-ms`
- `data-source.user-delegated-auth.enabled` / `.provider` / `.database-audience`
- `data-source-files` (multi-database configuration)

#### Runtime host
- `runtime.host.mode` (production, development)
- `runtime.host.max-response-size-mb`
- `runtime.host.cors.origins` / `.allow-credentials`
- `runtime.host.authentication.provider` (StaticWebApps, EntraID, AzureAD, AppService, Simulator, Custom, Unauthenticated)
- `runtime.host.authentication.jwt.audience` / `.issuer`

#### REST (global)
- `runtime.rest.path`
- `runtime.rest.request-body-strict`

#### GraphQL (global)
- `runtime.graphql.path`
- `runtime.graphql.allow-introspection`
- `runtime.graphql.depth-limit`
- `runtime.graphql.multiple-mutations.create.enabled`

#### MCP (global)
- `runtime.mcp.path`
- `runtime.mcp.description`
- `runtime.mcp.dml-tools` (describe-entities, create-record, read-records, update-record, delete-record, execute-entity, aggregate-records)

#### Cache
- `runtime.cache.enabled` / `.ttl-seconds`
- `runtime.cache.level-2.enabled` / `.provider` / `.connection-string` / `.partition`
- `entities..cache.enabled` / `.ttl-seconds` / `.level`

#### Pagination
- `runtime.pagination.default-page-size` / `.max-page-size`
- `runtime.pagination.next-link-relative`

#### Compression
- `runtime.compression.level` (optimal, fastest, none)

#### Telemetry
- `runtime.telemetry.application-insights.connection-string` / `.enabled`
- `runtime.telemetry.open-telemetry.endpoint` / `.headers` / `.service-name` / `.exporter-protocol` / `.enabled`
- `runtime.telemetry.azure-log-analytics.enabled` / `.auth` / `.dab-identifier` / `.flush-interval-seconds`
- `runtime.telemetry.file.enabled` / `.path` / `.rolling-interval` / `.retained-file-count-limit` / `.file-size-limit-bytes`
- `runtime.telemetry.log-level`

#### Health
- `runtime.health.enabled` / `.roles` / `.cache-ttl-seconds` / `.max-query-parallelism`
- `entities..health.enabled` / `.first` / `.threshold-ms`

#### Entity source
- `entities..source.type` (table, view, stored-procedure)
- `entities..source.object`
- `entities..source.parameters` (stored procedure parameter mappings)
- `entities..source.key-fields` (deprecated; replaced by `fields[].primary-key`)
- `entities..source.description`
- Views (not discovered; cannot be added manually)
- Stored procedures (not discovered; cannot be added manually)

#### Entity fields & mapping
- `entities..fields[]` (name, alias, description, primary-key)
- `entities..mappings` (deprecated; replaced by `fields[].alias`)
- `entities..description`

#### Entity permissions
- Custom role definitions (only `anonymous` and `authenticated` are available)
- `entities..permissions[].role` / `.actions[]`
- `entities..permissions[].actions[].fields.include` / `.exclude`
- `entities..permissions[].actions[].policy.database` (item-level security)

#### Entity relationships
- `entities..relationships..cardinality` (one, many)
- `entities..relationships..target.entity`
- `entities..relationships..source.fields` / `.target.fields`
- `entities..relationships..linking.object` / `.linking.source.fields` / `.linking.target.fields`

#### Entity-level REST & GraphQL
- `entities..rest.enabled` / `.path` / `.methods`
- `entities..graphql.enabled` / `.type` (singular/plural) / `.operation`

#### Entity-level MCP
- `entities..mcp.dml-tools`
- `entities..mcp.custom-tool`

#### Azure Key Vault
- `azure-key-vault.endpoint`
- `azure-key-vault.retry-policy.*`

#### Auto-entities
- `autoentities..patterns` (include, exclude, name)
- `autoentities..template` (mcp, rest, graphql, health, cache)
- `autoentities..permissions`

#### Lifecycle
- Add a new entity from an existing table/view/SP
- Remove an entity from the configuration
- Export / save configuration to a `dab-config.json` file
- Start / stop the DAB runtime

### Steps to Reproduce

Use Copilot against MCP.

### Affected Area

- [ ] Connection dialog (SQL Server | Azure browse/Fabric browse)
- [ ] Query editor
- [ ] Query results panel
- [ ] Object Explorer
- [ ] GitHub Copilot integration
- [ ] Preview/Edit data
- [ ] Table Designer
- [x] Schema Designer
- [ ] Schema Compare
- [ ] Local SQL Server Container provisioning
- [ ] SQL database in Fabric provisioning
- [ ] DACPAC/BACPAC export/import
- [ ] SQL Database projects
- [ ] Query Plan Visualizer
- [ ] Other (please describe below)

### If you selected "Other", please describe the affected area

_No response_

### Environment Information

Identifier: ms-mssql.mssql
Version: 1.42.2
OS: Windows
DB: Local SQL

### Confirmation

- [x] I have searched existing issues and couldn't find a match
- [ ] I want to work on this issue

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.