> ## Documentation Index
> Fetch the complete documentation index at: https://docs.attio.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Available data

> Schemas, tables, and how to discover them

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

* `objects`: one table per object, named by its [slug](/docs/slugs-and-ids). 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

```sql theme={"system"}
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

```sql theme={"system"}
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;
```