Use AI to chat with a SQL Database 3.0 - INSANE new features!

[@adokshajbhandarkar5492]

Thank you for your contribution to the developer community.

[@davidbello29]

What a hidden gem mate. I have tried multiple times to find a video like this one in the last two weeks but have had no luck. Today it just showed up on my feed. Thanks

[@alexthecodewolf]

Thanks! The first two vids have a lot of views but for some reason this one hasn't had much exposure

[@spesaru]

Thanks!

[@alexthecodewolf]

Thank you so much!

[@pedrosoto9750]

Thanks! I'm eager to see what's next! I joined the club! Thanks again!

[@alexthecodewolf]

Thanks for the support!

[@jlou65535]

I wanted to let you know that version 3 is absolutely fantastic! The deployment went smoothly without any issues, and I must commend you on the excellent work ! Just like with version 2, your efforts have really paid off ;) I did encounter a small SQL error in some queries (Error: Incorrect syntax near 'LIMIT'). I believe this can be easily fixed. Alternatively, we could run the query through Azure OpenAI, report the error message, and request a corrected version. This would create a self-correcting loop using AI. Additionally, it would be interesting to explore what could be done with databases like OneLake or Fabric. This would allow us to use other types of connectors alongside SQL, which could be equally beneficial.

[@alexthecodewolf]

Thanks for sharing this feedback - Bicep templates and AZD can be kind of fickle so its good to hear that the deployment process is working for people. I tried to design it with defaults that would work in most environments. There's definitely refinements we could make to the SQL and database part of this. I'd love to be able to connect to more data sources like you mentioned. I'd also like to make it easier to swap to other DB syntax like MySQL and Postgres using some UI settings or something since right now its tailored to MSSQL format.

[@atmakurir]

Wow, Thank you , this was great you explained in very simple manner and its working flawless as is with no issues. Thanks again for your help and looking for more..

[@alexthecodewolf]

Thanks, I appreciate the feedback

[@maheshshinde4168]

Thanks

[@alexthecodewolf]

Thanks so much!

[@si_walker]

Wow, that was excellent. Thank you! One thing that I have been curious about is if this application could somehow be configured as a Blazor WASM application hosted in a production Azure environment, but then somehow allow it to access a local database on the local machine either a LOCALDB instance etc (for example) or a SQLIte file; I know that violates the sandbox concept, but having a production Blazor WASM app able to handle local databases would be enormously helpful. Also, using Microsoft Entra External ID as an 'external' tenant as opposed to using a 'workforce' tenant has always given me problems when I have tried for some reason; I'd vote for a video that covered that off if I could. Keep up the great work - thank you again!

[@alexthecodewolf]

Thanks for the feedback and for watching! Although I really like Blazor Wasm, getting it to work with this app had various challenges so I ended up going with Interactive Server. I would not recommend trying to break out of the sandbox or access a database directly through Wasm. Your best bet would be to run a modified UI in Wasm but then have it call a backend api that handles requests for secure tasks, such as connecting to the AI model and retrieving connection strings from Keyvault. This is a common pattern where there is a pass through API of some sorts to handle security concerns for the UI, the API doesn't have to be overly complex, just several endpoints to take care of some of these issues.

[@OvRaf]

thanks

[@alanwhitehouse7832]

Fantastic stuff. Thank you for posting. Question: seems like the query syntax sometimes get confused if your table or column names have spaces in them. For instance if the table is something like [dbo].[Financial Data] it will bring back in the query dbo.Financial Data (with a space, which doesn't work). How is this best addressed assuming you cannot change table names? Is there a syntax you can give the AI model to tell it to always use brackets around table or column names?

[@fagnerdossantosgoncalves9563]

Great job man, this is amazing!!, is possible use mysql as database source for this project ?

[@alexthecodewolf]

Thanks! Yes you'd just have to adjust the prompt to tell it to format queries for MySQL instead of Mssql

[@nicolassuarez2933]

Outstanding! But you should add Autogen 🤓

[@alexthecodewolf]

Well there's always the 4.0 option :D

[@nicolassuarez2933]

@alexthecodewolf 😁

[@moisenach1]

Great video ! do you think this code will also work with a PostgreSQL DB as well?

[@alexthecodewolf]

Yes any relational database, though you might have to adjust the AI prompt slightly to tell it to use postgres syntax

[@moisenach1]

@@alexthecodewolf wonderful . I think you did a great job!

[@alexthecodewolf]

Thanks I appreciate it!

[@moisenach1]

Anyway I can contact you privately?

[@jbschaab]

Thanks!

[@alexthecodewolf]

Thanks so much! :D

[@OvRaf]

Thanks

[@alexthecodewolf]

Thanks you!!