Skip to main content
Workspace data is exposed as SQL tables across two 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.
Today only object and list data is queryable. Historic (point-in-time) values and activity/interaction data (emails, calendar events, and other interactions) 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;