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 public."macro_user" ("id", "username", "email", "stripe_customer_id")
VALUES ('a1111111-1111-1111-1111-111111111111', 'user', '[email protected]', 'stripe_id');
INSERT INTO public."User" ("id","email","stripeCustomerId","macro_user_id")
VALUES ('macro|[email protected]', '[email protected]','stripe_id','a1111111-1111-1111-1111-111111111111');
-- Test Documents
INSERT INTO public."Document" ("id","name","fileType", "owner")
VALUES ('d0000001-0000-0000-0000-000000000001', 'test_document_name','pdf', 'macro|[email protected]');
INSERT INTO public."Document" ("id","name","fileType", "owner")
VALUES ('d0000002-0000-0000-0000-000000000002', 'test_document_name','pdf', 'macro|[email protected]');
INSERT INTO public."Document" ("id","name","fileType", "owner")
VALUES ('d0000003-0000-0000-0000-000000000003', 'test_document_name','pdf', 'macro|[email protected]');
-- Test Chats
INSERT INTO public."Chat" ("id","name","userId", "model", "createdAt", "updatedAt")
VALUES ('chat-one', 'test-chat', 'macro|[email protected]', 'gpt-4o', '2019-10-16 00:00:00', '2019-10-16 00:00:00');
INSERT INTO public."Chat" ("id","name","userId", "model", "createdAt", "updatedAt")
VALUES ('chat-two', 'test-chat 2', 'macro|[email protected]', 'gpt-4o', '2019-10-16 00:00:01', '2019-10-16 00:00:01');
INSERT INTO public."Chat" ("id","name","userId", "model", "createdAt", "updatedAt")
VALUES ('chat-three', 'test-chat 3', 'macro|[email protected]', 'gpt-4o', '2019-10-16 00:00:01', '2019-10-16 00:00:01');
-- Chat Messages
INSERT INTO public."ChatMessage" ("id", "content", "role", "chatId")
VALUES ('message-one', '"test-chat message"', 'system', 'chat-three');
INSERT INTO public."ChatMessage" ("id", "content", "role", "chatId")
VALUES ('message-two', '"test-chat message 2"', 'user', 'chat-three');
-- Chat attachments on both chat
INSERT INTO public."ChatAttachment" ("id", "chatId", "entity_type", "entity_id")
VALUES ('chat-attachment-one', 'chat-one', 'document', 'd0000002-0000-0000-0000-000000000002');
INSERT INTO public."ChatAttachment" ("id", "chatId", "entity_type", "entity_id")
VALUES ('chat-attachment-two', 'chat-one', 'document', 'd0000002-0000-0000-0000-000000000002');
INSERT INTO public."ChatAttachment" ("id", "chatId", "entity_type", "entity_id")
VALUES ('chat-attachment-six', 'chat-two', 'document', 'd0000002-0000-0000-0000-000000000002');
-- Chat attachments on messages
INSERT INTO public."ChatAttachment" ("id", "messageId", "entity_type", "entity_id")
VALUES ('chat-attachment-three', 'message-one', 'document', 'd0000001-0000-0000-0000-000000000001');
INSERT INTO public."ChatAttachment" ("id", "messageId", "entity_type", "entity_id")
VALUES ('chat-attachment-four', 'message-one', 'document', 'd0000002-0000-0000-0000-000000000002');
INSERT INTO public."ChatAttachment" ("id", "messageId", "entity_type", "entity_id")
VALUES ('chat-attachment-five', 'message-one', 'document', 'd0000003-0000-0000-0000-000000000003');