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 RubyMine by default. If the relevant features aren't available, make sure that you didn't disable the plugin.
Press Control+Alt+S to open the IDE settings and then select .
Open the Installed tab, find the Database tools and SQL plugin, and select the checkbox next to the plugin name.
To connect to a database and start working with it, you must create a data source that will contain the connection details, and specify those details for the database that you are connecting to.
Select a database that you want to connect to. RubyMine 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