Integration

    SQL Server and Volty

    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 VoltyFree trial

    Updated

    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.
    VoltyLet 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.

    AishaHi 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

    SerialModelInstalledWarranty ends
    2WH-55102HX-30 Storage14 Mar 202413 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.

    An IT technician in a flannel shirt works on the cables of an open server rack lit with blue lights.
    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 Serverdbo.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

    1. When

      Every Monday at 8am

      A scheduled automation

    2. Step 1

      Runs one SELECT

      On the tables you picked

    3. Step 2

      Posts the totals

      In the sales channel

    4. Step 3

      Logs the run

      On the automation's runs list

    A smiling customer service agent in a headset types at her desk, with colleagues working at screens along the windows behind her.
    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.

    1. 01

      Create a read-only login

      One of its own, with db_datareader and nothing more.

    2. 02

      Add SQL Server

      Host, database, and the port or instance name.

    3. 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 tablesReads
    • Describe tablesReads
    • Run a SELECTReads

    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.

    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

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