DB Explorer is a web application for exploring relational databases, visualizing database schemas, and discovering related data through foreign-key relationships.
- Visualize database schemas.
- Display tables, columns, data types, sizes, nullability, and comments.
- Display physical foreign-key relationships.
- Support logical relationships between tables.
- Navigate between related tables.
- Search for a value across multiple tables.
- Discover related records starting from a known value.
- Explore table data through REST APIs and a web interface.
- Support Oracle and other JDBC-compatible databases.
- Handle Oracle JSON columns as strings.
- Use JDBC metadata to inspect database structures.
DB Explorer reads database metadata through JDBC and builds an internal representation of:
- schemas;
- tables;
- columns;
- primary keys;
- foreign keys;
- column comments;
- table comments;
- update and delete rules.
The metadata is then used to generate a visual schema and to navigate through relationships between tables.
Starting from a value, DB Explorer can search for matching records and follow the available relationships.
For example, it can:
- find a customer identifier;
- locate related orders;
- find associated addresses;
- navigate from a master record to dependent records;
- show records connected through foreign keys.
The search should be limited to tables and columns that can be reached through configured or detected relationships.
A physical relationship is defined by an actual database foreign key.
Example:
CUSTOMER.ID -> ORDER.CUSTOMER_ID