# SQL Server and Volty

> Volty answers your team's questions from SQL Server with read-only queries on the tables an admin picks.

Volty answers colleagues' and automations' questions from your own SQL Server database, through a read-only login and only the tables an admin picks.

Talk to Volty · Free trial

Updated 2 Nov 2026

## A warranty question

A customer asks something only the database holds. Volty brings in a colleague, who asks Volty from the staff side.

DR

Daniel Reyes

WhatsApp · Customer

Is my water heater still under warranty? Serial WH-55102.

Volty Let me get a colleague to check that for you, Daniel. They will reply here shortly.

Volty brought in Aisha from Service. She asked Volty from the staff side, and Volty read dbo.Warranty.

Aisha Hi Daniel, your heater was installed on 14 March 2024 and the warranty runs to 13 March 2027, so you're covered. Shall I book a technician?

Google Sheets

dbo.Warranty · 1 row

|  | Serial | Model | Installed | Warranty ends |
| --- | --- | --- | --- | --- |
| 2 | WH-55102 | HX-30 Storage | 14 Mar 2024 | 13 Mar 2027 |

Row 2 added by Volty

## What Volty does with SQL Server

Many businesses keep their orders, warranties and service history in a SQL Server database of their own. Volty connects to it through a read-only login and reads only the tables an admin picks. Colleagues and automations ask questions in plain words, and Volty answers with one read-only query, so nobody waits for IT to write a report.

- Read only, by design · Volty runs one SELECT at a time, and a write or a second statement is refused.
- Only the tables you pick · A query on any other table is refused.
- For colleagues and automations · These tools never run in a customer conversation, so Volty brings in a colleague instead.
- Totals before rows · Volty counts and sums, and an answer carries 200 rows at most.

Connects with

A read-only SQL Server login

Volty reads

The tables an admin picks

Volty can change

None. Writes are refused

Setup

A few minutes once the login exists

Category

Spreadsheets & databases

Your own database, read through the tables an admin picks.

### Weekly totals to the team

An automation runs the week's totals and posts them in Slack, when that switch is on.

#sales

Slack · Team

Queried SQL Server · dbo.Orders · 1 SELECT · grouped by region

VoltyAPP

Orders last week: North 142 ($61,380), East 118 ($49,920), West 97 ($40,115). Total 357 orders, $151,415.

J

Jonathan

Thanks. West is down again, I'll look at it with the team.

## As an automation

Describe it to Volty in a sentence; it drafts the automation and an admin turns it on.

Monday sales totals

- When · Every Monday at 8am · A scheduled automation
- Step 1 · Runs one SELECT · On the tables you picked
- Step 2 · Posts the totals · In the sales channel
- Step 3 · Logs the run · On the automation's runs list

Colleagues ask Volty and get the figure from the database.

## How Volty connects to SQL Server

An admin adds SQL Server from the Sources page with the server's address and a login that can only read, then picks the tables Volty may use.

- 01 · Create a read-only login · One of its own, with db_datareader and nothing more.
- 02 · Add SQL Server · Host, database, and the port or instance name.
- 03 · Pick the tables · Volty lists what the login can see.

### The tools Volty gets

Each one is a switch on the Sources page in Volty.

- List tables · Reads
- Describe tables · Reads
- Run a SELECT · Reads

Reading tools can be turned on straight away. Anything that changes SQL Server starts Off, and once on it can be set to check with staff, so each change waits for a colleague.

## Common questions

### Can Volty change data in my SQL Server database?

No. Volty connects through a login that can only read, runs one SELECT at a time, and refuses a write, a second statement or a table that is not on the admin's list.

### Does Volty query the database in customer conversations?

No. The SQL Server tools run for colleagues and automations only. When a customer asks something only the database answers, Volty brings in a colleague.

### How much does it cost to connect SQL Server with Volty?

Every Volty plan includes seats, active contacts and AI credits and starts with a free 7-day trial, and the plan prices are on voltade.com/pricing. Meta bills message charges separately for WhatsApp, Instagram and Messenger.

## Related integrations

- Supabase Spreadsheets & databases
- Custom API Developer & analytics
- MCP server Developer & analytics
- Microsoft Excel Spreadsheets & databases
- NetSuite Accounting & ERP

All integrations

## Start your free trial

Talk to Volty · Start your free trial

Sign up for our 7-day trial. No credit card needed.

## Not convinced? Hear more from our CEO and Volty

The Leonard and Volty Show · 8 October 2026

### Meta now charges for WhatsApp replies

The Leonard and Volty Show · 1 October 2026

### Too busy to hire?

The Leonard and Volty Show · 21 September 2026

### From $500 chatbot jobs to agentic AI

The Leonard and Volty Show · 10 September 2026

### Your AI is a new employee

The Leonard and Volty Show · 4 September 2026

### Trust in the AI world

The Leonard and Volty Show · 29 August 2026

### Does the AI model matter?

The Leonard and Volty Show · 19 August 2026

### What are AI agents?

Meta now charges for WhatsApp replies. Here's what it means for your business, 8 October 2026

## Links

- [Spreadsheets & databases](https://voltade.com/integrations?category=data)
- [SupabaseSpreadsheets & databases](https://voltade.com/integrations/supabase)
- [Custom APIDeveloper & analytics](https://voltade.com/integrations/custom-api)
- [MCP serverDeveloper & analytics](https://voltade.com/integrations/mcp-server)
- [Microsoft ExcelSpreadsheets & databases](https://voltade.com/integrations/microsoft-excel)
- [NetSuiteAccounting & ERP](https://voltade.com/integrations/netsuite)
- [All integrations](https://voltade.com/integrations)
