PostgreSQL

PostgreSQL is the world's most advanced open source database and every Nhost project has its own Postgres database.

The following versions of PostgreSQL is supported when creating a Nhost project:

• 12.0
• 11.5
• 10.5
• 9.6

Each newly created project's database have the following prepared tables:

• public.users
• auth.account_providers
• auth.account_roles
• auth.accounts
• auth.providers
• auth.refresh_tokens
• auth.roles

Every Postgres instance comes preconfigured with an SSL certificate

The PostgreSQL database can be accessed directly with a Postgres client such as pgAdmin, DBeaver, or Table Plus. Find the Postgres connection string in the Nhost console in the Postgres tab.