SQL Browser

View contents of tables and views and execute SQL queries.

Check which database objects (tables, views, stored procedures, functions) use selected object and which other objects are used by that object.

List Stored Procedures and Functions, view their parameters and execute them after providing the values to the parameters.

Find a table, view, column, index, stored procedure or function name and code that contains given word.

Search entire database's data for a given value.

View detailed statistics and data distribution for every column of a table or view.

Quickly inspect which columns could be indexed or NULLed.

Detect invalid or out-of-range data by looking at the minimum and maximum values.

View definition of database objects. Create DDL (Data Definition Language) SQL commands to recreate or inspect the selected object.

Run a check to verify whether given pair of columns could create a parent-child, child-parent or one-to-one relation. That's useful to deduplicate and normalize data by extracting one or two columns to a separate dictionary table.

Start browsing data from one table or query and immediately look up foreign keys in new views.

After you edit data and submit it, you will see a confirmation window with the generated query. You can either proceed and commit the change or just copy the SQL query to the clipboard and revert that change.

Find which objects use and are used by which in an expandable tree view.

Manually or automatically refresh data in opened windows to see updates, inserts and deletes live as they happen in the database.