# list_collections

Source: https://modulify.ai/docs/mcp/database/list-collections

Lists the tables in a site database with an exact row count for each.

- Title: List database collections
- Scope: `data:read`
- Access: Read only

This is the starting point for any question about the content stored in a site. Each table comes back with its `schema`, `name` and `rowCount`, and the `schema` and `name` are what the other data tools take.

Link tables that hold nothing but two foreign keys, and the join tables behind multi-reference fields, are left out unless you pass `includeHidden`, because they are plumbing rather than content. When you do, they come back with `isHidden` set to true. The field metadata table, `_collection_fields`, is never listed. See [The CMS](https://modulify.ai/docs/data/cms).

## Inputs

| Input | Type | Required | Description |
| --- | --- | --- | --- |
| `projectId` | string | Yes | The site id. |
| `includeHidden` | boolean | No | Also lists the internal link tables that join two collections together. Off by default. |