PyCharm supports interfacing with almost any database. Once you give PyCharm a created database, it can give you the schema of the database, generate a diagram of all the tables and how they are connected, and provide you with SQL writing tools that have code completion.
In PyCharm you cannot create databases, but provides facilities to manage and query them. Once you are granted access to a certain database, you can configure one or more data sources within PyCharm that reflect the structure of the database and store the database access credentials.
Adding an existing database is a simple process of configuring the hostname and port and providing the authentication details required for the connection. It might take a while to initially configure the database since PyCharm will need to download JDBC drivers in order to do so. To add a database, we must first select a type.
In this case, we are going to connect to an existing PostgreSQL...