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