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.
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.
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.
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
. in the database name, but this should not present any issues—you will be able to access your database as intended.
For more information on using JetBrains IDEs with databases, check out the documentation on the IntelliJ Database Tool
Updated 3 months ago