Read-only by default
Enforced on the server side of the connection, per connection — not just a disabled button.
Desktop console · PostgreSQL + MongoDB
One Go binary on your machine opens ssh tunnels to your servers and serves a web console on loopback. Browse, query and administer PostgreSQL and MongoDB; changes are possible only when you turn write mode on.
browser └─▶ pmonitor 127.0.0.1:8090 (your machine) ├─ ssh -L ─▶ PostgreSQL on the server └─ ssh -L ─▶ MongoDB on the server # server side: nothing installed, no new port opened mode: READ ONLY write mode: per connection, off again after 15 min
What it does
Built for the person who looks after the servers and wants to see before touching.
Enforced on the server side of the connection, per connection — not just a disabled button.
Tunnels use the system ssh with your ~/.ssh/config, agent and known_hosts. Tunnels that die are rebuilt.
Browse schemas, tables and views with filtering and paging, inspect structure, run SQL, and see sessions, locks and sizes.
Find and aggregate with Extended JSON, plus indexes, statistics, running operations and replica-set status.
Each gateway domain mapped to its port, process and service with status, uptime, memory and logs.
For a PGateway database: 24-hour traffic per route, stuck calls, open dead-letters, outbox and breakers, plus lookup by message id.
How it works
There is no account and no service to run on the server.
make build produces one binary.
make config copies the example to ~/.config/pmonitor/config.json with 0600 permissions.
Name the ssh host, the database address as seen from the server, and an optional passwordFile.
make run prints a URL with a token and opens your browser.
FAQ
No. It runs on your own machine and reaches databases through ssh tunnels.
Only after you turn write mode on for that connection, and only for 15 minutes at a time.
PostgreSQL and MongoDB. A database can also be on the same machine, without ssh.
PMonitor is an internal tool of the Calix team. Contact us if you would like to use it.
Get in touch and tell us which databases you look after.
Get in touch