Manage your Supabase database on mobile

4 minute read Database Beginner

The Supabase Table Editor is one of the most useful parts of the dashboard — and one of the most broken on mobile. BaseDeck gives you a clean, touch-friendly alternative: browse your tables, inspect rows, and run SQL queries against your live database, all from your phone.

The Database tab

Open BaseDeck at https://basedeck.netlify.app/dashboard and tap Database in the bottom navigation. BaseDeck fetches a list of all tables in your project's public schema and displays them as a scrollable list.

BaseDeck reads tables from your public schema only. Tables in other schemas are not listed here — use the SQL tab to query them directly.

Browsing table rows

1

Tap a table name

Tapping any table in the list loads its rows. BaseDeck fetches the first 50 rows via PostgREST and displays them in a horizontally scrollable data table.

2

Paginate through rows

Use the Prev and Next buttons at the bottom of the table to move between pages of 50 rows. The row range is displayed between the buttons so you always know where you are.

3

Go back to the table list

Tap ← Tables at the top left to return to the full table list without losing your place.

The SQL tab

For anything the table browser can't do — filtering rows, joining tables, checking row counts, running aggregates — use the SQL tab. Tap SQL in the bottom nav. A CodeMirror editor opens with a starter query.

Running a query

Type or paste your SQL, then tap Run (or press Ctrl+Enter on a connected keyboard). Results appear in a scrollable table below the editor. The execution time in milliseconds is shown alongside the row count.

-- Check how many rows are in a table
SELECT COUNT(*) FROM orders WHERE status = 'pending';

-- Recent signups
SELECT id, email, created_at
FROM auth.users
ORDER BY created_at DESC
LIMIT 10;

Destructive queries

If your query contains DROP, DELETE, TRUNCATE, or ALTER TABLE, BaseDeck shows a confirmation dialog before running it. This gives you a chance to catch mistakes — especially useful when typing on a small screen.

BaseDeck runs SQL with the same permissions as your encrypted token. Write queries carefully — there is no undo for destructive operations.

Query history and snippets

BaseDeck automatically saves your last 20 queries to history. Tap History to browse and reload any previous query in one tap. For queries you use regularly, tap Save to give it a name and store it as a snippet — accessible any time via the Snippets button.