SQLyog is a GUI tool for the

RDBMS A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A Relational Database Management System (RDBMS) is a type of database management system that stores data in a structured forma ...

MySQL MySQL () is an Open-source software, open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A rel ...

. It is developed by Webyog, Inc., based in

Bangalore, India Bengaluru, also known as Bangalore (List of renamed places in India#Karnataka, its official name until 1 November 2014), is the Capital city, capital and largest city of the southern States and union territories of India, Indian state of Kar ...

, and

Santa Clara, California Santa Clara ( ; Spanish language, Spanish for "Clare of Assisi, Saint Clare") is a city in Santa Clara County, California. The city's population was 127,647 at the 2020 United States census, 2020 census, making it the List of cities and towns i ...

. SQLyog is being used by more than 30,000 customers worldwide and has been downloaded more than 2,000,000 times.

History

SQLyog v0.9 was first released to the public in 2001 after eight months of development. SQLyog was available free of charge, but with closed source code, until v3.0 when it was made a fully commercial software. Nowadays SQLyog is distributed both as

free software Free software, libre software, libreware sometimes known as freedom-respecting software is computer software distributed open-source license, under terms that allow users to run the software for any purpose as well as to study, change, distribut ...

as well as several paid, proprietary, versions. The free software version is known as Community Edition at

GitHub GitHub () is a Proprietary software, proprietary developer platform that allows developers to create, store, manage, and share their code. It uses Git to provide distributed version control and GitHub itself provides access control, bug trackin ...

. Paid versions are sold as Professional, Enterprise and Ultimate Editions.

Features

Prominent features of SQLyog are: * 64-bit binaries are available from version 11.0. * Editor with

syntax highlighting Syntax highlighting is a feature of text editors that is used for programming language, programming, scripting language, scripting, or markup language, markup languages, such as HTML. The feature displays text, especially source code, in differe ...

and various automatic formatting options * Intelligent Code Completion * Data manipulations (INSERT, UPDATE, DELETE) may be done from a spreadsheet-like interface. Both raw table data and a result set from a query can be manipulated. * Visual Schema Designer * Visual Query Builder * Query Formatter * Connectivity options: Direct client/server using

API An application programming interface (API) is a connection between computers or between computer programs. It is a type of software interface, offering a service to other pieces of software. A document or standard that describes how to build ...

( SSL supported),

HTTP HTTP (Hypertext Transfer Protocol) is an application layer protocol in the Internet protocol suite model for distributed, collaborative, hypermedia information systems. HTTP is the foundation of data communication for the World Wide Web, wher ...

HTTPS Hypertext Transfer Protocol Secure (HTTPS) is an extension of the Hypertext Transfer Protocol (HTTP). It uses encryption for secure communication over a computer network, and is widely used on the Internet. In HTTPS, the communication protoc ...

tunneling, SSH tunneling * Wizard-driven tool for import of data from

ODBC In computing, Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. An ...

-databases * Backup Tool for performing unattended backups. Backups may be compressed and optionally stored as a file-per-table as well as identified with a timestamp. * "SQL Scheduler and Reporting Tool" - a tool for scheduling and automating execution of any sequence of SQL statements. Result of queries may be sent as

HTML Hypertext Markup Language (HTML) is the standard markup language for documents designed to be displayed in a web browser. It defines the content and structure of web content. It is often assisted by technologies such as Cascading Style Sheets ( ...

-formatted reports. * Schema/Structure Synchronization and Data Synchronization * Query Profiler and Redundant Index Finder * All automated jobs have mail alerting and reporting options. * Full character set/

Unicode Unicode or ''The Unicode Standard'' or TUS is a character encoding standard maintained by the Unicode Consortium designed to support the use of text in all of the world's writing systems that can be digitized. Version 16.0 defines 154,998 Char ...

support * A "Data Search" feature using a Google-type search syntax translated transparently for user to SQL. * Form view to display one row at a time * Foreign key lookup * Visual Data Compare

Technical specification

* Programmed and developed in C++ using Win32

. No dependencies on runtimes (

.NET The .NET platform (pronounced as "''dot net"'') is a free and open-source, managed code, managed computer software framework for Microsoft Windows, Windows, Linux, and macOS operating systems. The project is mainly developed by Microsoft emplo ...

Java Java is one of the Greater Sunda Islands in Indonesia. It is bordered by the Indian Ocean to the south and the Java Sea (a part of Pacific Ocean) to the north. With a population of 156.9 million people (including Madura) in mid 2024, proje ...

etc.). * Uses

C API to communicate with MySQL servers. No dependencies on

database abstraction layer A database abstraction layer (DBAL or DAL) is an application programming interface which unifies the communication between a computer application and databases such as SQL Server, IBM Db2, MySQL, PostgreSQL, Oracle or SQLite. Traditionally, all ...

s (like

JDBC Java Database Connectivity (JDBC) is an application programming interface (API) for the Java (programming language), Java programming language which defines how a client may access a database. It is a Java-based data access technology used for Java ...

). * Uses

SQLite SQLite ( "S-Q-L-ite", "sequel-ite") is a free and open-source relational database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it ...

to store internal data like Grid settings. Consequently, these settings are persistent across sessions on a per-table basis.

Platforms

SQLyog works on the

Windows Windows is a Product lining, product line of Proprietary software, proprietary graphical user interface, graphical operating systems developed and marketed by Microsoft. It is grouped into families and subfamilies that cater to particular sec ...

platform ranging from

Windows Vista Windows Vista is a major release of the Windows NT operating system developed by Microsoft. It was the direct successor to Windows XP, released five years earlier, which was then the longest time span between successive releases of Microsoft W ...

Windows 10 Windows 10 is a major release of Microsoft's Windows NT operating system. The successor to Windows 8.1, it was Software release cycle#Release to manufacturing (RTM), released to manufacturing on July 15, 2015, and later to retail on July 2 ...

. (Windows 9x/ME support was removed in version 5.0, Windows 2000 support stopped with version 8.6, and Windows XP support ended with version 12.5.) It has also been made to work under

Linux Linux ( ) is a family of open source Unix-like operating systems based on the Linux kernel, an kernel (operating system), operating system kernel first released on September 17, 1991, by Linus Torvalds. Linux is typically package manager, pac ...

and various Unixes (including

macOS macOS, previously OS X and originally Mac OS X, is a Unix, Unix-based operating system developed and marketed by Apple Inc., Apple since 2001. It is the current operating system for Apple's Mac (computer), Mac computers. With ...

) using the

Wine Wine is an alcoholic drink made from Fermentation in winemaking, fermented fruit. Yeast in winemaking, Yeast consumes the sugar in the fruit and converts it to ethanol and carbon dioxide, releasing heat in the process. Wine is most often made f ...

environment. Further, a subset of SQLyog Enterprise/Ultimate functionalities are available with the free SJA (SQLyog Job Agent) for Linux as a native Linux utility. This makes it possible to specify and test "scheduled jobs" on a Windows environment and port execution parameters seamlessly to a Linux environment.

Support

Webyog provides priority support to customers primarily through a ticket based support system. Users of Community Edition can get support throug
Webyog Forums
which has more than 15000 registered users. Webyog also maintains an extensive FAQ for most commonly asked questions.

References

External links

Official Webyog home page

Community Edition project page

Comparison Sheet between Community and commercial editions

SQLyog Screenshots

{{DEFAULTSORT:Sqlyog Database administration tools