Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.
TypeScript agentaiai-agentsall-in-onecrmcrm-systememaillinearmcpmessagingnotesnotionofficerustslackslack-alternativestartupstartup-toolstypescriptworkspace
INSERT INTO comms_channels (id, name, channel_type, org_id, owner_id)
VALUES ('11111111-1111-1111-1111-111111111111', 'Test Public Channel', 'public', NULL, 'owner1'),
('22222222-2222-2222-2222-222222222222', 'Test Organization Channel', 'private', NULL, 'owner2'),
('33333333-3333-3333-3333-333333333333', 'Test Private Channel', 'private', NULL, 'owner3');
INSERT INTO comms_channel_participants (channel_id, role, user_id)
VALUES ('11111111-1111-1111-1111-111111111111', 'owner', 'user1'),
('11111111-1111-1111-1111-111111111111', 'member', 'user2'),
('11111111-1111-1111-1111-111111111111', 'member', 'user3'),
('22222222-2222-2222-2222-222222222222', 'owner', 'user3'),
('22222222-2222-2222-2222-222222222222', 'member', 'user4'),
('33333333-3333-3333-3333-333333333333', 'owner', 'user5');
INSERT INTO comms_messages (id, parent_entity_type, parent_entity_id, sender_id, content, thread_id)
VALUES ('11111111-1111-1111-1111-111111111111', 'channel', '11111111-1111-1111-1111-111111111111', 'user1', 'Test message 1',
NULL);
INSERT INTO comms_entity_mentions (id, source_entity_type, source_entity_id, entity_type, entity_id)
VALUES ('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'message', '11111111-1111-1111-1111-111111111111', 'user', 'user1');