Introducing PopSQL + dbt. The first SQL editor with built-in dbt support.Read more →

Connecting to PostgreSQL

  1. Click Manage Connections in the top center of the app.
  2. Click New Connection in the Manage Connections modal in PopSQL. alt text
  3. For Nickname, enter something a descriptive name for your connection, like Acme Production.
  4. For Type, choose PostgreSQL.
  5. For Hostname, enter the hostname of your database server.
  6. For Port, use the default 5432, or enter the port used by your server.
  7. For Database, enter the name of your database.
  8. For Username and Password, enter the username and password for PostgreSQL. These are optional.
  9. Hit Connect and you're all set!

alt text

Happy querying! 🍭

AWS RDS IAM

If you need to use AWS IAM to sign into your PostgreSQL AWS RDS database, we support that on our Enterprise plan. Please get in touch with us if this applies to you.

Once enabled, you will be able to select "Amazon RDS IAM Credentials" or "Amazon RDS IAM Profile" as the connection method for PostgreSQL. When using the credentials method, you will be asked for the Region, AWS Access Key ID, AWS Secret Access Key, and optionally the AWS Session Token, which should provided by your administrator. For the profile method, you will be asked for your Profile which corresponds to the named profile you have configured within the AWS CLI.

For both methods, you will also be asked for a Username corresponds to the DB user you wish to use to connect to the database. This user should be granted the rds_iam permission within the database. For example, to create a new user for IAM, you would do the following:

-- Create a new database user
CREATE USER iam_user;
-- Grant permission to use RDS IAM to that user
GRANT rds_iam TO iam_user;

This authentication mechanism only works with direct connections, so please make sure your computer can reach RDS (i.e. you may need to configure need to configure the RDS VPC to allow your IP address).

Ready for a modern SQL editor?