PyCharm 2023.1 Help

Connecting to database

Enable the Database tools and SQL plugin

This functionality relies on the Database tools and SQL plugin, which is bundled and enabled in PyCharm by default. If the relevant features aren't available, make sure that you didn't disable the plugin.

  1. Press Control+Alt+S to open the IDE settings and select Plugins.

  2. Open the Installed tab, find the Database tools and SQL plugin, and select the checkbox next to the plugin name.

To issue a query to a database, you must create a data source connection. Data source is the location of your data and can be a server or a DDL file. The data source includes a name and connection settings that are dependent on the data source type.

Select a data source that you want to create. PyCharm provides a complete support for the following database vendors:

Complete support of a database vendor includes such features as enhanced code completion and better retrieval of database objects (introspection). All the inspections, quick-fixes, and other code assistance features are also available. Whereas a basic support has limited features available.

For more information on the support types, refer to the Other databases topic.

For the database vendors listed below, a basic support is provided:

  • AWS Athena

  • Apache Ignite

  • Apache Spark

  • DuckDB

  • Elasticsearch

  • Firebird

  • Google Cloud Spanner

  • Informix

  • InterSystems IRIS

  • Mimer SQL

  • OpenEdge

  • Phoenix

  • Presto

  • SAP HANA

  • SingleStore

  • Tarantool

  • Teradata

  • TiDB

  • Tibero

  • Trino

  • YugabyteDB

Last modified: 21 June 2023