How do I see the schema of a data table?

Run memberstack tables describe followed by the table key. This displays the table name, key, ID, access rules for CRUD operations, and all fields with their type, required status, and references.

What access rules can I set on a table?

Tables support four access rule levels for create, read, update, and delete operations. PUBLIC allows anyone, AUTHENTICATED requires login, AUTHENTICATED_OWN restricts access to a member's own records, and ADMIN_ONLY limits access to admins.

Can I reference a table by its key instead of its ID?

Yes. Most table commands accept either the table key (e.g., products) or the table ID (e.g., tbl_abc123). Using keys is shorter and easier to remember.

Tables | Memberstack CLI

memberstack tables <subcommand> [options]

tables list

List all data tables.

memberstack tables list

Example

$ memberstack tables list
[
  {
    "id": "tbl_abc123",
    "name": "Products",
    "key": "products",
    ...
  }
]

tables get

Get a data table by key or ID.

memberstack tables get <table_key>

Arguments

Argument	Description	Required
`table_key`	Table key or ID	Yes

Examples

memberstack tables get products
memberstack tables get tbl_abc123

tables describe

Show detailed schema information for a table.

memberstack tables describe <table_key>

Arguments

Argument	Description	Required
`table_key`	Table key or ID	Yes

Description

Displays the table name, key, ID, access rules (create, read, update, delete), and all fields with their type, required status, and references.

Example

$ memberstack tables describe products
Table: Products
  Key:  products
  ID:   tbl_abc123

Access Rules:
  Create:  ADMIN
  Read:    PUBLIC
  Update:  ADMIN
  Delete:  ADMIN

Fields:
  name        String    required
  price       Number    required
  category    String
  owner       Relation  → members

tables create

Create a new data table.

memberstack tables create [options]

Options

Option	Description	Required
`--name <name>`	Table name	Yes
`--key <key>`	Table key (unique identifier)	Yes
`--create-rule <rule>`	Access rule for creating records	No
`--read-rule <rule>`	Access rule for reading records	No
`--update-rule <rule>`	Access rule for updating records	No
`--delete-rule <rule>`	Access rule for deleting records	No

Access rule values: PUBLIC, AUTHENTICATED, AUTHENTICATED_OWN, ADMIN_ONLY

Examples

memberstack tables create --name "Products" --key products
memberstack tables create --name "Orders" --key orders --create-rule AUTHENTICATED --read-rule PUBLIC

tables update

Update a data table.

memberstack tables update <id> [options]

Arguments

Argument	Description	Required
`id`	Table ID	Yes

Options

Option	Description
`--name <name>`	Table name
`--create-rule <rule>`	Access rule for creating records
`--read-rule <rule>`	Access rule for reading records
`--update-rule <rule>`	Access rule for updating records
`--delete-rule <rule>`	Access rule for deleting records

Access rule values: PUBLIC, AUTHENTICATED, AUTHENTICATED_OWN, ADMIN_ONLY

Examples

memberstack tables update tbl_abc123 --name "Updated Products"
memberstack tables update tbl_abc123 --delete-rule ADMIN_ONLY --read-rule PUBLIC

tables delete

Delete a data table.

memberstack tables delete <id>

Arguments

Argument	Description	Required
`id`	Table ID	Yes

Example

memberstack tables delete tbl_abc123

Tables

tables list

Example

tables get

Arguments

Examples

tables describe

Arguments

Description

Example

tables create

Options

Examples

tables update

Arguments

Options

Examples

tables delete

Arguments

Example

FAQ

On this page