Builder Methods library
Viewing our staging & production databases in TablePlus
Connecting Table Plus to the staging and production Postgres databases hosted on Digital Ocean through Hatchbox. Once set up, you can inspect users, bookmarks, and tags across all three environments — local, staging, and production — from a single GUI.
A walkthrough of wiring up Table Plus to view the live staging and production databases via SSH. Pull the connection details from Hatchbox, configure the SSH-over-Postgres connection, and verify each database is showing the expected real data.
- Why Table Plus is useful for inspecting deployed databases
- Compatibility note: this works with Postgres but not SQLite on Hatchbox
- Locating database credentials inside Hatchbox under Databases
- Creating a new Postgres connection in Table Plus and labeling/coloring it
- Using the "Over SSH" option for Hatchbox-hosted databases
- Filling in database name, user, and password from Hatchbox
- Setting the SSH host (IP), using
deployas the SSH user, and enabling "Use SSH key" - Testing the connection and saving it
- Color-coding production red as a safety cue against accidental edits to live data
- Repeating the same setup for the production database
- Confirming real data: registered users, created bookmarks, and tags in each environment