Postgres / PostGIS
Connect Postgres / PostGIS databases, including Supabase, to Felt. Map spatial tables and views from your database.
Available on the Business and Enterprise plans. Compare plans
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.
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?