JetBrains IDEs (IntelliJ, PyCharm, 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 bit.io with JetBrains

In order to connect to bit.io with a JetBrains product, you'll need to find your PosgreSQL connection credentials from the bit.io 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.

46184618

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

16041604

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 bit.io

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.

48424842

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.

740740

Possible database warning

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


Did this page help you?