Connect with JetBrains DataGrip

Use the SingleStore JDBC driver to connect to your SingleStore databases from the JetBrains DataGrip IDE. DataGrip natively supports the SingleStore JDBC driver; select SingleStore from the list of supported drivers and then configure SingleStore as a data source.

Prerequisites

  • Install JetBrains DataGrip.

  • Download the latest version of the SingleStore JDBC Driver (singlestore-jdbc-client-<version>.jar).

  • An active SingleStore deployment.

Configure the Connection to SingleStore

To connect to SingleStore from JetBrains DataGrip:

  1. Open JetBrains DataGrip, and then select + (icon) > Driver. Alternatively, select File > Data Sources > Drivers (tab).

  2. On the Data Sources and Drivers dialog, select SingleStore.

  3. Under Driver Files, select + (icon) > Custom JARs.

  4. Select and upload the downloaded SingleStore JDBC driver .jar file.

  5. Select Create Data Source.

  6. On the SingleStore data source page, enter the connection configuration of your SingleStore deployment:

    • Host: Hostname or IP address of the SingleStore deployment.

    • Port: Default is 3306.

    • User: Username of the SingleStore database user.

    • Password: Password for the SingleStore database user.

    • Database: Enter the name of the SingleStore database to connect with.

  7. Select Test Connection to test connectivity to the SingleStore database.

  8. Upon successfully connecting to SingleStore, select OK to save the configuration.

The SingleStore connection is configured and ready.

Last modified:

Was this article helpful?