# Xano Documentation
## Docs
- [Adjust Server Performance](https://docs.xano.com/adjust-server-performance.md)
- [Agency Features](https://docs.xano.com/agencies/agency-features.md)
- [Agency Dashboard](https://docs.xano.com/agencies/agency-features/agency-dashboard.md)
- [Agency Profile](https://docs.xano.com/agencies/agency-features/agency-profile.md)
- [Client Invite](https://docs.xano.com/agencies/agency-features/client-invite.md)
- [Commission](https://docs.xano.com/agencies/agency-features/commission.md)
- [Private Marketplace](https://docs.xano.com/agencies/agency-features/private-marketplace.md)
- [Transfer Ownership](https://docs.xano.com/agencies/agency-features/transfer-ownership.md)
- [Xano For Agencies](https://docs.xano.com/agencies/xano-for-agencies.md)
- [Agents](https://docs.xano.com/ai-tools/agents.md): Agents are used to perform 'fuzzy logic', or perform workflows that require intricate decision making, powered by an AI model of your choice
- [Using OpenTelemetry with AI Agents](https://docs.xano.com/ai-tools/agents/opentelemetry.md): Learn how to integrate OpenTelemetry with AI agents for enhanced observability and monitoring.
- [Templates](https://docs.xano.com/ai-tools/agents/templates.md): Agent Templates
- [Agents](https://docs.xano.com/ai-tools/ai-agents.md): Agents are used to perform 'fuzzy logic', or perform workflows that require intricate decision making, powered by an AI model of your choice
- [MCP Builder](https://docs.xano.com/ai-tools/mcp-builder.md)
- [Connecting Clients](https://docs.xano.com/ai-tools/mcp-builder/connecting-clients.md)
- [MCP Functions](https://docs.xano.com/ai-tools/mcp-builder/mcp-functions.md)
- [Xano MCP Server](https://docs.xano.com/ai-tools/xano-mcp-server.md): Manage your Xano data using your favorite MCP client
- [Add a workspace addon](https://docs.xano.com/api-reference/addon/add-a-workspace-addon.md): add workspace addons
Authentication: required
- [Delete a workspace addon](https://docs.xano.com/api-reference/addon/delete-a-workspace-addon.md): delete workspace addons
Authentication: required
- [Retrieve a workspace addon](https://docs.xano.com/api-reference/addon/retrieve-a-workspace-addon.md): get workspace addon
Authentication: required
- [Retrieve all workspace addons](https://docs.xano.com/api-reference/addon/retrieve-all-workspace-addons.md): browse workspace addons
Authentication: required
- [Update a workspace addon](https://docs.xano.com/api-reference/addon/update-a-workspace-addon.md): update workspace addons
Authentication: required
- [Update addon security settings](https://docs.xano.com/api-reference/addon/update-addon-security-settings.md): update workspace addons security settings
Authentication: required
- [Create a new agent trigger using XanoScript](https://docs.xano.com/api-reference/agent-trigger/create-a-new-agent-trigger-using-xanoscript.md): Create a new agent trigger using XanoScript
Authentication: required
- [Delete an agent trigger permanently. This action cannot be undone](https://docs.xano.com/api-reference/agent-trigger/delete-an-agent-trigger-permanently-this-action-cannot-be-undone.md): Delete a agent trigger permanently. This action cannot be undone
Authentication: required
- [Retrieve all agent triggers](https://docs.xano.com/api-reference/agent-trigger/retrieve-all-agent-triggers.md): Retrieve all agent triggers
Authentication: required
- [Retrieve an agent trigger by ID](https://docs.xano.com/api-reference/agent-trigger/retrieve-an-agent-trigger-by-id.md): Retrieve an agent trigger by ID
Authentication: required
- [Update agent trigger security settings](https://docs.xano.com/api-reference/agent-trigger/update-agent-trigger-security-settings.md): Update agent trigger security configuration and access controls
Authentication: required
- [Update agent trigger using XanoScript](https://docs.xano.com/api-reference/agent-trigger/update-agent-trigger-using-xanoscript.md): Update agent trigger using XanoScript
Authentication: required
- [Create a new agent using XanoScript](https://docs.xano.com/api-reference/agent/create-a-new-agent-using-xanoscript.md): Create a new agent using XanoScript
Authentication: required
- [Delete an agent permanently. This action cannot be undone](https://docs.xano.com/api-reference/agent/delete-an-agent-permanently-this-action-cannot-be-undone.md): Delete a agent permanently. This action cannot be undone
Authentication: required
- [Retrieve a specific agent by ID](https://docs.xano.com/api-reference/agent/retrieve-a-specific-agent-by-id.md): Retrieve a specific agent by ID
Authentication: required
- [Retrieve all agents in a workspace](https://docs.xano.com/api-reference/agent/retrieve-all-agents-in-a-workspace.md): Retrieve all agents in a workspace
Authentication: required
- [Update agent details using XanoScript](https://docs.xano.com/api-reference/agent/update-agent-details-using-xanoscript.md): Update agent details using XanoScript
Authentication: required
- [Create a new API endpoint using XanoScript](https://docs.xano.com/api-reference/api-group-api/create-a-new-api-endpoint-using-xanoscript.md): Create a new API endpoint using XanoScript
Authentication: required
- [Delete an API endpoint permanently. This action cannot be undone](https://docs.xano.com/api-reference/api-group-api/delete-an-api-endpoint-permanently-this-action-cannot-be-undone.md): Delete an API endpoint permanently. This action cannot be undone
Authentication: required
- [Generate OpenAPI specification for a specific API endpoint](https://docs.xano.com/api-reference/api-group-api/generate-openapi-specification-for-a-specific-api-endpoint.md): Generate OpenAPI specification for a specific API endpoint
Authentication: required
Required API Scope:
Workspace Api: Read
- [Retrieve a specific API endpoint by ID](https://docs.xano.com/api-reference/api-group-api/retrieve-a-specific-api-endpoint-by-id.md): Retrieve a specific API endpoint by ID
Authentication: required
- [Retrieve all API endpoints in a group](https://docs.xano.com/api-reference/api-group-api/retrieve-all-api-endpoints-in-a-group.md): Retrieve all API endpoints in a group
Authentication: required
- [Update an API endpoint](https://docs.xano.com/api-reference/api-group-api/update-an-api-endpoint.md): Update API endpoint code, settings, and authentication rules
Authentication: required
- [Update API endpoint security settings](https://docs.xano.com/api-reference/api-group-api/update-api-endpoint-security-settings.md): Update API endpoint security configuration and access controls
Authentication: required
- [Create a new API group](https://docs.xano.com/api-reference/api-group/create-a-new-api-group.md): Create a new API group in a workspace. Include name, description, and optional tags.
Authentication: required
- [Delete an API group](https://docs.xano.com/api-reference/api-group/delete-an-api-group.md): Delete an API group and all its endpoints. This action cannot be undone.
Authentication: required
- [Get OpenAPI spec for an API group](https://docs.xano.com/api-reference/api-group/get-openapi-spec-for-an-api-group.md): Get the OpenAPI specification for an API group. Returns the complete Swagger JSON for all endpoints.
Authentication: required
Required API Scope:
Workspace Api: Read
- [Retrieve a specific API group](https://docs.xano.com/api-reference/api-group/retrieve-a-specific-api-group.md): Get detailed information for a specific API group. Returns complete metadata and configuration.
Authentication: required
- [Retrieve all API groups in a workspace](https://docs.xano.com/api-reference/api-group/retrieve-all-api-groups-in-a-workspace.md): Retrieve a list of API groups inside of a workspace. Use the optional filtering and sorting parameters for more granular returns.
Authentication: required
- [Update an API group](https://docs.xano.com/api-reference/api-group/update-an-api-group.md): Update an existing API group. Modify name, description, documentation settings, or tags.
Authentication: required
- [Update API group security settings](https://docs.xano.com/api-reference/api-group/update-api-group-security-settings.md): Update security settings for an API group. Configure access permissions and authentication requirements.
Authentication: required
- [Browse audit logs across all workspaces](https://docs.xano.com/api-reference/audit-logs/browse-audit-logs-across-all-workspaces.md): browse audit logs across all workspaces
Authentication: required
- [Retrieve workspace audit logs with pagination support](https://docs.xano.com/api-reference/audit-logs/retrieve-workspace-audit-logs-with-pagination-support.md): Retrieve workspace audit logs with pagination support
Authentication: required
Required API Scope:
Workspace Log: Read
- [Search audit logs across all workspaces](https://docs.xano.com/api-reference/audit-logs/search-audit-logs-across-all-workspaces.md): search audit logs across all workspaces with support for complex filtering and sorting
Authentication: required
- [Search workspace audit logs](https://docs.xano.com/api-reference/audit-logs/search-workspace-audit-logs.md): Search audit logs using advanced filters and custom sorting options
Authentication: required
Required API Scope:
Workspace Log: Read
- [Retrieve information about the authenticated user including ID, name, and email address.](https://docs.xano.com/api-reference/authentication/retrieve-information-about-the-authenticated-user-including-id-name-and-email-address.md): Retrieve information about the authenticated user including ID, name, and email address.
Authentication: required
- [Create a new branch by cloning an existing branch.](https://docs.xano.com/api-reference/branch/create-a-new-branch-by-cloning-an-existing-branch.md): Create a new branch by cloning an existing branch.
Authentication: required
Required API Scope:
Instance Workspace: Update
- [Delete a workspace branch](https://docs.xano.com/api-reference/branch/delete-a-workspace-branch.md): Delete a workspace branch. Cannot delete the default branch or currently live branch.
Authentication: required
Required API Scope:
Instance Workspace: Update
- [Retrieve a specific branch by label.](https://docs.xano.com/api-reference/branch/retrieve-a-specific-branch-by-label.md): Retrieve a specific branch by label.
Authentication: required
Required API Scope:
Instance Workspace: Read
- [Retrieve all branches in a workspace.](https://docs.xano.com/api-reference/branch/retrieve-all-branches-in-a-workspace.md): Retrieve all branches in a workspace.
Authentication: required
Required API Scope:
Instance Workspace: Read
- [Set a branch as the live (active) branch for the workspace.](https://docs.xano.com/api-reference/branch/set-a-branch-as-the-live-active-branch-for-the-workspace.md): Set a branch as the live (active) branch for the workspace.
Authentication: required
Required API Scope:
Instance Workspace: Update
- [Update a workspace branch](https://docs.xano.com/api-reference/branch/update-a-workspace-branch.md): Update an existing branch's label, description, or color.
Authentication: required
Required API Scope:
Instance Workspace: Update
- [Convert from JSON to XanoScript](https://docs.xano.com/api-reference/convert/convert-from-json-to-xanoscript.md):
Authentication: required
Required API Scope:
Instance Workspace: Read
- [Convert from XanoScript to JSON](https://docs.xano.com/api-reference/convert/convert-from-xanoscript-to-json.md):
Authentication: required
Required API Scope:
Instance Workspace: Read
- [Delete a file permanently. This action cannot be undone.](https://docs.xano.com/api-reference/file/delete-a-file-permanently-this-action-cannot-be-undone.md): Delete a file permanently. This action cannot be undone.
Authentication: required
Required API Scope:
Workspace File: Delete
- [Delete multiple files permanently. This action cannot be undone.](https://docs.xano.com/api-reference/file/delete-multiple-files-permanently-this-action-cannot-be-undone.md): Delete multiple files permanently. This action cannot be undone.
Authentication: required
Required API Scope:
Workspace File: Delete
- [Retrieve workspace files](https://docs.xano.com/api-reference/file/retrieve-workspace-files.md): Retrieve workspace files with optional search, filtering, and pagination
Authentication: required
Required API Scope:
Workspace File: Read
- [Upload files to workspace](https://docs.xano.com/api-reference/file/upload-files-to-workspace.md): Upload files to workspace
Authentication: required
Required API Scope:
Workspace File: Create
- [Create a new function using XanoScript](https://docs.xano.com/api-reference/function/create-a-new-function-using-xanoscript.md): Create a new function using XanoScript
Authentication: required
- [Delete a function permanently. This action cannot be undone](https://docs.xano.com/api-reference/function/delete-a-function-permanently-this-action-cannot-be-undone.md): Delete a function permanently. This action cannot be undone
Authentication: required
- [Retrieve a specific function by ID](https://docs.xano.com/api-reference/function/retrieve-a-specific-function-by-id.md): Retrieve a specific function by ID
Authentication: required
- [Retrieve all functions in a workspace](https://docs.xano.com/api-reference/function/retrieve-all-functions-in-a-workspace.md): Retrieve all functions in a workspace
Authentication: required
- [Update a function](https://docs.xano.com/api-reference/function/update-a-function.md): Update function code, metadata, and caching settings
Authentication: required
- [Update function security settings](https://docs.xano.com/api-reference/function/update-function-security-settings.md): Update function security configuration and access controls
Authentication: required
- [Create a new MCP server trigger using XanoScript](https://docs.xano.com/api-reference/mcp-server-trigger/create-a-new-mcp-server-trigger-using-xanoscript.md): Create a new mcp_server trigger using XanoScript
Authentication: required
- [Delete an MCP server trigger permanently. This action cannot be undone](https://docs.xano.com/api-reference/mcp-server-trigger/delete-an-mcp-server-trigger-permanently-this-action-cannot-be-undone.md): Delete a mcp_server trigger permanently. This action cannot be undone
Authentication: required
- [Retrieve all MCP server triggers](https://docs.xano.com/api-reference/mcp-server-trigger/retrieve-all-mcp-server-triggers.md): Retrieve all mcp_server triggers
Authentication: required
- [Retrieve an MCP server trigger by ID](https://docs.xano.com/api-reference/mcp-server-trigger/retrieve-an-mcp-server-trigger-by-id.md): Retrieve an mcp_server trigger by ID
Authentication: required
- [Update an MCP server trigger using XanoScript](https://docs.xano.com/api-reference/mcp-server-trigger/update-an-mcp-server-trigger-using-xanoscript.md): Update mcp_server trigger using XanoScript
Authentication: required
- [Update MCP server trigger security settings](https://docs.xano.com/api-reference/mcp-server-trigger/update-mcp-server-trigger-security-settings.md): Update mcp_server trigger security configuration and access controls
Authentication: required
- [Create a new MCP server using XanoScript](https://docs.xano.com/api-reference/mcp-server/create-a-new-mcp-server-using-xanoscript.md): Create a new MCP server using XanoScript
Authentication: required
- [Delete a MCP server permanently. This action cannot be undone](https://docs.xano.com/api-reference/mcp-server/delete-a-mcp-server-permanently-this-action-cannot-be-undone.md): Delete a MCP server permanently. This action cannot be undone
Authentication: required
- [Retrieve a specific MCP server by ID](https://docs.xano.com/api-reference/mcp-server/retrieve-a-specific-mcp-server-by-id.md): Retrieve a specific MCP server by ID
Authentication: required
- [Retrieve all MCP servers in a workspace](https://docs.xano.com/api-reference/mcp-server/retrieve-all-mcp-servers-in-a-workspace.md): Retrieve all MCP servers in a workspace
Authentication: required
- [Retrieve MCP server documentation and available commands](https://docs.xano.com/api-reference/mcp-server/retrieve-mcp-server-documentation-and-available-commands.md): Documentation endpoint that provides a comprehensive overview of the MCP Server's operation and includes detailed documentation for the XanoScript syntax. Use the type "start" to view all available commands.
Authentication: required
- [Update MCP server details using XanoScript](https://docs.xano.com/api-reference/mcp-server/update-mcp-server-details-using-xanoscript.md): Update MCP server details using XanoScript
Authentication: required
- [Create a new middleware using XanoScript](https://docs.xano.com/api-reference/middleware/create-a-new-middleware-using-xanoscript.md): Create a new middleware using XanoScript
Authentication: required
- [Delete a middleware permanently. This action cannot be undone](https://docs.xano.com/api-reference/middleware/delete-a-middleware-permanently-this-action-cannot-be-undone.md): Delete a middleware permanently. This action cannot be undone
Authentication: required
- [Retrieve a specific middleware by ID](https://docs.xano.com/api-reference/middleware/retrieve-a-specific-middleware-by-id.md): Retrieve a specific middleware by ID
Authentication: required
- [Retrieve all middlewares in a workspace](https://docs.xano.com/api-reference/middleware/retrieve-all-middlewares-in-a-workspace.md): Retrieve all middlewares in a workspace
Authentication: required
- [Update a middleware](https://docs.xano.com/api-reference/middleware/update-a-middleware.md): Update middleware code, metadata, and caching settings
Authentication: required
- [Update middleware security settings](https://docs.xano.com/api-reference/middleware/update-middleware-security-settings.md): Update middleware security configuration and access controls
Authentication: required
- [Create a new realtime trigger using XanoScript](https://docs.xano.com/api-reference/realtime-trigger/create-a-new-realtime-trigger-using-xanoscript.md): Create a new realtime trigger using XanoScript
Authentication: required
- [Delete a realtime trigger permanently. This action cannot be undone](https://docs.xano.com/api-reference/realtime-trigger/delete-a-realtime-trigger-permanently-this-action-cannot-be-undone.md): Delete a realtime trigger permanently. This action cannot be undone
Authentication: required
- [Retrieve a realtime trigger by ID](https://docs.xano.com/api-reference/realtime-trigger/retrieve-a-realtime-trigger-by-id.md): Retrieve a realtime trigger by ID
Authentication: required
- [Retrieve all realtime triggers](https://docs.xano.com/api-reference/realtime-trigger/retrieve-all-realtime-triggers.md): Retrieve all realtime triggers
Authentication: required
- [Update realtime trigger security settings](https://docs.xano.com/api-reference/realtime-trigger/update-realtime-trigger-security-settings.md): Update realtime trigger security configuration and access controls
Authentication: required
- [Update realtime trigger using XanoScript](https://docs.xano.com/api-reference/realtime-trigger/update-realtime-trigger-using-xanoscript.md): Update realtime trigger using XanoScript
Authentication: required
- [Create a new realtime channel using XanoScript](https://docs.xano.com/api-reference/realtime/create-a-new-realtime-channel-using-xanoscript.md): Create a new realtime channel using XanoScript
Authentication: required
- [Delete a realtime channel permanently. This action cannot be undone](https://docs.xano.com/api-reference/realtime/delete-a-realtime-channel-permanently-this-action-cannot-be-undone.md): Delete a realtime channel permanently. This action cannot be undone
Authentication: required
- [Retrieve a realtime channel](https://docs.xano.com/api-reference/realtime/retrieve-a-realtime-channel.md): get realtime channel
Authentication: required
- [Retrieve all realtime channels](https://docs.xano.com/api-reference/realtime/retrieve-all-realtime-channels.md): Retrieve all realtime channels
Authentication: required
- [Retrieve real-time operational metrics and connection details](https://docs.xano.com/api-reference/realtime/retrieve-real-time-operational-metrics-and-connection-details.md): Retrieve real-time operational metrics and connection details
Authentication: required
Required API Scope:
Instance Workspace: Read
- [Update real-time settings and connection configuration](https://docs.xano.com/api-reference/realtime/update-real-time-settings-and-connection-configuration.md): Update real-time settings and connection configuration
Authentication: required
Required API Scope:
Instance Workspace: Update
- [Update realtime channel details using XanoScript](https://docs.xano.com/api-reference/realtime/update-realtime-channel-details-using-xanoscript.md): Update realtime channel details using XanoScript
Authentication: required
- [Retrieve API function request history](https://docs.xano.com/api-reference/request-history/retrieve-api-function-request-history.md): Retrieve API function request history
Authentication: required
Required API Scope:
Workspace Request History: Read
- [Retrieve API request history](https://docs.xano.com/api-reference/request-history/retrieve-api-request-history.md): Retrieve API request history
Authentication: required
Required API Scope:
Workspace Request History: Read
- [Retrieve middleware request history](https://docs.xano.com/api-reference/request-history/retrieve-middleware-request-history.md): Retrieve middleware request history
Authentication: required
Required API Scope:
Workspace Request History: Read
- [Retrieve task request history](https://docs.xano.com/api-reference/request-history/retrieve-task-request-history.md): Retrieve task request history
Authentication: required
Required API Scope:
Workspace Request History: Read
- [Retrieve tool request history](https://docs.xano.com/api-reference/request-history/retrieve-tool-request-history.md): Retrieve tool request history
Authentication: required
Required API Scope:
Workspace Request History: Read
- [Retrieve trigger request history](https://docs.xano.com/api-reference/request-history/retrieve-trigger-request-history.md): Retrieve trigger request history
Authentication: required
Required API Scope:
Workspace Request History: Read
- [Search API request history](https://docs.xano.com/api-reference/request-history/search-api-request-history.md): Search API request history using advanced filters and custom sorting options
Authentication: required
Required API Scope:
Workspace Request History: Read
- [Search function request history](https://docs.xano.com/api-reference/request-history/search-function-request-history.md): Search function request history using advanced filters and custom sorting options
Authentication: required
Required API Scope:
Workspace Request History: Read
- [Search middleware request history](https://docs.xano.com/api-reference/request-history/search-middleware-request-history.md): Search middleware request history using advanced filters and custom sorting options
Authentication: required
Required API Scope:
Workspace Request History: Read
- [Search task request history](https://docs.xano.com/api-reference/request-history/search-task-request-history.md): Search task request history using advanced filters and custom sorting options
Authentication: required
Required API Scope:
Workspace Request History: Read
- [Search tool request history](https://docs.xano.com/api-reference/request-history/search-tool-request-history.md): Search tool request history using advanced filters and custom sorting options
Authentication: required
Required API Scope:
Workspace Request History: Read
- [Search trigger request history](https://docs.xano.com/api-reference/request-history/search-trigger-request-history.md): Search trigger request history using advanced filters and custom sorting options
Authentication: required
Required API Scope:
Workspace Request History: Read
- [Create a static host build](https://docs.xano.com/api-reference/static-host/create-a-static-host-build.md): create a static host build
Authentication: required
- [Delete a static host build](https://docs.xano.com/api-reference/static-host/delete-a-static-host-build.md): delete a static host build
Authentication: required
- [Retrieve a specific build for a static host](https://docs.xano.com/api-reference/static-host/retrieve-a-specific-build-for-a-static-host.md): Retrieve a specific build for a static host
Authentication: required
- [Retrieve builds for a static host](https://docs.xano.com/api-reference/static-host/retrieve-builds-for-a-static-host.md): Retrieve builds for a static host
Authentication: required
- [Retrieve workspace static hosts](https://docs.xano.com/api-reference/static-host/retrieve-workspace-static-hosts.md): Retrieve workspace static hosts
Authentication: required
- [Update static hosting environment](https://docs.xano.com/api-reference/static-host/update-static-hosting-environment.md): update static hosting environment
Authentication: required
- [Create a new record in the table](https://docs.xano.com/api-reference/table-content/create-a-new-record-in-the-table.md): Each table has unique schema, which means that the request body should be updated with the schema relevant to the table being used.
The example below is assuming that the table has a column labeled "name".
Required API Scope:
Workspace Content: Create
- [Create multiple records in a single batch operation](https://docs.xano.com/api-reference/table-content/create-multiple-records-in-a-single-batch-operation.md): Each table has unique schema, which means that the request body should be an array of objects with the schema relevant to the table being used.
The example below is assuming that the table has a column labeled "name".
Required API Scope:
Workspace Content: Create
- [Delete a specific record by ID](https://docs.xano.com/api-reference/table-content/delete-a-specific-record-by-id.md): Delete a specific record by ID
Authentication: required
Required API Scope:
Workspace Content: Delete
- [Delete all records matching specified search criteria](https://docs.xano.com/api-reference/table-content/delete-all-records-matching-specified-search-criteria.md): Provide search criteria to delete all matching rows.
Required API Scope:
Workspace Content: Delete
- [Delete multiple records by their IDs in a single operation](https://docs.xano.com/api-reference/table-content/delete-multiple-records-by-their-ids-in-a-single-operation.md): The request body should contain an array of **row_ids**, where each id identifies a row to be deleted.
Required API Scope:
Workspace Content: Delete
- [Retrieve a specific record by ID](https://docs.xano.com/api-reference/table-content/retrieve-a-specific-record-by-id.md): Retrieve a specific record by ID
Authentication: required
Required API Scope:
Workspace Content: Read
- [Retrieve paginated records from a table](https://docs.xano.com/api-reference/table-content/retrieve-paginated-records-from-a-table.md): Retrieve paginated records from a table
Authentication: required
Required API Scope:
Workspace Content: Read
- [Search table records](https://docs.xano.com/api-reference/table-content/search-table-records.md): Search table records with advanced filtering and sorting options
Authentication: required
Required API Scope:
Workspace Content: Read
- [Truncate a database table](https://docs.xano.com/api-reference/table-content/truncate-a-database-table.md): Delete all records from the table and optionally reset the primary key
Authentication: required
Required API Scope:
Workspace Content: Delete
- [Update a specific record by ID](https://docs.xano.com/api-reference/table-content/update-a-specific-record-by-id.md): Each table has unique schema, which means that the request body should be updated with the schema relevant to the table being used.
The example below is assuming that the table has a column labeled "name".
Required API Scope:
Workspace Content: Update
- [Update all records matching specified search criteria](https://docs.xano.com/api-reference/table-content/update-all-records-matching-specified-search-criteria.md): Provide search and update objects with path and new value to patch rows matching search criteria.
Required API Scope:
Workspace Content: Update
- [Update multiple records in a single batch operation](https://docs.xano.com/api-reference/table-content/update-multiple-records-in-a-single-batch-operation.md): The request body should contain an array of **items**, where each item represents a row to be updated. For each row, provide the **row_id** and **updates** array that specifies the columns (**path**) to update and the new values (**value**).
The example below is assuming that the table being modified has a column labeled *name*.
Required API Scope:
Workspace Content: Update
- [Create a btree index on table columns](https://docs.xano.com/api-reference/table-index/create-a-btree-index-on-table-columns.md): Create a btree index on table columns to optimize query performance
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a full-text search index on table columns](https://docs.xano.com/api-reference/table-index/create-a-full-text-search-index-on-table-columns.md): Create a full-text search index for table columns with language-specific optimization
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a spatial index on a table](https://docs.xano.com/api-reference/table-index/create-a-spatial-index-on-a-table.md): Create a spatial index on a table for optimized geometry operations
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a unique index on table columns](https://docs.xano.com/api-reference/table-index/create-a-unique-index-on-table-columns.md): Create a unique index on table fields to enforce data uniqueness and improve query performance
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a vector index on a table column](https://docs.xano.com/api-reference/table-index/create-a-vector-index-on-a-table-column.md): Options include `vector_ip_ops` (Inner Product), `vector_cosine_ops` (Cosine), `vector_l1_ops` (L1 Distance), `vector_l2_ops` (L2 Distance)
Required API Scope:
Workspace Database: Create
- [Delete a specific table index. This action cannot be undone.](https://docs.xano.com/api-reference/table-index/delete-a-specific-table-index-this-action-cannot-be-undone.md): Delete a specific table index. This action cannot be undone.
Authentication: required
Required API Scope:
Workspace Database: Delete
- [Replace all indexes for a database table](https://docs.xano.com/api-reference/table-index/replace-all-indexes-for-a-database-table.md): Replace all indexes for a database table with new index configuration
Authentication: required
Required API Scope:
Workspace Database: Update
- [Retrieve all indexes for a database table](https://docs.xano.com/api-reference/table-index/retrieve-all-indexes-for-a-database-table.md): Retrieve all indexes for a database table
Authentication: required
Required API Scope:
Workspace Database: Read
- [Create a boolean column](https://docs.xano.com/api-reference/table-schema-type/create-a-boolean-column.md): Create a boolean column with true/false values and optional default settings
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a date column](https://docs.xano.com/api-reference/table-schema-type/create-a-date-column.md): Create a date column for storing calendar dates without time information
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a decimal column](https://docs.xano.com/api-reference/table-schema-type/create-a-decimal-column.md): Create a decimal column for precise numeric values with configurable min/max limits
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a geographic linestring column](https://docs.xano.com/api-reference/table-schema-type/create-a-geographic-linestring-column.md): Create a geographic linestring column for storing connected coordinate paths
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a geographic multilinestring column](https://docs.xano.com/api-reference/table-schema-type/create-a-geographic-multilinestring-column.md): Create a geographic multilinestring column for storing multiple coordinate paths
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a geographic multipoint column](https://docs.xano.com/api-reference/table-schema-type/create-a-geographic-multipoint-column.md): Create a geographic multipoint column for storing collections of coordinate points
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a geographic multipolygon column](https://docs.xano.com/api-reference/table-schema-type/create-a-geographic-multipolygon-column.md): Create a geographic multipolygon column for storing complex area boundaries
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a geographic point column](https://docs.xano.com/api-reference/table-schema-type/create-a-geographic-point-column.md): Create a geographic point column for storing latitude/longitude coordinates
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a geographic polygon column](https://docs.xano.com/api-reference/table-schema-type/create-a-geographic-polygon-column.md): Create a geographic polygon column for storing area boundaries and shapes
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a JSON column](https://docs.xano.com/api-reference/table-schema-type/create-a-json-column.md): Create a JSON column for storing structured data objects and arrays
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a password column](https://docs.xano.com/api-reference/table-schema-type/create-a-password-column.md): Create a password column with automatic hashing and complexity validation rules
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a table reference column](https://docs.xano.com/api-reference/table-schema-type/create-a-table-reference-column.md): Create a table reference column to establish relationships with other database tables
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a text column](https://docs.xano.com/api-reference/table-schema-type/create-a-text-column.md): Create a text column with formatting options and customizable validation rules
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a timestamp column](https://docs.xano.com/api-reference/table-schema-type/create-a-timestamp-column.md): Create a timestamp column for storing precise date and time values
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a UUID-based table reference column](https://docs.xano.com/api-reference/table-schema-type/create-a-uuid-based-table-reference-column.md): Create a UUID-based table reference column for relationships with UUID primary keys
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a UUID column](https://docs.xano.com/api-reference/table-schema-type/create-a-uuid-column.md): Create a UUID column for generating universally unique identifiers
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a vector column](https://docs.xano.com/api-reference/table-schema-type/create-a-vector-column.md): Create a vector column for storing multi-dimensional data used in AI and ML applications
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create a video column](https://docs.xano.com/api-reference/table-schema-type/create-a-video-column.md): Create a video file column for storing video uploads and media content
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create an attachment column](https://docs.xano.com/api-reference/table-schema-type/create-an-attachment-column.md): Create an attachment column for file uploads in a database table
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create an audio column](https://docs.xano.com/api-reference/table-schema-type/create-an-audio-column.md): Create an audio file column for storing audio uploads and media
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create an email column](https://docs.xano.com/api-reference/table-schema-type/create-an-email-column.md): Create an email column with built-in email format validation
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create an enum column](https://docs.xano.com/api-reference/table-schema-type/create-an-enum-column.md): Create an enum column with predefined value options for dropdown selections
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create an image column](https://docs.xano.com/api-reference/table-schema-type/create-an-image-column.md): Create an image column for storing photo uploads and visual media
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create an integer column](https://docs.xano.com/api-reference/table-schema-type/create-an-integer-column.md): Create an integer column for whole numbers with configurable min/max limits
Authentication: required
Required API Scope:
Workspace Database: Create
- [Create an object column](https://docs.xano.com/api-reference/table-schema-type/create-an-object-column.md): Create an object column with nested child fields for complex data structures
Authentication: required
Required API Scope:
Workspace Database: Create
- [Delete a column from a table's schema. This action cannot be undone.](https://docs.xano.com/api-reference/table-schema/delete-a-column-from-a-tables-schema-this-action-cannot-be-undone.md): Delete a column from a table's schema. This action cannot be undone.
Authentication: required
Required API Scope:
Workspace Database: Delete
- [Rename a column in a table's schema](https://docs.xano.com/api-reference/table-schema/rename-a-column-in-a-tables-schema.md): Rename a column in a table's schema
Authentication: required
Required API Scope:
Workspace Database: Update
- [Replace the entire schema definition for a database table](https://docs.xano.com/api-reference/table-schema/replace-the-entire-schema-definition-for-a-database-table.md): Replace the entire schema definition for a database table
Authentication: required
Required API Scope:
Workspace Database: Update
- [Retrieve details for a specific column in a table's schema](https://docs.xano.com/api-reference/table-schema/retrieve-details-for-a-specific-column-in-a-tables-schema.md): Retrieve details for a specific column in a table's schema
Authentication: required
Required API Scope:
Workspace Database: Read
- [Retrieve the complete schema definition for a database table](https://docs.xano.com/api-reference/table-schema/retrieve-the-complete-schema-definition-for-a-database-table.md): Retrieve the complete schema definition for a database table
Authentication: required
Required API Scope:
Workspace Database: Read
- [Create a new table trigger using XanoScript](https://docs.xano.com/api-reference/table-trigger/create-a-new-table-trigger-using-xanoscript.md): Create a new table trigger using XanoScript
Authentication: required
- [Delete a table trigger permanently. This action cannot be undone](https://docs.xano.com/api-reference/table-trigger/delete-a-table-trigger-permanently-this-action-cannot-be-undone.md): Delete a table trigger permanently. This action cannot be undone
Authentication: required
- [Retrieve a specific table trigger by ID](https://docs.xano.com/api-reference/table-trigger/retrieve-a-specific-table-trigger-by-id.md): Retrieve a specific table trigger by ID
Authentication: required
- [Retrieve all table triggers](https://docs.xano.com/api-reference/table-trigger/retrieve-all-table-triggers.md): Retrieve all table triggers
Authentication: required
- [Update table trigger security settings](https://docs.xano.com/api-reference/table-trigger/update-table-trigger-security-settings.md): Update table trigger security configuration and access controls
Authentication: required
- [Update table trigger using XanoScript](https://docs.xano.com/api-reference/table-trigger/update-table-trigger-using-xanoscript.md): Update table trigger using XanoScript
Authentication: required
- [Configure table security rules](https://docs.xano.com/api-reference/table/configure-table-security-rules.md): Configure table security rules by assigning an API group GUID or removing restrictions
Authentication: required
- [Create a new database table with optional schema definition](https://docs.xano.com/api-reference/table/create-a-new-database-table-with-optional-schema-definition.md): This endpoint can create a complete table in a single API request, as long as all values below are fully fleshed out. If you want to create the table in multiple steps, then just fill out the name field as shown in the example.
- [Delete a database table and all its data permanently](https://docs.xano.com/api-reference/table/delete-a-database-table-and-all-its-data-permanently.md): Delete a database table and all its data permanently
Authentication: required
- [Retrieve all tables in a workspace](https://docs.xano.com/api-reference/table/retrieve-all-tables-in-a-workspace.md): Retrieve all tables in a workspace
Authentication: required
- [Retrieve detailed information for a specific table](https://docs.xano.com/api-reference/table/retrieve-detailed-information-for-a-specific-table.md): Retrieve detailed information for a specific table
Authentication: required
- [Update a workspace table](https://docs.xano.com/api-reference/table/update-a-workspace-table.md): update workspace table
Authentication: required
- [Update table autocomplete settings](https://docs.xano.com/api-reference/table/update-table-autocomplete-settings.md): update workspace table's autocomplete
Authentication: required
Required API Scope:
Workspace Database: Update
- [Update table properties](https://docs.xano.com/api-reference/table/update-table-properties.md): Update table properties including name, description, tags, and authentication settings
Authentication: required
Required API Scope:
Workspace Database: Update
- [Create a new scheduled task using XanoScript](https://docs.xano.com/api-reference/task/create-a-new-scheduled-task-using-xanoscript.md): Create a new scheduled task using XanoScript
Authentication: required
- [Delete a scheduled task permanently. This action cannot be undone](https://docs.xano.com/api-reference/task/delete-a-scheduled-task-permanently-this-action-cannot-be-undone.md): Delete a scheduled task permanently. This action cannot be undone
Authentication: required
- [Retrieve a specific scheduled task by ID](https://docs.xano.com/api-reference/task/retrieve-a-specific-scheduled-task-by-id.md): Retrieve a specific scheduled task by ID
Authentication: required
- [Retrieve all scheduled tasks in a workspace](https://docs.xano.com/api-reference/task/retrieve-all-scheduled-tasks-in-a-workspace.md): Retrieve all scheduled tasks in a workspace
Authentication: required
- [Update a scheduled task](https://docs.xano.com/api-reference/task/update-a-scheduled-task.md): Update task code, schedule settings, and activation status
Authentication: required
- [Update scheduled task security settings](https://docs.xano.com/api-reference/task/update-scheduled-task-security-settings.md): Update scheduled task security configuration and access controls
Authentication: required
- [Create a new tool using XanoScript](https://docs.xano.com/api-reference/tool/create-a-new-tool-using-xanoscript.md): Create a new tool using XanoScript
Authentication: required
- [Delete a tool permanently. This action cannot be undone](https://docs.xano.com/api-reference/tool/delete-a-tool-permanently-this-action-cannot-be-undone.md): Delete a tool permanently. This action cannot be undone
Authentication: required
- [Retrieve a specific tool by ID](https://docs.xano.com/api-reference/tool/retrieve-a-specific-tool-by-id.md): Retrieve a specific tool by ID
Authentication: required
- [Retrieve all tools in a workspace](https://docs.xano.com/api-reference/tool/retrieve-all-tools-in-a-workspace.md): Retrieve all tools in a workspace
Authentication: required
- [Update a tool](https://docs.xano.com/api-reference/tool/update-a-tool.md): Update tool code, metadata, and caching settings
Authentication: required
- [Update tool security settings](https://docs.xano.com/api-reference/tool/update-tool-security-settings.md): Update tool security configuration and access controls
Authentication: required
- [Add a workflow test](https://docs.xano.com/api-reference/workflow_test/add-a-workflow-test.md): add workspace workflow test
Authentication: required
- [Delete a workflow test](https://docs.xano.com/api-reference/workflow_test/delete-a-workflow-test.md): delete workspace workflow test
Authentication: required
- [Retrieve a workflow test](https://docs.xano.com/api-reference/workflow_test/retrieve-a-workflow-test.md): get workspace workflow test
Authentication: required
- [Retrieve all workflow tests](https://docs.xano.com/api-reference/workflow_test/retrieve-all-workflow-tests.md): browse workspace workflow tests
Authentication: required
- [Update a workflow test](https://docs.xano.com/api-reference/workflow_test/update-a-workflow-test.md): update workspace workflow test
Authentication: required
- [Update workflow test security settings](https://docs.xano.com/api-reference/workflow_test/update-workflow-test-security-settings.md): update workspace workflow test security settings
Authentication: required
- [Create a new external data source with custom label and color](https://docs.xano.com/api-reference/workspace-datasource/create-a-new-external-data-source-with-custom-label-and-color.md): Create a new external data source with custom label and color
Authentication: required
Required API Scope:
Instance Workspace: Create
- [Delete a data source permanently. This action cannot be undone.](https://docs.xano.com/api-reference/workspace-datasource/delete-a-data-source-permanently-this-action-cannot-be-undone.md): Delete a data source permanently. This action cannot be undone.
Authentication: required
Required API Scope:
Instance Workspace: Delete
- [Retrieve all external data sources for a workspace](https://docs.xano.com/api-reference/workspace-datasource/retrieve-all-external-data-sources-for-a-workspace.md): Retrieve all external data sources for a workspace
Authentication: required
Required API Scope:
Instance Workspace: Read
- [Update an existing data source's label and color properties](https://docs.xano.com/api-reference/workspace-datasource/update-an-existing-data-sources-label-and-color-properties.md): Update an existing data source's label and color properties
Authentication: required
Required API Scope:
Instance Workspace: Update
- [Create a new workspace trigger using XanoScript](https://docs.xano.com/api-reference/workspace-trigger/create-a-new-workspace-trigger-using-xanoscript.md): Create a new workspace trigger using XanoScript
Authentication: required
- [Delete a workspace trigger permanently. This action cannot be undone](https://docs.xano.com/api-reference/workspace-trigger/delete-a-workspace-trigger-permanently-this-action-cannot-be-undone.md): Delete a workspace trigger permanently. This action cannot be undone
Authentication: required
- [Retrieve a specific workspace trigger by ID](https://docs.xano.com/api-reference/workspace-trigger/retrieve-a-specific-workspace-trigger-by-id.md): Retrieve a specific workspace trigger by ID
Authentication: required
- [Retrieve all workspace triggers](https://docs.xano.com/api-reference/workspace-trigger/retrieve-all-workspace-triggers.md): Retrieve all workspace triggers
Authentication: required
- [Update a workspace trigger](https://docs.xano.com/api-reference/workspace-trigger/update-a-workspace-trigger.md): Update workspace trigger code, metadata, and caching settings
Authentication: required
- [Update workspace trigger security settings](https://docs.xano.com/api-reference/workspace-trigger/update-workspace-trigger-security-settings.md): Update workspace trigger security configuration and access controls
Authentication: required
- [Create a new workspace](https://docs.xano.com/api-reference/workspace/create-a-new-workspace.md): Create a new workspace
Authentication: required
Required API Scope:
Instance Workspace: Create
- [Delete a workspace permanently](https://docs.xano.com/api-reference/workspace/delete-a-workspace-permanently.md): Delete a workspace permanently
Authentication: required
Required API Scope:
Instance Workspace: Delete
- [Export complete workspace data and configuration as an archive](https://docs.xano.com/api-reference/workspace/export-complete-workspace-data-and-configuration-as-an-archive.md): Leave the `branch` parameter empty to indicate the current live branch. `password` is optional. If provided, will encrypt the export and will be required when importing the file.
Required API Scope:
Instance Workspace: Read
- [Export database table schemas and branch configuration as a file](https://docs.xano.com/api-reference/workspace/export-database-table-schemas-and-branch-configuration-as-a-file.md): Leave the `branch` parameter empty to indicate the current live branch. `password` is optional. If provided, will encrypt the export and will be required when importing the file.
Required API Scope:
Instance Workspace: Read
- [Generate full workspace context](https://docs.xano.com/api-reference/workspace/generate-full-workspace-context.md): generate a full context for a workspace
Authentication: required
Required API Scope:
Instance Workspace: Read
- [Import database schema into a new branch with optional deployment](https://docs.xano.com/api-reference/workspace/import-database-schema-into-a-new-branch-with-optional-deployment.md): Import database schema into a new branch with optional deployment
Authentication: required
Required API Scope:
Instance Workspace: Read
- [Replace workspace content and configuration with imported archive](https://docs.xano.com/api-reference/workspace/replace-workspace-content-and-configuration-with-imported-archive.md): If the file is encrypted, the correct `password` is required to decrypt.
Required API Scope:
Instance Workspace: Update
- [Retrieve all accessible workspaces for the authenticated user](https://docs.xano.com/api-reference/workspace/retrieve-all-accessible-workspaces-for-the-authenticated-user.md): Retrieve all accessible workspaces for the authenticated user
Authentication: required
- [Retrieve detailed information about a specific workspace](https://docs.xano.com/api-reference/workspace/retrieve-detailed-information-about-a-specific-workspace.md): Retrieve detailed information about a specific workspace
Authentication: required
Required API Scope:
Instance Workspace: Read
- [Retrieve workspace-wide OpenAPI spec](https://docs.xano.com/api-reference/workspace/retrieve-workspace-wide-openapi-spec.md): get workspace-wide OpenAPI (swagger) spec for all API groups
Authentication: required
Required API Scope:
Instance Workspace: Read
- [Update an existing workspace](https://docs.xano.com/api-reference/workspace/update-an-existing-workspace.md): Update an existing workspace
Authentication: required
Required API Scope:
Instance Workspace: Update
- [Push XanoScript multidoc](https://docs.xano.com/api-reference/xanoscript/push-xanoscript-multidoc.md):
Authentication: required
- [Retrieve XanoScript multidoc](https://docs.xano.com/api-reference/xanoscript/retrieve-xanoscript-multidoc.md):
Authentication: required
- [Key Concepts](https://docs.xano.com/before-you-begin/key-concepts.md): Get a quick primer on the key concepts and terminology that we use throughout the product and documentation to get you started quickly.
- [Navigating Xano](https://docs.xano.com/before-you-begin/navigating-xano.md)
- [Set Up A Free Xano Account](https://docs.xano.com/before-you-begin/set-up-a-free-xano-account.md): Let's make sure that you are ready to play around in Xano before continuing.
- [The Development Life Cycle](https://docs.xano.com/before-you-begin/the-development-life-cycle.md): Learn more about the fundamentals of application development and the software development life cycle.
- [Using These Docs](https://docs.xano.com/before-you-begin/using-these-docs.md)
- [Where Should I Start?](https://docs.xano.com/before-you-begin/where-should-i-start.md)
- [Browse Snippets](https://docs.xano.com/browse-snippets.md)
- [Chatbots](https://docs.xano.com/building-backend-features/chatbots.md)
- [Custom Report Generation](https://docs.xano.com/building-backend-features/custom-report-generation.md)
- [Emails](https://docs.xano.com/building-backend-features/emails.md)
- [Fuzzy Search](https://docs.xano.com/building-backend-features/fuzzy-search.md)
- [Location Data](https://docs.xano.com/building-backend-features/location-data.md)
- [Messaging](https://docs.xano.com/building-backend-features/messaging.md)
- [Notifications](https://docs.xano.com/building-backend-features/notifications.md)
- [Payments](https://docs.xano.com/building-backend-features/payments.md)
- [User Auth & Data](https://docs.xano.com/building-backend-features/user-authentication-and-user-data.md)
- [OAuth (SSO)](https://docs.xano.com/building-backend-features/user-authentication-and-user-data/oauth-sso.md)
- [Restricting Access (RBAC)](https://docs.xano.com/building-backend-features/user-authentication-and-user-data/restricting-access-rbac.md)
- [Separating User Data](https://docs.xano.com/building-backend-features/user-authentication-and-user-data/separating-user-data.md)
- [User Roles](https://docs.xano.com/building-backend-features/user-roles.md)
- [Webhooks](https://docs.xano.com/building-backend-features/webhooks.md): Webhooks are specialized API endpoints designed to be triggered based on other events
- [Building Visually with the Canvas View](https://docs.xano.com/building/build-visually/canvas-view.md): Build a workflow without code using the Canvas View
- [Function Stack](https://docs.xano.com/building/build-visually/function-stack.md): Build a function stack in the visual builder
- [API Request Assistant](https://docs.xano.com/building/build-with-ai/api-request-assistant.md): Learn how to use the API Request Assistant to help build external API requests for your backend
- [Database Assistant](https://docs.xano.com/building/build-with-ai/database-assistant.md): Learn how to use the Database Assistant to help add to or update your database
- [Getting Started Assistant](https://docs.xano.com/building/build-with-ai/getting-started-assistant.md): Learn how to use the Getting Started Assistant to build your Xano workspace
- [Lambda Assistant](https://docs.xano.com/building/build-with-ai/lambda-assistant.md): Learn how to use the Lambda Assistant to help build Lambda functions for your backend
- [Logic Assistant](https://docs.xano.com/building/build-with-ai/logic-assistant.md)
- [Prompt Assistant](https://docs.xano.com/building/build-with-ai/prompt-assistant.md): Learn how to use the Prompt Assistant to help build AI system and user prompts
- [SQL Assistant](https://docs.xano.com/building/build-with-ai/sql-assistant.md): Learn how to use the SQL Assistant to help build complex SQL queries for your database
- [Template Assistant](https://docs.xano.com/building/build-with-ai/template-assistant.md): Learn how to use the Template Assistant to help build templates for AI prompts, HTML, and other more large-format data
- [Xano MCP Server](https://docs.xano.com/building/build-with-ai/xano-mcp.md): Learn how to use the Xano MCP Server with an MCP client to build your entire backend with AI
- [Xano MCP Tool filters](https://docs.xano.com/building/build-with-ai/xano-mcp-tool-filters.md): When connecting to the Xano MCP server, you'll need to select what categories of tools to allow. This guide explains the available tool filter options.
- [Xano MCP Tools](https://docs.xano.com/building/build-with-ai/xano-mcp-tools.md): A list of all the tools available in the Xano MCP Server
- [Building with Code](https://docs.xano.com/building/code.md): Learn how to build with code in Xano
- [Addons in Xano](https://docs.xano.com/building/logic/addons.md): Learn how to build and use Addons in Xano to fetch related data for APIs and other queries.
- [Building APIs in Xano](https://docs.xano.com/building/logic/apis.md): Learn how to build APIs with no code, with code, or with AI, all in Xano
- [Background Tasks in Xano](https://docs.xano.com/building/logic/background-tasks.md): Learn how to build and schedule background tasks (cron jobs) in Xano using the visual builder or XanoScript.
- [Core Components of Logic](https://docs.xano.com/building/logic/core-components.md): Learn about what makes up the logic and workflows you build in Xano
- [Environment Variables](https://docs.xano.com/building/logic/core-components/environment-variables.md)
- [Filters](https://docs.xano.com/building/logic/core-components/filters.md): Use filters to manipulate data throughout your logic
- [Functions](https://docs.xano.com/building/logic/core-components/functions.md): The functions that make up your logic
- [Inputs](https://docs.xano.com/building/logic/core-components/inputs.md): Data that is supplied to the logic before execution
- [Logic](https://docs.xano.com/building/logic/core-components/logic.md): The business logic that executes when called
- [Response](https://docs.xano.com/building/logic/core-components/response.md): Anything that is returned when the logic is complete
- [Building Custom Functions in Xano](https://docs.xano.com/building/logic/custom-functions.md): Learn how to build Custom Functions (reusable logic)
- [Logic & Workflows](https://docs.xano.com/building/logic/logic.md): Everything you can build with Xano's logic engine — APIs, functions, tasks, triggers, and middleware.
- [Middleware](https://docs.xano.com/building/logic/middleware.md): Middleware is used to add additional logic that executes before or after other logic.
- [Triggers](https://docs.xano.com/building/logic/triggers.md): Triggers are workflows that can run based on other events that happen in your workspace.
- [AI Agent Trigger](https://docs.xano.com/building/logic/triggers/ai-agent.md)
- [Database Triggers](https://docs.xano.com/building/logic/triggers/database.md)
- [MCP Server Triggers](https://docs.xano.com/building/logic/triggers/mcp-servers.md)
- [Realtime Triggers](https://docs.xano.com/building/logic/triggers/realtime.md)
- [Workspace Triggers](https://docs.xano.com/building/logic/triggers/workspace.md): Workspace triggers are workflows that will run when certain actions happen in the workspace.
- [Working with Data](https://docs.xano.com/building/logic/working-with-data.md): Learn how to use, transform, and manipulate data in Xano
- [Dot Notation](https://docs.xano.com/building/logic/working-with-data/dot-notation.md): Dot notation is used to target specific pieces of data inside of objects and arrays
- [Environment Variables](https://docs.xano.com/building/logic/working-with-data/environment-variables.md): Variables that are available across your entire workspace
- [Variables](https://docs.xano.com/building/logic/working-with-data/variables.md): Variables are used to store temporary information that you need to access later in a workflow
- [Building Visually](https://docs.xano.com/building/visually.md): Learn about how Xano enables you to build your backend without code
- [Building with AI](https://docs.xano.com/building/with-ai.md): Learn how to build with AI in Xano using our AI Assistants
- [CI/CD](https://docs.xano.com/ci-cd.md): Learn more about CI/CD inside of Xano
- [Browse Integrations](https://docs.xano.com/connect.md)
- [Connecting a Frontend](https://docs.xano.com/connecting-to-a-frontend.md): Learn how to connect your Xano backend to popular frontends like WeWeb, Bubble, and AI builders like Lovable, use the Swagger (OpenAPI) specification with AI copilots, or integrate with traditional TypeScript development.
- [Deployment](https://docs.xano.com/deployment.md): Overview of deployment options and resources for taking your Xano projects from development to production.
- [Deployment Readiness](https://docs.xano.com/deployment-readiness.md): Ensure your Xano backend is production-ready with performance checks, testing, and validation strategies.
- [Developer API (Deprecated)](https://docs.xano.com/developer-api-deprecated.md)
- [Developer MCP](https://docs.xano.com/developer-mcp/get-started.md): Install and configure the Xano Developer MCP for AI-assisted XanoScript development
- [Resources & Library Usage](https://docs.xano.com/developer-mcp/resources.md): Access XanoScript documentation as MCP resources and use the package as an npm library
- [Tools Reference](https://docs.xano.com/developer-mcp/tools.md): Complete reference for all tools available in the Xano Developer MCP
- [Enterprise Features](https://docs.xano.com/enterprise/enterprise-features.md)
- [Compliance Center](https://docs.xano.com/enterprise/enterprise-features/compliance-center.md)
- [Deployment](https://docs.xano.com/enterprise/enterprise-features/deployment.md)
- [Instance Activity](https://docs.xano.com/enterprise/enterprise-features/instance-activity.md)
- [Microservices](https://docs.xano.com/enterprise/enterprise-features/microservices.md)
- [Ollama](https://docs.xano.com/enterprise/enterprise-features/microservices/ollama.md): Deploy LLMs as a part of your Xano instance
- [Choosing A Model](https://docs.xano.com/enterprise/enterprise-features/microservices/ollama/choosing-a-model.md)
- [RBAC (Role Based Access Control)](https://docs.xano.com/enterprise/enterprise-features/rbac-role-based-access-control.md)
- [Resource Management](https://docs.xano.com/enterprise/enterprise-features/resource-management.md): BYOC (Bring your own Cloud) users can manage their available instance resources from their instance settings
- [Security Policy](https://docs.xano.com/enterprise/enterprise-features/security-policy.md)
- [Tenant Center](https://docs.xano.com/enterprise/enterprise-features/tenant-center.md)
- [Xano Link](https://docs.xano.com/enterprise/enterprise-features/xano-link.md)
- [Xano For Enterprise (Custom Plans)](https://docs.xano.com/enterprise/xano-for-enterprise.md)
- [File Storage In Xano](https://docs.xano.com/file-storage/file-storage-in-xano.md)
- [Private File Storage](https://docs.xano.com/file-storage/private-file-storage.md)
- [Xano — Features & Capabilities FAQ](https://docs.xano.com/frequently-asked-questions.md): An overview of Xano's features, architecture, AI capabilities, security, and enterprise readiness.
- [AI-Assisted Development in VS Code](https://docs.xano.com/getting-started-ai.md): A guide to using AI coding assistants like GitHub Copilot with the XanoScript VS Code extension to build and iterate on your backend.
- [Building with the VS Code Extension](https://docs.xano.com/getting-started-code.md): A guide to connecting VS Code to Xano, editing endpoints in XanoScript, and syncing changes.
- [Building Visually](https://docs.xano.com/getting-started-visual.md): A guide to using Xano's visual builder to inspect, validate, and iterate on your backend workflows.
- [Get Started](https://docs.xano.com/index.md): Go from zero to a live backend in minutes.
- [Welcome To Xano!](https://docs.xano.com/indexold.md)
- [API Rate Limit](https://docs.xano.com/instances/api-rate-limit.md)
- [Partner Integration Guide](https://docs.xano.com/integration/integration-guide.md): Learn how to integrate with Xano through programmatic backend building or by embedding your product into the Xano ecosystem.
- [null](https://docs.xano.com/link/pricing.md)
- [Instance Dashboard](https://docs.xano.com/maintenance-monitoring-and-logging/instance-dashboard.md)
- [Memory Usage](https://docs.xano.com/maintenance-monitoring-and-logging/instance-dashboard/memory-usage.md)
- [Performance Insights](https://docs.xano.com/maintenance-monitoring-and-logging/performance-insights.md): Review performance of individual functions and function stacks throughout your workspace
- [Request History](https://docs.xano.com/maintenance-monitoring-and-logging/request-history.md)
- [Statement Explorer](https://docs.xano.com/maintenance-monitoring-and-logging/statement-explorer.md): Use the Statement Explorer to quickly find instances of specific functions across all function stacks
- [Quick Start Template](https://docs.xano.com/quick-start-template.md): Spin up a working B2B SaaS backend in minutes with Xano’s Quick Start template.
- [Channel Permissions](https://docs.xano.com/realtime/channel-permissions.md)
- [Realtime In Webflow](https://docs.xano.com/realtime/realtime-in-webflow.md)
- [Realtime In Xano](https://docs.xano.com/realtime/realtime-in-xano.md)
- [Best Practices](https://docs.xano.com/security/best-practices.md)
- [GDPR](https://docs.xano.com/security/gdpr.md)
- [Getting Answers to Security Questions](https://docs.xano.com/security/getting-answers-to-security-questions.md): A guide on how to effectively obtain answers to common security questions for compliance and risk management.
- [HIPAA](https://docs.xano.com/security/hipaa.md)
- [ISO 2700-1](https://docs.xano.com/security/iso-27001.md)
- [security.xano.com](https://docs.xano.com/security/security.md)
- [SOC 2](https://docs.xano.com/security/soc2.md)
- [Branching & Merging](https://docs.xano.com/team-collaboration/branching-and-merging.md)
- [Managing Team Members](https://docs.xano.com/team-collaboration/managing-team-members.md)
- [Realtime Collaboration](https://docs.xano.com/team-collaboration/realtime-collaboration.md)
- [Role Based Access Control (RBAC)](https://docs.xano.com/team-collaboration/role-based-access-control-rbac.md)
- [Docker](https://docs.xano.com/technology/docker.md)
- [Kubernetes](https://docs.xano.com/technology/kubernetes.md)
- [PostgreSQL](https://docs.xano.com/technology/postgresql.md)
- [Test Suites](https://docs.xano.com/testing-debugging/test-suites.md)
- [Testing And Debugging Function Stacks](https://docs.xano.com/testing-debugging/testing-and-debugging-function-stacks.md)
- [Unit Tests](https://docs.xano.com/testing-debugging/unit-tests.md)
- [Database Overview](https://docs.xano.com/the-database/database.md): All the resources you need to get started with the Xano database
- [Database Basics](https://docs.xano.com/the-database/database-basics.md): In this section, you'll learn about the basic concepts of what a database is, and how it works.
- [Data Sources](https://docs.xano.com/the-database/database-basics/data-sources.md)
- [Database Views](https://docs.xano.com/the-database/database-basics/database-views.md): Database Views are used to save filtering, sorting, and search options in your tables so that you can quickly return later.
- [Export And Sharing](https://docs.xano.com/the-database/database-basics/export-and-sharing.md)
- [Field Types](https://docs.xano.com/the-database/database-basics/field-types.md)
- [Relationships](https://docs.xano.com/the-database/database-basics/relationships.md): Database Relationships are used to define related data between one or more tables.
- [Using The Xano Database](https://docs.xano.com/the-database/database-basics/using-the-xano-database.md)
- [Database Performance And Maintenance](https://docs.xano.com/the-database/database-performance-and-maintenance.md)
- [Indexing](https://docs.xano.com/the-database/database-performance-and-maintenance/indexing.md)
- [Maintenance](https://docs.xano.com/the-database/database-performance-and-maintenance/maintenance.md)
- [Schema Versioning](https://docs.xano.com/the-database/database-performance-and-maintenance/schema-versioning.md)
- [Database Storage Explained](https://docs.xano.com/the-database/database-performance-and-maintenance/storage.md)
- [Database Design Fundamentals](https://docs.xano.com/the-database/designing-your-database.md)
- [Getting Started Shortcuts](https://docs.xano.com/the-database/getting-started-shortcuts.md)
- [Migrating Data to Xano](https://docs.xano.com/the-database/migrating-your-data.md)
- [Adalo to Xano](https://docs.xano.com/the-database/migrating-your-data/adalo-to-xano.md): A step-by-step guide to move your collections, records, and relationships from an Adalo app into a Xano backend.
- [Add via API](https://docs.xano.com/the-database/migrating-your-data/add-via-api.md)
- [Airtable To Xano](https://docs.xano.com/the-database/migrating-your-data/airtable-to-xano.md)
- [Bubble to Xano](https://docs.xano.com/the-database/migrating-your-data/bubble-to-xano.md)
- [Connect to an External Database](https://docs.xano.com/the-database/migrating-your-data/connect-to-an-external-database.md): Learn how to connect to and migrate your data from an external database to Xano
- [CSV Import & Export](https://docs.xano.com/the-database/migrating-your-data/csv-import-and-export.md)
- [Fastgen to Xano](https://docs.xano.com/the-database/migrating-your-data/fastgen-to-xano.md)
- [Google Sheets to Xano](https://docs.xano.com/the-database/migrating-your-data/google-sheets-to-xano.md)
- [Migrating Your Data](https://docs.xano.com/the-database/migrating-your-data/migrating.md): Learn how to migrate your data from other sources to Xano
- [Supabase To Xano](https://docs.xano.com/the-database/migrating-your-data/supabase-to-xano.md)
- [Additional Features](https://docs.xano.com/the-function-stack/additional-features.md)
- [Response Caching](https://docs.xano.com/the-function-stack/additional-features/response-caching.md)
- [Swagger/OpenAPI Docs](https://docs.xano.com/the-function-stack/building-with-visual-development/apis/swagger-openapi-documentation.md): Using Swagger/OpenAPI to document your Xano APIs for easy integration.
- [Configuring Expressions](https://docs.xano.com/the-function-stack/building-with-visual-development/configuring-expressions.md)
- [Async Functions](https://docs.xano.com/the-function-stack/building-with-visual-development/custom-functions/async-functions.md): Use async functions to ensure that your custom functions execute exactly as you intend
- [Publishing](https://docs.xano.com/the-function-stack/building-with-visual-development/publishing.md): Learn how to publish changes in your Xano function stacks so that new logic and API updates are deployed to your live environment.
- [OpenAPI Documentation](https://docs.xano.com/the-function-stack/building-with-visual-development/swagger-openapi-documentation.md): Using Swagger/OpenAPI to document your Xano APIs for easy integration.
- [Data Types](https://docs.xano.com/the-function-stack/data-types.md)
- [Array](https://docs.xano.com/the-function-stack/data-types/array.md)
- [Boolean](https://docs.xano.com/the-function-stack/data-types/boolean.md)
- [Decimal](https://docs.xano.com/the-function-stack/data-types/decimal.md)
- [Expression](https://docs.xano.com/the-function-stack/data-types/expression.md)
- [Integer](https://docs.xano.com/the-function-stack/data-types/integer.md)
- [Null](https://docs.xano.com/the-function-stack/data-types/null.md)
- [Object](https://docs.xano.com/the-function-stack/data-types/object.md)
- [Text](https://docs.xano.com/the-function-stack/data-types/text.md)
- [Timestamp](https://docs.xano.com/the-function-stack/data-types/timestamp.md)
- [Environment Variables](https://docs.xano.com/the-function-stack/environment-variables.md)
- [Filter Reference](https://docs.xano.com/the-function-stack/filters.md)
- [Array](https://docs.xano.com/the-function-stack/filters/array.md)
- [Comparison](https://docs.xano.com/the-function-stack/filters/comparison.md)
- [Conversion](https://docs.xano.com/the-function-stack/filters/conversion.md)
- [Manipulation](https://docs.xano.com/the-function-stack/filters/manipulation.md)
- [Math](https://docs.xano.com/the-function-stack/filters/math.md)
- [Security](https://docs.xano.com/the-function-stack/filters/security.md)
- [Text](https://docs.xano.com/the-function-stack/filters/text.md)
- [Timestamp](https://docs.xano.com/the-function-stack/filters/timestamp.md)
- [Transform](https://docs.xano.com/the-function-stack/filters/transform.md)
- [Functions Reference](https://docs.xano.com/the-function-stack/functions.md)
- [AI Tools](https://docs.xano.com/the-function-stack/functions/ai-tools.md)
- [APIs & Lambdas](https://docs.xano.com/the-function-stack/functions/apis-and-lambdas.md)
- [External API Request](https://docs.xano.com/the-function-stack/functions/apis-and-lambdas/external-api-request.md)
- [Lambda Functions](https://docs.xano.com/the-function-stack/functions/apis-and-lambdas/lambda-functions.md)
- [Supported Libraries](https://docs.xano.com/the-function-stack/functions/apis-and-lambdas/lambda-functions/supported-libraries.md)
- [Realtime Functions](https://docs.xano.com/the-function-stack/functions/apis-and-lambdas/realtime-functions.md)
- [Cloud Services](https://docs.xano.com/the-function-stack/functions/cloud-services.md)
- [Connected](https://docs.xano.com/the-function-stack/functions/connected.md)
- [Custom Functions](https://docs.xano.com/the-function-stack/functions/custom-functions.md)
- [Data Caching (Redis)](https://docs.xano.com/the-function-stack/functions/data-caching-redis.md)
- [Data Manipulation](https://docs.xano.com/the-function-stack/functions/data-manipulation.md)
- [Arrays](https://docs.xano.com/the-function-stack/functions/data-manipulation/arrays.md)
- [Conditional](https://docs.xano.com/the-function-stack/functions/data-manipulation/conditional.md)
- [Create Variable](https://docs.xano.com/the-function-stack/functions/data-manipulation/create-variable.md)
- [Loops](https://docs.xano.com/the-function-stack/functions/data-manipulation/loops.md)
- [Math](https://docs.xano.com/the-function-stack/functions/data-manipulation/math.md)
- [Objects](https://docs.xano.com/the-function-stack/functions/data-manipulation/objects.md)
- [Switch](https://docs.xano.com/the-function-stack/functions/data-manipulation/switch.md)
- [Text](https://docs.xano.com/the-function-stack/functions/data-manipulation/text.md)
- [Update Variable](https://docs.xano.com/the-function-stack/functions/data-manipulation/update-variable.md)
- [Database Requests](https://docs.xano.com/the-function-stack/functions/database-requests.md)
- [Add Or Edit Record](https://docs.xano.com/the-function-stack/functions/database-requests/add-or-edit-record.md)
- [Add Record](https://docs.xano.com/the-function-stack/functions/database-requests/add-record.md)
- [Bulk Operations](https://docs.xano.com/the-function-stack/functions/database-requests/bulk-operations.md): Perform actions on multiple records at once.
- [Clear All Records](https://docs.xano.com/the-function-stack/functions/database-requests/clear-all-records.md)
- [Database Transaction](https://docs.xano.com/the-function-stack/functions/database-requests/database-transaction.md)
- [Delete Record](https://docs.xano.com/the-function-stack/functions/database-requests/delete-record.md)
- [Direct Database Query](https://docs.xano.com/the-function-stack/functions/database-requests/direct-database-query.md)
- [Edit Record](https://docs.xano.com/the-function-stack/functions/database-requests/edit-record.md)
- [External Database Query](https://docs.xano.com/the-function-stack/functions/database-requests/external-database-query.md)
- [Get Database Schema](https://docs.xano.com/the-function-stack/functions/database-requests/get-database-schema.md)
- [Get Record](https://docs.xano.com/the-function-stack/functions/database-requests/get-record.md)
- [Patch Record](https://docs.xano.com/the-function-stack/functions/database-requests/patch-record.md)
- [Query All Records](https://docs.xano.com/the-function-stack/functions/database-requests/query-all-records.md)
- [External Filtering Examples](https://docs.xano.com/the-function-stack/functions/database-requests/query-all-records/external-filtering-examples.md)
- [File Storage](https://docs.xano.com/the-function-stack/functions/file-storage.md)
- [Security](https://docs.xano.com/the-function-stack/functions/security.md)
- [Utility Functions](https://docs.xano.com/the-function-stack/functions/utility-functions.md)
- [Error Reference](https://docs.xano.com/troubleshooting-and-support/error-reference.md)
- [Getting Help](https://docs.xano.com/troubleshooting-and-support/getting-help.md)
- [Community Code Of Conduct](https://docs.xano.com/troubleshooting-and-support/getting-help/community-code-of-conduct.md)
- [Community Content Modification Policy](https://docs.xano.com/troubleshooting-and-support/getting-help/community-content-modification-policy.md)
- [Granting Access](https://docs.xano.com/troubleshooting-and-support/getting-help/granting-access.md)
- [Reporting Potential Bugs & Issues](https://docs.xano.com/troubleshooting-and-support/getting-help/reporting-potential-bugs-and-issues.md): Follow these guidelines to get the best possible support from our team.
- [What to Do If Your APIs Aren't Responding](https://docs.xano.com/troubleshooting-and-support/my-apis-arent-responding.md)
- [What to Do If Your Instance Is Down](https://docs.xano.com/troubleshooting-and-support/my-instance-is-down.md)
- [Plan Comparison](https://docs.xano.com/troubleshooting-and-support/plan-comparison.md): Information for when you're on a legacy plan and want to know how the current offerings stack up
- [Plan Comparison](https://docs.xano.com/troubleshooting-and-support/plan-comparison-refactor.md): Understand how legacy plans (Starter, Launch, Scale) map to the current lineup (Free, Essential, Pro).
- [Reporting Potential Bugs and Issues](https://docs.xano.com/troubleshooting-and-support/reporting-potential-bugs-and-issues.md)
- [Troubleshooting and Support - Start Here](https://docs.xano.com/troubleshooting-and-support/start.md)
- [Things Feel Slow](https://docs.xano.com/troubleshooting-and-support/things-feel-slow.md)
- [Troubleshooting Performance](https://docs.xano.com/troubleshooting-and-support/troubleshooting-performance.md)
- [Function Stack Performance](https://docs.xano.com/troubleshooting-and-support/troubleshooting-performance/function-stack-performance.md)
- [RAM Usage](https://docs.xano.com/troubleshooting-and-support/troubleshooting-performance/ram-usage.md)
- [When A Single Workflow Feels Slow](https://docs.xano.com/troubleshooting-and-support/troubleshooting-performance/when-a-single-workflow-feels-slow.md)
- [When Everything Feels Slow](https://docs.xano.com/troubleshooting-and-support/troubleshooting-performance/when-everything-feels-slow.md)
- [What's New](https://docs.xano.com/updates.md): What's new in Xano -- Release Notes, Announcements, and Documentation Updates
- [Using AI Builders With Xano](https://docs.xano.com/using-ai-builders-with-xano.md): Get the latest on using platforms like Bolt.new, v0, and Cursor with Xano
- [Get the Extension,](https://docs.xano.com/vscode-ext.md)
- [Browse Actions](https://docs.xano.com/xano-actions/browse-actions.md)
- [Actions](https://docs.xano.com/xano-actions/what-are-actions.md)
- [Database Assistant](https://docs.xano.com/xano-ai/ai-database-assistant.md)
- [Lambda Assistant](https://docs.xano.com/xano-ai/ai-lambda-assistant.md)
- [SQL Assistant](https://docs.xano.com/xano-ai/ai-sql-assistant.md)
- [API Request Assistant](https://docs.xano.com/xano-ai/api-request-assistant.md)
- [Building a Backend Using AI](https://docs.xano.com/xano-ai/building-a-backend-using-ai.md)
- [Function Stack Assistant](https://docs.xano.com/xano-ai/function-stack-assistant.md)
- [Get Started Assistant](https://docs.xano.com/xano-ai/get-started-assistant.md)
- [Streaming APIs](https://docs.xano.com/xano-ai/streaming-apis.md)
- [Template Engine](https://docs.xano.com/xano-ai/template-engine.md)
- [null](https://docs.xano.com/xano-cli/DOC_ACCURACY_REPORT.md)
- [Get Started](https://docs.xano.com/xano-cli/get-started.md): Install the Xano CLI and set up your first profile
- [Work from Existing](https://docs.xano.com/xano-cli/guide-from-existing.md): Pull down an existing Xano workspace and develop locally
- [Start from Scratch](https://docs.xano.com/xano-cli/guide-from-scratch.md): Build a new Xano backend from zero using the CLI and AI
- [Platforms](https://docs.xano.com/xano-cli/platforms.md): View platform versions available for tenant deployment
- [Push & Pull](https://docs.xano.com/xano-cli/push-pull.md): Sync XanoScript files between your local filesystem and Xano
- [Releases](https://docs.xano.com/xano-cli/releases.md): Create, manage, and deploy releases from the CLI
- [Tenants](https://docs.xano.com/xano-cli/tenants.md): Manage tenants, deployments, environments, and backups from the CLI
- [Testing](https://docs.xano.com/xano-cli/workflow-tests.md): Run unit tests and workflow tests from the CLI
- [Workspaces & Branches](https://docs.xano.com/xano-cli/workspaces-and-branches.md): Manage your Xano workspaces and branches from the CLI
- [Advanced Back End Features](https://docs.xano.com/xano-features/advanced-back-end-features.md)
- [Developer API (Deprecated)](https://docs.xano.com/xano-features/advanced-back-end-features/developer-api-deprecated.md)
- [Xano Link](https://docs.xano.com/xano-features/advanced-back-end-features/xano-link.md)
- [Instance Settings](https://docs.xano.com/xano-features/instance-settings.md)
- [Backup And Restore](https://docs.xano.com/xano-features/instance-settings/backup-and-restore.md)
- [Change Server Region](https://docs.xano.com/xano-features/instance-settings/change-server-region.md)
- [Direct Database Connector](https://docs.xano.com/xano-features/instance-settings/direct-database-connector.md): Establish a direct connection to your instance's PostgreSQL database
- [Release Track Preferences](https://docs.xano.com/xano-features/instance-settings/release-track-preferences.md): Decide when to get the latest Xano updates
- [Security Policy](https://docs.xano.com/xano-features/instance-settings/security-policy.md)
- [Static IP (Outgoing)](https://docs.xano.com/xano-features/instance-settings/static-ip-outgoing.md)
- [Metadata API](https://docs.xano.com/xano-features/metadata-api.md)
- [Get authorized user](https://docs.xano.com/xano-features/metadata-api/account_api/auth_me.md): Returns the authorized user's basic account information
- [Browse instances](https://docs.xano.com/xano-features/metadata-api/account_api/browse-instances.md): Returns a list of instances linked to your Xano account
- [Creates a new install token on the snippet](https://docs.xano.com/xano-features/metadata-api/account_api/creates-a-new-install-token-on-the-snippet.md): Creates a new install token for a specific snippet
- [Deletes a snippet token](https://docs.xano.com/xano-features/metadata-api/account_api/deletes-a-snippet-token.md): Deletes a specific snippet token
- [Get a specific snippet by ID](https://docs.xano.com/xano-features/metadata-api/account_api/get-a-specific-snippet-by-id.md): Returns details for a specific snippet by its canonical ID
- [Get instance](https://docs.xano.com/xano-features/metadata-api/account_api/get-instance.md): Returns details for a specific instance by name
- [List snippets owned by the authenticated user](https://docs.xano.com/xano-features/metadata-api/account_api/list-snippets.md): Returns a paginated list of snippets owned by the authenticated user
- [Returns a list of tokens for a snippet](https://docs.xano.com/xano-features/metadata-api/account_api/returns-a-list-of-tokens-for-a-snippet.md): Returns a list of install tokens for a specific snippet
- [Update settings on the snippet](https://docs.xano.com/xano-features/metadata-api/account_api/update-settings-on-the-snippet.md): Updates the settings for a specific snippet
- [Updates a snippet token](https://docs.xano.com/xano-features/metadata-api/account_api/updates-a-snippet-token.md): Updates the settings for a specific snippet token
- [Xano Metadata API (Account & Snippets)](https://docs.xano.com/xano-features/metadata-api/accountapi.md): Endpoints for validating access tokens, listing/browsing instances, and managing snippet tokens and visibility.
- [Content](https://docs.xano.com/xano-features/metadata-api/content.md)
- [File](https://docs.xano.com/xano-features/metadata-api/file.md)
- [browse audit logs across all workspaces](https://docs.xano.com/xano-features/metadata-api/instance_api/browse_audit_logs_across_all_workspaces.md): browse audit logs across all workspaces
- [Configure table security rules by assigning an API group GUID or removing restrictions](https://docs.xano.com/xano-features/metadata-api/instance_api/configure_table_security_rules_by_assigning_an_api_group_guid_or_removing_restrictions.md): Configure table security rules by assigning an API group GUID or removing restrictions
- [Create a boolean column with true/false values and optional default settings](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_boolean_column_with_truefalse_values_and_optional_default_settings.md): Create a boolean column with true/false values and optional default settings
- [Create a btree index on table columns to optimize query performance](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_btree_index_on_table_columns_to_optimize_query_performance.md): Create a btree index on table columns to optimize query performance
- [Create a date column for storing calendar dates without time information](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_date_column_for_storing_calendar_dates_without_time_information.md): Create a date column for storing calendar dates without time information
- [Create a decimal column for precise numeric values with configurable min/max limits](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_decimal_column_for_precise_numeric_values_with_configurable_minmax_limits.md): Create a decimal column for precise numeric values with configurable min/max limits
- [Create a full-text search index for table columns with language-specific optimization](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_full-text_search_index_for_table_columns_with_language-specific_optimization.md): Create a full-text search index for table columns with language-specific optimization
- [Create a geographic linestring column for storing connected coordinate paths](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_geographic_linestring_column_for_storing_connected_coordinate_paths.md): Create a geographic linestring column for storing connected coordinate paths
- [Create a geographic multilinestring column for storing multiple coordinate paths](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_geographic_multilinestring_column_for_storing_multiple_coordinate_paths.md): Create a geographic multilinestring column for storing multiple coordinate paths
- [Create a geographic multipoint column for storing collections of coordinate points](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_geographic_multipoint_column_for_storing_collections_of_coordinate_points.md): Create a geographic multipoint column for storing collections of coordinate points
- [Create a geographic multipolygon column for storing complex area boundaries](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_geographic_multipolygon_column_for_storing_complex_area_boundaries.md): Create a geographic multipolygon column for storing complex area boundaries
- [Create a geographic point column for storing latitude/longitude coordinates](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_geographic_point_column_for_storing_latitudelongitude_coordinates.md): Create a geographic point column for storing latitude/longitude coordinates
- [Create a geographic polygon column for storing area boundaries and shapes](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_geographic_polygon_column_for_storing_area_boundaries_and_shapes.md): Create a geographic polygon column for storing area boundaries and shapes
- [Create a JSON column for storing structured data objects and arrays](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_json_column_for_storing_structured_data_objects_and_arrays.md): Create a JSON column for storing structured data objects and arrays
- [Create a new API endpoint using XanoScript](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_new_api_endpoint_using_xanoscript.md): Create a new API endpoint using XanoScript
- [Create a new API group in a workspace. Include name, description, and optional tags.](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_new_api_group_in_a_workspace_include_name_description_and_optional_tags.md): Create a new API group in a workspace. Include name, description, and optional tags.
- [Create a new database table with optional schema definition](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_new_database_table_with_optional_schema_definition.md): This endpoint can create a complete table in a single API request, as long as all values below are fully fleshed out. If you want to create the table in multiple steps, then just fill out the name ...
- [Create a new external data source with custom label and color](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_new_external_data_source_with_custom_label_and_color.md): Create a new external data source with custom label and color
- [Create a new function using XanoScript](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_new_function_using_xanoscript.md): Create a new function using XanoScript
- [Create a new record in the table](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_new_record_in_the_table.md): Each table has unique schema, which means that the request body should be updated with the schema relevant to the table being used.
- [Create a new scheduled task using XanoScript](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_new_scheduled_task_using_xanoscript.md): Create a new scheduled task using XanoScript
- [Create a password column with automatic hashing and complexity validation rules](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_password_column_with_automatic_hashing_and_complexity_validation_rules.md): Create a password column with automatic hashing and complexity validation rules
- [Create a spatial index on a table for optimized geometry operations](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_spatial_index_on_a_table_for_optimized_geometry_operations.md): Create a spatial index on a table for optimized geometry operations
- [Create a table reference column to establish relationships with other database tables](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_table_reference_column_to_establish_relationships_with_other_database_tables.md): Create a table reference column to establish relationships with other database tables
- [Create a text column with formatting options and customizable validation rules](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_text_column_with_formatting_options_and_customizable_validation_rules.md): Create a text column with formatting options and customizable validation rules
- [Create a timestamp column for storing precise date and time values](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_timestamp_column_for_storing_precise_date_and_time_values.md): Create a timestamp column for storing precise date and time values
- [Create a unique index on table fields to enforce data uniqueness and improve query performance](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_unique_index_on_table_fields_to_enforce_data_uniqueness_and_improve_query_performance.md): Create a unique index on table fields to enforce data uniqueness and improve query performance
- [Create a UUID-based table reference column for relationships with UUID primary keys](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_uuid-based_table_reference_column_for_relationships_with_uuid_primary_keys.md): Create a UUID-based table reference column for relationships with UUID primary keys
- [Create a UUID column for generating universally unique identifiers](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_uuid_column_for_generating_universally_unique_identifiers.md): Create a UUID column for generating universally unique identifiers
- [Create a vector column for storing multi-dimensional data used in AI and ML applications](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_vector_column_for_storing_multi-dimensional_data_used_in_ai_and_ml_applications.md): Create a vector column for storing multi-dimensional data used in AI and ML applications
- [Create a vector index on a table column with support for Inner Product, Cosine, L1, and L2 distance operations](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_vector_index_on_a_table_column_with_support_for_inner_product_cosine_l1_and_l2_distance_operations.md): Options include `vector_ip_ops` (Inner Product), `vector_cosine_ops` (Cosine), `vector_l1_ops` (L1 Distance), `vector_l2_ops` (L2 Distance)
- [Create a video file column for storing video uploads and media content](https://docs.xano.com/xano-features/metadata-api/instance_api/create_a_video_file_column_for_storing_video_uploads_and_media_content.md): Create a video file column for storing video uploads and media content
- [Create an attachment column for file uploads in a database table](https://docs.xano.com/xano-features/metadata-api/instance_api/create_an_attachment_column_for_file_uploads_in_a_database_table.md): Create an attachment column for file uploads in a database table
- [Create an audio file column for storing audio uploads and media](https://docs.xano.com/xano-features/metadata-api/instance_api/create_an_audio_file_column_for_storing_audio_uploads_and_media.md): Create an audio file column for storing audio uploads and media
- [Create an email column with built-in email format validation](https://docs.xano.com/xano-features/metadata-api/instance_api/create_an_email_column_with_built-in_email_format_validation.md): Create an email column with built-in email format validation
- [Create an enum column with predefined value options for dropdown selections](https://docs.xano.com/xano-features/metadata-api/instance_api/create_an_enum_column_with_predefined_value_options_for_dropdown_selections.md): Create an enum column with predefined value options for dropdown selections
- [Create an image column for storing photo uploads and visual media](https://docs.xano.com/xano-features/metadata-api/instance_api/create_an_image_column_for_storing_photo_uploads_and_visual_media.md): Create an image column for storing photo uploads and visual media
- [Create an integer column for whole numbers with configurable min/max limits](https://docs.xano.com/xano-features/metadata-api/instance_api/create_an_integer_column_for_whole_numbers_with_configurable_minmax_limits.md): Create an integer column for whole numbers with configurable min/max limits
- [Create an object column with nested child fields for complex data structures](https://docs.xano.com/xano-features/metadata-api/instance_api/create_an_object_column_with_nested_child_fields_for_complex_data_structures.md): Create an object column with nested child fields for complex data structures
- [Create multiple records in a single batch operation](https://docs.xano.com/xano-features/metadata-api/instance_api/create_multiple_records_in_a_single_batch_operation.md): Each table has unique schema, which means that the request body should be an array of objects with the schema relevant to the table being used.
- [Delete a column from a table's schema. This action cannot be undone.](https://docs.xano.com/xano-features/metadata-api/instance_api/delete_a_column_from_a_tables_schema_this_action_cannot_be_undone.md): Delete a column from a table's schema. This action cannot be undone.
- [Delete a data source permanently. This action cannot be undone.](https://docs.xano.com/xano-features/metadata-api/instance_api/delete_a_data_source_permanently_this_action_cannot_be_undone.md): Delete a data source permanently. This action cannot be undone.
- [Delete a database table and all its data permanently](https://docs.xano.com/xano-features/metadata-api/instance_api/delete_a_database_table_and_all_its_data_permanently.md): Delete a database table and all its data permanently
- [Delete a file permanently. This action cannot be undone.](https://docs.xano.com/xano-features/metadata-api/instance_api/delete_a_file_permanently_this_action_cannot_be_undone.md): Delete a file permanently. This action cannot be undone.
- [Delete a function permanently. This action cannot be undone](https://docs.xano.com/xano-features/metadata-api/instance_api/delete_a_function_permanently_this_action_cannot_be_undone.md): Delete a function permanently. This action cannot be undone
- [Delete a scheduled task permanently. This action cannot be undone](https://docs.xano.com/xano-features/metadata-api/instance_api/delete_a_scheduled_task_permanently_this_action_cannot_be_undone.md): Delete a scheduled task permanently. This action cannot be undone
- [Delete a specific record by ID](https://docs.xano.com/xano-features/metadata-api/instance_api/delete_a_specific_record_by_id.md): Delete a specific record by ID
- [Delete a specific table index. This action cannot be undone.](https://docs.xano.com/xano-features/metadata-api/instance_api/delete_a_specific_table_index_this_action_cannot_be_undone.md): Delete a specific table index. This action cannot be undone.
- [Delete a workspace branch. Cannot delete the default branch or currently live branch.](https://docs.xano.com/xano-features/metadata-api/instance_api/delete_a_workspace_branch_cannot_delete_the_default_branch_or_currently_live_branch.md): Delete a workspace branch. Cannot delete the default branch or currently live branch.
- [Delete all records from the table and optionally reset the primary key](https://docs.xano.com/xano-features/metadata-api/instance_api/delete_all_records_from_the_table_and_optionally_reset_the_primary_key.md): Delete all records from the table and optionally reset the primary key
- [Delete all records matching specified search criteria](https://docs.xano.com/xano-features/metadata-api/instance_api/delete_all_records_matching_specified_search_criteria.md): Provide search criteria to delete all matching rows.
- [Delete an API endpoint permanently. This action cannot be undone](https://docs.xano.com/xano-features/metadata-api/instance_api/delete_an_api_endpoint_permanently_this_action_cannot_be_undone.md): Delete an API endpoint permanently. This action cannot be undone
- [Delete an API group and all its endpoints. This action cannot be undone.](https://docs.xano.com/xano-features/metadata-api/instance_api/delete_an_api_group_and_all_its_endpoints_this_action_cannot_be_undone.md): Delete an API group and all its endpoints. This action cannot be undone.
- [Delete multiple files permanently. This action cannot be undone.](https://docs.xano.com/xano-features/metadata-api/instance_api/delete_multiple_files_permanently_this_action_cannot_be_undone.md): Delete multiple files permanently. This action cannot be undone.
- [Delete multiple records by their IDs in a single operation](https://docs.xano.com/xano-features/metadata-api/instance_api/delete_multiple_records_by_their_ids_in_a_single_operation.md): The request body should contain an array of **row_ids**, where each id identifies a row to be deleted.
- [Export complete workspace data and configuration as an archive](https://docs.xano.com/xano-features/metadata-api/instance_api/export_complete_workspace_data_and_configuration_as_an_archive.md): Leave the `branch` parameter empty to indicate the current live branch. `password` is optional. If provided, will encrypt the export and will be required when importing the file.
- [Export database table schemas and branch configuration as a file](https://docs.xano.com/xano-features/metadata-api/instance_api/export_database_table_schemas_and_branch_configuration_as_a_file.md): Leave the `branch` parameter empty to indicate the current live branch. `password` is optional. If provided, will encrypt the export and will be required when importing the file.
- [Generate OpenAPI specification for a specific API endpoint](https://docs.xano.com/xano-features/metadata-api/instance_api/generate_openapi_specification_for_a_specific_api_endpoint.md): Generate OpenAPI specification for a specific API endpoint
- [Get detailed information for a specific API group. Returns complete metadata and configuration.](https://docs.xano.com/xano-features/metadata-api/instance_api/get_detailed_information_for_a_specific_api_group_returns_complete_metadata_and_configuration.md): Get detailed information for a specific API group. Returns complete metadata and configuration.
- [Get the OpenAPI specification for an API group. Returns the complete Swagger JSON for all endpoints.](https://docs.xano.com/xano-features/metadata-api/instance_api/get_the_openapi_specification_for_an_api_group_returns_the_complete_swagger_json_for_all_endpoints.md): Get the OpenAPI specification for an API group. Returns the complete Swagger JSON for all endpoints.
- [Import database schema into a new branch with optional deployment](https://docs.xano.com/xano-features/metadata-api/instance_api/import_database_schema_into_a_new_branch_with_optional_deployment.md): Import database schema into a new branch with optional deployment
- [Rename a column in a table's schema](https://docs.xano.com/xano-features/metadata-api/instance_api/rename_a_column_in_a_tables_schema.md): Rename a column in a table's schema
- [Replace all indexes for a database table with new index configuration](https://docs.xano.com/xano-features/metadata-api/instance_api/replace_all_indexes_for_a_database_table_with_new_index_configuration.md): Replace all indexes for a database table with new index configuration
- [Replace the entire schema definition for a database table](https://docs.xano.com/xano-features/metadata-api/instance_api/replace_the_entire_schema_definition_for_a_database_table.md): Replace the entire schema definition for a database table
- [Replace workspace content and configuration with imported archive](https://docs.xano.com/xano-features/metadata-api/instance_api/replace_workspace_content_and_configuration_with_imported_archive.md): If the file is encrypted, the correct `password` is required to decrypt.
- [Retrieve a list of API groups inside of a workspace. Use the optional filtering and sorting parameters for more granular returns.](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_a_list_of_api_groups_inside_of_a_workspace_use_the_optional_filtering_and_sorting_parameters_for_more_granular_returns.md): Retrieve a list of API groups inside of a workspace. Use the optional filtering and sorting parameters for more granular returns.
- [Retrieve a specific API endpoint by ID](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_a_specific_api_endpoint_by_id.md): Retrieve a specific API endpoint by ID
- [Retrieve a specific function by ID](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_a_specific_function_by_id.md): Retrieve a specific function by ID
- [Retrieve a specific record by ID](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_a_specific_record_by_id.md): Retrieve a specific record by ID
- [Retrieve a specific scheduled task by ID](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_a_specific_scheduled_task_by_id.md): Retrieve a specific scheduled task by ID
- [Retrieve all accessible workspaces for the authenticated user](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_all_accessible_workspaces_for_the_authenticated_user.md): Retrieve all accessible workspaces for the authenticated user
- [Retrieve all API endpoints in a group with optional filtering and pagination](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_all_api_endpoints_in_a_group_with_optional_filtering_and_pagination.md): Retrieve all API endpoints in a group with optional filtering and pagination
- [Retrieve all branches in a workspace.](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_all_branches_in_a_workspace.md): Retrieve all branches in a workspace.
- [Retrieve all external data sources for a workspace](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_all_external_data_sources_for_a_workspace.md): Retrieve all external data sources for a workspace
- [Retrieve all functions in a workspace with optional filtering and pagination](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_all_functions_in_a_workspace_with_optional_filtering_and_pagination.md): Retrieve all functions in a workspace with optional filtering and pagination
- [Retrieve all indexes for a database table](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_all_indexes_for_a_database_table.md): Retrieve all indexes for a database table
- [Retrieve all scheduled tasks in a workspace with optional filtering and pagination](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_all_scheduled_tasks_in_a_workspace_with_optional_filtering_and_pagination.md): Retrieve all scheduled tasks in a workspace with optional filtering and pagination
- [Retrieve all tables in a workspace with optional filtering and pagination](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_all_tables_in_a_workspace_with_optional_filtering_and_pagination.md): Retrieve all tables in a workspace with optional filtering and pagination
- [Retrieve API function request history with optional filtering and pagination](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_api_function_request_history_with_optional_filtering_and_pagination.md): Retrieve API function request history with optional filtering and pagination
- [Retrieve API request history with optional filtering and pagination](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_api_request_history_with_optional_filtering_and_pagination.md): Retrieve API request history with optional filtering and pagination
- [Retrieve detailed information about a specific workspace](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_detailed_information_about_a_specific_workspace.md): Retrieve detailed information about a specific workspace
- [Retrieve detailed information for a specific table](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_detailed_information_for_a_specific_table.md): Retrieve detailed information for a specific table
- [Retrieve details for a specific column in a table's schema](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_details_for_a_specific_column_in_a_tables_schema.md): Retrieve details for a specific column in a table's schema
- [Retrieve information about the authenticated user including ID, name, and email address.](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_information_about_the_authenticated_user_including_id_name_and_email_address.md): Retrieve information about the authenticated user including ID, name, and email address.
- [Retrieve middleware request history with optional filtering and pagination](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_middleware_request_history_with_optional_filtering_and_pagination.md): Retrieve middleware request history with optional filtering and pagination
- [Retrieve paginated records from a table](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_paginated_records_from_a_table.md): Retrieve paginated records from a table
- [Retrieve real-time operational metrics and connection details](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_real-time_operational_metrics_and_connection_details.md): Retrieve real-time operational metrics and connection details
- [Retrieve task request history with optional filtering and pagination](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_task_request_history_with_optional_filtering_and_pagination.md): Retrieve task request history with optional filtering and pagination
- [Retrieve the complete schema definition for a database table](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_the_complete_schema_definition_for_a_database_table.md): Retrieve the complete schema definition for a database table
- [Retrieve tool request history with optional filtering and pagination](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_tool_request_history_with_optional_filtering_and_pagination.md): Retrieve tool request history with optional filtering and pagination
- [Retrieve trigger request history with optional filtering and pagination](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_trigger_request_history_with_optional_filtering_and_pagination.md): Retrieve trigger request history with optional filtering and pagination
- [Retrieve workspace audit logs with pagination support](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_workspace_audit_logs_with_pagination_support.md): Retrieve workspace audit logs with pagination support
- [Retrieve workspace files with optional search, filtering, and pagination](https://docs.xano.com/xano-features/metadata-api/instance_api/retrieve_workspace_files_with_optional_search_filtering_and_pagination.md): Retrieve workspace files with optional search, filtering, and pagination
- [Search API request history using advanced filters and custom sorting options](https://docs.xano.com/xano-features/metadata-api/instance_api/search_api_request_history_using_advanced_filters_and_custom_sorting_options.md): Search API request history using advanced filters and custom sorting options
- [search audit logs across all workspaces with support for complex filtering and sorting](https://docs.xano.com/xano-features/metadata-api/instance_api/search_audit_logs_across_all_workspaces_with_support_for_complex_filtering_and_sorting.md): search audit logs across all workspaces with support for complex filtering and sorting
- [Search audit logs using advanced filters and custom sorting options](https://docs.xano.com/xano-features/metadata-api/instance_api/search_audit_logs_using_advanced_filters_and_custom_sorting_options.md): Search audit logs using advanced filters and custom sorting options
- [Search function request history using advanced filters and custom sorting options](https://docs.xano.com/xano-features/metadata-api/instance_api/search_function_request_history_using_advanced_filters_and_custom_sorting_options.md): Search function request history using advanced filters and custom sorting options
- [Search middleware request history using advanced filters and custom sorting options](https://docs.xano.com/xano-features/metadata-api/instance_api/search_middleware_request_history_using_advanced_filters_and_custom_sorting_options.md): Search middleware request history using advanced filters and custom sorting options
- [Search table records with advanced filtering and sorting options](https://docs.xano.com/xano-features/metadata-api/instance_api/search_table_records_with_advanced_filtering_and_sorting_options.md): Search table records with advanced filtering and sorting options
- [Search task request history using advanced filters and custom sorting options](https://docs.xano.com/xano-features/metadata-api/instance_api/search_task_request_history_using_advanced_filters_and_custom_sorting_options.md): Search task request history using advanced filters and custom sorting options
- [Search tool request history using advanced filters and custom sorting options](https://docs.xano.com/xano-features/metadata-api/instance_api/search_tool_request_history_using_advanced_filters_and_custom_sorting_options.md): Search tool request history using advanced filters and custom sorting options
- [Search trigger request history using advanced filters and custom sorting options](https://docs.xano.com/xano-features/metadata-api/instance_api/search_trigger_request_history_using_advanced_filters_and_custom_sorting_options.md): Search trigger request history using advanced filters and custom sorting options
- [Update a specific record by ID](https://docs.xano.com/xano-features/metadata-api/instance_api/update_a_specific_record_by_id.md): Each table has unique schema, which means that the request body should be updated with the schema relevant to the table being used.
- [Update all records matching specified search criteria](https://docs.xano.com/xano-features/metadata-api/instance_api/update_all_records_matching_specified_search_criteria.md): Provide search and update objects with path and new value to patch rows matching search criteria.
- [Update an existing API group. Modify name, description, documentation settings, or tags.](https://docs.xano.com/xano-features/metadata-api/instance_api/update_an_existing_api_group_modify_name_description_documentation_settings_or_tags.md): Update an existing API group. Modify name, description, documentation settings, or tags.
- [Update an existing data source's label and color properties](https://docs.xano.com/xano-features/metadata-api/instance_api/update_an_existing_data_sources_label_and_color_properties.md): Update an existing data source's label and color properties
- [Update API endpoint code, settings, and authentication rules](https://docs.xano.com/xano-features/metadata-api/instance_api/update_api_endpoint_code_settings_and_authentication_rules.md): Update API endpoint code, settings, and authentication rules
- [Update API endpoint security configuration and access controls](https://docs.xano.com/xano-features/metadata-api/instance_api/update_api_endpoint_security_configuration_and_access_controls.md): Update API endpoint security configuration and access controls
- [Update function code, metadata, and caching settings](https://docs.xano.com/xano-features/metadata-api/instance_api/update_function_code_metadata_and_caching_settings.md): Update function code, metadata, and caching settings
- [Update function security configuration and access controls](https://docs.xano.com/xano-features/metadata-api/instance_api/update_function_security_configuration_and_access_controls.md): Update function security configuration and access controls
- [Update multiple records in a single batch operation](https://docs.xano.com/xano-features/metadata-api/instance_api/update_multiple_records_in_a_single_batch_operation.md): The request body should contain an array of **items**, where each item represents a row to be updated. For each row, provide the **row_id** and **updates** array that specifies the columns (**path*...
- [Update real-time settings and connection configuration](https://docs.xano.com/xano-features/metadata-api/instance_api/update_real-time_settings_and_connection_configuration.md): Update real-time settings and connection configuration
- [Update scheduled task security configuration and access controls](https://docs.xano.com/xano-features/metadata-api/instance_api/update_scheduled_task_security_configuration_and_access_controls.md): Update scheduled task security configuration and access controls
- [Update security settings for an API group. Configure access permissions and authentication requirements.](https://docs.xano.com/xano-features/metadata-api/instance_api/update_security_settings_for_an_api_group_configure_access_permissions_and_authentication_requirements.md): Update security settings for an API group. Configure access permissions and authentication requirements.
- [Update table properties including name, description, tags, and authentication settings](https://docs.xano.com/xano-features/metadata-api/instance_api/update_table_properties_including_name_description_tags_and_authentication_settings.md): Update table properties including name, description, tags, and authentication settings
- [Update task code, schedule settings, and activation status](https://docs.xano.com/xano-features/metadata-api/instance_api/update_task_code_schedule_settings_and_activation_status.md): Update task code, schedule settings, and activation status
- [update workspace table](https://docs.xano.com/xano-features/metadata-api/instance_api/update_workspace_table.md): update workspace table
- [update workspace table's autocomplete](https://docs.xano.com/xano-features/metadata-api/instance_api/update_workspace_tables_autocomplete.md): update workspace table's autocomplete
- [Upload files to workspace](https://docs.xano.com/xano-features/metadata-api/instance_api/upload_files_to_workspace.md): Upload files to workspace
- [Xano Metadata API (Instances)](https://docs.xano.com/xano-features/metadata-api/instanceapi.md): Endpoints for browsing and managing instances via the Metadata API.
- [Master Metadata API](https://docs.xano.com/xano-features/metadata-api/master-metadata-api.md)
- [browse instances](https://docs.xano.com/xano-features/metadata-api/master-metadata-api/instance/browse-instances.md): browse instances
Authentication: required
- [get instance](https://docs.xano.com/xano-features/metadata-api/master-metadata-api/instance/get-instance.md): get instance
Authentication: required
- [creates a new install token on the snippet](https://docs.xano.com/xano-features/metadata-api/master-metadata-api/snippet-token/creates-a-new-install-token-on-the-snippet.md): creates a new install token on the snippet
Authentication: required
- [deletes a snippet token](https://docs.xano.com/xano-features/metadata-api/master-metadata-api/snippet-token/deletes-a-snippet-token.md): deletes a snippet token
Authentication: required
- [returns a list of tokens for a snippet](https://docs.xano.com/xano-features/metadata-api/master-metadata-api/snippet-token/returns-a-list-of-tokens-for-a-snippet.md): returns a list of tokens for a snippet
Authentication: required
- [updates a snippet token](https://docs.xano.com/xano-features/metadata-api/master-metadata-api/snippet-token/updates-a-snippet-token.md): updates a snippet token
Authentication: required
- [get a specific snippet by ID](https://docs.xano.com/xano-features/metadata-api/master-metadata-api/snippet/get-a-specific-snippet-by-id.md): get a specific snippet by ID
Authentication: required
- [list snippets owned by the authenticated user](https://docs.xano.com/xano-features/metadata-api/master-metadata-api/snippet/list-snippets-owned-by-the-authenticated-user.md): list snippets owned by the authenticated user
Authentication: required
- [update settings on the snippet](https://docs.xano.com/xano-features/metadata-api/master-metadata-api/snippet/update-settings-on-the-snippet.md): update settings on the snippet
Authentication: required
- [Request History](https://docs.xano.com/xano-features/metadata-api/request-history.md)
- [Search](https://docs.xano.com/xano-features/metadata-api/search.md)
- [Tables And Schema](https://docs.xano.com/xano-features/metadata-api/tables-and-schema.md)
- [Token Scopes Reference](https://docs.xano.com/xano-features/metadata-api/token-scopes-reference.md)
- [Workspace Import And Export](https://docs.xano.com/xano-features/metadata-api/workspace-import-and-export.md)
- [Snippets](https://docs.xano.com/xano-features/snippets.md)
- [Static Hosting](https://docs.xano.com/xano-features/static-hosting.md): Use static hosting in Xano to host your frontend right alongside your backend
- [Workspace Settings](https://docs.xano.com/xano-features/workspace-settings.md): An explanation of all available workspace settings
- [Audit Logs](https://docs.xano.com/xano-features/workspace-settings/audit-logs.md): Audit Logs provide clear and searchable logging of all workspace changes
- [Git Sync](https://docs.xano.com/xano-features/workspace-settings/git-sync.md): Learn how to use Git Sync to sync your Xano workspace to GitHub or GitLab
- [Xano n8n Node](https://docs.xano.com/xano-n8n-node.md): Use the n8n community node to run Xano Metadata API operations from any workflow.
- [Using Xano Transform](https://docs.xano.com/xano-transform/using-xano-transform.md)
- [XanoScript for Addons](https://docs.xano.com/xanoscript/addons.md): Define addons in XanoScript to create reusable database query components
- [XanoScript for AI Agents](https://docs.xano.com/xanoscript/agents.md): Learn how to define and configure AI Agents using XanoScript.
- [XanoScript for AI Tools](https://docs.xano.com/xanoscript/ai-tools.md): Define AI tools in XanoScript to create intelligent agents and assistants
- [XanoScript for APIs](https://docs.xano.com/xanoscript/api.md): Define APIs in XanoScript to build RESTful API endpoints
- [null](https://docs.xano.com/xanoscript/api-groups.md)
- [XanoScript for Custom Functions](https://docs.xano.com/xanoscript/custom-functions.md): Define Custom Functions in XanoScript to build reusable logic
- [XanoScript for the Database](https://docs.xano.com/xanoscript/db.md): Define database tables, schemas, indexes, and views using XanoScript
- [Field Types Reference](https://docs.xano.com/xanoscript/field-type-reference.md): Reference of all the field types available in XanoScript
- [XanoScript Filter Reference](https://docs.xano.com/xanoscript/filter-reference.md): Reference of all the filters available in XanoScript
- [Array](https://docs.xano.com/xanoscript/filter-reference/array.md)
- [Comparison](https://docs.xano.com/xanoscript/filter-reference/comparison.md)
- [Manipulation](https://docs.xano.com/xanoscript/filter-reference/manipulation.md)
- [Math](https://docs.xano.com/xanoscript/filter-reference/math.md)
- [Security](https://docs.xano.com/xanoscript/filter-reference/security.md)
- [Text](https://docs.xano.com/xanoscript/filter-reference/text.md)
- [Timestamp](https://docs.xano.com/xanoscript/filter-reference/timestamp.md)
- [Transform](https://docs.xano.com/xanoscript/filter-reference/transform.md)
- [Function Reference](https://docs.xano.com/xanoscript/function-reference.md): Reference of all the functions available in XanoScript
- [Actions](https://docs.xano.com/xanoscript/function-reference/actions.md)
- [AI Tools](https://docs.xano.com/xanoscript/function-reference/ai-tools.md)
- [APIs & Lambdas](https://docs.xano.com/xanoscript/function-reference/apis-and-lambdas.md)
- [Cloud Services](https://docs.xano.com/xanoscript/function-reference/cloud-services.md)
- [Algolia](https://docs.xano.com/xanoscript/function-reference/cloud-services/algolia.md)
- [AWS OpenSearch](https://docs.xano.com/xanoscript/function-reference/cloud-services/aws-opensearch.md)
- [AWS S3](https://docs.xano.com/xanoscript/function-reference/cloud-services/aws-s3.md)
- [Azure Blob Storage](https://docs.xano.com/xanoscript/function-reference/cloud-services/azure-blob-storage.md)
- [Elasticsearch](https://docs.xano.com/xanoscript/function-reference/cloud-services/elasticsearch.md)
- [Google Cloud Storage](https://docs.xano.com/xanoscript/function-reference/cloud-services/google-cloud-storage.md)
- [Custom Functions](https://docs.xano.com/xanoscript/function-reference/custom-functions.md)
- [Data Caching (Redis)](https://docs.xano.com/xanoscript/function-reference/data-caching-redis.md)
- [Data Manipulation](https://docs.xano.com/xanoscript/function-reference/data-manipulation.md)
- [Arrays](https://docs.xano.com/xanoscript/function-reference/data-manipulation/arrays.md)
- [Conditionals](https://docs.xano.com/xanoscript/function-reference/data-manipulation/conditionals.md)
- [Loops](https://docs.xano.com/xanoscript/function-reference/data-manipulation/loops.md)
- [Math](https://docs.xano.com/xanoscript/function-reference/data-manipulation/math.md)
- [Objects](https://docs.xano.com/xanoscript/function-reference/data-manipulation/objects.md)
- [Text](https://docs.xano.com/xanoscript/function-reference/data-manipulation/text.md)
- [Variables](https://docs.xano.com/xanoscript/function-reference/data-manipulation/variables.md)
- [Database Operations](https://docs.xano.com/xanoscript/function-reference/database-operations.md)
- [File Storage](https://docs.xano.com/xanoscript/function-reference/file-storage.md)
- [Security](https://docs.xano.com/xanoscript/function-reference/security.md)
- [Utility Functions](https://docs.xano.com/xanoscript/function-reference/utility-functions.md)
- [Input types](https://docs.xano.com/xanoscript/input-types-reference.md)
- [Intro to XanoScript](https://docs.xano.com/xanoscript/introduction.md): Introduction to XanoScript
- [XanoScript Key Concepts](https://docs.xano.com/xanoscript/key-concepts.md): Get a quick primer of how XanoScript is written.
- [XanoScript for MCP Servers](https://docs.xano.com/xanoscript/mcp-servers.md): Define MCP servers in XanoScript to create intelligent agents and assistants
- [XanoScript for Middleware](https://docs.xano.com/xanoscript/middleware.md): Define middleware functions that can be applied to APIs, functions, tasks, and AI tools using XanoScript
- [XanoScript for Background Tasks](https://docs.xano.com/xanoscript/tasks.md): Define Background Tasks in XanoScript to run logic on a schedule
- [XanoScript for Tests](https://docs.xano.com/xanoscript/tests.md): Define unit tests and workflow tests using XanoScript
- [XanoScript for Triggers](https://docs.xano.com/xanoscript/triggers.md): Define database, workspace, realtime, and MCP server triggers using XanoScript
- [XanoScript VS Code Extension](https://docs.xano.com/xanoscript/vs-code.md): Use the XanoScript VS Code extension to write XanoScript in your favorite IDE, such as VS Code, Cursor, or Windsurf
- [XanoScript Workspace Settings](https://docs.xano.com/xanoscript/workspace-settings.md)
- [Account Settings](https://docs.xano.com/your-xano-account/account-page.md)
- [Billing](https://docs.xano.com/your-xano-account/billing.md)
- [Referrals & Commissions](https://docs.xano.com/your-xano-account/referrals-and-commissions.md)
## OpenAPI Specs
- [apispec_meta_instance](https://docs.xano.com/apispec_meta_instance.json)
- [metadata_api_instance](https://docs.xano.com/xano-features/metadata-api/metadata_api_instance.json)
- [metadata_api_account](https://docs.xano.com/xano-features/metadata-api/metadata_api_account.json)
- [openapi](https://docs.xano.com/openapi.json)
- [apispec_meta](https://docs.xano.com/assets/apispec_meta.json)
- [apispec_Bbi3Wu6V](https://docs.xano.com/assets/apispec_Bbi3Wu6V.json)
- [apispec_Bbi3Wu6V (1)](https://docs.xano.com/assets/apispec_Bbi3Wu6V (1).json)
- [Account API](https://docs.xano.com/assets/Account API.json)