Clarity for MySQL - Powerful MySQL GUI Tool. The Best Code AutoComplete!!

Write perfect queries, functions, and procedures in half the time, create and modify database objects easily with visual designers, or quickly edit table data. Clarity even lets you copy-and-paste database objects from one database to another with just a few keystrokes.

• Works with  MySQL 5.0 or newer
• Powerful SQL Editor with comprehensive SQL autocomplete
• Graphically Edit Security Objects, Tables and more ..
• Edit/import/export table data to/from a variety of popular file formats
• Integrated Debugger - debug your scripts and procedures
• Reverse-engineer ER Diagrams

Other features

Unparalleled SQL Editor

A lot of SQL Editors promise AutoComplete - but most are limited to only table and column names, and only for a certain set of commands. Clarity takes this concept one step further, and shows you complete step-by-step AutoComplete information for most SQL commands you'll ever use. Need to know what the syntax is for an ALTER TABLE command ? How about a CREATE INDEX ? Just type in a couple of letters of your command, and let Clarity take care of the rest. You'll never type in the wrong syntax again.

 скрины

Need to execute a procedure? type in the procedure name and Clarity will display the parameters as a tooltip. Hit TAB, and Clarity will automatically insert the parameters into your script, allowing you to tab through the list of parameters. Say goodbye to manually looking up parameters.
As you're typing your SQL, Clarity will automatically hyperlink table and procedure names, so you can quickly view the definitions or data for the given tables or procedures.

 скрины

And of course, Clarity offers all the standard editor features such as syntax coloring, parenthesis and quote matching, and line numbering, features that you would expect from any decent editor.

Powerful History Manager

As you're running your scripts, making data changes2 or viewing object definitions, Clarity will keep track your operations, and display them in the easy to use History Pane. Using the History Pane, you can easily re-run a SQL command or an operation just by ctrl-clicking it. Made table changes but want to roll them back ? Clarity will even allow you selectively roll back certain rows. Searched for some database objects ? Re-run your search at a later time just using one-click.

Graphically Edit Everything

From server configurations, to table data - Clarity lets you edit most objects using easy to use Graphical Designers. Clarity offers graphical designers for the following database objects ...

• Alerts
• Aliases
• Databases
• Defaults
• Groups
• Functions
• Indexes
• Logins
• Messages
• Operators
• Roles
• Rules
• Schedules
• Scheduled Tasks
• Server Roles
• Tables
• Users

In addition, Clarity allows you to easily edit your table data graphically, even if your table contains image data. Use the 'Apply Lookup Table' feature to lookup IDs from another table, or use 'View Related Rows' to view related data from another table ..

Integrated Debugger

Step Through Your Code
Clarity features a powerful built-in SQL debugger that is ready to work out of the box. Use it to step through, or over, your SQL scripts and stored procedures. You can easily set breakpoints, and inspect local and watch variables. Clarity even lets you modify the value of your variables during a debug session.

Compare/Merge Objects & Data

ompare Objects Easily
Clarity let's you compare two text sources (any text sources, whether they are text files, or object definitions directly from the database) and shows them as side by side views. Comparing data between two tables (or any data sources) is easy with the 'Compare Data' option. And finally, you can compare two databases for all there data and objects.

But if you're going to compare, why stop there ? Clarity can automatically merge them into a new text file if you're comparing texts. If you're comparing data, you can create a merged resultset, or just sync the table data in place using one click of the button.

Feature Summary

• Configurable workspace with dockable panes
• Unlimited¹ number of SQL editors with syntax coloring, parenthesis/quote matching and multi-level undo.
• Comprehensive auto-complete, and object name hyperlinking.
• Unlimited¹ number of resultset windows.
• Grouping/Sorting/filtering of resultsets.
• Import/export results in multiple popular file formats.
• View results in grid/text/form view format.
• View thumbnail images for image columns in your resultset
• Graphically edit table data, with automatic lookups
• View all related data from another table using 'View Related Rows'
• Quickly view list of most server objects
• Graphically create or edit most server objects
• Powerful History Manager displays and allows you to re-run (or undo, in some cases) the following ..
  
  
  
  
  • SQL commands
  • Database object searches
  • Database object definition lookups
  It also allows you to rollback the following operations ..
  
  
  
  
  • Database object drops
  • Table data edits
  • Truncate tables
• Compare (and merge) scripts or table data
• Compare two databases for content
• Integrated SQL Debugger
• Reverse-engineer database ER diagram
• Chart resultsets in bar-chart, pie-chart or line-chart formats
• Monitor server performance/space usage using Performance Monitors

And more .. :))

Download trial:  http://www.taurensys.com/download_page.aspx