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-like functionality - they are displayed in the suggestion list together with keywords, table names, etc based 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.

Generate CRUD statements with a single click

With the CRUD Generator, you can generate a result script for the SELECT, INSERT, UPDATE, and DELETE statements to a new SQL document in just a wink. Just right-click a table or multiple tables in Database Explorer, point to Generate Scrip As, then point to CRUD, and then click either to New SQL Window, or to Clipboard. Depending on your choice, the generated CRUD statement will be opened in SQL Editor, or copied to clipboard.

On the CRUD tab of the Options dialog box, you can select statements to be included into the script and in what order the columns should be set. You can also modify the template scripts for each part of the CRUD statement.

Correct errors in a 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

To get the detailed information on how to simplify, optimize and facilitate your SQL coding, refer to MySQL Code Editor article.