# Manually run SQL queries on MS SQL via n8n
This automation template allows manual execution of SQL queries against a Microsoft SQL database using n8n. It streamlines one-off or administrative data tasks for users who need reliable access to database information without direct connection tools.
## Who it´s for
- Database administrators running routine or ad-hoc SQL queries
- Analysts needing quick access to MS SQL data
- Developers automating test queries to the database
## What the automation does
- Triggered manually on demand
- Executes a predefined SQL query in Microsoft SQL
- Returns query results for inspection or downstream processing
- Supports safe execution of DDL and DML operations without direct DB access
- Enables ad-hoc analysis, such as retrieving last month’s sales data
## What´s included
- Ready-to-use n8n workflow
- Manual trigger logic
- Integration with Microsoft SQL
- Basic setup and adaptation guide
## Requirements for setup
- Access to a Microsoft SQL instance with remote connections enabled
- n8n account (cloud or self-hosted)
- Database credentials (username, password, host, port, database name)
## Benefits and outcomes
- Accelerates ad-hoc queries without external SQL clients
- Centralizes database access through a single control point
- Reduces risk of errors via repeatable, templated execution
- Suitable for testing schema changes (e.g., table alterations)
- Convenient for fetching live data like updated customer lists
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet