Microsoft SQL Server Connector
Connect Microsoft SQL Server databases to OnPremiseAgent for natural-language querying, automated report generation, and real-time monitoring. Full support for Windows Authentication, Azure SQL, and SQL Server on Linux. Agents understand T-SQL syntax, stored procedures, and views to generate accurate queries.
Service AccountToken
Auth
Service Account, Token
Category
Data & Storage
Compatibility
SQL Server 2016+, Azure SQL, SQL Server on Linux
Tier
Available
Purpose-built capabilities
Everything you need to integrate Microsoft SQL Server into your on-premise agent workflows.
T-SQL Generation
Agents generate optimized T-SQL queries from natural language, respecting SQL Server-specific syntax and features.
Windows Authentication
Support for Windows Integrated Authentication and Active Directory authentication for seamless enterprise integration.
Stored Procedure Access
Agents can discover and execute stored procedures, passing parameters based on natural language instructions.
Real-Time Monitoring
Monitor query performance, blocking, and resource utilization with AI-powered anomaly detection.
01
Create Login
Create a SQL Server login with db_datareader role on the databases your agents need to query.
01
Key Benefits
Why enterprises choose this connector
- Native Windows Authentication support for enterprise environments
- T-SQL-optimized query generation
- Support for SQL Server 2016+ and Azure SQL Database
- Cross-database querying for complex enterprise schemas
- Compatible with Always Encrypted and TDE
01
Financial Reporting
Generate financial reports from SQL Server data warehouses with natural language, meeting SOX compliance requirements.
02
Legacy System Access
Give modern AI capabilities to legacy applications backed by SQL Server without modifying existing systems.
03
Cross-Database Analytics
Query across multiple SQL Server databases in a single natural-language request for comprehensive analysis.
Frequently Asked Questions
Does this support Azure SQL Database?
Yes. Both Azure SQL Database and Azure SQL Managed Instance are fully supported with AAD authentication.
Can agents call stored procedures?
Yes. Agents can discover stored procedures, understand their parameters, and execute them based on natural language instructions — with explicit permission controls.
Works great with
Combine Microsoft SQL Server with these connectors for a complete integration stack.
Ready to connect Microsoft SQL Server?
Deploy on your own infrastructure with full data sovereignty. Get started in minutes.