Once your MySQL tables have data, you need an easy way to view, inspect, and verify it. The Nobregas MySQL Panel includes a built-in table browser that displays your data in a clean, paginated table — no SQL queries required.
Opening the Table Browser
- Log in at mysql.nobregas.org.
- Click Databases in the top navigation bar.
- Click Manage on the database that contains the table you want to browse.
- In the tables list, click the table name or the Browse button on that table's row.
The Table Browse page opens with two tabs: Data and Structure. The Data tab is selected by default.
Understanding the Data View
The Data tab displays your table's contents in a formatted table:
- Column headers — Each column name is shown at the top.
- Data rows — Each row of data is displayed beneath the headers.
- Row count — The total number of rows and columns is displayed at the top.
Navigating Through Large Tables
If your table has many rows, the data is paginated:
- 25 rows per page are displayed.
- Use the navigation arrows at the bottom to move between pages.
- The current page number and total pages are shown alongside the arrows.
This keeps the page fast and responsive even for tables with thousands of records.
Reading Different Data Types
The browser handles different data types intelligently:
- Text and numbers are displayed as-is.
- NULL values are shown with a distinct visual indicator so you can distinguish them from empty strings.
- Timestamps are displayed in a human-readable date/time format.
- JSON data is displayed as formatted text.
Row Actions
Each row in the data view has a Delete button (trash icon). Clicking it opens a confirmation prompt before the row is permanently removed — preventing accidental data loss.
Switching to the Structure Tab
Click the Structure tab to view the table's schema instead of its data. This shows column definitions, data types, keys, and default values — useful for understanding the table's design.
Tips for Effective Data Browsing
- Use the SQL Query page if you need to filter or sort your data using WHERE or ORDER BY clauses.
- Navigate to the Structure tab to verify column types and indexes.
- Before deleting a row, double-check the data to ensure it is the correct record.
- Use pagination to avoid loading too much data at once.
