Connecting to database

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. WebStorm provides a complete support for the following database vendors:

• 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

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