PyCharm 2019.3 Help

Database tools and SQL

The database management functionality in PyCharm is supported by the Database tools and SQL plugin. The Database tools and SQL plugin provides support of all the features that are available in DataGrip, the standalone database management environment for developers. With the plugin, you can query, create and manage databases. Databases can work locally, on a server, or in the cloud. The plugin supports MySQL, PostgreSQL, Microsoft SQL Server, SQLite, MariaDB, Oracle, Apache Cassandra, and others. See the full list of supported vendors in Connecting to a database.

Get started with database tools

These set of topics are focused on describing features, functionality, the application interface, and might help you to get started quickly.

Connect

Start working with your data source by creating a connection to it.

Run a query

Connect an SQL file to a data source and run your code.

View results

Connect an SQL file to a data source and run your code.

Export/Import

Import and export your data to and from various formats with or without special tools like mysqldump, pg_dump, pg_restore, or psql. Also, you can have a look at the How to export data in PyCharm tutorial.

LocalDB

Step-by-step tutorial how to create, connect, and start working with your SQL Server Express LocalDB instance.

Microsoft SQL server

Tutorial shows you how to start working with Microsoft SQL server and connect to its instance with Windows domain or SQL Server authentication.

Troubleshooting

Connectivity issue is a very common definition and might include many problems. This troubleshooting article will guide you through the most common steps to identify and fix the issue. If you could not find the answer, try to contact JetBrains and we can try to help you.

Diagrams

Generate diagrams for database objects, build query and execution plans, generate flame graphs for EXPLAIN statements.

Last modified: 24 February 2020