Complete setup guide for deploying Background Agents in your enterprise environment
This guide walks you through the complete setup process for deploying Background Agents in your enterprise environment, including system requirements, configuration, and initial testing.
-- init.sqlCREATE DATABASE background_agents;CREATE USER context_agent WITH ENCRYPTED PASSWORD 'your_secure_password';GRANT ALL PRIVILEGES ON DATABASE background_agents TO context_agent;\c background_agents;-- Create required tablesCREATE EXTENSION IF NOT EXISTS "uuid-ossp";CREATE TABLE agent_tasks ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), task_type VARCHAR(100) NOT NULL, status VARCHAR(50) NOT NULL DEFAULT 'pending', priority INTEGER DEFAULT 5, input_data JSONB NOT NULL, output_data JSONB, progress_percentage INTEGER DEFAULT 0, error_message TEXT, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), completed_at TIMESTAMP WITH TIME ZONE, created_by VARCHAR(255) NOT NULL, organization_id VARCHAR(100) NOT NULL);CREATE TABLE agent_logs ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), task_id UUID REFERENCES agent_tasks(id), level VARCHAR(20) NOT NULL, message TEXT NOT NULL, metadata JSONB, timestamp TIMESTAMP WITH TIME ZONE DEFAULT NOW());CREATE INDEX idx_agent_tasks_status ON agent_tasks(status);CREATE INDEX idx_agent_tasks_created_at ON agent_tasks(created_at);CREATE INDEX idx_agent_tasks_org ON agent_tasks(organization_id);CREATE INDEX idx_agent_logs_task_id ON agent_logs(task_id);