When you first access pgAdmin, you'll see a login form:
- Email Address:
[email protected] - Password:
admin
If you don't see a login screen, you might already be logged in (check the top right corner for your email).
- In the left sidebar, find "Servers"
- Right-click on "Servers" → "Register" → "Server..."
- Name:
Trust Center DB(or any name you prefer)
Fill in these details:
- Host name/address:
trust-center-db- (Use
localhostif connecting from your Mac, not from Docker)
- (Use
- Port:
5432 - Maintenance database:
postgres - Username:
postgres - Password:
postgres - ✅ Check "Save password" (optional, for convenience)
Click the "Save" button at the bottom
You should now see:
- Trust Center DB in the left sidebar under Servers
- Expand it to see:
- Databases → postgres
- Schemas → public, auth, storage, extensions
- Tables → All your application tables
- Expand: Servers → Trust Center DB → Databases → postgres → Schemas → public → Tables
- You'll see all your tables:
organizationsadmin_usersdocumentsdocument_requests- etc.
- Right-click on "postgres" database → "Query Tool"
- Type your SQL and click the play button (
▶️ ) or press F5
Can't connect?
- Make sure
trust-center-dbcontainer is running:docker ps | grep db - Try using
localhostinstead oftrust-center-dbin the host field - Check the port is
5432
Don't see login screen?
- Clear browser cache and cookies for localhost:5050
- Try incognito/private browsing mode
- Check if you're already logged in (look for email in top right)