About collections with the Data API
Collections store documents in databases. Collections are best for cases where your data isn’t fully structured, or where you don’t want to use a fixed schema. If your data is fully structured and you want to use a fixed schema, use tables instead.
Serverless (Vector) databases created after June 24, 2024 can have approximately 10 collections. Databases created before this date can have approximately 5 collections. The collection limit is based on the number of indexes.