Modulify

List database collections

list_collections

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

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.

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.