Previous Next

Code Completion and SQL Formatting Tools for MySQL

Reduce the time you spend on typing SQL code in dbForge Studio for MySQL — auto completion is here for you! With the intelligent MySQL prompt feature, our MySQL GUI tool offers customizable MySQL syntax highlighting, automatic syntax check, and other capabilities that will let you write and check SQL code effectively and almost effortlessly.

Write more, type less with code completion features

In dbForge Studio for MySQL, code completion features provide the following benefits:

  • List Members
  • Word Completion
  • Phrase Completion
  • Parameter Information for stored procedures
  • Quick Information about schema objects

Save your time with code snippets

Code Snippets are now tightly connected with Intellisense functionality - they are displayed in the suggestion list together with keywords, table names, etc basing on the symbols you type. To insert a snippet, just choose it from the suggestion list or use smart tags.

Managing code snippets is performed through Snippets Manager. In this window, you can edit, add, and remove code snippets.

Use code profiles and formatter to get standards-driven SQL code

Beautify SQL code using formatting capabilities of dbForge Studio for MySQL and make your code clear to everybody. SQL Formatter Wizard lets you format SQL code in multiple files or folders.

Code profiles are used for command standardization. You can create your own profiles with necessary statements to format and set their formatting. The application also allows adjusting existing profiles.

Correct errors in code even before running the statement

Automatic SQL syntax check option lets you write error-free SQL code from the very beginning. Just start typing, and any found errors will be highlighted.

One-click access to schema objects' definitions

When working with SQL scripts, you can navigate to definitions of schema objects and variables. Do you have a definition outside the current script? Then an object editor or a corresponding DDL script will open in another window.

Online Tutorial

Read Enhanced SQL Management article to learn how to facilitate your SQL coding with dbForge Studio features.

Availability

Features

Pro

Std

Exp

SQL Formatter Wizard and automatic syntax check
Yes
Yes
Yes
Code snippets
Yes
Yes
No
Code completion
Yes
Yes
Yes
Phrase completion
Yes
Yes
No
Formatting code through the command line
Yes
No
No
Quick information about schema objects
Yes
Yes
Yes

1 Available only for SELECT and DML statements.

2 Only basic information on objects is available.