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:

SQL Editor code completion

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:

SQL Editor JOIN completion

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:

SQL Editor quick script

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

SQL Editor Tooltip

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.

SQL Editor results

Next > Database relations