Skip to main content
ZenSearch
sql_server

Connect MS SQL Server to your coworker.

Query your SQL Server databases with natural language. Schema discovery and AI-powered SQL generation make enterprise data accessible to everyone.

What It Reads

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.

Setup

Up and running in three steps.

01

Connect

Authenticate your account and select the resources to index. ZenSearch handles OAuth, API keys, and enterprise SSO.

02

Index

ZenSearch parses, chunks, and vectorizes your content. Incremental sync keeps everything up to date automatically.

03

Delegate

Your coworker searches, answers, and acts across this source — with permission-aware results and governed actions.

In Practice

Questions your team can finally ask.

Once MS SQL Server is connected, your team asks in natural language and gets cited answers — and governed action — 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.

Get Started

Put MS SQL Server
to work.

Connect MS SQL Server in minutes and let your coworker read, answer, and act on it.

Try it