#PostgreSQL

Run SQL against any Postgres database. Multi-account = multi-database (dev/staging/prod, per-client).

#Get a token

Generate a Connection string (postgresql://…) at https://supabase.com/docs/guides/database/connecting-to-postgres.

#Recommended scopes

• Use a least-privilege role (read-only recommended for unattended agents).

#Add it to the vault

bash
mcpvault add postgres

Example session:

text
$ mcpvault add postgres
Label: acme-prod
Connection string: postgresql://••••
✓ Parsed: acme-prod@db.acme.com/main
✓ Saved.

#Tools exposed

• see upstream — query, schema introspection

#Notes

• Each account is one connection string. Add 'prod', 'staging', 'dev' separately and switch via the agent.

#Switch to this account

In any chat client wired to mcpvault, ask:

Switch to my <label> PostgreSQL account.

The vault server's activate_account tool flips the active label. Wrappers re-read it on the next call — no restart.