dbForge SQL Complete for SSMS & Visual Studio | AI SQL Assistant Demo

See how dbForge SQL Complete helps you write SQL faster in SQL Server Management Studio and Visual Studio. This demo shows AI-powered SQL generation, query explanation, code fixes, smarter autocomplete, snippets, JOIN suggestions, and faster INSERT/UPDATE writing. Based on the Northwind database walkthrough, the video highlights how dbForge SQL Complete reduces manual work and gives more database context directly inside the IDE.

Timestamps:
00:00 Introduction
01:07 Download and Setup
01:22 Integration in SSMS
02:39 Code Snippet Example
03:01 Enhanced Metadata in Intellisense
03:28 Using The 'Tab' Shortcut Key
03:50 Troubleshoot Errors with AI Assistant
04:40 Authoring Complex Queries Quickly
06:29 Using the AI Assistant to Generate Contextual Queries
08:03 Explain SQL Using AI Assistant
08:45 Building SELECT Statements With Context Windows and Metadata
09:39 Generating INSERT and UPDATE Statements
10:31 Conclusion

Download links ⬇️
👉 dbForge SQL Complete: https://is.gd/l8fLqQ
👉 dbForge AI Assistant: https://is.gd/npzSgN
👉 dbForge SQL Tools: https://is.gd/pLcZUu

#dbForgeSQLComplete #SQLComplete #Devart #SSMS #SQLServerManagementStudio #VisualStudio #AISQLAssistant #SQLAutocomplete #SQLIntelliSense #SQLFormatter #SQLCodeCompletion #SQLProductivity #SQLDeveloperTools #TSQL #DatabaseDevelopment

---

Closed Caption:

Hi everybody. Trevor Williams here and
today we're going to discuss the DB
Forge SQL Complete tool. Now this tool
is a productivity tool for writing SQL,
especially if you're writing SQL using
the SQL Server Management Studio or
Visual Studio. And if you spend enough
time in those environments, you would
definitely understand that this
productivity tool is needed because it
can be annoying when you have to be
jumping between writing SQL statements
and looking at the table and the
metadata of the columns to write the
best statement possible. There are times
when you have complex queries that you'd
love to explain and then sometimes you
have to go outside of the IDE and use
some other third-party tool in this day
and age, probably an AI assistant to
explain what the query is doing and so
on. So this tool brings all of that into
one. It helps us with all of those
things and we're just going to go
through some scenarios to kind of see
the power and the value-added
proposition of it.
So we start off with the product page on
the Devart website. Go to devart.com, go
to products and look for SQL Complete
and from here you can opt to get a free
trial. Once you have installed the tool
and you launch your SQL Server
Management Studio, you're going to
notice a few new things. The first new
would be that you have an AI Assistant
button which gives you an AI Assistant
chat to the right-hand side, similar to
what you would see with Copilot. The SQL
Complete tool and the AI Assistant,
they're fully context-aware and they're
doing a little bit more in the context
of the database that you're actually
working with. Another thing that you may
notice is in the context strip up top
you may see
a menu item that says SQL complete. Now,
for some reason, my extensions menu says
that it should be there and it allows me
to select if it should be there, yet
it's not showing me. But, that's a me
problem. You probably won't have that
problem. Either way, once you're seeing
at least the AI assistant, then you know
that everything is up and running.
Now, this tool is very powerful and it
has a lot of features. I cannot go
through every single feature in this
particular video. However, I'm going to
highlight some of the things that I've
found very useful, and I hope you will
find them useful as well, but do
explore, do experiment. For this demo,
I'm going to be using the Northwind
database, which is a great demo
database.
Now, one of the first things we write as
SQL developers or somebody extracting
data is a select query. Now, I did
mention snippets. A snippet here is SSF.
If I type SSF and press tab, it's
automatically generating that select
query for me. And then I can go ahead
and choose a table. So, I'm getting the
customers table. You'll also notice that
there's additional metadata being
provided. So, it's telling me an
estimated number of rows in this table.
It's telling me the columns and the
constraints and data types. That's very
useful at a glance. I'm going to go
ahead and say customer C. But, what if I
don't want every
thing from the customers table? And
usually, star is not recommended. It's
more readable when you list out the
columns. I can highlight star and press
tab, and it just lists out all of the
columns for me. Now, I can cherry-pick.
I don't want customer ID, contact title,
or address.
And I don't want these
other ones.
So, now I only have the company name,
the contact city, region. Now, what if I
had an error and you're tired, I don't
have the time and the cognitive ability
in that moment to sit down and spend
hours trying to debug what's wrong with
the SQL statement. Well, you can
right-click, you can go to the AI
assistant, and you can say fix SQL. So,
if I do that, it launches the AI
assistant window, it automatically
places the SQL statement here, it
explains what is wrong, and then it
gives me not only a corrected but an
even more readable and better formatted
query. So, you'll see if I copy this and
place it underneath, you'll
automatically see
the differences. So, of course, it
corrected that simple error. It also
fixes the indentation and makes it a
little more readable.
So, that's good. Now, what if I wanted
data from other tables? So, I want to
see some details about the orders. So, I
want o. s.
And this would be orders columns. Let us
say I wanted the order dates. All right,
let's just bring over order dates. Now,
obviously, this is an error because
there's no table with the alias o, let
alone a column. This query knows nothing
about that. So, that means I need a
join. So, if I'm going to start writing
join, look at what the auto complete
automatically does. It completes that
join because of the context dual
awareness. It realizes, "Oh, you might
want something from the orders table.
So, clearly, you want to join the orders
table." What if I also wanted to get the
employee name? So, I'm going to do two
things in this part of the demo. One,
I'm going to use the concat function.
So, one of the great things here is that
it gives you tooltips for your
functions, and this is great for the
built-in functions of SQL, but it's also
great for your custom functions where
you might have to use in custom
functions and sprocs and so on and that
additional context does help you to make
better decisions. So, I'm going to say e
.first name
and e
And a little
empty string here.
E would represent employees.
That's not known to the query. Well,
guess what?
I can join and intellisense will
automatically
figure it out for me. So, that is great.
That's a great productivity bit right
there.
Now, let us move on to another scenario
where maybe we want to get some complex
data and maybe we need to write a
report. We have the description of the
report and
we don't have the hours it takes to
convert from description to actual
sequel. So, we can go to the AI
assistant and I can say
please find top customers with total
order value.
Now, I'm going to
attach the database this time and I'm
going to select the connection and make
sure I'm pointing to the correct
database.
And now that I have that connection, I'm
going to run and let it generate that
answer.
And in a few seconds, it's giving me a
query
that is potentially the answer to the
report.
Always remember, whatever the AI does,
you should always review. That's what we
call human in the loop. So, generative
AI and AI assistants and tools are
great. They do help us, but always
review and make sure that the output is
what you need. So, when I select that, I
would see that, okay, this looks
accurate enough. So, I'm satisfied that
the AI assistant did a good job giving
me that query.
And this is where it differs from
generic assistants, like I mentioned
before. It's not just giving me random
SQL. It's actually giving me SQL within
the context of the database that we are
working with.
Now, let us say that this query came
back. We see the results, but we don't
quite understand what it is doing. So,
we can right-click it, go to the AI
assistant again, and say, "Please
explain this SQL." And it is going to,
in plain English, tell us exactly what
it is doing. And the query effectively
shows 10 customers who have spent the
most money. All right, so that's a nice
way to review what your queries are
doing. And it's not just about these
simple queries, but let's say you open
an older stored procedure or somebody
else's query. This can help to shorten
the time between you looking at it and
you understanding what it is doing.
Now, while we're still on select
queries, I do want to show you another
feature of the select that I found very
useful. And that is the ability to
actually navigate the tables right here
from inside the select. So, earlier, we
generated select star from, and then we
listed out all the columns, and then we
built the query. But, what if we could
just build the query from here? So, I
can say I want all of the category
queries, or maybe I just want the
category name here, and then I want the
products down here, the product name,
and the
let us just say reorder level,
etc., right? I can build out all of
these things, and it is generating those
for me as needed.
So, that helps to cut down the time to
find the right object, the right column,
and the right relationship all the time.
Now, one more thing I'm going to show
you is with the insert. So,
a lot of the times with insert
statements, we
um
have to be bouncing between the actual
authoring of the statement and looking
at the columns and the order of the
columns and remembering which order they
are in for the values. If I just press
tab, so I'll let it do this insert
categories, press tab, it generated the
rest of the query for me. I can now fill
it in.
Let us try that with an update. So, if I
say update categories, press tab, look
at that, it's going to fill it out for
me. Set category name, that that that
that, where etc. All right, so
from a productivity standpoint, these
two are really winners. If the select
statements didn't win me over, the
ability to generate the insert and the
update statements very quickly
definitely did. So, so that's really all
I wanted to show you about this tool and
why it's useful to have it sitting right
there in your IDE, whether it's the
Management Studio or Visual Studio, and
its ability to give you contextually
aware and accurate SQL is invaluable.
And actually, I've used other AI tools
that were not this accurate. So, this is
not just me saying, "Here's an AI tool,
use it." This is me saying I've used
others and they were not this good. So,
definitely this is something for you to
check out. If you found this video
useful, please like it. Please share it.
If you find this and other things on my
channel useful, please subscribe. And
also, if you found this tool useful, the
link is in the description. You can go
ahead and use that link to make your
purchase. If you have any special
requests, do leave a comment and I will
get back to you as soon as possible. But
for now, thank you for joining me on
this little adventure. I hope you like
it. I hope you acquire it for your team
and that your story will be as great as
mine is so far. So, thanks again and
I'll see you in the next lesson.