# Connect to a database using URL

Create a database connection by providing a pre-built URL with connection details.

Before you begin
: Make sure your database instance is configured to accept incoming connections from the following IP address:
:
:
:
:
: ```
: 63.33.83.29
: ```
:
:
:
: > **Note:**
: > If you are using Datalore On-Premises, its IP address is different. Contact your Datalore administrator for details.

Procedure: Step 1. Configure a database connection

1. Open the New database connection dialog. The step depends on whether you want to add a new database connection in workspace resources or in a notebook.

In a workspace:

1.  In the sidebar on the Home page, select the workspace where you want to create a database connection.

2.

In the workspace resources, select ![Document](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/document.svg) Data and switch to the Databases tab.

!['Databases' tab](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/ws-databases.png)

3.  Click ![Plus icon](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/plus.svg) New database connection at the top right.

In a notebook:

1.  In the sidebar, select ![Attach](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/attach.svg) (Attached data).

2. Switch to the Databases tab.

3.

Click ![Plus](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/plus.svg)New database.

![The Attached data section in a notebook with the Databases tab open](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/database-notebook.png)

2. In the New database connection dialog, switch  to the Enter URL tab.

![New database connection dialog](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/nb_dialog.png)

3. Provide the URL in the Connection URL  text field and click the Next button.

This will open the connection dialog for the respective database type with all the fields pre-filled.

> **Tip:**
> You can pass additional parameters when providing the URL. For example, add `&SSL=true` to the URL string to enable SSL.

![Enter URL tab](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/prebuilt_url.png)

4. Click the Test connection button at the bottom of the dialog.

5. Once successfully tested, click the Create and close button.

Procedure: Step 2. Attach the connection to a notebook

In a workspace:

1. Open the notebook you want to attach the connection to.

2.  If the notebook is not running, start it by clicking `Run | Start machine`.

3.  In the sidebar, select Attached data and switch to the Databases tab.

4.

Enable the toggle in your database connection.

In a notebook:

1.  If the notebook is not running, start it by clicking `Run | Start machine`.

2.  In the sidebar, select Attached data and switch to the Databases tab.

3.

Enable the toggle in your database connection.

## Next steps

* If OAuth authentication was used for this connection, report users and notebook collaborators may be required to provide their credentials to access the database.

* To retrieve and process data from the connected database, use [Query data with SQL cells](sql-cells.html).

* Learn how to manage and delete database connections [in a workspace](databases-as-workspace-resources.html) and [in a notebook](database-connections-on-notebook-level.html).

## Keywords

database, database connection, attach data, data sources, configure connection, pre-built connection URL, prebuilt URL, prebuilt connection URL