0

As far as I can see the only options currently for copilot/ChatGPT SQL assistance is to generate queries outside of SSMS.

The real power would be within the SSMS, with access to table definitions, SP's etc. I could see this saving me hours of dev time. Anyone know if there's anything on the cards or whether MS allows for external tools to be incorporated into SSMS?

Sami.C
  • 561
  • 1
  • 11
  • 24
  • 2
    This is probably the best example I've seen of _lack of research_ my advice to anyone else who is going to post questions about openAI is to ask it first... – Chris Schaller Jun 09 '23 at 01:41
  • @ChrisSchaller so if you consider this question lack of research, why up-vote it? Down-vote is for lack of research. – Dale K Jun 09 '23 at 01:51
  • @ChrisSchaller, Dale K I appreciate the concern for people posting 101 openAI questions without first researching, however I think you've falsely categorised me :) I'm not using SSDT or Azure Data Studio. I'm using SSMS. I've already read about the support both of these have but nothing on SSMS, hence why I posted. – Sami.C Jun 09 '23 at 01:55
  • To be honest, its not a valid question for this site, its not about programming, its about tools - which is off topic. – Dale K Jun 09 '23 at 01:58
  • @DaleK if you're capable of answering the question I'll happily accept your answer ;) – Sami.C Jun 09 '23 at 02:23
  • Any add ins like this are likely to be implemented in Azure Data Studio, not SSMS. Or whatever web dev tool exists in Fabric / Synapse – Nick.Mc Jun 09 '23 at 03:55

1 Answers1

0

Even SQL Server Developer Tools Gets an AI Copilot

SSMS was originally built on top of the Visual Studio Shell, even to this day it retains a rich extensibility framework

External Tools - SQL Server Management Studio

I can't help but wonder why you didn't put this prompt into chat gpt yourself:

can i get copilot to assist me generate sql queries in SSMS

Yes, you can use GitHub Copilot for SQL queries in SSMS. GitHub Copilot is an AI-powered pair programmer that assists you with context-aware code completions, suggestions, and even entire code snippets. It is now available for Azure Data Studio 1.

To use it in SSMS, you can install the GitHub Copilot extension for Visual Studio Code and then connect to SSMS using the SQL Server Object Explorer 1.

I hope this helps! Let me know if you have any other questions.

Chris Schaller
  • 13,704
  • 3
  • 43
  • 81
  • 1
    Odd, I didn't think this question would be feasible given ChatGPT only goes to 2021. Infact I did try it and it essentially told me it didn't know because of the 2021 knowledge limitation (even with 4.0). I have read about Azure Data Studio support, however we don't use this. – Sami.C Jun 09 '23 at 01:46