microsoft / microsoft/vscode-mssql

[Feature Request]: SQL Notebooks AI Generate - Multiple Cells

Open
#21,674 0 comments 0 reactions 0 assignees View on GitHub
Area - SQL Notebook Enhancement User-filed
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

### Feature Description

First off, thank you very much for adding SQL Notebook support to the MSSQL extension.

I see that AI generation has been added, which is awesome.
At the moment, it is a single line text box, although you can paste multiline but you can't hit enter without submitting.

### Problem and Motivation

There seems to be a limitation where the generate button makes a new cell and only the content of that cell is generated.
I would propose that instead of immediately creating a new cell, that you have a larger prompt box, and let the AI potentially create multiple cells.
This would be very helpful for modernizing some old script files.

### 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
- [x] Other (please describe below)

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

SQL Notebooks

### Confirmation

- [x] I have searched existing feature requests and couldn't find a match
- [x] I want to help implement this feature

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by tracing the SQL Notebooks AI generation flow in the MSSQL extension, focusing on how the current prompt and generated cell are handled. Determine how multiline prompts and multiple generated cells should be represented and presented. Done means a user can submit a larger prompt and receive more than one notebook cell when appropriate.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql, typescript
Domain
database, devtools
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.