> ## 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

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

<Card title="Get Record" icon="table" href="/the-function-stack/functions/database-requests/get-record">
  Get Record is used to retrieve a single record from a database table using a
  single field to search by.
</Card>

<Card title="Query All Records" icon="table" href="/the-function-stack/functions/database-requests/query-all-records">
  Query All Records is used to retrieve records based on a search, or all
  records from a database table.
</Card>

<Card title="Database Transaction" icon="table" href="/the-function-stack/functions/database-requests/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.
</Card>

<Card title="Direct Database Query" icon="table" href="/the-function-stack/functions/database-requests/direct-database-query">
  Direct Database Query is used to execute SQL queries, which is a query that is
  executed directly against the database.
</Card>

<Card title="Add Record" icon="table" href="/the-function-stack/functions/database-requests/add-record">
  Add Record is used to add a new record to a database table.
</Card>

<Card title="Add Or Edit Record" icon="table" href="/the-function-stack/functions/database-requests/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.
</Card>

<Card title="Edit Record" icon="table" href="/the-function-stack/functions/database-requests/edit-record">
  Edit Record is used to edit an existing record in a database table.
</Card>

<Card title="Delete Record" icon="table" href="/the-function-stack/functions/database-requests/delete-record">
  Delete Record is used to delete an existing record from a database table.
</Card>

<Card title="Patch Record" icon="table" href="/the-function-stack/functions/database-requests/patch-record">
  Patch Record is used to patch an existing record in a database table.
</Card>

{" "}

<Card title="Bulk Operations" icon="table" href="/the-function-stack/functions/database-requests/bulk-operations">
  Bulk Operations are used to perform bulk operations on a database table, such
  as adding or editing multiple records at once.
</Card>

<Card title="Clear All Records" icon="table" href="/the-function-stack/functions/database-requests/clear-all-records">
  Clear All Records is used to clear all records from a database table.
</Card>

<Card title="External Database Query" icon="table" href="/the-function-stack/functions/database-requests/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.
</Card>