For the complete documentation index, see llms.txt. This page is also available as Markdown.

Postgres / PostGIS

Connect Postgres / PostGIS databases, including Supabase, to Felt. Map spatial tables and views from your database.

Connect Postgres / PostGIS to add a PostgreSQL database's tables, views, and materialized views to maps or query them with SQL. Felt must be able to reach the database over the internet. It uses PostGIS geometry and geography columns to place features on the map.

Connect Postgres / PostGIS

Create a read-only database user for Felt with access to the schemas and tables you want to use. Then follow the steps in Add a source and select Postgres / PostGIS. If the database accepts connections only from known addresses, allow Felt's IP addresses.

In Connection, fill in these fields, or click Autofill and paste a connection string such as postgresql://user:password@database.server.com:5432/dbname.

Field
Required
What to enter

Host

Yes

The Postgres host name or IP address, such as db.companyname.com. It can't be localhost.

Port

Yes

The Postgres port. The default is 5432.

Database

Yes

The name of the database.

Username

Yes

The database user you created for Felt, not your Felt login.

Password

Yes

That user's password. Felt hides it after you save.

Schema

No

One schema to read. Leave it empty to read all schemas. It can't start with pg_.

Connect Supabase

A Supabase database runs Postgres, so it connects as a Postgres / PostGIS source. In the Supabase dashboard, copy the session pooler connection string, not the direct connection string. Then follow Connect Postgres / PostGIS, click Autofill, and paste the string. See Supabase's guide to connection poolers.

Last updated

Was this helpful?