# Data source templates

Procedure: Enable the Database Tools and SQL plugin

This functionality relies on the  Database Tools and SQL plugin, which  is bundled and enabled in IntelliJ IDEA   by default. If the relevant features are not available, make sure that you did not disable the plugin.

> **Note:**
> Database Tools and SQL functionality support is limited in IntelliJ IDEA without the Ultimate subscription.

1. Press `Ctrl+Alt+S` (Windows), `⌘ Comma` (macOS), `⌘ Comma` (IntelliJ IDEA Classic (macOS)), `⌘ Comma` (macOS System Shortcuts), `Ctrl+Alt+S` (XWin), `Ctrl+Alt+S` (GNOME), `Ctrl+Alt+S` (KDE), `Ctrl+Alt+S` (Emacs), `Ctrl+Alt+S` (Sublime Text), `⌘ Comma` (Sublime Text (macOS)), `Ctrl+Alt+S` (NetBeans), `Ctrl+Alt+S` (Visual Studio), `⌘ Comma` (Visual Studio (macOS)), `Ctrl+Alt+S` (Eclipse), `⌘ Comma` (Eclipse (macOS)) to open settings and then select `Plugins`.

2. Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name.

Procedure: Enable the Backup and Sync plugin

This functionality relies on the [Backup and Sync](https://plugins.jetbrains.com/plugin/20868-backup-and-sync) plugin,  which is bundled and enabled in IntelliJ IDEA by default. If the relevant features are not available, make sure that you did not disable the plugin.

1. Press `Ctrl+Alt+S` (Windows), `⌘ Comma` (macOS), `⌘ Comma` (IntelliJ IDEA Classic (macOS)), `⌘ Comma` (macOS System Shortcuts), `Ctrl+Alt+S` (XWin), `Ctrl+Alt+S` (GNOME), `Ctrl+Alt+S` (KDE), `Ctrl+Alt+S` (Emacs), `Ctrl+Alt+S` (Sublime Text), `⌘ Comma` (Sublime Text (macOS)), `Ctrl+Alt+S` (NetBeans), `Ctrl+Alt+S` (Visual Studio), `⌘ Comma` (Visual Studio (macOS)), `Ctrl+Alt+S` (Eclipse), `⌘ Comma` (Eclipse (macOS)) to open settings and then select `Plugins`.

2. Open the Installed tab, find the Backup and Sync plugin, and select the checkbox next to the plugin name.

## Overview

You can store your data sources in your [JetBrains Account](https://sales.jetbrains.com/hc/en-gb/articles/208459005-What-is-JetBrains-Account) as data source templates. If you need to reuse some data source settings in another IDE in which you are signed in to your account, you can use a template.

Data source templates include settings from the General and Advanced tabs of the Data Source and Drivers dialog, excluding the User and Password fields.

Procedure: Save a data source as a template

1. In the    Database   tool window   ,  open the General tab of the Data Sources section.

2. Select the data source you want to create a template from and click Save as Template.

![The Save as template button in the Data Sources and Drivers dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_connectivity_templates_save.png)

3. In the Save Data Source as Template dialog, specify the name for your new data source template and click OK.

IntelliJ IDEA creates the new template in the Data Source Templates section.

4. Make sure your URL in the URL field does not contain your username or password.

5. Click OK to     save your new data source template and close the dialog .

Procedure: Create a data source from a template

1. In the    Database   tool window   ,  open the General tab of the Data Source Templates section.

2. Select the template you want to create a data source from and click Create Data Source.

IntelliJ IDEA creates the new data source in the Data Sources section.

![The Create Data Source button in the Data Source Templates tab](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_connectivity_templates_tab.png)