Integration

Xano Metadata API integration

Manage a Xano backend instance (Metadata API, beta): workspaces, database tables with their columns, indexes and records (create, read, search, update and delete rows, in bulk or by search), API groups and endpoints, custom functions and scheduled tasks written in XanoScript, data sources, branches, workspace files, realtime settings, audit logs and request histories. Workspace export and import (archive files), the two table routes the vendor marks deprecated (table meta and autocomplete, both covered by update_table) and the account-level routes on app.xano.com are not exposed. Authentication is a Metadata API access token (Bearer) created in the instance settings, plus the instance host.

Connect Xano Metadata API How integrations work

Ask it in chat

Say what should happen.
The workflow builds itself.

When this happens, do that in Xano Metadata API.Built from the 116 Xano Metadata API tools below, on the connection you add once.

What you can do with Xano Metadata API

Each of these is one operation on one endpoint, available both as a workflow step and as a tool an AI agent can call on its own. Nothing bundles several operations into one action, so what a run did stays readable afterwards.

Most endpoints run on the free plan. A few, mainly the ones that publish on your behalf, need a paid plan.

Search, 10 operations

create_search_indexCreate search indexPOSTCreate a full-text search index for table columns with language-specific optimization. Token scope: Workspace Database: Create.
search_function_historySearch function historyPOSTSearch function request history using advanced filters and custom sorting options. Token scope: Workspace Request History: Read.
search_instance_audit_logsSearch instance audit logsPOSTSearch audit logs across all workspaces with support for complex filtering and sorting.
search_middleware_historySearch middleware historyPOSTSearch middleware request history using advanced filters and custom sorting options. Token scope: Workspace Request History: Read.
search_recordsSearch recordsPOSTSearches the records of a table with search conditions and a sort, paginated. Returns matching records with paging info. Token scope: Workspace Content: Read.
search_request_historySearch request historyPOSTSearch API request history using advanced filters and custom sorting options. Token scope: Workspace Request History: Read.
search_task_historySearch task historyPOSTSearch task request history using advanced filters and custom sorting options. Token scope: Workspace Request History: Read.
search_tool_historySearch tool historyPOSTSearch tool request history using advanced filters and custom sorting options. Token scope: Workspace Request History: Read.
search_trigger_historySearch trigger historyPOSTSearch trigger request history using advanced filters and custom sorting options. Token scope: Workspace Request History: Read.
search_workspace_audit_logsSearch workspace audit logsPOSTSearch audit logs using advanced filters and custom sorting options. Token scope: Workspace Log: Read.

Api, 6 operations

create_apiCreate apiPOSTCreates an API endpoint in an API group from XanoScript source (a query block with its verb, inputs, stack and response). Returns the endpoint with its id.
delete_apiDelete apiDELETEDelete an API endpoint permanently. This action cannot be undone.
get_apiGet apiGETRetrieve a specific API endpoint by ID.
list_apisList apisGETRetrieve all API endpoints in a group with optional filtering and pagination.
update_apiUpdate apiPUTUpdates the settings of an API endpoint (name, description, verb, auth, cache, tags); its code is changed with update_api_code. Read it with get_api first: name, description and verb are required.
update_api_codeUpdate api codePUTReplaces the code of an API endpoint with new XanoScript source (the whole query block). Read the current source (xanoscript.value) with get_api first.

Function, 6 operations

create_functionCreate functionPOSTCreates a custom function from XanoScript source (the whole function block, as in the vendor example). Returns the function with its id.
delete_functionDelete functionDELETEDelete a function permanently. This action cannot be undone.
get_functionGet functionGETRetrieve a specific function by ID.
list_functionsList functionsGETRetrieve all functions in a workspace with optional filtering and pagination.
update_functionUpdate functionPUTUpdates the settings of a custom function (name, description, docs, cache, tags); its code is changed with update_function_code. Read it with get_function first: name and description are required.
update_function_codeUpdate function codePUTReplaces the code of a custom function with new XanoScript source (the whole function block). Read the current source (xanoscript.value) with get_function first.

Task, 6 operations

create_taskCreate taskPOSTCreates a scheduled background task from XanoScript source (a task block with its stack and schedule). Returns the task with its id.
delete_taskDelete taskDELETEDelete a scheduled task permanently. This action cannot be undone.
get_taskGet taskGETRetrieve a specific scheduled task by ID.
list_tasksList tasksGETRetrieve all scheduled tasks in a workspace with optional filtering and pagination.
update_taskUpdate taskPUTUpdates the settings of a scheduled task (name, description, docs, data source, active, tags); its code and schedule change with update_task_code. Read it with get_task first.
update_task_codeUpdate task codePUTReplaces the code and schedule of a scheduled task with new XanoScript source (the whole task block). Read the current source (xanoscript.value) with get_task first.

Apigroup, 5 operations

create_api_groupCreate api groupPOSTCreate a new API group in a workspace. Include name, description, and optional tags. Token scope: Workspace Api: Create.
delete_api_groupDelete api groupDELETEDelete an API group and all its endpoints. This action cannot be undone. Token scope: Workspace Api: Delete.
get_api_groupGet api groupGETGet detailed information for a specific API group. Returns complete metadata and configuration. Token scope: Workspace Api: Read.
list_api_groupsList api groupsGETRetrieve a list of API groups inside of a workspace. Use the optional filtering and sorting parameters for more granular returns. Token scope: Workspace Api: Read.
update_api_groupUpdate api groupPUTUpdates an API group (name, description, docs, swagger, tags). Read it with get_api_group first: name, description and swagger are required. Token scope: Workspace Api: Update.

Content, 5 operations

create_recordCreate recordPOSTCreates one record in a table. Send the record fields (the table columns, see get_table_schema) as the record object. Returns the created record. Token scope: Workspace Content: Create.
delete_recordDelete recordDELETEDelete a specific record by ID. Token scope: Workspace Content: Delete.
get_recordGet recordGETRetrieve a specific record by ID. Token scope: Workspace Content: Read.
list_recordsList recordsGETLists the records of a table, 50 per page by default, with paging info (curPage, nextPage, itemsTotal). Use search_records to filter or sort. Token scope: Workspace Content: Read.
update_recordUpdate recordPUTUpdates one record of a table. Send the columns to change in the record object. Returns the updated record. Token scope: Workspace Content: Update.

Security, 5 operations

update_api_group_securityUpdate api group securityPUTUpdate security settings for an API group. Configure access permissions and authentication requirements. Token scope: Workspace Api: Update.
update_api_securityUpdate api securityPUTUpdate API endpoint security configuration and access controls.
update_function_securityUpdate function securityPUTUpdate function security configuration and access controls.
update_table_securityUpdate table securityPUTSets the security of a table by assigning an API group guid (from get_api_group), or removes the restriction.
update_task_securityUpdate task securityPUTUpdate scheduled task security configuration and access controls.

Table, 5 operations

create_tableCreate tablePOSTCreates a table. Only name is required: send schema, index and the other fields to create it complete in one call, or add columns later with the create_<type>_column tools.
delete_tableDelete tableDELETEDelete a database table and all its data permanently.
get_tableGet tableGETRetrieve detailed information for a specific table.
list_tablesList tablesGETRetrieve all tables in a workspace with optional filtering and pagination.
update_tableUpdate tablePUTUpdates a table definition (name, description, docs, auth, schema, index, tags, autocomplete). Read it first with get_table and send the values to keep.

Datasource, 4 operations

create_data_sourceCreate data sourcePOSTCreate a new external data source with custom label and color. Token scope: Instance Workspace: Create.
delete_data_sourceDelete data sourceDELETEDelete a data source permanently. This action cannot be undone. Token scope: Instance Workspace: Delete.
list_data_sourcesList data sourcesGETRetrieve all external data sources for a workspace. Token scope: Instance Workspace: Read.
update_data_sourceUpdate data sourcePUTUpdate an existing data source's label and color properties. Token scope: Instance Workspace: Update.

Schema, 4 operations

delete_columnDelete columnDELETEDelete a column from a table's schema. This action cannot be undone. Token scope: Workspace Database: Delete.
get_columnGet columnGETRetrieve details for a specific column in a table's schema. Token scope: Workspace Database: Read.
get_table_schemaGet table schemaGETRetrieve the complete schema definition for a database table. Token scope: Workspace Database: Read.
replace_table_schemaReplace table schemaPUTReplaces the WHOLE schema of a table with the columns given: a column left out is removed. Read it with get_table_schema first. Token scope: Workspace Database: Update.

File, 3 operations

delete_fileDelete fileDELETEDelete a file permanently. This action cannot be undone. Token scope: Workspace File: Delete.
list_filesList filesGETRetrieve workspace files with optional search, filtering, and pagination. Token scope: Workspace File: Read.
upload_fileUpload filePOSTUploads a file to the workspace file library (public or private access, optional type image, video or audio). Returns the file record. Token scope: Workspace File: Create.

Index, 3 operations

delete_indexDelete indexDELETEDelete a specific table index. This action cannot be undone. Token scope: Workspace Database: Delete.
list_indexesList indexesGETRetrieve all indexes for a database table. Token scope: Workspace Database: Read.
replace_indexesReplace indexesPUTReplaces ALL indexes of a table with the ones given: an index left out is removed. Read them with list_indexes first. Token scope: Workspace Database: Update.

Audit log, 2 operations

list_instance_audit_logsList instance audit logsGETBrowse audit logs across all workspaces.
list_workspace_audit_logsList workspace audit logsGETRetrieve workspace audit logs with pagination support. Token scope: Workspace Log: Read.

Branch, 2 operations

delete_branchDelete branchDELETEDelete a workspace branch. Cannot delete the default branch or currently live branch. Token scope: Instance Workspace: Update.
list_branchesList branchesGETRetrieve all branches in a workspace. Token scope: Instance Workspace: Read.

Delete, 2 operations

delete_recordsDelete recordsPOSTDeletes the records whose ids are given in row_ids. This cannot be undone. Returns the count deleted. Token scope: Workspace Content: Delete.
delete_records_by_searchDelete records by searchPOSTDeletes every record matching the search conditions. Always pass at least one condition. This cannot be undone. Token scope: Workspace Content: Delete.

Openapi, 2 operations

get_api_group_openapiGet api group openapiGETGet the OpenAPI specification for an API group. Returns the complete Swagger JSON for all endpoints. Token scope: Workspace Api: Read.
get_api_openapiGet api openapiGETGenerate OpenAPI specification for a specific API endpoint. Token scope: Workspace Api: Read.

Patch, 2 operations

update_recordsUpdate recordsPOSTUpdates several records in one call: items is an array of {row_id, updates}, where updates holds the columns to change and their new values. Token scope: Workspace Content: Update.
update_records_by_searchUpdate records by searchPOSTUpdates every record matching the search conditions with the given column values. Always pass at least one condition. Token scope: Workspace Content: Update.

Realtime, 2 operations

get_realtime_settingsGet realtime settingsGETRetrieve real-time operational metrics and connection details. Token scope: Instance Workspace: Read.
update_realtime_settingsUpdate realtime settingsPUTUpdate real-time settings and connection configuration. Token scope: Instance Workspace: Update.

Vector, 2 operations

create_vector_columnCreate vector columnPOSTCreate a vector column for storing multi-dimensional data used in AI and ML applications. Token scope: Workspace Database: Create.
create_vector_indexCreate vector indexPOSTCreates a vector index on vector columns of a table, with the distance operator per column (inner product, cosine, L1 or L2). Token scope: Workspace Database: Create.

Workspace, 2 operations

get_workspaceGet workspaceGETRetrieve detailed information about a specific workspace. Token scope: Instance Workspace: Read.
list_workspacesList workspacesGETLists the workspaces of this Xano instance the token can access, with the workspace id every other tool needs.

Attachment, 1 operation

create_attachment_columnCreate attachment columnPOSTCreate an attachment column for file uploads in a database table. Token scope: Workspace Database: Create.

Audio, 1 operation

create_audio_columnCreate audio columnPOSTCreate an audio file column for storing audio uploads and media. Token scope: Workspace Database: Create.

Bool, 1 operation

create_bool_columnCreate bool columnPOSTCreate a boolean column with true/false values and optional default settings. Token scope: Workspace Database: Create.

Btree, 1 operation

create_btree_indexCreate btree indexPOSTCreate a btree index on table columns to optimize query performance. Token scope: Workspace Database: Create.

Bulk, 1 operation

create_recordsCreate recordsPOSTCreates several records in a table in one call. Send items, an array of record objects with the table columns. Token scope: Workspace Content: Create.

Bulk delete, 1 operation

delete_filesDelete filesDELETEDeletes several files of the workspace library by id. This cannot be undone. Token scope: Workspace File: Delete.

Date, 1 operation

create_date_columnCreate date columnPOSTCreate a date column for storing calendar dates without time information. Token scope: Workspace Database: Create.

Decimal, 1 operation

create_decimal_columnCreate decimal columnPOSTCreate a decimal column for precise numeric values with configurable min/max limits. Token scope: Workspace Database: Create.

Email, 1 operation

create_email_columnCreate email columnPOSTCreate an email column with built-in email format validation. Token scope: Workspace Database: Create.

Enum, 1 operation

create_enum_columnCreate enum columnPOSTCreate an enum column with predefined value options for dropdown selections. Token scope: Workspace Database: Create.

Function history, 1 operation

list_function_historyList function historyGETRetrieve API function request history with optional filtering and pagination. Token scope: Workspace Request History: Read.

Geo linestring, 1 operation

create_geo_linestring_columnCreate geo linestring columnPOSTCreate a geographic linestring column for storing connected coordinate paths. Token scope: Workspace Database: Create.

Geo multilinestring, 1 operation

create_geo_multilinestring_columnCreate geo multilinestring columnPOSTCreate a geographic multilinestring column for storing multiple coordinate paths. Token scope: Workspace Database: Create.

Geo multipoint, 1 operation

create_geo_multipoint_columnCreate geo multipoint columnPOSTCreate a geographic multipoint column for storing collections of coordinate points. Token scope: Workspace Database: Create.

Geo multipolygon, 1 operation

create_geo_multipolygon_columnCreate geo multipolygon columnPOSTCreate a geographic multipolygon column for storing complex area boundaries. Token scope: Workspace Database: Create.

Geo point, 1 operation

create_geo_point_columnCreate geo point columnPOSTCreate a geographic point column for storing latitude/longitude coordinates. Token scope: Workspace Database: Create.

Geo polygon, 1 operation

create_geo_polygon_columnCreate geo polygon columnPOSTCreate a geographic polygon column for storing area boundaries and shapes. Token scope: Workspace Database: Create.

Image, 1 operation

create_image_columnCreate image columnPOSTCreate an image column for storing photo uploads and visual media. Token scope: Workspace Database: Create.

Int, 1 operation

create_int_columnCreate int columnPOSTCreate an integer column for whole numbers with configurable min/max limits. Token scope: Workspace Database: Create.

Json, 1 operation

create_json_columnCreate json columnPOSTCreate a JSON column for storing structured data objects and arrays. Token scope: Workspace Database: Create.

Me, 1 operation

get_current_userGet current userGETReturns the user the access token belongs to: id, name and email. Use it to check the token works.

Middleware history, 1 operation

list_middleware_historyList middleware historyGETRetrieve middleware request history with optional filtering and pagination. Token scope: Workspace Request History: Read.

Object, 1 operation

create_object_columnCreate object columnPOSTCreate an object column with nested child fields for complex data structures. Token scope: Workspace Database: Create.

Password, 1 operation

create_password_columnCreate password columnPOSTCreate a password column with automatic hashing and complexity validation rules. Token scope: Workspace Database: Create.

Rename, 1 operation

rename_columnRename columnPOSTRename a column in a table's schema. Token scope: Workspace Database: Update.

Request history, 1 operation

list_request_historyList request historyGETRetrieve API request history with optional filtering and pagination. Token scope: Workspace Request History: Read.

Spatial, 1 operation

create_spatial_indexCreate spatial indexPOSTCreate a spatial index on a table for optimized geometry operations. Token scope: Workspace Database: Create.

Tableref, 1 operation

create_tableref_columnCreate tableref columnPOSTCreate a table reference column to establish relationships with other database tables. Token scope: Workspace Database: Create.

Tablerefuuid, 1 operation

create_tablerefuuid_columnCreate tablerefuuid columnPOSTCreate a UUID-based table reference column for relationships with UUID primary keys. Token scope: Workspace Database: Create.

Task history, 1 operation

list_task_historyList task historyGETRetrieve task request history with optional filtering and pagination. Token scope: Workspace Request History: Read.

Text, 1 operation

create_text_columnCreate text columnPOSTCreate a text column with formatting options and customizable validation rules. Token scope: Workspace Database: Create.

Timestamp, 1 operation

create_timestamp_columnCreate timestamp columnPOSTCreate a timestamp column for storing precise date and time values. Token scope: Workspace Database: Create.

Tool history, 1 operation

list_tool_historyList tool historyGETRetrieve tool request history with optional filtering and pagination. Token scope: Workspace Request History: Read.

Trigger history, 1 operation

list_trigger_historyList trigger historyGETRetrieve trigger request history with optional filtering and pagination. Token scope: Workspace Request History: Read.

Truncate, 1 operation

truncate_tableTruncate tableDELETEDeletes ALL records of a table (the table and its schema stay). reset=true also restarts the primary key. This cannot be undone. Token scope: Workspace Content: Delete.

Unique, 1 operation

create_unique_indexCreate unique indexPOSTCreate a unique index on table fields to enforce data uniqueness and improve query performance. Token scope: Workspace Database: Create.

Uuid, 1 operation

create_uuid_columnCreate uuid columnPOSTCreate a UUID column for generating universally unique identifiers. Token scope: Workspace Database: Create.

Video, 1 operation

create_video_columnCreate video columnPOSTCreate a video file column for storing video uploads and media content. Token scope: Workspace Database: Create.

Use Xano Metadata API from Claude Code, Cursor or Codex

Connect Xano Metadata API in LiveContext, create an API key in Settings, then add the LiveContext MCP server to your client. Its Xano Metadata API operations become tools the client can call, next to every other integration you connected.

Claude Code

claude mcp add --transport http livecontext https://livecontext.ai/mcp --header "X-API-Key: YOUR_API_KEY"

Codex (~/.codex/config.toml)

[mcp_servers.livecontext]
url = "https://livecontext.ai/mcp"

[mcp_servers.livecontext.http_headers]
"X-API-Key" = "YOUR_API_KEY"

Cursor, Claude Desktop and other JSON configs

{
  "mcpServers": {
    "livecontext": {
      "type": "http",
      "url": "https://livecontext.ai/mcp",
      "headers": {
        "X-API-Key": "YOUR_API_KEY"
      }
    }
  }
}

Set up the MCP server step by step

How to connect Xano Metadata API

Create your workspace
Sign up free. Nothing to install.
Connect Xano Metadata API once
Add your Xano Metadata API connection in Settings. Every tool from this integration reuses it, and secrets are encrypted at rest and visible only to you.
Describe the job in chat
The workflow builds itself in front of you and picks the endpoints it needs. Drag the steps yourself on the canvas whenever you would rather be explicit.