Script Management

Table of contents

• Saving Scripts
• Loading Scripts
• Renaming Scripts
• Reverting Changes
• Changing default scripts directory
• Adding external directory
• SQL Console
  • Read data in SQL console
  • Save your scripts
• Exporting and importing scripts

Saving Scripts

You can save scripts to a predefined space in the currently active project or somewhere in the file system.

To save a script to the current project space, just press Ctrl+S or right-click the script and click Save on the context menu:

You can find the script saved this way in the Project Explorer view in the Scripts folder.

To save a script to the file system, right-click the script, click File -> Export SQL script on the context menu and then select the folder in the file system. You can also click SQL Editor -> Export SQL script on the main menu:

Unsaved data is highlighted in color on the left side of the editor, in addition to having an asterisk in the name of the script.

Loading Scripts

To load a script stored in the file system to the SQL Editor, press CTRL+SHIFT+O, or click SQL Editor -> Import SQL script on the main menu, or right-click the script panel and click File -> Import SQL script on the context menu:

Renaming Scripts

To rename a script, right-click anywhere in the script panel, click File -> Rename SQL Script on the context menu or press CTRL+F2:

Then enter the new name in the Rename SQL script dialog box and click OK:

Reverting Changes

If you want to revert all changes made to the current SQL script and return it to its initial state (reload from disk), right-click anywhere in the script panel and click File -> Revert on the context menu.

Changing default scripts directory

By default all of the scripts are saved to a "Scripts" folder located in your project inside the workspace directory. This can be changed by clicking the Configure button in Project Explorer view. There you can click on a folder's name an pick any other folder inside the Project.

Adding external directory

You can also link an external directory to your project to either save your scripts into it, or to access scripts that were created outside of DBeaver.
To link an External directory right-click anywhere in the Project Explorer and pick Create -> Link Folder. There you can link any directory on your drive to a project. This will allow you to open any externally created scripts through Project explorer and to set this folder as default to save new scripts into.

SQL Console

SQL console lets you run queries without creating a script. It has no associated .sql file, so closing the console discards its contents.

Read data in SQL console

To open a SQL console, use Read data in SQL console in the Database Navigator. It generates and runs a SELECT statement for the selected object automatically.

1. In the Database Navigator, right-click the database object you want to query.
2. Select Read data in SQL console.
3. A SQL console opens and runs the query.

Save your scripts

• Right-click the editor and select Save.
• Use the toolbar: File -> Save / File -> Save As.
• Press Ctrl+S.

Saving converts the SQL console into a SQL editor.

Exporting and importing scripts

Transfer scripts between environments using the built-in import and export tools.

1. Go to File -> Import (to import) or Export (to export)

2. In the opened window, select DBeaver, then choose Scripts

3. In the next step:

   • for importing, select the location that contains the exported scripts, then click Finish
   • for exporting, choose where to save the scripts, then click Finish

4. If prompted, restart DBeaver to apply the imported scripts.

Tip: Exporting and importing items is helpful for sharing or backing up configurations without migrating the entire workspace.