Schema Explorer & ER Diagrams
Once your connection is established, Tepun AI Report Builder provides powerful tools to explore and understand your database structure.
Schema Browser
Navigate your database structure visually:
- Tables List: See all tables in your database with row counts
- Column Details: View columns, data types, and constraints
- Relationships: See foreign key connections between tables
- Sample Data: Preview rows from any table to understand content
- Search: Find specific tables or columns across large schemas
ER Diagrams
Tepun reports automatically generates visual entity-relationship diagrams from your schema:
- Visual Relationships: See how tables connect through foreign keys
- Interactive: Click tables to see details, zoom and pan to explore
- Auto-Layout: AI arranges tables for optimal readability
- Export: Save diagrams as images for documentation
Understanding Your Data: The ER diagram helps you understand how data flows through your system, which is essential for building accurate reports at report.tepun.com.
Refreshing Schema
When your database structure changes:
- Open the Connection — Navigate to the specific connection
- Click Refresh Schema — Find the refresh button in the schema view toolbar
- Wait for Scan — AI rescans your database and updates the index
- Review Changes — New tables and columns appear in the browser
Learn about AI Suggestions that are generated from your schema.