![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.](/assets/devops-postgres-table.svg)

*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.
