Xano Documentation
  • 👋Welcome to Xano!
  • 🌟Frequently Asked Questions
  • 🔐Security & Compliance (Trust Center)
  • 🙏Feature Requests
  • 💔Known Issues
  • Before You Begin
    • Using These Docs
    • Where should I start?
    • Set Up a Free Xano Account
    • Key Concepts
    • The Development Life Cycle
    • Navigating Xano
    • Plans & Pricing
  • The Database
    • Designing your Database
    • Database Basics
      • Using the Xano Database
      • Field Types
      • Relationships
      • Database Views
      • Export and Sharing
      • Data Sources
    • Migrating your Data
      • Airtable to Xano
      • Supabase to Xano
      • CSV Import & Export
    • Database Performance and Maintenance
      • Storage
      • Indexing
      • Maintenance
      • Schema Versioning
  • 🛠️The Function Stack
    • Building with Visual Development
      • APIs
        • Swagger (OpenAPI Documentation)
      • Custom Functions
        • Async Functions
      • Background Tasks
      • Triggers
      • Middleware
      • Configuring Expressions
      • Working with Data
    • Functions
      • AI Tools
      • Database Requests
        • Query All Records
          • External Filtering Examples
        • Get Record
        • Add Record
        • Edit Record
        • Add or Edit Record
        • Patch Record
        • Delete Record
        • Bulk Operations
        • Database Transaction
        • External Database Query
        • Direct Database Query
        • Get Database Schema
      • Data Manipulation
        • Create Variable
        • Update Variable
        • Conditional
        • Switch
        • Loops
        • Math
        • Arrays
        • Objects
        • Text
      • Security
      • APIs & Lambdas
        • Realtime Functions
        • External API Request
        • Lambda Functions
      • Data Caching (Redis)
      • Custom Functions
      • Utility Functions
      • File Storage
      • Cloud Services
    • Filters
      • Manipulation
      • Math
      • Timestamp
      • Text
      • Array
      • Transform
      • Conversion
      • Comparison
      • Security
    • Data Types
      • Text
      • Expression
      • Array
      • Object
      • Integer
      • Decimal
      • Boolean
      • Timestamp
      • Null
    • Environment Variables
    • Additional Features
      • Response Caching
  • Testing and Debugging
    • Testing and Debugging Function Stacks
    • Unit Tests
    • Test Suites
  • CI/CD
  • File Storage
    • File Storage in Xano
    • Private File Storage
  • Realtime
    • Realtime in Xano
    • Channel Permissions
    • Realtime in Webflow
  • Maintenance, Monitoring, and Logging
    • Statement Explorer
    • Request History
    • Instance Dashboard
      • Memory Usage
  • Building Backend Features
    • User Authentication & User Data
      • Separating User Data
      • Restricting Access (RBAC)
      • OAuth (SSO)
    • Webhooks
    • Messaging
    • Emails
    • Custom Report Generation
    • Fuzzy Search
    • Chatbots
  • Xano Features
    • Snippets
    • Instance Settings
      • Release Track Preferences
      • Static IP (Outgoing)
      • Change Server Region
      • Direct Database Connector
      • Backup and Restore
      • Security Policy
    • Workspace Settings
    • Advanced Back-end Features
      • Xano Link
      • Developer API (Deprecated)
    • Metadata API
      • Master Metadata API
      • Tables and Schema
      • Content
      • Search
      • File
      • Request History
      • Workspace Import and Export
      • Token Scopes Reference
  • Build With AI
    • Building a Backend Using AI
    • Get Started Assistant
    • AI Database Assistant
    • AI Lambda Assistant
    • AI SQL Assistant
    • API Request Assistant
    • Template Engine
    • Streaming APIs
  • Using AI Builders with Xano
  • Build For AI
    • MCP Builder
      • Connecting Clients
      • MCP Functions
    • Xano MCP Server
  • Xano Transform
    • Using Xano Transform
  • Xano Actions
    • What are Actions?
    • Browse Actions
  • Team Collaboration
    • Realtime Collaboration
    • Managing Team Members
    • Branching & Merging
    • Role-based Access Control (RBAC)
  • Agencies
    • Xano for Agencies
    • Agency Features
      • Agency Dashboard
      • Client Invite
      • Transfer Ownership
      • Agency Profile
      • Commission
      • Private Marketplace
  • Enterprise
    • Xano for Enterprise
    • Enterprise Features
      • Microservices
        • Ollama
          • Choosing a Model
      • Tenant Center
      • Compliance Center
      • Security Policy
      • Instance Activity
      • Deployment
      • RBAC (Role-based Access Control)
      • Xano Link
  • Your Xano Account
    • Account Page
    • Billing
    • Referrals & Commissions
  • Troubleshooting & Support
    • Error Reference
    • Troubleshooting Performance
      • When a single workflow feels slow
      • When everything feels slow
      • RAM Usage
      • Function Stack Performance
    • Getting Help
      • Granting Access
      • Community Code of Conduct
      • Community Content Modification Policy
  • Special Pricing
    • Students & Education
    • Non-Profits
  • Security
    • Best Practices
Powered by GitBook
On this page
  • General Settings
  • Data Sources
  • Middleware
  • Clone Workspace
  • Export Workspace
  • Xano Link
  • Triggers
  • Statement Explorer
  • Realtime Settings
  • Reset Drafts
  • Compliance Center

Was this helpful?

  1. Xano Features

Workspace Settings

An explanation of all available workspace settings

Last updated 7 days ago

Was this helpful?

Before you begin

Please note that this page provides only a general overview of some settings. When relevant, each section will contain a link to that feature specific documentation, which is recommended reading before adjusting anything

General Settings

This panel is accessible by heading to your workspace dashboard and clicking the ⋮ icon > Settings

Setting
Purpose

Name*

text

Give your workspace a unique name

Description

text

A description of your workspace

Use Internal Documentation Tool checkbox

Enables the Internal Documentation Tool for your function stacks--a plain text input typically used to house information such as example inputs

Show Start

Enables the Start Page, which offers beginner guidance on working in Xano

Show Marketplace

Enables the Marketplace, which contains snippets and extensions available for import into your Xano workspace

AI Preferences

Data Sources

Data Sources allow you to maintain separate databases with the same schema. Useful for maintaining things like separate production and testing data sets.

Setting
Purpose

Manage

Quick access to managing your data sources, such as browsing or adding new ones

Migrate

Allows you to migrate data from one data source to another

Middleware

Provides quick access to Middleware settings

Clone Workspace

Creates a clone of your workspace

Cloning a workspace will copy all database table schema, API groups, APIs, functions, addons, and tasks into another workspace. It will not copy the database table records.

Export Workspace

Exports a copy of your workspace

Exporting your data is done in the background and may take a significant amount of time to process depending on the amount of data in your workspace.

You may also include media attachments, but this may increase the export size and time significantly depending on the number of files.

Once the export is complete, you will receive an email notification as well as a notification in Xano that your data is ready to be downloaded. This export will be available for 12 hours.

Xano Link

Xano Link is a premium addon for syncing branches and database schema from one workspace to others.

Triggers

Triggers allow you to build workflows that run based on when certain events happen, such as when a database record is added or when certain branch actions take place.

Statement Explorer

The Statement Explorer allows you to search for instances of specific statements across your workspace, such as finding all Query All Records functions. This is useful for things like security audits and making sweeping changes or improvements across multiple workflows.

Realtime Settings

Access your Realtime in Xano settings from here

Reset Drafts

Resets all drafts in the current workspace

Sometimes, you may want to clear out all drafts and revert fully back to published versions of your function stacks. This option allows you to quickly do so. It can also be useful in the rare circumstance that you have functions that are in draft state or have been recently published and are not behaving correctly.

This action is not reversible, so if you have questions, reach out to our support chat before proceeding.

Compliance Center

Offers quick access to the Compliance Center, which is a premium feature that enables advanced auditing of the state of your workspace and actions of your team members

Accept AI specific license terms to use certain AI-powered features, such as our

AI Database Assistant

Branch Defaults

These are default settings related to what is logged in your Request History

In your workspace settings, you can manage the request history for your entire workspace in the Branch Defaults panel.

From this panel, we can define the request history defaults for each object type (query, function, task, middleware, trigger) that maintains history.

  • Enable / Disable - Performs the selected action on the object type

  • Function Statement Limit - The number of statements to record for each object type. You can choose between:

    • No statements

    • 100 statements

    • 1,000 statements

    • 10,000 statements

    • Store all statements

Please note that request history utilizes your Database (SSD) storage. It is important to consider this when determining how many statements can be stored, or if they need to be stored at all.

Inheriting Settings

In each individual API, function, task, middleware, or trigger's settings, you can also control the request history for that object specifically.

By default, these will be set to inherit, which means it will obey the branch defaults. Otherwise, you can adjust this for specific objects as necessary.

Custom SQL Table Names

From your Workspace settings, you can enable Custom SQL Table Names.

By default, Xano assigns each table a SQL name in the format mvpw_ (e.g., mvpw1_3). This identifier works for direct access, but can be difficult to read or use with direct queries and database tools.

You can replace this with a custom SQL name to make queries more intuitive and improve compatibility with external connectors.

If you change a table's SQL name, be sure to update any queries that reference the old name to avoid breaking functionality.

Once you've enabled Custom SQL Table Names, head to any database table's settings, and click Manage next to SQL Table Name.

Table Format

Table Formats - Only relevant for direct database connections

As of our 1.68 release (5/27/25), all new workspaces will default to the standard SQL column format for tables. For all workspaces created prior to that, read below.

Your tables can be created using one of two formats:

  • JSONB format

    • This creates your tables with two columns:

      • id - the ID of the record

      • jsonb - contains a JSON representation of the entire record

  • Standard SQL format

    • This creates a more standard table layout. Instead of a jsonb column, each column is written separately.

If you are using the , Standard SQL format is usually recommended.

Converting Tables from JSONB to standard SQL

This change is permanent. Most users will not need to adjust these settings, and they only impact your experience if you are connecting to your database directly via third-party tools.

1

From your workspace dashboard, click the settings icon in the upper-right corner, and click Settings.

2

Scroll down to the Database Preferences section, and check the option to 'Use standard SQL columns for new tables'

3

Convert your table(s) from your workspace settings, or the settings of any table.

From the migration panel, select any of the tables you'd like to convert, and confirm your choices. The migration will begin immediately.

  • Leave the SQL Table Name field blank to use Xano’s default SQL table name, which follows the format mvpw<workspaceID>_<tableID> (e.g., mvpw1_3).

  • SQL table names must be globally unique across all workspaces. Hint: Use the Custom Prefix to ensure uniqueness across workspaces.

  • Datasources automatically add a suffix based on their environment. For example, users becomes users_test in the test datasource.

  • To reuse the same base name across workspaces, use a workspace-specific prefix (e.g., projA_users, projB_users).

Direct Database Connector
This setting must be enabled before you can convert existing tables to the new format.