YourSQL is a simple but powerful program to create and manipulate MySQL databases. It is intended to be easy to use for the beginner as well as the more advanced user, and provides access to some otherwise underused, advanced features of MySQL, such as indices, InnoDB tables, multi-statement SQL scripts and multi-threaded handling of SQL dumps for backups or similar administration tasks.

YourSQL is an open source project from Ludit s.r.l..

YourSQL is what the name suggests: The simple tool to create and edit your MySQL databases without too many hassles. The philosophy is to cover those not-too-complicated databases that make up the large majority of databases on the web - and elsewhere. The feature set is limited for exactly this goal: if a feature is not used in most databases, then it should not take up space in the interface, nor should it be allowed to potentially confuse the user by its presence.

YourSQL is intended as the iApp of MySQL clients: the beginner's or intermediate user's quick tool for MySQL database creation. If you have plans for a website with database support for dynamic pages, then chances are that YourSQL will let you create the database you need and especially modify it easily as the development process goes along.

YourSQL is also the ideal tool for experimentation, allowing you to change data types fast and easily, adding and deleting columns as you go.

YourSQL can connect to as many different servers as you wish, and will work in the same way irrespective of the operating system the database is running on. It has been tested with MySQL running on Linux, MacOSX and Windows - you just have to enter the network name of the computer that MySQL is running on. There is an "Add Connection" item ready on the toolbar for that purpose, and you will of course need a valid user name and password for that database. You may wish to use a user name which has assigned all relevant privileges (such as SELECT, UPDATE, DELETE, CREATE, DROP, etc.)


Features :
Easy connections

• Connect to local Mac or servers on local net or on the Internet.
• The character set can be specified for each connection (especially useful for Asian users).
  
• Unavailable servers do not cause the application to hang.

Database browsing and editing

• Browse databases and tables.
  
• View and edit table definitions in a simple, all-in-one Design Table view.
  
• View and edit table data in a spreadsheet-like table view.
  
• Create a new database with one click.
  
• Create tables with choice of available table types on the server (InnoDB, MyISAM, BDB).
  
• Define table columns with all column types and optional modifiers:
  • Case sensitivity (text type columns)
  • Unsigned (numerical columns)
  • Nullable (all columns)
  • Default value
  • One-click definition of automatic increment (integer columns)
  
  
• Simple user interface for custom ENUM and SET type definitions.
  
• Easy re-use of ENUM or SET column definitions to maintain join operations on ENUM fields consistent.
  
• One-click definition of primary keys and standard indices (one-column keys only).
  
• Menu options for UNIQUE and FULLTEXT indices.
  
• Drag and drop reordering of Table columns.

Data viewing and editing

• Immediate update and synchronisation of row view guaranteed for tables with a primary key, when editing non-primary key columns.
  
• Immediate update of tables without a primary key, no synchronisation of the view.
• Refresh Data menu item to synchronise view with changes from other sources.
  
• Menu item for quick emptying of a table, all rows deleted in one operation.
  
• Multiple rows (in non-contiguous intervals) can be selected and deleted in one operation.
  
• Changes to any tables in the system "mysql" database can be flushed automatically (preference setting).
  
• BLOB fields with image data viewable in a drawer to minimise intrusion.
  
• VARCHAR and TEXT fields can be edited in a full-page sheet activated by a simple keyboard shortcut.

Searching

• Large tables are divided into "slices" of a size specified in the preferences.
• A new live search feature provides immediate search for partial strings in table data.
  
• Live search is carried out in all columns for quick searches or in a single specified column for specific purposes.
  
• Live search on large tables is only carried out within the current slice.
  
• Selected table rows can be dragged to other applications or to the desktop as clip files.
  
• Selected table rows can be copied to the clip board and pasted into other applications.
  
• Numerical input is format checked before being sent to the server, to value accidentally being set to 0.

Free-form SQL input

• The free-form SQL queries or more complex scripts can be performed in their own tab.
  
• Allows multiple statements to be run and shows the results of the last statement providing a result set.
• SQL statements are syntax coloured.
  
• The Tab key (or the standard Alt-Esc combo) provide code completion with table and column names.
  
• A SQL script history is maintained for each database and for connections with no database selected.
  
• The query history can be searched easily with PageUp and PageDn.
  
• The script input has its own undo/redo memory.
  
• Results can be copied to the clipboard and pasted into other applications.

Data import/export

• Whole databases (or selected tables) can be dumped to SQL files.
• Dumps are compatible with MySQL's own command line tools on Macs and other platforms for easy and reliable exchange.
  
• Read SQL files (e.g. dumps) into a database.
• Database loads and dumps are performed in a separate threads for easy interruption.
  
• Errors in imported SQL are shown in a separate view together with the specific error message.
  
• Errors can be saved out to a new SQL file for editing and re-importation at a later state.
  
• Byte-precise progress bars for load and save SQL operations.

Documentation

• Save Schema description to HTML, readable by Word and other word processors.

Interface features

• User editable toolbar.