Integration
SQL Server voice AI integration
The SQL Server integration connects your AI voice and chat agents to SQL Server, so they can db.query on a live call. It's a database connector that runs as a tool the agent calls mid-conversation — you connect with an api key, attach it to an agent, and it acts in real time without a human in the loop.
Last updated 2026-09-15
What your agent can do with SQL Server
Read a page of rows from a SQL Server database using the configured SELECT. For filling a call list — not for looking a record up mid-call.
Inputs
| Field | Type | Description |
|---|---|---|
| limit | integer | Rows per page (max 500) |
| offset | integer | 0-based row offset of this page |
Write call outcomes back onto the rows they were read from — the campaign write-back path for SQL Server.
Inputs
| Field | Type | Description |
|---|---|---|
| rows* | array | [{row_number, cells}] — address plus the columns to set |
Append a row for every call — the destination path for SQL Server. Unlike write-back this INSERTS, because a call is often about somebody who was never in the table.
Inputs
| Field | Type | Description |
|---|---|---|
| rows* | array | [{cells}] — the columns to insert. No address: an append has nothing to address. |
Look a record up in the connected SQL Server during the call — e.g. find the caller's account, order or booking by phone number, email or reference. Returns only the fields this tool was set up to read.
Inputs
| Field | Type | Description |
|---|---|---|
| limit | integer | Most records to return (1-20, default 5). |
| search_column | string | Which field to look in. Omit when the tool has only one searchable field. |
| search_value* | string | The value to look for — e.g. the caller's phone number or a booking reference. |
Create a new record in the connected SQL Server during the call — a ticket, a lead, a booking. Only the fields this tool was set up with can be filled.
Inputs
| Field | Type | Description |
|---|---|---|
| cells | object | Field → value for the new record. |
Change a record in the connected SQL Server during the call. Look the record up first, then pass the id it returned along with only the fields that changed.
Inputs
| Field | Type | Description |
|---|---|---|
| cells | object | Field → new value, for just the fields that changed. |
| record_id* | string | Identifies the record to change — take it from the look-up tool's result. |
What you'll need to connect SQL Server
Connect with an API key. In Telenow, open Integrations → SQL Server and provide:
- Password — Use a login with SELECT only. T-SQL has no read-only transaction, so on this engine a read-only login is the strongest guarantee there is — the statement check is the only other line of defence.
- Host — Must be reachable from the public internet and allowlisted to our egress IP. A private or VPC-internal address is refused.
- Port — 1433
- Database
- Login — SQL Server authentication. Windows/AD authentication is not supported.
- TLS mode — verify-full (default) validates the certificate against the host name. `require` still encrypts but skips validation — acceptable here only because this engine dials an address it has already checked. `disable` is refused.
Other Database integrations
Frequently asked questions
What can an AI voice agent do with SQL Server?+
During a live call or chat, a Telenow agent can db.query, db.update, db.append, look up a record, create a record, and update a record — each runs as a tool the agent calls mid-conversation, so it acts on SQL Server in real time without a human.
How do you connect SQL Server to Telenow?+
In Telenow, open Integrations, pick SQL Server, and you paste a SQL Server API key into the connection, then bind it to your agent. Then add its database tool to your agent (or install a template that already includes it) and you're live.
Can I use SQL Server in a ready-made agent?+
Yes — add SQL Server to any Telenow agent, or start from a template and attach it as a tool.
Does SQL Server work on phone calls and WhatsApp?+
Yes. Telenow agents run on phone, web, chat and WhatsApp, and SQL Server works the same across every channel — the agent calls it whenever the conversation needs it.
How much does the SQL Server integration cost?+
Connecting SQL Server is included — you only pay Telenow's transparent per-minute and per-component usage, and new accounts get free signup credit to try it.
Connect SQL Server to your AI voice agent
Sign up free and get $1.00 in credit — no card required. Connect your number, pick a template, and go live in minutes.