See llms.txt for all machine-readable content.
Microsoft SQL and Redis integration
Save yourself the work of writing custom integrations for Microsoft SQL and Redis and use n8n instead. Build adaptable and scalable Development, Data & Storage, workflows that work with your technology stack. All within a building experience you will love.
How to connect Microsoft SQL and Redis
Build your own Microsoft SQL and Redis integration
Create custom Microsoft SQL and Redis workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.
Microsoft SQL supported actions
| Execute Query | Execute an SQL query |
|---|---|
| Insert | Insert rows in database |
| Update | Update rows in database |
| Delete | Delete rows in database |
Redis supported actions
| Delete | Delete a key from Redis |
|---|---|
| Get | Get the value of a key from Redis |
| Increment | Atomically increments a key by 1. Creates the key if it does not exist. |
| Info | Returns generic information about the Redis instance |
| Keys | Returns all the keys matching a pattern |
| List Length | Returns the length of a list |
| Pop | Pop data from a redis list |
| Publish | Publish message to redis channel |
| Push | Push data to a redis list |
| Set | Set the value of a key in redis |
Microsoft SQL and Redis integration details
Microsoft SQL
SQL Server is database management system developed by Microsoft. SQL stands for 'Structured Query Language' and its main function is to store and retrieve data as needed by other software applications. It remains one of the most used databases in the world.
Redis
Redis is an open-source, advanced key-value store. It is often referred to as a data structure server. Its high performance makes it a favorite fast data store, cache, and even lightweight message broker.
Other integrations with Microsoft SQL and Redis
With Microsoft SQL
Microsoft SQL and Redis integration tutorials
FAQ about Microsoft SQL integrations
Need help setting up your Microsoft SQL and Redis integration?
Discover our latest community's recommendations and join the discussions about Microsoft SQL and Redis integration.
Open topicSyntax error when inserting multiple rows using Microsoft SQL node with Azure Dedicated SQL pool
Cathryn17
Describe the problem/error/question When inserting multiple rows (items) into an Azure Dedicated SQL pool (on a regular Azure SQL Server), we receive a syntax error from the DB (“Parse error at line: 1, column: 73: Incor…
Open topicGet All Elements of a Redis List
Carlo
Hi, I’m stuck with a problem in my n8n workflow. I’m trying to retrieve all the messages stored in a Redis list (used by my chatbot), but with the Redis node i can only returns the last element of the list or SET. What…
Looking to integrate Slack and VirusTotal in your company?
Trusted by teams building smarter workflows
Why use n8n to integrate Microsoft SQL with Redis
Handle branching, merging and iteration easily. Pause your workflow to wait for external events.
Re-run single steps to test changes in no time. And pin your data to avoid generating trigger events every time you execute.
Your data is displayed alongside your settings, making edge cases easy to track down.
Use 1000+ workflow templates available from our core team and our community.
Copy and paste, easily import and export workflows.
I have found the holy grail of automation.
Luisa Vidal 
n8n’s integration with third-party services is absolutely mind-blowing. It’s like a Swiss army knife for automation.
Felix Leber 
Anything is possible with n8n. I think the cloud version is great, they are doing amazing stuff.
Robyn Tindall 
Thank you to the n8n community. I did the beginners course and promptly took an automation WAY beyond my skill level.
Charley Mann
Simple enough to
understand + sophisticated
enough to ship
