Last updated
Was this helpful?
Last updated
Was this helpful?
Hint
Use the to create and update tables for you!
Click in the top right corner.
Choose Import Data to , or Enter Data Manually to start with an empty table where you can add your own data later, or generate sample data automatically.
If you're just starting out, we'd recommend choosing Enter Data Manually and using the sample data generator. You can always import data later.
In the panel that opens, give your table a and a
When naming your table, it's considered best practice to use camelCase for multiple words, and to not use plurals in the table name. For example, a table of dog breeds would be named dogBreed
The description is just for you to make notes on what this table will contain, notable data constraints, or any other information you'd like to store.
The primary key is the ID of each record. Xano offers two types of primary keys to choose from.
When designing your database structure in Xano, choosing the right identifier type is an important decision. Here's a straightforward guide to help you decide:
Sequential IDs are best for:
Performance-sensitive operations - they're faster to index and query
Human-friendly references - easier to communicate ("Please check record #42")
Storage efficiency - they consume less space in your database
When chronological order matters - the sequence reveals creation order
Single-database applications where centralized ID generation works well
Systems that benefit from predictable numbering patterns
Common use cases: Customer IDs, order numbers, ticket systems, invoice numbers, internal record tracking
UUIDs are best for:
Distributed systems where multiple services create records independently
Data synchronization across different databases or systems
Preventing ID guessing or enumeration attacks
Frontend-first workflows where IDs need to be generated before server contact
Multi-region deployments with separate databases
When you don't want to expose information about record counts
Scenarios where data privacy is paramount
Common use cases: User accounts in modern applications, cross-system record tracking, session management, event logging in distributed architectures
Let's start with the top control bar.
Just below the control bar, you'll see your database records.
Use your mouse or arrow keys to navigate between records and individual cells.
To modify data, just select the cell and make your desired changes. They will be saved automatically.
After you've selected your desired field type, you will be presented with a number of options. You can review each one of them and what they mean below.
Note
The settings listed below only impact your API endpoints that utilize the feature. This means that it is possible to make changes that break these rules via the database table view.
For each field, you can apply various rules and filters to ensure that the data is stored in the format that you expect.
Right-click on the header of a field to access field-related settings and make adjustments to the options already detailed above, as well as some additional controls.
Please note that renaming a field should be handled with care, as it may impact any function steps that reference that field.
Xano will attempt to convert the data in the column to the new data type, but because of potential variations between data types, and the specific data being converted, this may not always be successful. It is always recommended to create a new column instead.
Deleting a column is irreversible. Proceed with caution.
This option is located at the bottom of your database records — so, if you have no records, you should see it right at the top.
The record generation will look at the name and the data type for each of your fields and try to auto-suggest what they should be filled with.
You can click on one of those data types to change what that field is populated with, or specific settings related to that data type.
In the bottom-right corner, you can change the number of records generated, up to 100 at a time.
When you're ready, click "Generate" and you should see your new sample data populated. You can always generate more records if you'd like.
Want to clear out all of the sample data? There's a quick "Clear All Records" shortcut in the upper-right settings menu. This will delete all records in the table in one swing.
The record will be created using any default values you've specified in the field options, and you can click on each cell to fill it in manually.
f
Select one or more records by checking these boxes
Open a card view of the selected record
Add a new field
Click the to add a new field, and choose the you want to add from the panel that opens.
Rename this field
You can click when viewing a database table to open Referenced By and view any database operations that utilize that column first to understand where changes need to be made. In the screenshot below, we know we want to update the name column, so we can use Referenced By to find where it's used beforehand.
Access field settings (the options detailed earlier in this document)
Make a copy of this column
Insert a new column directly after the selected column
Reorder your database fields. This does not impact how the data is returned in your function stacks.
Change the data type of the column
Delete the column
After you've created your database , you can generate some sample data to use right away by clicking
Click at the bottom of your existing records (if any) to add a new record.
You can also click to open up the card view and fil in multiple, or all fields at once when creating a new record.
Click to access table settings after creation, including both settings detailed earlier in this document, as well as some additional options.
Table name, ID, description, and tags
Go back to your list of database tables.
Refresh the list of records
Change the
Search for specific records
Filter your records by certain conditions, such as "all records with an ID greater than 100"
Sort your database records
Hide database fields from view
Cut, Copy, Paste, Undo, and Redo
Show
Show
Review available keyboard shortcuts for the database view
Name
The name of the field you are creating
Description
Add additional details here
Data Structure
Single - Each record will only store one value in this field. This is the more common selection. List - Each record can hold multiple values in this field. For example, if this was a table of authors, we might have a field that can store multiple books for each author.
Allow Nullable Values
A null
value is similar to an empty value in that it represents "nothing is here", but it's still an actual value written to the record. Useful if you need to specifically check whether or not that field has data stored.
Format
For some field types, you can specify a format. This does not change the actual data being stored and is only used to enable easier viewing and editing for you inside of the table view.
Default Value
When adding new records, you can automatically populate a default value
Required
Determines whether or not this field is required when adding a record
Sensitive Data
Hide the contents of this field from certain areas, such as request history
Column Visibility
Public - The field will be available as an input Private - This field will not appear in inputs Internal - Hide this field from API inputs and responses
Custom Rules & Filters
See below.
min
Enforces a minimum number of required characters
max
Enforces a maximum number of required characters
startsWith
Enforces a prefix
endsWith
Enforces a suffix
prevent
Blacklists phrases
lower
Stores the value in all lowercase
upper
Stores the value in all uppercase
alphaOk
Whitelist certain alphanumeric characters
digitOk
Whitelist certain numbers
ok
Whitelist certain characters
pattern
Enforce a
Authentication
Determines whether or not this table is used for user authentication.
Security
Change the table .
Versions
Xano maintains a version history of your table schema. You can roll back to a previous version of your schema if you've made changes that you want to undo. Note: This does not change the data in your table, only the fields. If you need to restore a backup of your table data, see this document.
Triggers
Access your .
Auto-complete
Access your settings.
Clear all records
Deletes all records in the table. You can also choose to reset the primary ID back to 1 on tables that use a sequential ID.
Clone table
Cloning copies the table schema. Cloning does not copy existing data.
Export data
Export your table data using the current view as a CSV
Import data
Import records from a CSV Learn More