Data Browser

The Data Browser page provides a unified interface for exploring schemas and tables across all Wasteology databases.

Page Overview

Data Browser

Browse schemas, tables, and preview data across all connected databases

How to Use

1Select a database from the dropdown

2Choose a schema to browse

3Select a table to view details

4Adjust row limit for data preview

5View columns, row counts, and sample data

Features

🗄️

Multi-Database

Switch between PostgreSQL and Azure SQL databases instantly

📋

Schema Browser

Explore schemas and tables with hierarchical navigation

📊

Data Preview

Preview table data with configurable row limits

ℹ️

Column Info

View column types, nullability, and constraints

Database Selection

Choose from four pre-configured Wasteology databases:

Database	Status	Description
PostgreSQL Production	✓Connected	Main production data
PostgreSQL Development	ℹConnected	Development environment
Azure SQL Production	✓Connected	Azure production data
Azure SQL Development	ℹConnected	Azure development environment

Schema Navigation

After selecting a database:

1. Schemas are listed in the left panel
2. Click a schema to expand and see its tables
3. Tables show row counts when available
4. Click a table to view its details

Table Details

When you select a table, the browser shows:

Column Information

Column	Data Type	Nullable	Default
id	integer	No	nextval
name	varchar(255)	No	-
created_at	timestamp	No	now()

Data Preview

The data preview section shows sample rows from the selected table:

• Row Limit - Adjust how many rows to preview (default: 100)
• Download - Export the preview as CSV
• Refresh - Reload data from the database

Performance

For large tables, keep the row limit low (10-100) to ensure fast preview loading.

Search and Filter

Use the search box to quickly find tables:

• Type a table name to filter the list
• Partial matches are supported
• Search is case-insensitive

Troubleshooting

"No schemas found"

This typically means:

1. Database credentials are incorrect
2. The user doesn't have permissions to list schemas
3. The database is empty

Slow preview loading

For better performance:

1. Reduce the row limit
2. Select specific columns instead of all
3. Check for missing indexes on large tables