SQLyog Community Edition is a front end for the MySQL database server. The program is aimed at users that are familiar with SQL statements and need an easy to use, no fuss, graphical interface to execute SQL queries, manage users and permissions, edit table properties and more. The program supports execution of multiple queries and selected (highlighted) or single queries and offers a template explorer to quickly insert commonly used queries, such as create table, insert, drop table, rollback and others. In addition, you can export data in CSV, HTML & XML format and Import from a text file, export data and schema itself, flush hosts/logs and more. The program also allows you to diagnose and optimize your databases, save your favorite SQL scripts in favorite folders and more. The Community Edition displays a nag screen that promotes the commercial version of the software.