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
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
CREATE TABLE agent_session (id UUID PRIMARY KEY, list_hidden BOOLEAN NOT NULL DEFAULT FALSE, thread_id UUID);
CREATE TABLE agent_conversation_sessions (session_id UUID PRIMARY KEY, channel_id UUID, bot_id UUID);
CREATE TABLE comms_channel_agents (channel_id UUID, bot_id UUID, kind TEXT);
INSERT INTO agent_session (id, list_hidden, thread_id) VALUES
('00000000-0000-0000-0000-000000000001', TRUE, NULL),
('00000000-0000-0000-0000-000000000002', FALSE, NULL),
('00000000-0000-0000-0000-000000000003', FALSE, NULL),
('00000000-0000-0000-0000-000000000004', FALSE, NULL),
('00000000-0000-0000-0000-000000000005', TRUE, '00000000-0000-0000-0000-000000000006');
INSERT INTO agent_conversation_sessions (session_id, channel_id, bot_id) VALUES
('00000000-0000-0000-0000-000000000002', '00000000-0000-0000-0000-000000000007', '00000000-0000-0000-0000-000000000008'),
('00000000-0000-0000-0000-000000000003', '00000000-0000-0000-0000-000000000007', '00000000-0000-0000-0000-000000000008');
INSERT INTO comms_channel_agents (channel_id, bot_id, kind) VALUES
('00000000-0000-0000-0000-000000000007', '00000000-0000-0000-0000-000000000008', 'direct');