Database tooling in PyCharm
The database tooling in PyCharm is complete but generic. By this, I mean that PyCharm attempts to support every database out there, and as such, it generally supports features common to all. You may find yourself sometimes leaning on more specific tools, such as SQL Server Management Studio (SSMS) for SQL Server. However, for general development work, the tooling in PyCharm is more than sufficient. The starting point for working with databases in PyCharm is opening the database tools and creating a connection. For this, you also need a database. PyCharm supports dozens of the most popular database servers. Since this is true, it would be impossible for me to predict which one you prefer, so I’m going to fall back on one that I know well: MySQL. Regardless of your favorite, the tooling in PyCharm is generic, so as long as you pick a relational database that is standards-compliant, the processes are the same.
