user_directory

1 row

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ user_id room_id display_name avatar_url
1 1 @james:matrix.jamesst.one   james  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "user_directory" ( user_id TEXT NOT NULL, room_id TEXT, display_name TEXT, avatar_url TEXT );
CREATE INDEX user_directory_room_idx ON user_directory(room_id);
CREATE UNIQUE INDEX user_directory_user_idx ON user_directory(user_id);