Available data

Schemas, tables, and how to discover them

Workspace data is exposed as SQL tables across three queryable schemas:

• objects: one table per object, named by its slug. This is the default schema, so SELECT … FROM companies resolves to objects.companies.
• lists: one table per list, named by its slug. Each row is a list entry.
• activities: one table per activity, named by its slug. Each row is an activity record, e.g. activities.phone_calls.

Historic (point-in-time) values, email messages and calendar events aren’t exposed as tables yet, but support is planned.

Discovering the schema

Two introspection schemas are available: information_schema and a Postgres-compatible pg_catalog, so standard SQL tooling can discover tables and columns. These describe the schema, not your CRM data.

List all tables

SELECT table_schema, table_name FROM information_schema.tables
WHERE table_schema NOT IN ('information_schema', 'pg_catalog')
ORDER BY table_schema, table_name;

List all columns across all tables

SELECT table_schema, table_name, column_name, ordinal_position, data_type, is_nullable FROM information_schema.columns
WHERE table_schema IN ('objects', 'lists')
ORDER BY table_schema, table_name, ordinal_position;