PyCharm
 
2024.3
Get PyCharm

Databases with basic support

Last modified: 04 December 2024

To create a data source, you need a JDBC driver. There are two types of drivers in PyCharm: with Complete Support and with Basic Support. You can see a list of database vendors with complete and basic support on the Drivers tab in the Data Sources and Drivers dialog. Also, note that user-created drivers are considered as drivers with basic support.

  • Complete Support includes such features as enhanced code completion and better retrieval of database objects (introspection). For example, with complete support, you will see the following objects in the corresponding databases: user-defined types in Apache Cassandra, macros in Apache Hive, extensions in PostgreSQL. Also, all inspections, quick-fixes, and other coding assistance features are available for databases with the complete support.

  • Basic Support provides a code highlighting, and it also displays the objects retrieved by the JDBC driver. PyCharm uses JDBC metadata for database introspection and the SQL 2016 dialect for code highlighting. No errors are detected and highlighted.

    The introspection with JDBC metadata means that some specific database objects will not appear in the database tree view. Code completion will not include objects that were not retrieved during introspection.

Drivers with complete and basic support

Basic support is provided for the following database vendors:

  • 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