SQLlyRedis GUI for Mac, Windows and Linux
Redis isn't SQL, and SQLly doesn't pretend it is. You get a command editor that speaks redis-cli, a key browser that folds keys by prefix, and the monitoring tools you already use for your SQL servers - plus Valkey, KeyDB, DragonflyDB, ElastiCache and MemoryDB.
- Connects over
- RESP, the Redis protocol
- Default port
- 6379
- Sign-in
- Password, with an ACL user name if the server uses one
- Paste a URL
- redis://user:password@host:6379/2 or rediss://
What SQLly does for Redis
Redis is the one engine in SQLly that isn’t a SQL database. So instead of forcing it into tables, SQLly gives it a command editor, a key browser and the monitoring tools - and the SQL-only tools say plainly why they don’t apply.
Commands, the redis-cli way
A query tab runs one command per line in the same syntax as redis-cli, quotes and escapes included - or a JSON list of arguments for awkward values. SELECT switches the logical database for the rest of the script, and a failing command reports the server’s own error with its line number.
Every reply as a result set
Hashes come back as field/value rows, sorted sets as member/score, INFO as section/key/value, and CLIENT LIST and SLOWLOG as real tables - sortable and exportable like any other result.
A key browser, folded by prefix
The explorer lists numbered databases with key counts and walks keys with a bounded, non-blocking scan, folding them by your delimiter - user:42:profile sits under user β 42. Each key shows its type and remaining TTL.
Open any key with the right command
Double-click a key and SQLly runs the reader for its type - GET, HGETALL, LRANGE, SMEMBERS, ZRANGE with scores, XRANGE or JSON.GET. The key menu copies the key or its command, sets or removes the TTL, and deletes it after you confirm.
Monitoring you already know
Server Dashboard reads INFO, Activity Monitor reads CLIENT LIST and can kill a client, Query Insights reads the slow log, and Disk Usage shows memory per logical database.
Guardrails for commands
A read-only connection - and every query the AI composes - allows read-only commands only. FLUSHALL, FLUSHDB, DEL, CONFIG SET and SHUTDOWN ask first, and SUBSCRIBE, MONITOR or a blocking pop with no timeout are refused before they can hang the tab.
Connect to Redis
- Download SQLly for macOS, Windows or Linux from the download page and open it.
- Create a connection and pick Redis - or Valkey, KeyDB, DragonflyDB, Amazon ElastiCache or Amazon MemoryDB if that is what you run.
- Enter host and port (6379), an ACL user name if your server uses one, the password, and optionally a logical database number - or paste a
redis://user:password@host:6379/2orrediss://URL. - Choose a TLS mode. Anything but Disable switches to Redis’s TLS handshake, the same as a
rediss://URL; MemoryDB requires it. SSH tunnels, proxies and Kubernetes port-forwards work as they do for the SQL engines. - Test, save and connect. Expand the connection to browse keys, or type
HGETALL user:1in a query tab and run it.
Every SQLly tool on Redis
This is the same engine matrix the app uses to enable or disable its menus, so what you read here is what you get. Where a tool doesn’t apply to Redis, the app says why - and so do we.
| Tool | Redis |
|---|---|
| Explorer, IntelliSense and hover cards | Partial A key browser instead of a SQL catalog: logical databases, keys folded by prefix, and each key's type and TTL. |
| Activity Monitor | Yes CLIENT LIST, with kill. |
| Query Insights | Yes The slow log. |
| Server Dashboard | Yes INFO. |
| Disk Usage and Object Browser | Partial Disk Usage shows memory per logical database; the Object Browser does not apply, so browse keys in the explorer. |
| SSH tunnels, proxies and Kubernetes port-forward | Yes |
| Read-only connections | Yes Only read-only commands are allowed; destructive ones such as FLUSHALL go through confirmation. |
| Edit rows in the results grid | No Redis has no rows to edit; change values with SET, HSET and friends in a query tab. |
| Estimated execution plans | No Redis commands have no execution plan; SLOWLOG GET shows their timings. |
| Actual (executed) plans | No Redis commands have no execution plan; SLOWLOG GET shows their timings. |
| Maintenance menu | No Redis has no vacuum, analyze or reindex verbs to offer. |
| Schema Compare and Schema History | No Redis has no schema to compare; keys are the whole structure. |
| Data Compare | No Redis has no tables to compare; use the key browser and GET / HGETALL. |
| Data Transfer | No Redis has no tables to transfer; use DUMP / RESTORE or MIGRATE in a query tab. |
| Test Data Generator | No Redis has no tables to fill; write keys with SET / HSET in a query tab. |
| Table Structure Editor | No A Redis key's type is set by the command that creates it. |
| Index Analyzer | No Redis has no indexes; every key is looked up by name. |
| Security editor (users, roles, grants) | No Manage Redis users with ACL SETUSER / ACL LIST in a query tab. |
| Backup / Restore | No Redis snapshots itself on the server: run BGSAVE or BGREWRITEAOF in a query tab. |
| Create and drop database dialogs | No Redis databases are fixed numbered slots; there is nothing to create or drop. |
| Procedure Mode | No Redis has no stored procedures. |
| SQL Agent, Extended Events and guided designers | No SQL Server and Azure SQL only. |
| Auto-rollback safety wrap | No Redis has nothing to roll back, so the wrap refuses anything but read-only commands. |
Hosted and compatible engines
These are choices in SQLly’s connection editor in their own right. Each one sets the right port and encryption default, and a short note under the connection options says what differs from plain Redis.
- Valkey
- KeyDB
- DragonflyDB
- Amazon ElastiCache
- Amazon MemoryDB
Questions about Redis in SQLly
Is SQLly a Redis GUI, or only a SQL client?
Both. SQLly connects to Redis natively. A Redis query tab runs one command per line in redis-cli syntax and shows every reply as a result set, and the explorer becomes a key browser. The SQL-only tools - plans, row editing, compare, transfer and the structure and security editors - say why they do not apply.
Does SQLly work with Valkey, ElastiCache and MemoryDB?
Yes. Valkey, KeyDB, DragonflyDB, Amazon ElastiCache and Amazon MemoryDB are choices in the connection editor alongside Redis. MemoryDB requires TLS and takes its ACL user name in the Username field, and ElastiCache in-transit encryption means the Require or Verify full TLS mode.
Can a read-only Redis connection still change data?
No. With the SELECT-only lock on, and for queries composed by the AI, only read-only commands are allowed. On a connection that can write, destructive commands such as FLUSHALL, FLUSHDB, DEL, CONFIG SET and SHUTDOWN go through the usual confirmation first.
Can I run SUBSCRIBE or MONITOR in SQLly?
No. Commands that would never finish - SUBSCRIBE, MONITOR, or a blocking pop with no timeout - are refused before they are sent, so a query tab cannot hang. Cancel stops a running script at once.
Read more
In the docs
Other databases
Bring your Redis home to the pig
SQLly is free to start on macOS, Windows and Linux, with no account required.