🟦Microsoft SQL Server

iDBQuery's SQL Server connector turns any Microsoft SQL Server instance into a conversational data source — on-prem SQL Server 2016 through 2022, Azure SQL Database, Azure SQL Managed Instance, or AWS RDS for SQL Server. Provide host, port (default 1433), database, login, and password (or specify Windows authentication where supported), and schema introspection runs immediately. The AI sees tables, views, columns, types, primary and foreign keys, indexes, and stored procedure signatures, and uses that map to write correct T-SQL the first time. Every chat question becomes a safe parametrized SELECT, executed read-only, and returned as a chart, table, stat card, or dashboard. T-SQL specifics — `TOP`, `OFFSET/FETCH`, window functions, CTEs, MERGE-style read patterns, JSON_VALUE, and the spatial types — are all in the model's vocabulary. For databases on private networks, SSH tunneling through a bastion host keeps the connection private; for Azure SQL, IP allow-listing the iDBQuery egress works as well. Credentials are encrypted at rest with strong symmetric encryption, used only at query time, and never returned by any API. The free tier — 1M tokens per month, three sources, five reports, no credit card — lets you validate the workflow on a real SQL Server before paying. iDBQuery makes T-SQL approachable to anyone who can ask a question.

• SQL Server 2016, 2017, 2019, 2022 — on-prem and cloud
• Azure SQL Database and Azure SQL Managed Instance
• AWS RDS for SQL Server
• Schema introspection: tables, views, types, PK/FK, indexes
• T-SQL features: window functions, CTEs, JSON_VALUE, spatial types
• Read-only enforcement at the connector layer
• Encrypted connections (TLS) supported and recommended
• SSH tunnel for clusters on private networks