# PostgreSQL integration

Connect PostgreSQL so Annie can query application data, slow queries and database health read-only, and correlate them with your infrastructure graph.

Source: https://anyshift.io/for-agents/integrations/postgresql

## Availability

- Available in beta.

## Capabilities

- Discover schemas, tables and indexes

- Run EXPLAIN and find slow queries with pg_stat_statements

- Check connections, locks, replication and table bloat

- Connect multiple databases, each with its own read-only credentials

- Strictly read-only: queries run in read-only transactions

## Connect and verify

- Check the intended project's existing integration before adding a connection.

- Verify that the resources and time window needed for the task are covered. Connection status alone does not establish that the evidence is available.

[PostgreSQL setup and permissions](https://docs.anyshift.io/pages/integration/postgresql)

## Use cases

- Check the application data behind a customer report during an incident

- Tie a slow-query spike to the deploy or infrastructure change that caused it

- Get index recommendations backed by real query plans

## Continue

[All integrations](https://anyshift.io/for-agents/integrations)

[Query your project with Graph MCP](https://anyshift.io/for-agents/product/context)