Skip to main content
GET
/
api
/
database
/
tables
/
{tableName}
Get Table Schema
curl --request GET \
  --url https://api.example.com/api/database/tables/{tableName} \
  --header 'Authorization: Bearer <token>'
{
  "tableName": "posts",
  "columns": [
    {
      "name": "id",
      "type": "uuid",
      "nullable": false,
      "unique": true,
      "default": "gen_random_uuid()",
      "isPrimaryKey": true,
      "foreignKey": null
    },
    {
      "name": "title",
      "type": "string",
      "nullable": false,
      "unique": false,
      "default": null,
      "isPrimaryKey": false,
      "foreignKey": null
    },
    {
      "name": "userId",
      "type": "uuid",
      "nullable": false,
      "unique": false,
      "default": null,
      "isPrimaryKey": false,
      "foreignKey": {
        "table": "auth.users",
        "column": "id",
        "on_delete": "CASCADE"
      }
    }
  ]
}

Authorizations

​
Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

​
tableName
string
required

Response

Table schema

​
table_name
string
​
columns
object[]