Yes, you heard that right. Query Redis with SQL. No LLMs needed.Most data science teams already speak SQL fluently, and for many (including LLMs and agents), it’s still the most intuitive way to express queries. At the same time, teams often need the speed and flexibility of Redis at scale.Luckily the Redis API already provides nearly all the primitives required to express rich, SQL-like queries against a single index, but translating between the two can be cumbersome.To help close this gap, we released the sql-redis library to PyPi and added the SQLQuery class to redisvl so you can run SQL-like queries at Redis speed.Quick start with RedisVLInstall:Setup index:Query:Output:Under the hoodThe SQLQuery class converts a sql-like statement such as:into an equivalent Redis query.Conveniently, you can preview the Redis query to be executed via the .redis_query_string() available on the SQLQuery class:The SQLQuery class accomplishes this deterministically, without an LLM, with the help of sqlglot and the parser within sql-redis. Check out the source code for more details.More than simple selectsThe core translation engine already handles aggregations, full-text search, geo queries, and async execution.Conditional operatorsNatural language intentSQLRedisVector searchNatural language intentSQLRedisAggregationsNatural language intentSQLRedisCheck out the redisvl user guide for a full demo of queries available.To wrap things upYou can now query Redis indexes with familiar SQL syntaxUnder the hood, sql-redis parses your SQL into an AST (Abstract Syntax Tree), checks it against your index schema, and emits the right FT.SEARCH or FT.AGGREGATE command.Beyond basic filters, it already supports aggregations, full-text search, geo queries, date functions, parameterized queries, and async execution.It runs fast. Schema metadata is cached so translation overhead stays in the low milliseconds.Try it out now
Use Redis with SQL | Redis
Developers love Redis. Unlock the full potential of the Redis database with Redis Enterprise and start building blazing fast apps.






