Appwrite

Appwrite TablesDB API

The TablesDB service allows you to create structured tables of columns, query and filter lists of rows. 80 operations across 59 paths in the Appwrite 2.0.0 OpenAPI.

GitHub OpenAPI

Operations 80

GET /tablesdb List databases #
POST /tablesdb Create database #
GET /tablesdb/specifications List specifications #
GET /tablesdb/transactions List transactions #
POST /tablesdb/transactions Create transaction #
GET /tablesdb/transactions/{transactionId} Get transaction #
PATCH /tablesdb/transactions/{transactionId} Update transaction #
DELETE /tablesdb/transactions/{transactionId} Delete transaction #
POST /tablesdb/transactions/{transactionId}/operations Create operations #
GET /tablesdb/{databaseId} Get database #
PUT /tablesdb/{databaseId} Update database #
DELETE /tablesdb/{databaseId} Delete database #
POST /tablesdb/{databaseId}/failovers Create failover #
GET /tablesdb/{databaseId}/migrations List migrations #
POST /tablesdb/{databaseId}/migrations Create migration #
GET /tablesdb/{databaseId}/migrations/{migrationId} Get migration #
DELETE /tablesdb/{databaseId}/migrations/{migrationId} Delete migration #
POST /tablesdb/{databaseId}/migrations/{migrationId}/cutovers Cutover migration #
GET /tablesdb/{databaseId}/operations List operations #
GET /tablesdb/{databaseId}/replicas Get replicas #
GET /tablesdb/{databaseId}/status Get status #
GET /tablesdb/{databaseId}/tables List tables #
POST /tablesdb/{databaseId}/tables Create table #
GET /tablesdb/{databaseId}/tables/{tableId} Get table #
PUT /tablesdb/{databaseId}/tables/{tableId} Update table #
DELETE /tablesdb/{databaseId}/tables/{tableId} Delete table #
GET /tablesdb/{databaseId}/tables/{tableId}/columns List columns #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/bigint Create bigint column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/bigint/{key} Update bigint column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/boolean Create boolean column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/boolean/{key} Update boolean column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/datetime Create datetime column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/datetime/{key} Update datetime column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/email Create email column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/email/{key} Update email column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/enum Create enum column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/enum/{key} Update enum column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/float Create float column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/float/{key} Update float column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/integer Create integer column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/integer/{key} Update integer column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/ip Create IP address column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/ip/{key} Update IP address column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/line Create line column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/line/{key} Update line column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/longtext Create longtext column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/longtext/{key} Update longtext column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/mediumtext Create mediumtext column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/mediumtext/{key} Update mediumtext column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/point Create point column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/point/{key} Update point column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/polygon Create polygon column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/polygon/{key} Update polygon column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/relationship Create relationship column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/string Create string column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/string/{key} Update string column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/text Create text column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/text/{key} Update text column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/url Create URL column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/url/{key} Update URL column #
POST /tablesdb/{databaseId}/tables/{tableId}/columns/varchar Create varchar column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/varchar/{key} Update varchar column #
GET /tablesdb/{databaseId}/tables/{tableId}/columns/{key} Get column #
DELETE /tablesdb/{databaseId}/tables/{tableId}/columns/{key} Delete column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/columns/{key}/relationship Update relationship column #
GET /tablesdb/{databaseId}/tables/{tableId}/indexes List indexes #
POST /tablesdb/{databaseId}/tables/{tableId}/indexes Create index #
GET /tablesdb/{databaseId}/tables/{tableId}/indexes/{key} Get index #
DELETE /tablesdb/{databaseId}/tables/{tableId}/indexes/{key} Delete index #
GET /tablesdb/{databaseId}/tables/{tableId}/rows List rows #
POST /tablesdb/{databaseId}/tables/{tableId}/rows Create row #
PUT /tablesdb/{databaseId}/tables/{tableId}/rows Upsert rows #
PATCH /tablesdb/{databaseId}/tables/{tableId}/rows Update rows #
DELETE /tablesdb/{databaseId}/tables/{tableId}/rows Delete rows #
GET /tablesdb/{databaseId}/tables/{tableId}/rows/{rowId} Get row #
PUT /tablesdb/{databaseId}/tables/{tableId}/rows/{rowId} Upsert a row #
PATCH /tablesdb/{databaseId}/tables/{tableId}/rows/{rowId} Update row #
DELETE /tablesdb/{databaseId}/tables/{tableId}/rows/{rowId} Delete row #
PATCH /tablesdb/{databaseId}/tables/{tableId}/rows/{rowId}/{column}/decrement Decrement row column #
PATCH /tablesdb/{databaseId}/tables/{tableId}/rows/{rowId}/{column}/increment Increment row column #

Documentation

📖
Documentation
https://appwrite.io/docs
📖
APIReference
https://appwrite.io/docs/references

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/appwrite/refs/heads/main/openapi/appwrite-tablesdb-api-openapi.yml

SDKs

📦
GitHubRepository
https://github.com/appwrite/appwrite

Other Resources

🔗
Overlay
https://raw.githubusercontent.com/api-evangelist/appwrite/refs/heads/main/overlays/appwrite-tablesdb-overlay.yaml

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/appwrite-tablesdb-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

appwrite-tablesdb-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  version: 2.0.0
  title: Appwrite Tables DB API
  description: Appwrite backend as a service cuts up to 70% of the time and costs required for building a modern application. We abstract and simplify common development tasks behind a REST APIs, to help you develop your app in a fast and secure way. For full API documentation and tutorials go to https://appwrite.io/docs
  termsOfService: https://appwrite.io/policy/terms
  contact:
    name: Appwrite Team
    url: https://appwrite.io/support
    email: team@appwrite.io
  license:
    name: BSD-3-Clause
    url: https://raw.githubusercontent.com/appwrite/appwrite/master/LICENSE
servers:
- url: https://cloud.appwrite.io/v1
  description: Appwrite Cloud endpoint.
- url: https://{region}.cloud.appwrite.io/v1
  description: Appwrite Cloud regional endpoint. Replace `{region}` with your project region.
  variables:
    region:
      default: fra
      description: Appwrite Cloud region.
tags:


# --- truncated at 32 KB (304 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/appwrite/refs/heads/main/openapi/appwrite-tablesdb-api-openapi.yml