Stackpane Stackpane
Download

Table Browser

Browse PostgreSQL tables, view rows with pagination, and navigate foreign key relationships in Supabase.

Overview

The Table Browser is the primary interface for exploring your Supabase PostgreSQL database in Stackpane. It lists all tables in the sidebar, displays rows in a sortable and paginated table, and provides foreign key navigation for relational data exploration.

Browsing Tables

When you select a Supabase connection, Stackpane loads all tables from the public schema in the sidebar. Click any table name to load its rows into the main table view.

  • Tables are listed alphabetically
  • Each table shows its row count when available
  • Column types are displayed in the table header (e.g., text, int4, uuid, timestamptz)

Table Sidebar

Use the search field at the top of the sidebar to filter tables by name. This is helpful in projects with many tables.

Refresh

Click the Refresh button to reload the table list. This picks up any tables created outside of Stackpane, such as through migrations or the Supabase SQL editor.

Row Table

The main content area displays rows from the selected table with auto-generated columns based on the table schema.

Column Headers

Each column header shows:

  • Column name — the PostgreSQL column name
  • Type indicator — the column data type (e.g., text, int8, bool, jsonb, uuid)
  • Key icon — a key indicator for primary key columns
  • Link icon — a link indicator for foreign key columns

Pagination

Rows load in pages based on your configured page size (default: 25). Navigation controls at the bottom of the table allow you to move between pages. The total row count is displayed when available.

Sorting

Click any column header to sort by that column. Click again to reverse the sort direction. An arrow indicator shows the current sort column and direction. Sorting is performed server-side for accurate results on large tables.

Column Visibility

Click the column configuration button in the toolbar to show or hide specific columns. This is useful for wide tables where you only need to view a subset of columns.

Foreign Key Navigation

Columns with foreign key relationships display a link icon in the header and clickable values in each row.

  1. Click a foreign key value in any row.
  2. Stackpane navigates to the referenced table and highlights the matching row.
  3. Use the browser back button or breadcrumb navigation to return to the original table.

Foreign key relationships are automatically detected from the PostgreSQL schema metadata, including the referenced table and column.

Foreign Key Introspection

To view all foreign key relationships for a table:

  1. Select the table in the sidebar.
  2. Open the table info panel from the toolbar.
  3. The panel lists all foreign keys with their source column, referenced table, and referenced column.

This provides a quick overview of how the table relates to other tables in your schema.

Aggregation Queries

Run aggregate operations against the current table:

  1. Open the aggregate panel from the toolbar.
  2. Select the aggregation type: COUNT, SUM, AVG, MIN, or MAX.
  3. For SUM, AVG, MIN, and MAX, select the column to aggregate.
  4. Click Run to see the result.

Aggregate queries respect any active filters, so you can compute aggregates on a filtered subset of rows.

Configuration

  • Default page size: 25, 50, 100, 250, or 500 rows per page (Settings > Data)
  • Row density: Compact, Regular, or Comfortable (Settings > Appearance)
  • Null display: Configure how NULL values appear in the table (Settings > Data)