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 are not available, make sure that you did not disable the plugin.
Press Ctrl+Alt+S to open the IDE settings and select .
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:
- Amazon Redshift
- Apache Cassandra
- Apache Derby
- Apache Hive
- Azure SQL Database
- BigQuery
- ClickHouse
- CockroachDB
- Couchbase Query
- Exasol
- Greenplum
- H2
- HSQLDB
- IBM Db2 LUW
- MariaDB
- Microsoft SQL Server
- MongoDB
- MySQL
- Oracle
- PostgreSQL
- Redis
- Snowflake
- SQLite
- Sybase ASE
- Vertica
- Other
Last modified: 07 February 2023