Next > Database relations

SQL Editor with code completion

Intelligent SQL editor allows you to create and edit SQL queries and scripts much faster,
with less typing errors and with no need to constanly search for correct name of some table or column.

DbOctopus offers completion of all SQL keywords and database objects:

JOINing few tables required lots of typing. Not anymore.
With DbOctopus all you have to do is select relation and JOIN will be written for you:

Basic commands like SELECT, INSERT, etc. can be autocreated and inserted into your query, where you can easily tweak them.
That way you can quickly build scripts containing several SQL commands:

DbOctopus shows tooltips with list of parameters for stored procedures and functions:

Of course, once you get results from your query you can filter them further, export, etc.
Most of features we have for tables is available here too.

Next > Database relations