# Postgres / PostGIS

{% embed url="<https://youtu.be/77UK-lbBsYw?si=H-AlC7cupkbiaJ59>" %}

[PostGIS](https://postgis.net/) is a powerful spatial database extension for PostgreSQL that allows you to store, query, and analyze geographic data. Felt provides a simple way to connect, query and visualize this data on a map. Felt can connect to any web-accessible Postgres database by IP address or URL

{% hint style="success" %}
This feature is only available to customers on the [Enterprise plan](https://felt.com/pricing). To upgrade, [contact sales](https://felt.com/sales).
{% endhint %}

1. Create a new, read-only user on your database for Felt access
2. Open **New data source** — from the workspace homepage, click **+** next to **Data sources**. Or from a map, click ![](/files/qv8POfyKJ00VfTgugMR2) in the toolbar and choose **+ New data source**.
3. Select **Postgres / PostGIS**
4. Enter Connection Details
   1. **`Source Name`**: name of the source in Felt
   2. **`Host`** & **`Port`:** host URL & port number: connection details to your database
   3. **`Database`**: name of the PostGIS database
   4. **`Username`** & **`Password`**: database user’s credentials *(not your Felt credentials)* \*\*\*\*
5. Click **`Connect`**
6. Once connected you will see a catalog of your data with previews for your new source
7. From here you can add any of these layers to your spatial dashboards!

#### Supabase configuration

If you use Supabase, input the "Session Pooler connection string" instead of the direct connection string format when connecting to Felt. The session pooler connection string can be found in the Supabase dashboard. See [Supabase docs](https://supabase.com/docs/guides/database/connecting-to-postgres#poolers) for more information.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.felt.com/data-sources/cloud-sources/postgres-postgis.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.