Note: This driver is available in Lite, Enterprise, Ultimate and Team editions only.

• Overview
• Redis specialty
• Setting Up
  • Redis connection settings
    • Connection details
    • Secure Connection Configurations
• Redis Features in DBeaver
  • Browsing keys
  • Executing commands

This guide provides instructions on how to set up and use Redis with DBeaver.

Before you can start managing your database, it's essential to establish a connection in DBeaver. This involves selecting the Redis option to connect to the Redis. If you have not yet created a connection in DBeaver, please refer to our Creating a Connection article for guidance.

Redis is an open-source, in-memory data structure store, used as a database, cache, and message broker. It supports various data structures such as strings, hashes, lists, sets, sorted sets with range queries, bitmaps, hyperloglogs, geospatial indexes, and streams. Redis has built-in replication, Lua scripting, LRU eviction, transactions, and different levels of on-disk persistence. Additionally, Redis offers high availability via Redis Sentinel and automatic partitioning with Redis Cluster.

Redis is particularly well-suited for real-time applications like leaderboards, session stores, real-time analytics, and geospatial services due to its fast performance and support for complex data types and operations. For detailed information on Redis and its features, please refer to the official documentation.

This section provides an overview of DBeaver's settings for establishing a direct connection and the configuration of secure connections using SSH, proxies, Kubernetes and SSL.

In this subsection, we will outline the settings for establishing a direct connection to a Redis database using DBeaver. Correctly configuring your connection ensures seamless interaction between DBeaver and your Redis database.

1. The first page of the connection settings requires you to fill in specific fields to establish the initial connection.

2. The second page of the connection settings offers additional options that allow you to customize the keys settings.

   

The Connection Details section in DBeaver allows you to customize your experience while working with Redis database. This includes options for adjusting the Navigator View, setting up Security measures, applying Filters, configuring Connection Initialization settings, and setting up Shell Commands. Each of these settings can significantly impact your database operations and workflow. For detailed guides on these settings, please refer to the following articles:

• Connection Details Configuration
• Database Navigator
• Security Settings Guide
• Filters Settings Guide
• Connection Initialization Settings Guide
• Shell Commands Guide

DBeaver supports secure connections to your Redis database. Guidance on configuring such connections, specifically SSH, Proxy, Kubernetes, and SSL connections, can be found in various referenced articles. For a comprehensive understanding, please refer to these articles:

• SSH Configuration.

• Proxy Configuration.

• SSL Configuration.

• Kubernetes Configuration.

DBeaver is not limited to typical SQL tasks. It also includes numerous additional features compatible with Redis, but not exclusive to it:

Redis keys are often viewed and edited as a simple list. However, when dealing with a large number of keys, which can run into millions or billions, a list view is not always practical or possible.

DBeaver offers a hierarchical view of Redis keys. Although Redis itself does not inherently support hierarchical data structures, it is common practice to organize keys into groups using specific delimiters like commas, dashes, or colons. DBeaver leverages these naming patterns to display keys in a hierarchical format. You can configure the group separator in the connection properties.

The key browser feature is useful, but for databases with a large key count, locating a specific key through the navigator might be challenging. In such cases, using the SQL editor with Redis commands is the most effective method to manage keys.

Redis operates differently from traditional SQL databases. It uses built-in commands and LUA scripting for operations.

To execute Redis commands, use the syntax similar to the Redis command line shell:

SET mykey "Hello"

This command will set the value of mykey to Hello. To run this command in DBeaver, you would type it into the SQL editor and execute it using either CTRL+Enter or ALT+X.

To learn more about Redis commands, refer to the official Redis commands documentation.

For LUA script execution, enclose the script in curly braces {} and execute it as a single statement. If your LUA script includes empty lines or special characters, highlight the script text before executing it. For instance:

{
    -- Retrieve the value of a Redis key
    local key = 'key1038' -- Specify the key you want to retrieve
    local value = redis.call('GET', key)
    return value
}

For LUA scripting in Redis, see LUA scripts in Redis.