DBeaver

DBeaver is used extensively in the LDP community. The DBeaver Community Edition is free and open source.

Connecting with DBeaver

1. From the "Database" menu, select "New Database Connection"
2. In the wizard that pops up, search for "PostgreSQL." Select it and click "Next >".
3. Type in the connection details above for host, port, database, user, and password.
4. Click on the SSL tab. Check the box next to "Use SSL." Using the "SSL mode" drop-down menu, select "require."
5. Click Finish.
6. The database connection should now appear in the left panel under the Database Navigator. Unless you changed the name, the connection will likely be named "PostgreSQL - ldp_snapshot."
7. Expand the arrow to see the contents of the database.
   1. Under "Schemas", select "public"
   2. Under "public", select "Tables"
   3. Under "Tables", double click on a table name to see basic information about the table, including a tab that shows the data
8. From the "SQL Editor" menu, select "New SQL Editor" to paste in and run an SQL query

Known issues

• Incorrect timezone with Redshift