xata

name

xata

description

Xata is a serverless data platform that combines a relational database, full-text search, and branching workflows, enabling developers to build applications with scalable data storage, querying, and collaboration features through APIs, SDKs, and managed infrastructure. Read and write Xata data through One: organizations, apikeys, projects, branches, organizationinvitations, githubappinstallations and more, 65 actions with real parameter documentation. Use whenever the user asks to look something up in Xata, create or update a record there, or build code against the Xata API.

Xata through One

Xata is a serverless data platform that combines a relational database, full-text search, and branching workflows, enabling developers to build applications with scalable data storage, querying, and collaboration features through APIs, SDKs, and managed infrastructure.

One exposes Xata through four MCP tools. The table below carries real action ids from One's knowledge base, so for a common operation you can skip search and go straight to reading the action's parameters.

How to run an action

1. Find the action in the table below, or call search_one_platform_actions with platform xata if it is not listed.
2. Call get_one_action_knowledge with the action id. Do this every time, including for actions in this table. The table gives you the id, not the parameters.
3. Call execute_one_action with parameters copied from that knowledge.

Never guess a parameter name, a body field, or an enum value. The knowledge has the real schema, and a guessed field is either a 400 or a silent write of the wrong thing.

Before you start

Call list_one_integrations once and confirm Xata is connected. If it is missing, the user has not connected it: say so and point them at https://app.withone.ai rather than reaching for raw HTTP.

Each connection carries an access field. If it reports {"policy": "methods", "methods": ["GET"]} the agent is read-only here, so plan a read-only answer instead of attempting a write that will be refused.

Before a write

Creates, updates, deletes and sends land on a real Xata account and cannot be recalled. State the action and the specific target in one line before the first write in a task, and let the user stop you. Reads need no confirmation.

Actions

Organizations

Action	Method	Path	Action id
Get an Organization by ID	GET	/organizations/{{organizationId}}	conn_mod_def::GMgWa9H8mdA::-dLpB6_dQvCWJE-R4zTvFQ
Get an Organization's Upcoming Billing Invoice	GET	/organizations/{{organizationId}}/billing/invoices/upcoming	conn_mod_def::GMgWaP1G0EA::qu28xR6kSVSx3nIoaXGNXw
List Organizations	GET	/organizations	conn_mod_def::GMgWa6-54SA::kw9XQKMhTdqVnOT-5PqYdA
Create an Organization	POST	/organizations	conn_mod_def::GMgWa0rUYZA::SamTRcD3SDKK-QnGN6Fi2w
Delete an Organization	DELETE	/organizations/{{organizationId}}	conn_mod_def::GMgWa7oo3pA::fV0tJZsjRoe34Fi-LEwKeg
Request Deletion for an Organization	POST	/organizations/{{organizationId}}/deletion-request	conn_mod_def::GMgWbDLLotg::WeATvhM7SXCl71MZ_qZDMA
Update an Organization	PUT	/organizations/{{organizationId}}	conn_mod_def::GMgWbK77Wog::US0xQNN1SqqOo3sGPrlF9A

ApiKeys

Action	Method	Path	Action id
List API Keys for an Organization	GET	/organizations/{{organizationId}}/api-keys	conn_mod_def::GMgWaHeSfwg::Sb6nkIWfRd2eTEhu7JteEw
List API Keys for the Authenticated User	GET	/api-keys	conn_mod_def::GMgWaNAvcrA::lqQVlXz1Qryd1DXfmOEYZg
Bulk Delete API Keys for an Organization	DELETE	/organizations/{{organizationId}}/api-keys	conn_mod_def::GMgWaFWqt5g::3PjAXKLYRqar1vR-VXFXTQ
Bulk Delete API Keys for the Authenticated User	DELETE	/api-keys	conn_mod_def::GMgWaGplRCg::jEAog3WVSNy5em7L-mrfnA
Create a User API Key	POST	/api-keys	conn_mod_def::GMgWaGdTsrA::OAi-wg6NTF-uB8JlY8yh4g

Projects

Action	Method	Path	Action id
Get Project Details for an Organization	GET	/organizations/{{organizationId}}/projects/{{projectId}}	conn_mod_def::GMgWba0EzQg::sJYlWJxdRLSknN2vvyiQqA
List an Organization's Projects	GET	/organizations/{{organizationId}}/projects	conn_mod_def::GMgWbbmj5TA::EEnXH2slQXKs84DEaxWpGw
Create a Project for an Organization	POST	/organizations/{{organizationId}}/projects	conn_mod_def::GMgWbLcPKeg::ko4sauimRgi9iIGNiyB15Q
Delete a Project for an Organization	DELETE	/organizations/{{organizationId}}/projects/{{projectId}}	conn_mod_def::GMgWbLA6iXg::92Ca4VtSRgeWklSz-iysvg
Update a Project in an Organization	PATCH	/organizations/{{organizationId}}/projects/{{projectId}}	conn_mod_def::GMgWbieSoEA::RcM6XmjjTAW2_hbfbxRrSA

Branches

Action	Method	Path	Action id
Get Branch Details for a Project in an Organization	GET	/organizations/{{organizationId}}/projects/{{projectId}}/branches/{{branchId}}	conn_mod_def::GMgWadW6EYA::BtzhEj3NTfawgHX_6Yj78g
List a Project's Branches	GET	/organizations/{{organizationId}}/projects/{{projectId}}/branches	conn_mod_def::GMgWafxZ7ng::ZnvkfIR8QEaa61-CNy_Rrw
Create a Branch for a Project in an Organization	POST	/organizations/{{organizationId}}/projects/{{projectId}}/branches	conn_mod_def::GMgWaWwCzjA::RAboCtOPTkKT1JgzUMCmFQ
Restore a Branch from Backup	POST	/organizations/{{organizationId}}/projects/{{projectId}}/branches/{{branchId}}/restore	conn_mod_def::GMgWaXbXTAA::B7kR1vzuTvC0dxDmDFZjFQ

OrganizationInvitations

Action	Method	Path	Action id
Get an Organization Invitation by ID	GET	/organizations/{{organizationId}}/invitations/{{invitationId}}	conn_mod_def::GMgWa8_rZUA::wJ410szRR9W-5YFhxq6NGA
Create an Invitation for an Organization	POST	/organizations/{{organizationId}}/invitations	conn_mod_def::GMgWbMDF9wA::qtXwg3bQRgmv36Tl175d3g
Delete an Organization Invitation	DELETE	/organizations/{{organizationId}}/invitations/{{invitationId}}	conn_mod_def::GMgWa675ubg::_XtJD8uZQg2XLnRmMAvRSQ
Resend an Organization Invitation	POST	/organizations/{{organizationId}}/invitations/{{invitationId}}/resend	conn_mod_def::GMgWbK1Wswg::mYaQSZIWRo-2P8ucTRz25A

GithubAppInstallations

Action	Method	Path	Action id
List GitHub App Installations for an Organization	GET	/organizations/{{organizationId}}/githubapp/installations	conn_mod_def::GMgWat0233g::j4XM6zdnQBKZRXuzYEb7tw
Create GitHub App Installation for an Organization	POST	/organizations/{{organizationId}}/githubapp/installations	conn_mod_def::GMgWasvbxeA::m8NUnEn6Qpik2IM1IAN09A
Update a GitHub App Installation for an Organization	PUT	/organizations/{{organizationId}}/githubapp/installations/{{githubInstallationId}}	conn_mod_def::GMgWazo4bZA::6ZQON4C1TnOFf_ti17IA7g

ProjectBranches

Action	Method	Path	Action id
Delete a Project Branch	DELETE	/organizations/{{organizationId}}/projects/{{projectId}}/branches/{{branchId}}	conn_mod_def::GMgWaWMlr6g::1kae42MuQ7Cy9oOyI5Bhww
Update a Project Branch in an Organization	PATCH	/organizations/{{organizationId}}/projects/{{projectId}}/branches/{{branchId}}	conn_mod_def::GMgWam1rt5A::LrBtkDT1S_OnwSLDpfqFdw

BranchCredentials

Action	Method	Path	Action id
Retrieve Branch Credentials for a Project Branch	GET	/organizations/{{organizationId}}/projects/{{projectId}}/branches/{{branchId}}/credentials	conn_mod_def::GMgWafLxZIg::wFpLqV8bRXil1hxJQABMNQ
Rotate Branch Credentials for a Project	POST	/organizations/{{organizationID}}/projects/{{projectID}}/branches/{{branchID}}/credentials/rotate	conn_mod_def::GMgWal-2Nfg::jpiQm3UvTISSthFfXYH5HA

GithubRepositoryMappings

Action	Method	Path	Action id
Create GitHub Repository Mapping for a Branch in a Project	POST	/organizations/{{organizationId}}/projects/{{projectId}}/branches/{{branchId}}/githubapp/repository	conn_mod_def::GMgWatcAKNA::rb0HLbwrRiqh59S8ITHSfw
Update GitHub Repository Mapping for a Branch	PUT	/organizations/{{organizationId}}/projects/{{projectId}}/branches/{{branchId}}/githubapp/repository	conn_mod_def::GMgWazsvpqA::eF4gMKGmRgWGsWeRXbmqIw

OrganizationMembers

Action	Method	Path	Action id
List an Organization's Members	GET	/organizations/{{organizationId}}/members	conn_mod_def::GMgWbDre1fg::6fqyZeNSSQuDlcSATneatQ
Remove a Member from an Organization	DELETE	/organizations/{{organizationId}}/members/{{userId}}	conn_mod_def::GMgWbD-eNrA::6Uj2IE40QEmUS4l_jWqOhg

ProjectResourceLimits

Action	Method	Path	Action id
Get Project Resource Limits	GET	/organizations/{{organizationId}}/projects/{{projectId}}/limits	conn_mod_def::GMgWbbp7s0g::AQQGGMeZTN2U0E9kn67amg
Get Project Resource Limits for an Organization	GET	/organizations/{{organizationId}}/projects/limits	conn_mod_def::GMgWbbjmIxA::nqmRKcYmRZ2fPzOso3y-zA

Webhooks

Action	Method	Path	Action id
GitHub Webhook	POST	/webhooks/github	conn_mod_def::GMgWbh9boRA::AMLmJohOS-yOwYyN0zrRYA
Orb Billing Webhook	POST	/webhooks/orb	conn_mod_def::GMgWbhZLWOA::TgJ0am3RQBeg3rl29HwpJw

OrganizationApiKeys

Action	Method	Path	Action id
Create an Organization API Key	POST	/organizations/{{organizationId}}/api-keys	conn_mod_def::GMgWaFWWAtA::iD0UPculQZ27kXbVz_9ISA

BillingPaymentMethodSession

Action	Method	Path	Action id
Create a Billing Payment Method Session for an Organization	POST	/organizations/{{organizationId}}/billing/payment-method-session	conn_mod_def::GMgWaOQrO1A::T4pbVItbRg-aW25QxGY-Sg

BillingCheckoutSession

Action	Method	Path	Action id
Create a Billing Checkout Session for an Organization	POST	/organizations/{{organizationId}}/billing/checkout-session	conn_mod_def::GMgWaOV0Iog::_zJ241H6QwiEQKjfc25wcw

BillingCustomerDetails

Action	Method	Path	Action id
Get Billing Customer Details for an Organization	GET	/organizations/{{organizationId}}/billing/customer	conn_mod_def::GMgWaPA3Wng::mC9LWdGiQCGZfEcZAhklmQ

BillingInvoices

Action	Method	Path	Action id
List Billing Invoices for an Organization	GET	/organizations/{{organizationId}}/billing/invoices	conn_mod_def::GMgWaWEC22A::vZyR_K_XS1q0hKTjtPURLg

BillingCustomer

Action	Method	Path	Action id
Update Billing Customer for an Organization	PATCH	/organizations/{{organizationId}}/billing/customer	conn_mod_def::GMgWaWvAYkg::jDmRO3tWRuae0MM_U8X6Ug

PostgresConfigurationDetails

Action	Method	Path	Action id
Get PostgreSQL Configuration Details for a Branch	GET	/organizations/{{organizationId}}/projects/{{projectId}}/branches/{{branchId}}/postgres-config	conn_mod_def::GMgWaeJoFfg::-kb0qwVVTOq-8NQCcSd2Ew

BranchLogs

Action	Method	Path	Action id
Retrieve Branch Logs for a Project in an Organization	POST	/organizations/{{organizationId}}/projects/{{projectId}}/branches/{{branchId}}/logs	conn_mod_def::GMgWaeoh5kg::1h8wF8qXSJ-COF_FCTDFMw

BranchMetrics

Action	Method	Path	Action id
Retrieve Branch Metrics for a Project	POST	/organizations/{{organizationId}}/projects/{{projectId}}/branches/{{branchId}}/metrics	conn_mod_def::GMgWal2ocFA::em0w7cTJR9iaXq4fHFzwvA

WebSocketWireProtocolProxy

Action	Method	Path	Action id
WebSocket Wire Protocol Proxy	GET	/v2	conn_mod_def::GMgWamAa34A::3zFJsGtiQHWOMLj1BDTbaA

Sql

Action	Method	Path	Action id
Execute SQL Query	POST	/sql	conn_mod_def::GMgWam655lg::jy-mWnH8SbukPgdR8TlAdA

GithubRepository

Action	Method	Path	Action id
Get a Branch's GitHub Repository	GET	/organizations/{{organizationId}}/projects/{{projectId}}/branches/{{branchId}}/githubapp/repository	conn_mod_def::GMgWatcRxKA::7Hx9b2vgQyGK_K54VZAXtg

GitHubRepositoryMapping

Action	Method	Path	Action id
Delete GitHub Repository Mapping for a Branch	DELETE	/organizations/{{organizationId}}/projects/{{projectId}}/branches/{{branchId}}/githubapp/repository	conn_mod_def::GMgWatlkfqA::NmQGgtm6SyOfYLNVqGARpg

McpMessages

Action	Method	Path	Action id
Send an MCP Message	POST	/mcp	conn_mod_def::GMgWazoISVg::a4M-0SPnT5-UhvieOQBdiA

MarketplaceRegistration

Action	Method	Path	Action id
Register with a Cloud Marketplace	POST	/marketplace/register	conn_mod_def::GMgWa1dVegg::pWIFlxGEQ4uAnI7WBgdSrA

OrganizationMembershipLimits

Action	Method	Path	Action id
Get Organization Membership Limits	GET	/organizations/{{organizationId}}/membership-limits	conn_mod_def::GMgWbDGYYpg::rFy7k94vSTu3e3sjkFcX4Q

Invitations

Action	Method	Path	Action id
List Invitations for an Organization	GET	/organizations/{{organizationId}}/invitations	conn_mod_def::GMgWbFUKRKg::yC5uFlDXQaev7YrsKwJEaQ

Extensions

Action	Method	Path	Action id
List Available Extensions for an Organization Image	GET	/organizations/{{organizationId}}/extensions	conn_mod_def::GMgWbSKIYLg::g3t8H7mTRuCTnBdn8Dp5jQ

InstanceTypes

Action	Method	Path	Action id
List Instance Types for an Organization	GET	/organizations/{{organizationId}}/instanceTypes	conn_mod_def::GMgWbTdS05g::qO747qmoQWewSaMrqcO-0g

Regions

Action	Method	Path	Action id
List Available Regions for an Organization	GET	/organizations/{{organizationId}}/regions	conn_mod_def::GMgWbT7GUAA::ezjp3hpsSX-ebJadOiiYNg

OrganizationResourceLimits

Action	Method	Path	Action id
Get Organization Resource Limits	GET	/organizations/{{organizationId}}/limits	conn_mod_def::GMgWbT777pA::UAzDhc9cQwaGBQYUbXVrZQ

Images

Action	Method	Path	Action id
List an Organization's Available Images	GET	/organizations/{{organizationId}}/images	conn_mod_def::GMgWbT_0f2A::9mDsWHFVT9m_p24j8WctnQ

ProjectBackups

Action	Method	Path	Action id
Get a Project Backup by ID	GET	/organizations/{{organizationId}}/projects/{{projectId}}/backups/{{backupId}}	conn_mod_def::GMgWbage6PA::iOn9bMRqSJWQhrrDrtIWYg

StripeWebhook

Action	Method	Path	Action id
Stripe Webhook	POST	/webhooks/stripe	conn_mod_def::GMgWbhZaOXg::ja2Wm43oSM--pnpGAoT-HA

Backups

Action	Method	Path	Action id
List Project Backups for an Organization Project	GET	/organizations/{{organizationId}}/projects/{{projectId}}/backups	conn_mod_def::GMgWbh04kjA::DYo5-EijROWyOC96XnTWpw

When a call fails

The error comes from Xata, not from One. A 400 or 422 means your parameters do not match the schema, so re-read the knowledge and fix the field. A 401 or 403 means the connection needs re-authorizing, which no retry will fix. A 404 means the id is not on this account. A 429 means slow down. Never retry a write more than once: the first attempt may have landed.

Full catalog: https://www.withone.ai/knowledge/xata

Integration knowledge by One (withone.ai), licensed under One-Knowledge-1.0. Attribution must be preserved in derivative works.