Workspace Settings

An explanation of all available workspace settings

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

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

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

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

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.

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

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 Direct Database Connector, Standard SQL format is usually recommended.

When to Convert to Standard SQL Format:

  • You need direct database connections with third-party tools that aren't friendly to JSONB format, such as Tableau or PowerBI

  • You want faster performance for non-indexed queries

  • You're frequently adding new fields (faster column additions)

  • You plan to use SQL analytics tools or run complex reports directly against your database

When to Keep JSONB Format:

  • You're satisfied with current performance

  • You don't need direct database connections

Converting Tables from JSONB to standard SQL

Using standard SQL does not mean you can't use JSONB — you have the ability to mix and match table types, if you prefer. You can also still use JSON fields on any table type for more complex, dynamic field structure.

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'

This setting must be enabled before you can convert existing tables to the new format.
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.

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.

  • 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).

Last updated

Was this helpful?