Connect MS SQL Server to ZenSearch
Query your SQL Server databases with natural language. Schema discovery and AI-powered SQL generation make enterprise data accessible to everyone.
What ZenSearch indexes from MS SQL Server
Schema Discovery
ZenSearch discovers databases, schemas, tables, columns, indexes, and relationships in your SQL Server instance. The full data model informs accurate query generation.
Natural Language to SQL
Translate questions into T-SQL queries. ZenSearch handles SQL Server-specific syntax, functions, and data types including datetime2, nvarchar, and hierarchyid.
Windows & SQL Authentication
Connect with SQL Server Authentication or Windows Authentication (Integrated Security). Supports both on-premise instances and Azure SQL Database.
Encrypted Connections
TLS encryption for connections to SQL Server. Supports trust server certificate mode for development and full certificate validation for production.
Schema Filtering
Limit queries to specific schemas (e.g., dbo, sales, hr). Exclude system schemas and sensitive tables from the queryable scope.
Read-Only Execution
All generated queries are validated as read-only SELECT statements. Stored procedure execution, mutations, and DDL statements are blocked.
Up and running in three steps
Authenticate your account and select the resources to index. ZenSearch handles OAuth, API keys, and enterprise SSO.
ZenSearch parses, chunks, and vectorizes your content. Incremental sync keeps everything up to date automatically.
Your team searches across all connected sources with AI-powered semantic search, chat, and agents.
Questions your team can finally answer
Once MS SQL Server is connected, your team can ask natural-language questions and get cited answers instantly.
“What are the total sales by region for the current fiscal year?”
Generates a T-SQL query joining sales and region tables with fiscal year date filtering, returning totals grouped by geographic region.
“Which employees in the engineering department were hired in the last 6 months?”
Queries the employee and department tables with date and department filters, returning names, titles, and hire dates.
“What is the inventory level for product SKU A1234?”
Looks up the product by SKU across inventory tables and returns current stock levels, warehouse locations, and reorder thresholds.
Explore related integrations
PostgreSQL
MySQL
ClickHouseReady to search your MS SQL Server data?
Connect MS SQL Server in minutes. No credit card required.
Start Free