a7 Sql Tools

Explore the database

The table explorer allows to look through the data stored in the tables, it contains several utilities to make it easier to filter the data or build complex where clauses.

After a table is selected, the first 100 rows are displayed

Explore tables in the database

We can use the fields in the columns to filter the data

Column filtering of rows

Use the filter wizard to construct complex where clauses, for example following wizard setup:

User friendly query builder

Will generate following query:

Sql query formatting

It's also possible to freely edit the sql query, and to make changes in the row data and commit the changes.