Sync PostgreSQL, MySQL or Google Sheets Data to an AI Calling Agent

In short: With the Database Catalog Sync add-on, open a catalog in Data Catalogs and click Connect Platform. Choose PostgreSQL, MySQL or Google Sheets, enter a read-only database login or a shared sheet link, choose a SQL query or a whole table, click Test Connection, match your columns, choose how often to sync and click Save & Start Sync. The catalog refreshes itself on that schedule, and your AI agents answer stock, price, order status and balance questions from it.

A step-by-step guide for BookAICall, an AI voice agent platform that makes and answers phone calls for businesses in Hindi, English, Hinglish and other Indian languages. Updated .

Steps

  1. Activate Database Catalog Sync in Marketplace (Developer category). It is bought once for the whole workspace.

  2. Open Data Catalogs, open the catalog you want to fill (create one first if needed), and click Connect Platform. The Connect a Data Source window opens.

  3. Under Select Integration Platform click PostgreSQL, MySQL or Google Sheets.

  4. For a database, enter the Host, Port, Database name, and the Username and Password of a read-only user, and choose the SSL mode. For Google Sheets, paste the Google Sheets link and, if needed, the Tab name.

  5. For a database, under What to read choose SQL query and write one SELECT, or Whole table and type the table name.

  6. Click Test Connection. When it works, Columns found lists your columns: under Match your columns pick the ones that hold the item name, SKU, price, stock, customer phone, order ID, order status or balance.

  7. Set the Unique column, how often to Sync and the Row limit, then click Save & Start Sync. It saves only if the test works, and the first sync runs at once.

  8. Open AI Agents, click Edit on the agent, tick the catalog under Connected Data Catalogs and click Save Changes.

Who it is for

Businesses whose live data already sits in their own system: a distributor whose stock and rates are in an ERP on MySQL, a dealer whose customer balances are in PostgreSQL, a builder whose unit availability is in a Google Sheet the sales team updates. Instead of exporting a file every day, the catalog copies the data on a schedule and the agent always speaks from a recent copy.

Connection settings

  • Port: 5432 for PostgreSQL and 3306 for MySQL unless your server uses another one.
  • SSL: Require (encrypted, no certificate check) is the default; Require and verify the certificate for servers with a proper certificate; Off (not recommended) only for test servers.
  • Use a database user that can only read (SELECT) the tables you list. The database must accept connections from the internet; addresses inside a private network are refused.
  • The password is stored encrypted and never shown again; when you edit the source, the field says Saved — leave blank to keep it.

What to read

  • SQL query: one SELECT only, with no comments and nothing that changes data. It runs read-only with a 15-second limit, so filter and pick the columns you need, for example the active products with name, code, rate and stock.
  • Whole table: the table name, such as products or public.products.
  • Google Sheets: in the sheet, Share, General access, Anyone with the link, Viewer. The first row must hold the column names. Leave Tab name blank for the tab in the link.

Match your columns

Matching is optional but helps the agent: Product / item name, SKU / item code, Price, Stock / quantity, Customer name, Customer phone, Order ID, Order status, Balance / amount due and Description. Every column is copied; the matched ones are what the agent uses for stock, prices, orders and balances. A matched customer phone also lets the agent find a caller's own rows (orders, balance) at the start of an incoming call.

Sync schedule and limits

  • Sync: Every 15 minutes, Every 30 minutes (the default), Every hour, Every 6 hours or Once a day.
  • Row limit: 5,000 by default, 10,000 at most per catalog.
  • Unique column: the column that identifies a row, such as sku or id.
  • Each sync replaces the rows that came from the source with what it returns now; rows you added by hand stay.
  • The agent answers from the latest copy, not from a live lookup: with a 30-minute sync, a stock change is known within 30 minutes.

After it is connected

Open Connect Platform again to see the Status, the Catalog Size in records, Last Synced and Sync Now. Change the query, schedule or columns and click Save & Start Sync again. To stop syncing, click Disconnect there (or on the source's card in Integrations, E-commerce Marketplaces); the rows already copied stay until you delete them.

Without the add-on

The PostgreSQL, MySQL and Google Sheets choices show: Connecting a database or Google Sheet needs the Database Catalog Sync add-on, with a link to Marketplace. You can still fill any catalog by importing Excel or CSV files or pasting rows.

Example: A tiles dealer's stock stays current

Gupta Tiles & Sanitary in Jaipur keeps stock and dealer rates in its billing software's MySQL database. Their IT person creates a user that can only read the items table, opens the Tiles stock catalog, clicks Connect Platform, chooses MySQL and writes a query for the active items with name, code, size, rate and closing stock. Test Connection finds the columns; he matches name, code, rate and stock, sets the unique column to code and the sync to every 15 minutes, and saves. The agent Kavya answers dealers who call asking whether 600x1200 glossy white is in stock, and the rate, from figures at most 15 minutes old.

Tips

  • Write the query to return only what callers ask about: fewer, cleaner columns give clearer answers.
  • Name the catalog for what it holds, such as Stock and rates or Customer balances; the agent reads the name.
  • Use a Google Sheet for small lists your team edits by hand, and the database for anything your software already keeps.

Frequently asked questions

Can the AI agent read live stock from my database?

Yes, from a copy that syncs every 15 minutes to once a day. Connect the database to a catalog with Database Catalog Sync and tick the catalog for the agent.

Google Sheet se catalog auto update kaise ho?

With Database Catalog Sync: Connect Platform → Google Sheets, paste the link shared as Anyone with the link (Viewer), test, match columns and Save & Start Sync.

Is my database safe?

Use a read-only user. Only one SELECT runs, read-only, with a 15-second limit; the login is stored encrypted and the connection uses SSL by default.

Can it write anything back to my database?

No. It only reads.

My database is on our office network.

Private network addresses are refused. The database must be reachable from the internet, protected by its login and SSL.

How many rows can I sync?

Up to 10,000 per catalog; 5,000 by default.

Do I need it for Shopify or Unicommerce orders?

No. Store and order platforms connect from Integrations, E-commerce Marketplaces, or Connect Platform, without this add-on.

Questions this guide answers

  • Can an AI calling agent read stock from my database?
  • How do I auto-update an AI agent's data from Google Sheets?
  • Is it safe to connect my database to an AI agent?

Related guides

Start the free trial · Book a demo · All guides

BookAICall provides enterprise AI voice agents with real-time conversational capabilities.

Contact: [email protected] | +91-8502044044 | Mansarovar Jaipur Rajasthan