Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.xano.com/llms.txt

Use this file to discover all available pages before exploring further.

Database Requests are used perform operations against your database tables, such as retrieving, creating, updating, and deleting records.

Get Record

Get Record is used to retrieve a single record from a database table using a single field to search by.

Query All Records

Query All Records is used to retrieve records based on a search, or all records from a database table.

Database Transaction

Database Transaction is used to perform a database transaction, which is a set of operations that are executed as a single unit. If any database operation fails, the entire transaction will be rolled back.

Direct Database Query

Direct Database Query is used to execute SQL queries, which is a query that is executed directly against the database.

Add Record

Add Record is used to add a new record to a database table.

Add Or Edit Record

Add Or Edit Record is used to search for a record by a single field, and edit it if it exists, or add it if it doesn’t.

Edit Record

Edit Record is used to edit an existing record in a database table.

Delete Record

Delete Record is used to delete an existing record from a database table.

Patch Record

Patch Record is used to patch an existing record in a database table.

Bulk Operations

Bulk Operations are used to perform bulk operations on a database table, such as adding or editing multiple records at once.

Clear All Records

Clear All Records is used to clear all records from a database table.

External Database Query

External Database Query is used to perform a query against an external database. This is useful for connecting to PostgreSQL, MS SQL, Oracle, or MySQL.