Database Explorer — User Guide

Audience: Dagen users who want to browse database schemas, run SQL queries, and inspect table data directly from the platform.

Overview

The Database Explorer (/database-browser) provides a visual interface for navigating your connected databases, writing and executing SQL, browsing table data, and inspecting schemas — all without leaving Dagen.

When to use Database Explorer

It complements Data Modeling (design + DDL) and Data Insights (conversational dashboards).

Selecting a Connection

1. Open Explore from the navigation menu.
2. In the left sidebar, use the Select Database Connection dropdown to choose a configured connection.
3. The navigation tree populates with databases, schemas, and tables from that connection.
4. Click Refresh to reload the connection list.

If no connection is selected, the main area shows: "Select a database connection to explore its structure."

Navigation Tree

The sidebar displays a collapsible tree:

• Database nodes — expand to see schemas.
• Schema nodes — expand to see tables and views.
• Table/View nodes — click to load the table in the main area.

Loading indicators appear while child nodes are being fetched. If a connection returns nothing, you see: "No databases or tables found for this connection."

SQL Console

The SQL Console tab is always available (no table selection needed).

Writing Queries

Type SQL in the editor area. The placeholder reads: SELECT * FROM your_table LIMIT 100;

If you have a table selected in the tree, the console title shows the table context for convenience.

SQL Templates

Click the templates menu for common query patterns:

Executing and Exporting

1. Click Execute to run the query.
2. Results appear below the editor with a row count and execution time.
3. Click Export Results to download the result set.
4. Use Copy to copy the SQL to clipboard, or Clear to reset the editor.

If the query succeeds but returns no rows, you see: "Query executed successfully but returned no data."

Data View

The Data View tab is enabled once you select a table from the navigation tree.

1. Click a table in the sidebar.
2. Switch to the Data View tab.
3. Browse paginated rows — choose items per page: 25, 50, 100, or 200.
4. Use the Search in data... field to filter visible rows.
5. Click Export to download the displayed data.
6. Click Refresh to reload.

Pagination shows "Showing X of Y rows" at the bottom.

If no table is selected, the tab shows: "Select a table from the navigation tree to view its data."

Schema Inspector

The Schema tab shows the structure of the selected table.

Columns

A table listing all columns with:

Constraints

If the table has constraints, they are listed with type, columns involved, and referenced tables/columns.

Indexes

If the table has indexes, they are listed with name, uniqueness flag, and indexed columns.

Click Refresh to reload schema information. If no table is selected: "Select a table from the navigation tree to view its schema."

Creating Datasets and Schemas

For BigQuery connections, you can create new datasets. For other databases, you can create new schemas.

1. Click Add Dataset (BigQuery) or Add Schema (other databases) in the sidebar.
2. Fill in:
   • Name (required, alphanumeric and underscores only).
   • Description (optional, max 500 characters).
   • Region (BigQuery datasets only).
3. Click Create Dataset or Create Schema.

Troubleshooting