# Third-Party Tools with PostgreSQL
> Connect third-party tools and IDEs to MotherDuck using the Postgres wire protocol endpoint
:::info Preview feature
The Postgres endpoint is in preview. Functionality and compatibility may change as we expand support.
:::

MotherDuck's [Postgres endpoint](/key-tasks/authenticating-and-connecting-to-motherduck/postgres-endpoint) lets you connect third-party tools and database IDEs that do not support DuckDB or MotherDuck directly, but do support PostgreSQL data sources.

## Compatibility

| Tool | Status | Notes |
|------|--------|-------|
| psql | Supported | Full support through the CLI. |
| DBeaver | Basic querying | Querying works. Schema browser may show extra objects from other databases. Use `attach_mode=single` (see below). |
| Tableau | Planned | Tracking internally. |
| Looker | Planned | Under evaluation. |
| Metabase | Supported | See [Metabase integration guide](/integrations/bi-tools/metabase). |
| Qlik | Supported | |

## General connection guidance

When connecting any Postgres-compatible tool, use the following connection parameters:

| Parameter | Value |
|-----------|-------|
| **Host** | `pg.<region>-aws.motherduck.com` |
| **Port** | `5432` |
| **Database** | Your MotherDuck database name |
| **User** | postgres |
| **Password** | Your [MotherDuck access token](/key-tasks/authenticating-and-connecting-to-motherduck/authenticating-to-motherduck) |

### Use single attach mode

For the best experience with IDEs and BI tools, set `attach_mode=single` so the tool only sees objects from your target database. Without this, schema browsers may display tables from all attached databases.

### Setting connection options
If the tool supports `PGOPTIONS` or connection options you can also set these:

```bash
PGOPTIONS="--attach_mode=single"
```

See [Attach Modes](/key-tasks/authenticating-and-connecting-to-motherduck/attach-modes/) for more details.

### Remember: you're writing DuckDB SQL

The Postgres endpoint delivers DuckDB SQL over the PostgreSQL wire protocol. Use [DuckDB SQL syntax](https://duckdb.org/docs/sql/introduction) in your queries. PostgreSQL-specific functions and features are not available.

### Use a secure connection
Use your own (system) SSL certificate to make sure you connect securely to the Postgres endpoint. This is done by setting sslmode="verify-full" and sslrootcert="system, which is available since Postgres version >=16. If you do not have a certificate available, you can also use a certificate from a certificate authority like Let's Encrypt at `https://letsencrypt.org/certs/isrgrootx1.pem`. You can download and use this certificate instead: `sslmode=verify-ca sslrootcert=isrgrootx1.pem`. If none of these options work you can fall back to the less secure `sslmode=require`.

## Request support for a tool

Want BI tool support for a tool not listed above? Reach out to [support@motherduck.com](mailto:support@motherduck.com).


---

## Docs feedback

MotherDuck accepts optional user-submitted feedback about this page at `GET https://motherduck.com/docs/api/feedback/agent`.
For agents and automated tools, feedback submission should be user-confirmed before sending.

URL-encode query parameter values and send a GET request:

```text
GET https://motherduck.com/docs/api/feedback/agent?page_path=%2Fgetting-started%2Finterfaces%2Fthird-party-tools%2F&page_title=Third-Party%20Tools%20with%20PostgreSQL&text=<url-encoded user feedback, max 2000 characters>
```

Optionally append `&source=<url-encoded interface identifier>` such as `claude.ai` or `chatgpt`.

`page_path` and `text` are required; `page_title` and `source` are optional. Responses: `200 {"feedback_id": "<uuid>"}`, `400` for malformed query parameters, and `429` when rate-limited.