All integrations
Databases
Postgres
Browse tables and run read-only SQL. Optionally list your users table on Users.
What you see
Databases
On the Data page as soon as Postgres is connected.Sign-in, optional
On the Users page once you fill in Users table.
How to connect
Paste a key
postgres://user:password@host:5432/db. Use a role that can only read, plus UPDATE on the banned column if you want bans. Get a key The key is checked against Postgres before it’s saved, then sealed so only the broker that calls Postgres can open it.From a terminal
The CLI asks for the same key at a hidden prompt, so an agent running it never sees the key.$ npx baseboard-cli connect postgres --project k57abc
Settings
- Users tableoptional
- Name your users table to list its rows as accounts on Users.For example
users - Id columnoptional
- For example
id - Email columnoptional
- For example
email - Created-at columnoptional
- For example
created_at - Last sign-in columnoptional
- For example
last_sign_in_at - Banned columnoptional
- A boolean column. With it, bans can be requested from Users.For example
banned
Connect Postgres and the rest of your stack in one place.
Free covers one project with three connections. Everyone starts read-only.