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.

The PostgreSQL data viewer: the schema list on the left with Tables, Views, Indexes, Functions and Queries, an accounts table open in its own tab, a filter and resize handle on each column header, and paging in the footer.

Illustrative mock-up with made-up data, not a screenshot.

Features

  • Run SQL queries
  • Browse databases, schemas and tables
  • View table data, paginated
  • Filter table data by column
  • Export query results
  • Query time and row count with every result
  • Resize table columns by dragging; widths are kept when you reopen the table
  • Interactive SQL console
  • Cancel a running query

For AI agents (MCP)

Connect Claude or another MCP client to Levirge DevOps and the agent can work with this plugin directly.

  • find_connection finds the right connection by name or type.
  • get_sql_schema returns tables and columns. The schema is also offered as an MCP resource, so clients can cache it.
  • run_query runs SQL and pages through large results. Reads work for every role; writes need a role that allows them, and the reply flags any statement that changed data.
  • list_saved_queries returns your saved queries, ready to run.
  • The explain_query prompt has the agent explain a query plan with EXPLAIN ANALYZE.
  • Changes an agent makes are recorded in the audit log as assistant actions.

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.
  • Writes from the web UI ask for an authenticator code first.
  • 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.