GitHub Copilot for SQL Developers: Turbocharge your SQL Development Workflow

Late to the party, but…

I spend most of my time in sql writing random queries. At most a few times a year I add a new table, alter a table, or write a sproc. When I do, I often have to stop by W3schools to refresh my memory on some bit of syntax.

my hope is copilot will speed this up. The suggestion may not be perfect, but it’ll get me closer to what I need without having to hit the browser.

I’ve tried the vscode mssql plugin over using SSMS.. I need to spend more time in it next time I have a bunch of sql work to do… the biggest pain point was not being able to run highlighted code. Maybe this has been fixed, or maybe I just need to get in the habit of commenting out queries I’m not interested in executing this run!

I ended up here to see if Microsoft has anything similar to PlanetScale’s Schema Recommendations. I look forward to Microsoft taking some inspiration from it 😉