> For the complete documentation index, see [llms.txt](https://codemash.gitbook.io/codemash/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://codemash.gitbook.io/codemash/cloud/database/collections.md).

# Collections

The list of your collections — each one a schema with its records, triggers and settings.

**Where:** Database → Collections · `/projects/<project>/db/collections`

A **collection** is a named set of records, like a table. Its **schema** sets which fields a record has and how the record form looks, so a collection and its schema are one thing: there is no separate "create collection" step. The list shows every schema of the environment you are working in (PROD when you chose none).

<figure><img src="https://712692422-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FHy372bqsaex2cqS3ikhL%2Fuploads%2Fgit-blob-cd8b993e281051185d3d8f898007b26ee444fd73%2Fcollections-list-1.png?alt=media" alt="Data Collections list with three rows: books (Published · v1, a flame icon in Triggers), archive_2024 (Published · v1) and authors (Published · v1), each with a row menu; below it the section Schemas under development with one row, reviews, and an Edit link; Add New at the top right"><figcaption><p>Database → Collections: published collections on top, schemas that were never published below.</p></figcaption></figure>

## Columns, search and filters

| Column     | What it shows                                                                                                                                                    |
| ---------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Name       | The collection (schema) name. Click it to open the collection's [records](/codemash/cloud/database/collections/records.md).                                      |
| Status     | `Published · v2`, or `Published · v2 · draft pending` when a newer draft is saved but not published yet.                                                         |
| Triggers   | A flame icon when the collection has [schema triggers](/codemash/cloud/database/collections/schema-triggers.md). Click it to open the schema's **Triggers** tab. |
| (row menu) | **Edit schema** — opens the schema builder, see [Edit a schema](/codemash/cloud/database/collections/edit-schema.md).                                            |

**Schemas under development** lists the schemas that were never published, each with **Edit**. Publish one to start adding records to it. The list has no search box or filters. **Add New** (top right) opens the schema builder for a new collection.

Reading the list needs `database:read`; creating a schema needs `database:create` on `database:schema:all`.

## What you can do here

* [Create a schema](/codemash/cloud/database/collections/create-schema.md) — **Add New**: a new collection with its fields and form.
* [Edit a schema](/codemash/cloud/database/collections/edit-schema.md) — row menu → **Edit schema**: change fields, publish a new version, change the collection settings, or delete the schema.
* [Schema triggers](/codemash/cloud/database/collections/schema-triggers.md) — send an email, push, SMS, webhook call or realtime event when a record changes.
* [Records list columns and index warnings](/codemash/cloud/database/collections/schema-indexes.md) — choose the records-list columns and the default sort.
* [Records](/codemash/cloud/database/collections/records.md) — click a collection name: browse its records.
* [Add or edit a record](/codemash/cloud/database/collections/add-records.md) · [Delete a record](/codemash/cloud/database/collections/delete-record.md)