The Ultimate DBeaver Developer Cheat Sheet

Mastering keyboard shortcuts and client directives is the fastest way to double your productivity when writing SQL, debugging procedural code, or managing complex database migrations in DBeaver. Bookmark this page as your quick desk reference.

1. SQL Execution Keybindings

2. Code Editor & Formatting Productivity

3. Procedural Debugger Keybindings

4. Transaction & Connection Management

5. DBeaver Client Script Directives

These commands execute directly inside the DBeaver client parser before queries are sent to the database:

-- 1. Declare client-side substitution variable
@set active_status = 'PUBLISHED'
@set current_year = 2026

-- 2. Use variable anywhere in subsequent queries
SELECT * FROM articles 
WHERE status = '${active_status}' 
  AND release_year = ${current_year};

-- 3. Dynamic parameter prompt modal (:param)
SELECT * FROM accounts WHERE account_id = :target_id;

-- 4. Change statement delimiter for triggers and procedures
--delimiter //
-- or standard MySQL delimiter directive:
DELIMITER $$

-- 5. Include external modular SQL scripts
@include '../migrations/001_initial_schema.sql';

6. DBeaver Command-Line Interface (CLI) Arguments

You can automate script executions and launch predefined workspaces via the command line or CI/CD build scripts: