Download Redis JDBC Driver

Download the Redis JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the Redis JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to Redis. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each Redis driver uses its own syntax — see the connection details below.

The Redis JDBC driver

Redis is an open-source, in-memory data structure store widely used as a cache, message broker, and real-time database. It supports strings, hashes, lists, sets, sorted sets, streams, and more, making it a versatile building block for high-performance applications.

DbSchema provides an open-source JDBC driver for Redis that translates SQL queries into native Redis commands, enabling standard JDBC tooling to connect to Redis.

The Redis JDBC URL

• Required File(s): redis-jdbc-driver.jar
• Java Driver Class: com.wisecoders.jdbc.redis.JdbcDriver
• JDBC URL: jdbc:redis://{HOST}:{PORT}/{DB_INDEX}
• Website: redis.io

The default Redis port is 6379 and the default database index is 0. For TLS connections use jdbc:redis+ssl://host:6380/0. To authenticate, append ?password=yourpassword to the URL. For Redis Cluster, connect to any cluster node — the driver handles key slot routing transparently.

Connecting to a Remote Redis Server

Redis has a second gate besides the bind address, and it catches people out: protected mode refuses remote clients even when the server is listening on every interface.

1. Bind an interface clients can reach. A bind 127.0.0.1 line in redis.conf keeps the server on the loopback interface. Name the private address clients use instead, and restart the server.
2. Set a password, or protected mode will block you. Since Redis 3.2, a server that binds all interfaces and has no password enters protected mode: it answers the loopback interface and replies to everyone else with an error explaining why. Setting requirepass, or creating an ACL user on Redis 6 and later, satisfies it — and is worth doing regardless. Pass the password to DbSchema with ?password=yourpassword on the URL.
3. Open port 6379 in the server's firewall. The database listens on port 6379 unless it was installed with a different one. A host firewall on the server blocks incoming connections on that port until a rule allows them. The firewall guide has the commands for Windows, ufw, firewalld and iptables.
4. Connect from DbSchema. In the Connection Dialog choose Remote computer or custom port, fill in the server host and the port, then press Test Connection to check that the server answers before you connect.

Redis is built to be reached by trusted clients on a trusted network. Do not open 6379 to the internet: a single FLUSHALL from a stranger empties the dataset. Where the server is remote, an SSH tunnel or jdbc:redis+ssl:// on port 6380 is the safer route.

• Or reach the server through SSH. When the database port is deliberately closed to the internet, press Setup SSH Tunnel... in the Connection Dialog and connect through a host that is exposed. The database host and port are then the ones seen from the SSH host — often localhost. See the SSH tunnel guide.

Downloading the Redis JDBC Driver

Download Redis JDBC Driver

The driver archive is a zip file. Unzip it to obtain the driver jar. The source code is available on GitHub.

DbSchema and Redis

DbSchema detects Redis key namespaces and renders them as a visual schema diagram. Use the data explorer to browse hash fields, list elements, and set members, and the SQL editor to query Redis data through the JDBC translation layer.