How to Browse and Manage Database Tables in a Web UI
Before You Start
Connect your MySQL or PostgreSQL database first using the MySQL setup guide or PostgreSQL setup guide. Once connected and the schema scan is complete, the web UI is immediately available. For editing capabilities, your database user needs write permissions in addition to SELECT.
Step-by-Step: Using the Table Browser
Navigate to the MySQL or PostgreSQL app in your admin panel. The main page shows a list of all tables in your database, along with the row count for each. Click on any table name to open it.
The table view displays your data in a paginated grid. Each column shows the column name and data type in the header. Scroll horizontally for wide tables, or use pagination to move through large datasets. The default view shows 50 rows per page.
Click on any column header to sort by that column (ascending or descending). Use the filter controls to narrow results by specific column values. You can combine multiple filters, for example showing only records where status equals "active" and created_date is within the last 30 days.
Click on any row to open the record editor. Each field becomes editable with the appropriate input type for its data type. Make your changes and click Save. The platform generates and runs the SQL UPDATE automatically. See How to Edit Database Records Without Writing SQL for more detail.
Use the Add Record button to insert a new row, or the Delete button on an existing record to remove it. Both actions confirm before executing to prevent accidental changes.
What the Web UI Shows You
Table Overview
The table list page gives you a quick overview of your entire database: every table, its row count, and the columns it contains. This is useful for understanding the structure of an unfamiliar database or quickly checking how much data is in each table.
Column Information
Each table view includes column headers that show the column name and data type. This helps you understand what kind of data each column holds without needing to run schema queries. Primary key columns and indexed columns are visually marked so you can identify the table structure at a glance.
Relationship Navigation
When foreign keys are defined, the web UI shows clickable links on foreign key values. If an orders table has a customer_id column that references the customers table, clicking on a customer_id value takes you directly to that customer's record. This makes it easy to follow data relationships across tables without writing JOIN queries.
Web UI vs Desktop Tools
The web UI replaces the need for desktop database tools in most day-to-day management tasks. You do not need to install phpMyAdmin, MySQL Workbench, pgAdmin, or DBeaver. The advantages of the built-in web UI include:
- No installation: Access your database from any browser, any device.
- AI integration: Switch between visual browsing and natural language queries in the same interface.
- Secure access: All connections go through the platform's authenticated sessions. No need to expose database ports to additional tools.
- Team access: Multiple team members can browse the database through their own platform accounts without sharing database credentials directly.
For advanced database administration tasks like creating tables, modifying schema, or managing users, you will still need a dedicated database tool or direct SQL access. The web UI is designed for data browsing and record management, not schema administration.
Browse and manage your database in a web browser. No desktop tools required.
Get Started Free