Liya allows a user to access three Database Systems simultaneously from a single visual interface.

Liya can access MySQL, PostgreSQL & SQLite3 databases, all in the same way, using a simple 3-panel display - one panel for selecting the database and the table, another for editing the table structure, and the last for editing the contents of the table.

Liya can access databases in all three systems simultaneously, using multiple windows, with each window showing the contents of a single database.

And Liya will move data from one database to another, just by dragging and droppiing. If you need to copy the table structure of one table to another, even across database systems, simply drag and drop across windows. Do the same with data. You can export data from one database for backups that can be read by any of the other databases.

What's New

Version 4.1

Some minor user interface bug fixes

Ratings and Reviews

5 out of 5

5 Ratings

5 Ratings

Works great for me


I’ve been using this for several years to help me debug CoreData in my apps. It works great. The author has also been responsive when I have contacted him about issues. The one thing I hope he will add is support for SQLite databases encypted using SQLCipher.

Hint for those having problems opening a database: you can drag a .sqlite file directly on the Liya app icon to open that database.

Good, but needs polish

Wayne Hartman

I just needed something to edit SQLite databases for iOS development and didn't want to pay money for a solution that had more features than I needed. This app fits the bill pretty well, but could use a but more polish. For example, the app needs to indicate to the user that a custom SQL query is invalid. Also, it would be nice to be able to double click a SQLite database in Finder to launch the app. You have to launch the app first, create a new connection, and then point it to the file. Other than these items, this is a no-frills SQLite viewer that does everything I need it to do.

An Excellent Tool

The Real Lyle

Every Mac comes with MySQL nowadays, and this wonderful app lets you access the power of the database hiding on your machine. The very generous developer has provided the Mac community with it for free! Awesome.

You can click your way to seeing data in existing databases in no time, just by following the onscreen hints, or you can create and run the hairiest SQL queries you write.


Bernard Teo
3.1 MB
Age Rating
Rated 4+
© Bernard Teo,


  • Family Sharing

    With Family Sharing set up, up to six family members can use this app.

More By This Developer