JetBrains IDEs (IntelliJ, PyCharm, DataGrip, etc.)

JetBrains offers a suite of IDEs (IntelliJ, PyCharm, etc...) with a rich ecosystem of plugins and built-in integrations. Many of these IDEs (e.g. PyCharm and IntelliJ Enterprise), have an integrated Postgres client that lets you connect to and query your data alongside whatever project you might be working on.

Connecting to with JetBrains

In order to connect to with a JetBrains product, you'll need to find your PosgreSQL connection credentials from the Connect Tab of the database to which you would like to connect. You can find everything you need to know about your PostgreSQL credentials here.


Inside the database view, create a new Postgres data source and use the credentials from


See notes below about connection details


Important notes about connection details

Please note you will have to replace the / in database names with a ., as the / is not valid in JetBrains' Postgres client.

You will also have to enable SSL for queries to function correctly.

Using JetBrains IDEs with

Once we've set up our connection, we can explore the schema, query our data, and do anything we might normally do in a standalone Postgres client.


JetBrains IDEs may return a warning cause by the change from / to . in the database name, but this should not present any issues—you will be able to access your database as intended.


Possible database warning

For more information on using JetBrains IDEs with databases, check out the documentation on the IntelliJ Database Tool


Connecting via DataGrip

When connecting via DataGrip, you may need to enable the "Single Database" option in the Options tab