Passwordless auth

Neon's psql passwordless auth feature helps you quickly authenticate a connection to Neon without providing a password.

The following instructions require a working installation of psql, an interactive terminal for working with Postgres. For information about psql, refer to the psql reference, in the PostgreSQL Documentation.

To connect using Neon's psql passwordless auth feature:

1. In your terminal, run the following command:

   psql -h pg.neon.tech

   A response similar to the following is displayed:

   NOTICE:  Welcome to Neon!
   Authenticate by visiting:
       https://console.neon.tech/psql_session/6d32af5ef8215b62

2. In your browser, navigate to the provided link. Log in to Neon if you are not already logged in. You are asked to select a Neon project to connect to. If your project has more than one compute, you are also asked to select one.

   After making your selections, you are advised that you can return to your terminal or command window where information similar to the following is displayed:

   NOTICE:  Connecting to database.
   psql (15.0 (Ubuntu 15.0-1.pgdg22.04+1))
   Type "help" for help.
   
   casey=>

   The passwordless auth feature connects to the first database created in the branch. To check the database you are connected to, issue this query:

   SELECT current_database();
    current_database
   ------------------
    neondb

   Switching databases from the psql prompt (using \c <database_name>, for example) after you have authenticated restarts the passwordless auth authentication process to authenticate a connection to the new database.

Running queries

After establishing a connection, try running the following queries:

CREATE TABLE my_table AS SELECT now();
SELECT * FROM my_table;

The following result set is returned:

SELECT 1
              now
-------------------------------
 2022-09-11 23:12:15.083565+00
(1 row)