AeroSQL – Web based MySql Manager

Update: May 8th, 2009

Demo
user: demo
pass: demo
Download
v0.9.2 / 8 May 2009
For production
(minified JS).
92 KB
Sources
For development.
94 KB

AeroSQL is an open source (GPLv3) web based tool for managing MySql servers written in PHP. The key feature of the product is an intuitive management of the database content. The result of SELECTs is displayed in a grid as in traditional desktop applications. The grid is editable: you can update cells and save the changes to the backend database server. For now, the query browser represents the main functionality. Additional features will be added in the next versions: administration tools (backup, restore), database object management (create tables).

Don’t forget to download the Ext JS 2.2.1 library before installing AeroSQL.

If you find this product useful, I’d be glad if you donate to support further development.

Screenshots

Screenshot Nr.1

Screenshot Nr.1

Screenshot Nr.2

Screenshot Nr.2

Screenshot Nr.3

Screenshot Nr.3

Screenshot Nr.4

Screenshot Nr.4

Screenshot Nr.5

Screenshot Nr.5

Screenshot Nr.6

Screenshot Nr.6

Key Features

  • Multiple servers administration;
  • Live Queries: if a SELECT is performed on a single table and the result contains a unique index, AeroSQL will let you update the result set, i.e. the result is not read-only; (The unique index with the mininum number of columns is used. If a table doesn’t have a unique index at all, ALL the columns are used as an index.)
  • Sql Monitor: view all SQL commands issued by the server side script;
  • Multi query execution: you can run a batch of sql queries delimited by a semicolon;
  • Correct handling of NULL values;
  • The user can select which columns to display while editing a database table. Subsequent navigation through table rows will fetch only visible columns, thus minimizing network traffic;
  • AeroSQL will provide column editors based on mysql data type:
    • ENUM columns are represented by a combobox;
    • TEXT column editor is a separate window with a TextArea and a WYSIWYG HTML editor;
    • Numeric columns will not allow you to enter letters. Even negative numbers are disallowed if the column was defined as UNSIGNED.
  • Easy to use web interface based on ExtJS framework;

Video

To Do

My intention is to make AeroSQL a full featured MySql manager with functionality found in existing software products like MySQL Query Browser, EMS SQL Manager for MySQL, SQLyog, PhpMyAdmin.

A small list of features that I plan to implement next:

  • bookmark SQL statements;
  • add create/rename/alter functionality for databases, tables, fields, indexes;
  • export data to different formats (CSV, XML, PDF, etc);
  • uploading/executing SQL scripts.
Share
  1. Pol
    October 4th, 2009 at 09:14
    Reply | Quote | #1

    Hi,

    Very nice software, can’t wait to have the new version with ext 3.0 !

    Thanks you for it :)

  2. D.F.
    December 15th, 2009 at 05:58
    Reply | Quote | #2

    Excellent work so far. I often need to backup and restore databases, so I can’t use your tool just yet, but it looks very promising. Keep up the good work!

  3. January 20th, 2010 at 11:49
    Reply | Quote | #3

    Hi,

    Well i really appreciate your efforts to make it a full functional MYSQL web based GUI and that will help alot if you are on linux as there is no good MYSQL GUI available for linux.

    One of my suggestion is to implement autocomplete feature with list of tables, fields and default MYSQL functions by pressing CTRL+SPACE or auto display. I know its very complex in web based interface but if you will implement this feature then your MYSQL GUI will rock!

    Thanks,

    Zeeshan

  4. February 23rd, 2010 at 00:30
    Reply | Quote | #4

    Great software Oleg! This is a definite improvement upon phpMyAdmin. I will use this for a simple site I built for a client that uses a mySQL database to hold entries. Thanks and I tweeted this link, hope you get some traffic ;)

  5. Abraham Elias
    March 4th, 2010 at 11:52
    Reply | Quote | #5

    Very nice work. It’s a great showcase of Ext JS.

You must be logged in to post a comment.
TOP