> ## Documentation Index
> Fetch the complete documentation index at: https://docs.softr.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Xano

# Xano integration

Connect Xano with your Softr applications to read and write database records directly from your workflows — no SQL scripting required. Turn form submissions, sign-ups, and record changes into records in your Xano backend, and pull that data back into your app in real time.

## Overview

The Softr Xano integration lets your app create, find, update, and delete records in your Xano database as part of a workflow. Trigger a new record from a form submission, update records when a status changes, or look up existing data to display or use in the next step — all driven by what your users do in Softr.

Whether you're building a customer portal, an internal admin tool, or a member dashboard, Xano becomes the backend your Softr app writes to and reads from, so your existing backend stays the single source of truth while Softr handles the front end and the automations. Xano connects to your workflows through Softr's SQL / Database action, using Xano's Data Connector.

## Available Actions

### Find record

Look up the first record that matches your conditions — perfect for fetching a customer, order, or profile to display in your app or use in a later step.

### Find multiple records

Return every record that meets your criteria, so you can power a live list, dashboard, or digest from your Xano data.

### Add record

Create a new record whenever a workflow runs — turn a form submission or sign-up into a record in your database instantly.

### Update record

Change a single record automatically as things happen in your app, such as updating a status or contact detail.

### Update multiple records

Update many records at once — ideal for bulk status changes or applying the same update across a set of records.

### Delete record

Remove a single record that's no longer needed as work is cancelled or cleaned up.

### Delete multiple records

Clear out a batch of records at once to keep your database tidy.

## Key Benefits

* **No-code database access:** Read from and write to your Xano backend visually inside Softr — no SQL or backend code required.
* **Your data stays the source of truth:** Keep your existing Xano backend and let Softr handle the front end and automations on top of it.
* **Always-current pickers:** Databases, schemas, tables, and fields load live from your connected instance, so your options stay up to date.
* **Real-time two-way sync:** New submissions become records the moment they arrive, and record changes flow back into your app instantly.
* **Custom queries when you need them:** Drop in a custom SQL query for anything the standard actions don't cover.

## Example Use Cases

| Use Case                         | Description                                                                                            |
| :------------------------------- | :----------------------------------------------------------------------------------------------------- |
| **Form-to-database intake**      | A Softr form submission adds a new record to your Xano table with all the submitted details.           |
| **User provisioning on sign-up** | When a new member signs up, create their record in Xano so their data is ready across your app.        |
| **Status sync**                  | When a record moves to "In progress" in your Softr app, update the matching Xano record automatically. |
| **Live data dashboard**          | Use Find multiple records to power a Softr list block that always reflects your latest Xano data.      |
| **Bulk updates**                 | Update multiple records at once — for example, mark a batch of orders as shipped from an admin action. |
| **Automated cleanup**            | Delete records that are cancelled or expired to keep your database tidy without manual work.           |

## How to Connect Softr with Xano

1. Open your Softr app and go to **Workflows**.
2. Create a new workflow and add a **SQL / Database** action — add, find, update, or delete a record.
3. Under **Account**, connect your Xano database as a data source. First enable the **Data Connector** add-on in Xano, then connect your instance in Softr. See the [Xano data source guide](/data-sources/xano) for the exact steps.
4. Pick the **database**, **schema**, and **table** the action should work with.
5. Map fields from your Softr forms, records, or previous workflow steps to the action's inputs — or write a custom **SQL Query** for advanced cases.
6. Save and activate your workflow.