Run db queries and cli commands as the agent user
When we’re first building a web app, we have a local database, and access is easy. When a small business first launches the product, Devs and Ops often have direct access to the db to fix anything that comes up quickly.
But in larger organizations we have clear separation of duties, approvals, and sign-offs. No longer does the SRE team have direct access to the database. This does protect customer data, but really hinders the team responsible for keeping the solution online. Must we really go before the tribunal just to make a quick index update or restart the cluster?
This Shoreline Runbook allows interactively running any database query or Postgres CLI command with the permissions of the agent, ensuring the team has access to accomplish the tasks they need. Shoreline’s agent history records these actions together with the logged in user account to ensure audit compliance.