Skip to content

Products

Desktop

DBeaver Enterprise Data management and SQL development DBeaver Ultimate Work with data and SQL on-premise and in the cloud DBeaver Lite Data tables and SQL queries with a lightweight interface

Web & hybrid

CloudBeaver Enterprise Secure browser-based data management DBeaver Team Edition Advanced data collaboration with access control

CLI

dbvr Running database operations in headless and terminal-first environments

See DBeaver in action

Connect with an expert

Book a demo
Pricing

Licenses

Buy Purchase a license License types See all available licenses Academic licenses Free for students

Choose your product

Learn about DBeaver PRO options

Compare products
Resources
Learning & training

Blog

Supported databases

Integrations

Use cases

For partners

Become a partner

Resellers

Technology partners

Universities

About us

Careers

Company

Customers

Events
Documentation

Documentation

DBeaver Desktop Products View documentation for DBeaver desktop products, on-premises database management tools with enterprise features and advanced automation. CloudBeaver Enterprise View documentation for CloudBeaver, a web-server application for distributed teams needing secure, browser-based access. DBeaver Team Edition View documentation for DBeaver Team Edition, a server-based database management platform for teams, deployable on-premises or in the cloud for collaboration. dbvr View documentation for dbvr, a lightweight CLI to run database operations without a GUI.

Support
Get a trial

Sign in Sign up

Sign in Sign up

DBeaver
CloudBeaver
Team Edition
dbvr

Initializing search

Getting started
Getting started
Web user guide
Web user guide
- Application window overview
- Basic operations
- Configure connections
  Configure connections
  - Create connection
  - Connection types
  - Network configuration settings
    Network configuration settings
    
    SSH configuration
    
    SSL configuration
    
    Network profiles
  - Databases authentication models
    Databases authentication models
    
    Database username/password
    
    MongoDB authentication
    
    Microsoft Entra ID authentication
    
    Oracle wallet authentication
    
    Salesforce authentication
    
    Kerberos authentication
  - Databases support
    Databases support
    
    Supported databases
    
    PostgreSQL
    PostgreSQL
    
    PostgreSQL
    
    PgPass authentication
    
    Snowflake
    Snowflake
    
    Snowflake
    
    Snowflake OAuth authentication
    
    File drivers
    File drivers
    
    Multi format
    
    CSV
    
    JSON
    
    Parquet
    
    XLSX
    
    XML
    
    File-based driver properties
    
    Drivers management
- Navigation
  Navigation
- Properties Editor
- Data Editor
  Data Editor
  - Data Editor
  - Data filters
  - Data ordering
  - Panels
    Panels
    
    Value panel
    
    Grouping panel
    
    References Panel
    
    Result details panel
  - Managing charts
  - JSON and Document view
  - Spatial GIS data
  - Server output
  - Datasets
- SQL Editor
  SQL Editor
- Entity relation diagrams
- Cloud services
  Cloud services
- AI
  AI
  - AI Assistant
  - Data privacy
  - Features
    Features
    
    AI chat
    
    AI tools & MCP
    AI tools & MCP
    
    AI tools & MCP
    
    Data read actions
    
    View and editor actions
    
    Work with SQL
    Work with SQL
    
    Explain query
    
    Fix SQL errors
    
    AI command
    
    Work with objects
    Work with objects
    
    Describe object with AI
  - Tutorials
    Tutorials
    
    Quick start with AI
  - Settings
    Settings
    
    AI Assistant settings
    
    Providers
    Providers
    
    OpenAI
    
    GitHub Copilot
    
    Azure OpenAI
    
    Google Gemini
    
    Ollama
    
    Anthropic Claude
    
    Amazon Bedrock
    
    Grok
- DBeaver Database Tunnel
- Data transfer
  Data transfer
  - Data export
  - Data import
    Data import
    
    Data import
    
    Data import and replace
- Database Object Editor
- Managing preferences
  Managing preferences
- Accessibility guide
- Keyboard shortcuts
- Search
Desktop user guide
Desktop user guide
- Application window overview
- Installation
  Installation
  - Standalone installation
  - Windows silent install
- Basic operations
- Desktop Client configuration
  Desktop Client configuration
- Configure connection
  Configure connection
  - Connection settings
    Connection settings
    
    Create connection
    
    Edit connection
    
    Invalidate and reconnect
    
    Disconnect from database
    
    Change current user password
    
    Shell commands
    
    Initialization settings
    
    Security restrictions for database connection
    
    Connection types
    
    Local client configuration
    
    Multiple datasource connections
  - Network configuration
    Network configuration
    
    Network configuration
    
    Connection network options
    Connection network options
    
    SSH configuration
    
    SSL
    SSL
    
    SSL configuration
    
    Truststore management
    Truststore management
    
    Manage certificates
    
    Import custom certificates
    
    Oracle SSL configuration
    
    Proxy
    Proxy
    
    Proxy configuration
    
    Proxy configuration with system files
    
    Kubernetes configuration
    
    AWS SSM configuration
    
    Network profiles
  - Transaction mode
    Transaction mode
    
    Transaction mode
    
    Pending transactions
    
    Transaction log
  - Database authentication models
    Database authentication models
    
    Database username/password
    
    Password from shell command
    
    DBeaver profile
    
    Microsoft Entra ID
    
    Kerberos
  - Driver settings
    Driver settings
    
    Driver manager
    
    ODBC driver
    
    File-based driver properties
    
    How to add additional artifacts to the driver
    
    JDBC time zones
    
    JDBC tracing
- Databases support
  Databases support
  - Database drivers
  - Multi Source Database
  - Classic
    Classic
    
    Apache Doris
    
    Apache Hive
    
    Cassandra
    
    ClickHouse
    
    Couchbase
    
    IBM Db2
    
    Greenplum
    
    InfluxDB
    
    Microsoft SQL Server
    
    MariaDB
    
    MongoDB
    MongoDB
    
    MongoDB
    
    MongoDB authentication
    
    MySQL
    MySQL
    
    MySQL
    
    Two-factor authentication
    
    Netezza
    
    Oracle
    Oracle
    
    Oracle
    
    Oracle authentication
    
    PostgreSQL
    PostgreSQL
    
    PostgreSQL
    
    Pgpass authentication
    
    SSPI (Windows SSO)
    
    Redis
    
    Salesforce
    Salesforce
    
    Salesforce
    
    Salesforce authentication
    
    Teradata
    Teradata
    
    Teradata
    
    LDAP authentication in Teradata
    
    Trino
    
    Yellowbrick
  - Cloud
    Cloud
    
    AWS
    AWS
    
    Athena
    
    Aurora DSQL
    
    DocumentDB
    
    DynamoDB
    
    Keyspaces
    
    Neptune
    
    Redshift
    
    Timestream
    
    Azure
    Azure
    
    Cosmos DB
    
    Cosmos DB for NoSQL
    
    Google
    Google
    
    AlloyDB for PostgreSQL
    
    BigQuery
    
    Bigtable
    
    Cloud SQL for MySQL
    
    Cloud SQL for PostgreSQL
    
    Cloud SQL for SQL Server
    
    Firestore
    
    Spanner
    
    Databricks
    Databricks
    
    Databricks
    
    Databricks authentication
    
    Snowflake
    Snowflake
    
    Snowflake
    
    Snowflake native authentication
  - Embedded
    Embedded
    
    SQLite
  - File drivers
    File drivers
    
    DDL
    
    Multi format
    
    CSV
    
    JSON
    
    Parquet
    
    XLSX
    
    XML
  - Graph
    Graph
    
    Neo4j
- Navigation
  Navigation
  - Connections
    Connections
    
    Connections
    
    Simple and advanced view
    
    Configuring filters
    
    Filter database objects
    
    Bookmarks
  - Projects
    Projects
    
    Projects view
    
    Project explorer
  - Search
    Search
    
    Search
    
    Find in results
    
    Database full-text search
    
    Database metadata search
    
    File search
- Cloud services
  Cloud services
  - Cloud explorer
    Cloud explorer
    
    Cloud explorer
    
    AWS cloud explorer
    
    Azure cloud explorer
    
    Google cloud explorer
  - Cloud storage
  - Cloud connection settings
    Cloud connection settings
    
    AWS
    AWS
    
    AWS credentials
    
    AWS SSO
    
    AWS permissions
    
    Azure
    Azure
    
    Azure permissions
    
    Google Cloud
    Google Cloud
    
    Google Cloud SSO
    
    Google Cloud credentials
- Properties Editor
- Data Editor
  Data Editor
  - Data Editor
  - Viewing and editing data
    Viewing and editing data
    
    Data view and format
    
    Data filters
    
    Data viewing and editing
    
    Data refresh
    
    Result set navigation
    
    Panels
    Panels
    
    Panels
    
    Value Panel
    
    References Panel
    
    Metadata Panel
    
    Grouping Panel
    
    Calc Panel
    
    Result details Panel
    
    Query trace Panel
    
    Managing charts
    
    Mock data generation
    
    Dashboards
  - XML and JSON data
  - Dictionary data
  - Spatial GIS data
  - Virtual entities
    Virtual entities
    
    Virtual columns
    
    Virtual keys
  - Data Editor preferences
    Data Editor preferences
    
    Data Editor preferences
    
    Data format preferences
- SQL Editor
  SQL Editor
  - SQL Editor
  - Visual query builder
  - Query execution
    Query execution
    
    SQL execution
    
    Query Execution Plan
    
    Script management
  - Query development and assistance
    Query development and assistance
    
    SQL assist and auto complete
    
    SQL templates
    
    SQL formatting
    
    Variables panel
    
    Spelling
  - SQL generation
  - SQL terminal
  - Client side commands
    Client side commands
    
    Client side scripting
    
    Export command
  - Query manager
  - SQL code Editor
  - SQL Plus script execution
  - PostgreSQL Arrays
  - PostgreSQL Extensions
- AI
  AI
  - AI Assistant
  - Data privacy
  - Features
    Features
    
    AI chat
    
    AI tools & MCP
    AI tools & MCP
    
    AI tools & MCP
    
    Data transfer actions
    
    Data read actions
    
    View and editor actions
    
    Script actions
    
    User interaction
    
    Work with SQL
    Work with SQL
    
    Query suggestion
    
    Explain query
    
    Fix SQL errors
    
    AI command
    
    Work with objects
    Work with objects
    
    Describe object with AI
  - Tutorials
    Tutorials
    
    Quick start with AI
  - Settings
    Settings
    
    AI Assistant settings
    
    Providers
    Providers
    
    OpenAI
    
    GitHub Copilot
    
    Azure OpenAI
    
    Google Gemini
    
    Ollama
    
    Anthropic Claude
    
    Amazon Bedrock
    
    Grok
    
    Disable AI Assistant
- Entity relation diagrams
  Entity relation diagrams
- Data transfer
  Data transfer
- Structure and data compare
  Structure and data compare
- Tasks
  Tasks
- Tutorials
  Tutorials
  - Table Creation
    Table Creation
    
    New table creation
    
    Incorporating triggers
    
    Creating columns
    
    Creating indexes
    
    Implementing constraints
    
    Utilizing foreign keys
  - Database partitions
Integrated tools
Integrated tools
- Backup and restore
- GIT integration
- Tableau integration
- Session manager
  Session manager
  - Session manager (Web)
  - Session Manager (Desktop)
- Lock Manager
Administration
Administration
- Server configuration
  Server configuration
  - Server configuration
  - Web server configuration
  - First launch guide
  - Server database
  - Domain manager
  - Managing Team Edition server
  - Product configuration parameters
    Product configuration parameters
    
    Product configuration parameters
    
    Authentication settings
    
    Navigation tree
    
    Data spreadsheet
    
    Data export
    
    Entity Relationship Diagrams (ERD)
    
    Connections settings
    
    Query manager database configuration
- Security and access configuration
  Security and access configuration
  - Server security and access configuration
  - Authentication methods
    Authentication methods
    
    Authentication methods
    
    Local access authentication
    
    Reverse proxy header authentication
    
    LDAP authentication
    
    Single sign-on (SSO)
    
    SAML authentication
    
    OpenID authentication
    
    AWS OpenID authentication
    
    AWS SAML database access via Okta
    
    AWS IAM authentication
    
    AWS OpenID database access via Okta
    
    Snowflake OpenID database access via Okta
    
    Okta OpenID authentication
    
    Cognito OpenID authentication
    
    Keycloak OpenID authentication
    
    JWT authentication
    
    NTLM user authentication
    
    Microsoft Entra ID authentication
    
    Google authentication
  - Pass-through authentication
  - Access Management
    Access Management
    
    Users
    Users
    
    Users
    
    Provisioning users
    
    Password policy
    
    User credentials storage
    
    Teams
    Teams
    
    Teams
    
    Projects
    
    Roles
    Roles
    
    Roles
    
    Role management
    
    Settings
    
    Admin password recovery
    
    Global Permissions
    
    Initial data configuration
  - Proxy configuration
  - WebSockets
  - Multiple Server URLs
  - Secret Management
    Secret Management
    
    Secret Providers
    
    Secret requirements
    
    Configure secret providers in web client
    
    Configure secret providers in desktop client
    
    Secret provider setup example
  - data-sources.json reference
    data-sources.json reference
    
    data-sources.json reference
    
    Auth model reference
    
    Network handlers reference
    
    Connection types reference
    
    Bootstrap settings reference
  - Pre-configured database connections
    Pre-configured database connections
    
    Pre-configured database connections
    
    Pre-configured permissions for connections
  - Supported browsers
- Migration from DBeaver Desktop
- Admin preferences and tools
  Admin preferences and tools
  - Manage preferences
  - Preference restrictions
  - Variables
  - Command line
  - Troubleshooting
    Troubleshooting
    
    Background tasks
    
    How to make a thread dump
    
    How to post issues
    
    How to set a variable if dbeaver.ini is read-only
    
    Troubleshooting task scheduler issues
    
    Troubleshooting Windows Defender issues
    
    Troubleshooting missing WebView2
    
    Logs
    Logs
    
    Log viewer
    
    Log files
    
    Audit logging
    
    Log customization
  - How to change Java security properties
  - Import CA certificates into DBeaver
  - Query manager
    Query manager
    
    Query manager
    
    Query history
  - Workspace
    Workspace
    
    Workspace location (Web)
    
    Workspace location (Desktop)
    
    AWS and S3-compatible workspace configuration
Deployment
Deployment
- Team Edition deployment overview
- Deployment options
  Deployment options
- Managing cloud-deployed services
API and Integration
API and Integration
- API and Integration overview
- GraphQL API
  GraphQL API
- REST API documentation
- Model Context Protocol Server (MCP)
- DBeaver Proxy driver
  DBeaver Proxy driver
  - Proxy driver overview
  - Connect Tableau to a database using DBeaver Proxy Driver
Licenses
Licenses
- Import license
- Update license
- License management in the user portal
- License types
  License types
Release cycles
Statistics collection
Customer technical support
FAQ
FAQ
- FAQ (Web)
- FAQ (Desktop)

Did this page help you?

What did you like?

Accurate

Easy to understand

Solved my problem

Helped me decide to use the product

Other

0 / 1000

What went wrong?

Hard to understand

Incorrect information

Missing the information

Other

0 / 1000

Thank you for your feedback!

Something went wrong. Please try again later.

Team Edition
Desktop user guide
SQL Editor

Open in ChatGPT Ask ChatGPT about this page Open in Claude Ask Claude about this page

Desktop client

SQL Plus script execution

Oracle SQL Plus script execution is now covered together with the other native clients. For steps and SQL Plus commands, see Execute script with local client.

Facebook
LinkedIn
Telegram
Reddit
Twitter
YouTube

Products
Download
Pricing
Resources
Documentation
For partners
About us
- Company
- Customers
- Contacts
- Careers
Legal