> AI agents: this is one page from PostHog's docs. Full index of Markdown docs for LLMs: https://posthog.com/llms.txt

# Linking pganalyze as a source

Canonical URL: https://posthog.com/docs/data-pipelines/sources/pganalyze

> **Cloud region:** This page uses US Cloud hosts. For an EU Cloud project, use `https://eu.posthog.com` instead of `https://app.posthog.com` (app host for links).

## On this page

- [Available tables](#available-tables)
- [Configuration](#configuration)
- [Supported tables](#supported-tables)

![](https://res.cloudinary.com/dmukukwp6/image/upload/texture_tan_9608fcca70)

![](https://res.cloudinary.com/dmukukwp6/image/upload/texture_tan_dark_a92b0e022d)

Let AI connect your sources for you

Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.

`npx @posthog/wizard warehouse`

![PostHog Wizard hedgehog](https://res.cloudinary.com/dmukukwp6/image/upload/wizard_3f8bb7a240.png)

![](https://res.cloudinary.com/dmukukwp6/image/upload/wizard_3f8bb7a240.png)Let AI connect your sources for you

The pganalyze connector syncs Postgres performance findings – such as missing index recommendations, slow queries, vacuum issues, and server metadata – into PostHog.

To link pganalyze:

1.  Go to the [sources tab](https://app.posthog.com/data-management/sources) of the data pipeline section in PostHog.

2.  Click **\+ New source** and then click **Link** next to pganalyze.

3.  Enter your pganalyze API key. You can generate a read-only key from your [pganalyze API keys settings](https://app.pganalyze.com/settings/api-keys).

4.  Enter your organization slug. This is the slug visible in your pganalyze URL (e.g., `https://app.pganalyze.com/organizations/your-org-slug`).

5.  *Optional:* If you're using a self-hosted pganalyze Enterprise Server, enter your custom API URL. Cloud users can leave this blank.

6.  Select the tables you want to sync and modify the method and frequency as needed. Once done, click **Import**.

Once the syncs are complete, you can query pganalyze data in PostHog.

## Available tables

| Table | Description |
| --- | --- |
| servers | Metadata about your monitored Postgres servers |
| issues | Database performance findings such as missing indexes, vacuum problems, slow queries, and schema issues |

The **issues** table supports incremental syncing using the `synced_at` field. The **servers** table uses full refresh syncing since it contains dimensional data that changes infrequently.

## Configuration

| Option | Type | Required |
| --- | --- | --- |
| `API key` | password | Yes |
| `Organization slug` | text | Yes |
| `API URL (optional, for self-hosted Enterprise Server)` | text | No |

## Supported tables

| Table | Description | Sync method | Incremental field | Primary key |
| --- | --- | --- | --- | --- |
| `servers` | — | Full refresh | — | — |
| `issues` | — | Incremental, Full refresh | synced\_at | — |