ChatGPT - Imagine you are a Microsoft SQL Server database server

A fun and insightful video on how to instruct ChatGPT to simulate a database server.

[artificialhits]

I don't know what's more amazing, the fact that ChatGPT can do this, or the fact that people keep coming up with clever ideas to implement AI on their domain of expertise. Literally the digital renaissance.

[hellaxar]

wow, this is so far beyond the scope of what i thought ChatGPT was capable of!

[chrishunter]

WOW! ChatGPT stopped the roleplay thing and provided additional information to the answer ..Not only that! It stopped the roleplay, but on the other side still "kept the server running". this is beyond amazing. like: hey i still act like i am a sql server but let us have a little chat beside that. gg chatgpt.

[ghostandgoblins]

This is super cool.

What I noticed is ChatGPT started providing explanations again BUT ONLY after you also broke the play-acting scenario where you were only giving it SQL commands. So I guess it figured you stopped playing, perhaps! But ya super interesting.

[watvannou]

The more ChatGPT content I see the more it reminds me of star trek where people talked to the computer and it just did things we were like "lol that'll never happen". Here we are though, in the next year or two the mobile assistants on phones are going to become insane

[ijosakawi]

If you want the output to look better, write "SELECT * FROM users, then output it as a Markdown table". ChatGPT's outputs are formatted using Markdown.

The Markdown formatting is also why you keep getting formatting bugs, as ChatGPT outputs
email age

which is first interpreted as a Markdown heading (because of the directly below text),
then as a horizontal separator (because of the spaces in the which is outputted as several line breaks.

[danilokocic]

The previous video I watched on GPT was a guy instructing it to generate SQL script to insert gpt generated business tables into a database schema and I thought that was incredible. However, here you are showing us that GPT can take it even further and stimulate an SQL Server for you while also writing SQL scripts. TRULY incredible

[KeldonA]

This prompt still works for me. I had a different list of existing databases. Openai have done a fantastic job of proving how generalizable GPT is (which ML experts already knew).

[Alexrider]

I think it started adding explanations because you moved from speaking to it "in character" (giving commands as if it were an SQL server) to once against speaking to it in plain English, so it started also communicating "out of character" in plain English.

[Nightstick]

It blows me away that ChatGPT can simulate running other languages like that. It makes sense, SQL is just a language itself, no reason another program couldn't simulate the results, but it's still mind blowing. Truly an insanely interesting time to be alive, I cannot wait to see what madness the future will bring us.

[fernandopardo]

What really suprised me is that time ago I asked it to create a sample stored procedure with a logic that I explained writing the explanation and it understood it. Since the SP was not exact what I was asking (I had created my version of the SP before using GPT) I started to chat with it to improve it little by little, and everithing I pointed it, it responded and improved the Sp! For example, in your sample, you could ask it "could you please use merge statement?" And get a new version of the same SP, it is very nice!

[boop]

This would be really cool as a tutorial implementation. Obviously it makes no sense to run a whole massive AI model just to emulate an SQL server, but being able to learn how to write database commands by having chatgpt emulate that database type, and being able to ask it questions about what's in the database, etc would be incredible.

[squorsh]

This is incredible. I've used chatGPT before to help explain code, but I had never thought of asking it to emulate servers

[adheremtmeat]

I just replaced my "Act as" to "imagine you are" and my prompt worked better than before thank you it is very powerful

[Narutoxcosplayxfreak]

I don't think it was a glitch. When you called the second "SELECT * FROM users;" It looked to me like GPT tried to return it as an actual table but table markup of some kind is probably not supported in it's chat box which is why it returned the column headers, then 'glitched' as it tried to format them into an actual table.

[randyg.]

What a trip. I would not have thought about this. Thanks

[SpiritmanProductions]

I believe it reverted to explanatory output because you changed from SQL input to natural language instructions.

[Vartazian]

I did this and 2 new databases were there from the start, northwind and pubs. I wonder if OpenAI saw what was happening in this video and modified the model for this usecase? Really REALLY cool

[kosnk]

This is both mindblowing and frightening.

[TheNiters]

The interesting part is that if this interface was connected to a proper database on the backend you could probably you this to tell it to do the same thing as you did with SQL, but with plain English. "Create a table to store users that saved the users email and their age. Use appropriate field types for each field."

This would be properly impressive compared to being able to generate likely responses from veeeery basic SQL that almost any tutorial on the web has solved before.