General Automation
Execute SQL queries and retrieve results from Microsoft SQL
2 nodes
126
81
Automatic trigger
Workflow Description
An automation that enables manual execution of SQL queries against Microsoft SQL Server databases and retrieves results directly. It streamlines repetitive analytical and administrative tasks without requiring database management tools.
How it works
- 1.Trigger the automation manually from the n8n interface
- 2.Write and configure your SQL query in the Microsoft SQL node
- 3.Execute the query and receive the database results
Use cases
- Generate periodic data reports from your database
- Update or delete records based on specific conditions
- Verify customer or order information without third-party tools
Requirements
- Active Microsoft SQL Server account and database access
- Connection credentials including server address, username, and password
- Sufficient database permissions to execute the required queries
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Microsoft Sql
Details
Trigger
Automatic trigger
Nodes
2
Apps
1
Views
126
Downloads
81
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (2)
On clicking 'execute'
Manual Trigger
Microsoft SQL
Microsoft Sql