The general form of a connection URI in PostgreSQL:

postgresql://[user[:password]@][netloc][:port][,...][/dbname][?param1=value1&...]

Some examples of valid PostgreSQL URI:

postgresql://
postgresql://localhost
postgresql://localhost:5433
postgresql://localhost/mydb
postgresql://[email protected]
postgresql://user:[email protected]
postgresql://[email protected]/otherdb?connect_timeout=10&application_name=myapp
postgresql://host1:123,host2:456/somedb?target_session_attrs=any&application_name=myapp

The URI scheme designator can be either postgresql:// or postgres://.

In TablePlus, when creating a new connection, you can choose to import directly from URI instead of filling in credentials manually. That’s a much faster and hassle-free option to create a connection.

Import URI in TablePlus


Need a good GUI Tool for PostgreSQL? TablePlus is a modern, native tool with an elegant UI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.


Download TablePlus for Mac.

Not on Mac? Download TablePlus for Windows.

On Linux? Download TablePlus for Linux

Need a quick edit on the go? Download TablePlus for iOS.

TablePlus GUI Tool PostgreSQL