Levirge DevOps · plugin

PostgreSQL

Query PostgreSQL behind a firewall through the outbound devops-client, without opening a port to the database.

Levirge DevOps is in private testing, with no public devops-client download yet.

Features

  • Run SQL queries
  • Browse databases, schemas and tables
  • View table data, paginated
  • Export query results
  • Interactive SQL console
  • Cancel a running query

Capabilities

  • Connects to local or network PostgreSQL instances devops-client can reach.
  • A connection can be set read-only, for example for a replica. devops-client then refuses writes.
  • Passwords stay in devops-client's environment on your machine.

Limits

  • Very large result sets are paginated rather than held in memory.
  • Stored procedures that return results through REFCURSOR aren't supported.