Available data

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;

Introduction

Guides

Discovering the schema

List all tables

List all columns across all tables

​Discovering the schema

​List all tables

​List all columns across all tables

Discovering the schema

List all tables

List all columns across all tables