# Appwrite TablesDB API

**Canonical:** https://apis.io/apis/appwrite/appwrite-tablesdb-api/  
**Provider:** Appwrite — https://apis.io/providers/appwrite/  
**Base URL:** https://cloud.appwrite.io/v1  
**Documentation:** https://appwrite.io/docs/references

Appwrite TablesDB API is one of 44 APIs that [Appwrite](https://apis.io/providers/appwrite/) publishes on the [APIs.io](https://apis.io/) network, described by a machine-readable OpenAPI specification. Tagged areas include Databases. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, an API reference, and a GitHub repository.

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.

## Operations (60 of 80)

| Method | Path | Summary |
|---|---|---|
| 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 |

…and 20 more operations. They are listed in full on the page.

## Machine-readable artifacts (5)

- **OpenAPI** — https://raw.githubusercontent.com/api-evangelist/appwrite/refs/heads/main/openapi/appwrite-tablesdb-api-openapi.yml
- **Overlay** — https://raw.githubusercontent.com/api-evangelist/appwrite/refs/heads/main/overlays/appwrite-tablesdb-overlay.yaml
- **Documentation** — https://appwrite.io/docs
- **APIReference** — https://appwrite.io/docs/references
- **GitHubRepository** — https://github.com/appwrite/appwrite

## Other Appwrite APIs (12)

- [Appwrite Project API](https://apis.io/apis/appwrite/appwrite-project-api/)
- [Appwrite Account API](https://apis.io/apis/appwrite/appwrite-account-api/)
- [Appwrite Databases API](https://apis.io/apis/appwrite/appwrite-databases-api/)
- [Appwrite Domains API](https://apis.io/apis/appwrite/appwrite-domains-api/)
- [Appwrite Messaging API](https://apis.io/apis/appwrite/appwrite-messaging-api/)
- [Appwrite Organizations API](https://apis.io/apis/appwrite/appwrite-organizations-api/)
- [Appwrite Users API](https://apis.io/apis/appwrite/appwrite-users-api/)
- [Appwrite PostgreSQL API](https://apis.io/apis/appwrite/appwrite-postgresql-api/)
- [Appwrite DocumentsDB API](https://apis.io/apis/appwrite/appwrite-documentsdb-api/)
- [Appwrite VectorsDB API](https://apis.io/apis/appwrite/appwrite-vectorsdb-api/)
- [Appwrite MySQL API](https://apis.io/apis/appwrite/appwrite-mysql-api/)
- [Appwrite MongoDB API](https://apis.io/apis/appwrite/appwrite-mongo-api/)

## Tags

Databases

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/apis/appwrite/appwrite-tablesdb-api/). The API's provider profile, Kin Score and agent-readiness rating are at https://apis.io/providers/appwrite/.