Appwrite

Appwrite Databases API

The Databases service allows you to create structured collections of documents, query and filter lists of documents. 70 operations across 51 paths in the Appwrite 2.0.0 OpenAPI.

GitHub OpenAPI

Operations 70

GET /databases List databases #
POST /databases Create database #
GET /databases/transactions List transactions #
POST /databases/transactions Create transaction #
GET /databases/transactions/{transactionId} Get transaction #
PATCH /databases/transactions/{transactionId} Update transaction #
DELETE /databases/transactions/{transactionId} Delete transaction #
POST /databases/transactions/{transactionId}/operations Create operations #
GET /databases/{databaseId} Get database #
PUT /databases/{databaseId} Update database #
DELETE /databases/{databaseId} Delete database #
GET /databases/{databaseId}/collections List collections #
POST /databases/{databaseId}/collections Create collections #
GET /databases/{databaseId}/collections/{collectionId} Get collection #
PUT /databases/{databaseId}/collections/{collectionId} Update collection #
DELETE /databases/{databaseId}/collections/{collectionId} Delete collection #
GET /databases/{databaseId}/collections/{collectionId}/attributes List attributes #
POST /databases/{databaseId}/collections/{collectionId}/attributes/bigint Create bigint attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/bigint/{key} Update bigint attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/boolean Create boolean attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/boolean/{key} Update boolean attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/datetime Create datetime attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/datetime/{key} Update datetime attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/email Create email attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/email/{key} Update email attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/enum Create enum attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/enum/{key} Update enum attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/float Create float attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/float/{key} Update float attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/integer Create integer attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/integer/{key} Update integer attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/ip Create IP address attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/ip/{key} Update IP address attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/line Create line attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/line/{key} Update line attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/longtext Create longtext attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/longtext/{key} Update longtext attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/mediumtext Create mediumtext attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/mediumtext/{key} Update mediumtext attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/point Create point attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/point/{key} Update point attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/polygon Create polygon attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/polygon/{key} Update polygon attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/relationship Create relationship attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/relationship/{key} Update relationship attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/string Create string attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/string/{key} Update string attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/text Create text attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/text/{key} Update text attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/url Create URL attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/url/{key} Update URL attribute #
POST /databases/{databaseId}/collections/{collectionId}/attributes/varchar Create varchar attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/attributes/varchar/{key} Update varchar attribute #
GET /databases/{databaseId}/collections/{collectionId}/attributes/{key} Get attribute #
DELETE /databases/{databaseId}/collections/{collectionId}/attributes/{key} Delete attribute #
GET /databases/{databaseId}/collections/{collectionId}/documents List documents #
POST /databases/{databaseId}/collections/{collectionId}/documents Create document #
PUT /databases/{databaseId}/collections/{collectionId}/documents Upsert documents #
PATCH /databases/{databaseId}/collections/{collectionId}/documents Update documents #
DELETE /databases/{databaseId}/collections/{collectionId}/documents Delete documents #
GET /databases/{databaseId}/collections/{collectionId}/documents/{documentId} Get document #
PUT /databases/{databaseId}/collections/{collectionId}/documents/{documentId} Upsert a document #
PATCH /databases/{databaseId}/collections/{collectionId}/documents/{documentId} Update document #
DELETE /databases/{databaseId}/collections/{collectionId}/documents/{documentId} Delete document #
PATCH /databases/{databaseId}/collections/{collectionId}/documents/{documentId}/{attribute}/decrement Decrement document attribute #
PATCH /databases/{databaseId}/collections/{collectionId}/documents/{documentId}/{attribute}/increment Increment document attribute #
GET /databases/{databaseId}/collections/{collectionId}/indexes List indexes #
POST /databases/{databaseId}/collections/{collectionId}/indexes Create index #
GET /databases/{databaseId}/collections/{collectionId}/indexes/{key} Get index #
DELETE /databases/{databaseId}/collections/{collectionId}/indexes/{key} Delete index #

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-databases-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-databases-overlay.yaml
🔗
PostmanCollection
https://raw.githubusercontent.com/api-evangelist/appwrite/refs/heads/main/postman/appwrite-databases-api.postman_collection.json
🔗
OpenCollection
https://raw.githubusercontent.com/api-evangelist/appwrite/refs/heads/main/collections/appwrite-databases-api.opencollection.json

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-databases-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-databases-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  version: 2.0.0
  title: Appwrite Databases 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 (263 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/appwrite/refs/heads/main/openapi/appwrite-databases-api-openapi.yml