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 macro_user (id, username, email, stripe_customer_id)
VALUES
('a0000000-0000-0000-0000-000000000000', 'member', '[email protected]', 'cus_member'),
('a0000000-0000-0000-0000-000000000001', 'gabriel', '[email protected]', 'cus_gabriel'),
('a0000000-0000-0000-0000-000000000002', 'peter', '[email protected]', 'cus_peter'),
('a0000000-0000-0000-0000-000000000003', 'teo', '[email protected]', 'cus_teo'),
('a0000000-0000-0000-0000-000000000004', 'hollis', '[email protected]', 'cus_hollis');
INSERT INTO "User" (id, email, macro_user_id)
VALUES
('macro|[email protected]', '[email protected]', 'a0000000-0000-0000-0000-000000000000'),
('macro|[email protected]', '[email protected]', 'a0000000-0000-0000-0000-000000000001'),
('macro|[email protected]', '[email protected]', 'a0000000-0000-0000-0000-000000000002'),
('macro|[email protected]', '[email protected]', 'a0000000-0000-0000-0000-000000000003'),
('macro|[email protected]', '[email protected]', 'a0000000-0000-0000-0000-000000000004');
-- The member has no profile and [email protected] has no user row at all:
-- both fall back to the local part of their email.
INSERT INTO macro_user_info (macro_user_id, first_name, last_name)
VALUES
('a0000000-0000-0000-0000-000000000001', 'Gabriel', 'Birman'),
('a0000000-0000-0000-0000-000000000002', 'Peter', 'Chinman'),
('a0000000-0000-0000-0000-000000000003', 'Teo', 'Nys'),
('a0000000-0000-0000-0000-000000000004', 'Hollis', 'N/A');
INSERT INTO bots (id, kind, owner_user_id, name, handle, created_by)
VALUES
('b0000000-0000-0000-0000-000000000001', 'owned', 'macro|[email protected]', 'Deal Desk', 'deal-desk', 'macro|[email protected]');
INSERT INTO comms_channels (id, name, channel_type, owner_id, created_at, updated_at)
VALUES
('11111111-1111-1111-1111-111111111111', 'Macro', 'private', 'macro|[email protected]', '2024-01-01 10:00:00+00', '2024-12-01 10:00:00+00'),
('22222222-2222-2222-2222-222222222222', 'Macro Planning', 'private', 'macro|[email protected]', '2024-01-02 10:00:00+00', '2024-12-02 10:00:00+00'),
('33333333-3333-3333-3333-333333333333', 'Macaroni', 'private', 'macro|[email protected]', '2024-01-03 10:00:00+00', '2024-12-03 10:00:00+00'),
('44444444-4444-4444-4444-444444444444', 'Macro Secret', 'private', 'macro|[email protected]', '2024-01-04 10:00:00+00', '2024-12-04 10:00:00+00'),
('55555555-5555-5555-5555-555555555555', 'Macro Former', 'private', 'macro|[email protected]', '2024-01-05 10:00:00+00', '2024-12-05 10:00:00+00'),
('66666666-6666-6666-6666-666666666666', NULL, 'direct_message', 'macro|[email protected]', '2024-01-06 10:00:00+00', '2024-12-06 10:00:00+00'),
('77777777-7777-7777-7777-777777777777', NULL, 'private', 'macro|[email protected]', '2024-01-07 10:00:00+00', '2024-12-07 10:00:00+00'),
('88888888-8888-8888-8888-888888888888', NULL, 'direct_message', 'macro|[email protected]', '2024-01-08 10:00:00+00', '2024-12-08 10:00:00+00'),
('99999999-9999-9999-9999-999999999999', NULL, 'direct_message', 'macro|[email protected]', '2024-01-09 10:00:00+00', '2024-12-09 10:00:00+00'),
('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', NULL, 'direct_message', 'macro|[email protected]', '2024-01-10 10:00:00+00', '2024-12-10 10:00:00+00'),
('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb', 'Design Decks', 'public', 'macro|[email protected]', '2024-01-11 10:00:00+00', '2024-12-11 10:00:00+00'),
('cccccccc-cccc-cccc-cccc-cccccccccccc', NULL, 'direct_message', 'macro|[email protected]', '2024-01-12 10:00:00+00', '2024-12-12 10:00:00+00'),
('dddddddd-dddd-dddd-dddd-dddddddddddd', NULL, 'direct_message', 'macro|[email protected]', '2024-01-13 10:00:00+00', '2024-12-13 10:00:00+00');
INSERT INTO comms_channel_participants (channel_id, role, user_id, left_at)
VALUES
('11111111-1111-1111-1111-111111111111', 'owner', 'macro|[email protected]', NULL),
('22222222-2222-2222-2222-222222222222', 'owner', 'macro|[email protected]', NULL),
('33333333-3333-3333-3333-333333333333', 'owner', 'macro|[email protected]', NULL),
('44444444-4444-4444-4444-444444444444', 'owner', 'macro|[email protected]', NULL),
('55555555-5555-5555-5555-555555555555', 'owner', 'macro|[email protected]', '2024-06-01 10:00:00+00'),
('66666666-6666-6666-6666-666666666666', 'owner', 'macro|[email protected]', NULL),
('66666666-6666-6666-6666-666666666666', 'member', 'macro|[email protected]', NULL),
('77777777-7777-7777-7777-777777777777', 'owner', 'macro|[email protected]', NULL),
('77777777-7777-7777-7777-777777777777', 'member', 'macro|[email protected]', NULL),
('77777777-7777-7777-7777-777777777777', 'member', 'macro|[email protected]', NULL),
('88888888-8888-8888-8888-888888888888', 'owner', 'macro|[email protected]', NULL),
('88888888-8888-8888-8888-888888888888', 'member', 'macro|[email protected]', NULL),
('99999999-9999-9999-9999-999999999999', 'owner', 'macro|[email protected]', NULL),
('99999999-9999-9999-9999-999999999999', 'member', 'bot|00000000-0000-0000-0000-00000000c0de', NULL),
('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'owner', 'macro|[email protected]', NULL),
('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'member', 'bot|b0000000-0000-0000-0000-000000000001', NULL),
('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb', 'owner', 'macro|[email protected]', NULL),
('cccccccc-cccc-cccc-cccc-cccccccccccc', 'owner', 'macro|[email protected]', NULL),
('cccccccc-cccc-cccc-cccc-cccccccccccc', 'member', 'macro|[email protected]', NULL),
-- A bot with no `bots` row (deleted or unknown) shows as "Bot".
('dddddddd-dddd-dddd-dddd-dddddddddddd', 'owner', 'macro|[email protected]', NULL),
('dddddddd-dddd-dddd-dddd-dddddddddddd', 'member', 'bot|b0000000-0000-0000-0000-000000000002', NULL);