Skip to content

[Feature Request]: Copilot publish validation errors & 'fix error' button #21436

@yoleichen

Description

@yoleichen

Feature Description

When a user publishes schema changes generated or suggested by Copilot, validation errors (such as foreign key constraint issues and script errors) may occur. Ideally, Copilot could avoid suggesting changes that produce errors at publish time to build AI trust. Pre-publishing validation is fairly heavy weight and would not be something we can add to each GHCP edit (same reason why we don't do this for the UI edits) As a middle ground, adding a "Copilot fix error" button is suggested, which would allow Copilot to analyze detected validation errors and propose schema fixes or corrective actions before retrying publish. See the attached screenshot for an example error dialog.

Image

Problem and Motivation

Currently, Copilot suggestions can result in errors at publish time, such as validation failures for foreign key constraints or incorrect SQL scripts. This negatively impacts user trust and workflow efficiency. With Copilot-driven validation or a fix button, users can more easily recover and publish valid changes, improving the collaborative schema design experience.

Related Area

  • Connection dialog (SQL Server | Azure browse/Fabric browse)
  • Query editor
  • Query results panel
  • Object Explorer
  • GitHub Copilot integration
  • Preview/Edit data
  • Table Designer
  • 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 area

No response

Confirmation

  • I have searched existing feature requests and couldn't find a match
  • I want to help implement this feature

Metadata

Metadata

Assignees

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions