agents.sql•545 B
CREATE TABLE agents (
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
name VARCHAR(255) NOT NULL,
description TEXT,
created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE agent_mcp_servers (
agent_id UUID NOT NULL,
server_id VARCHAR(255) NOT NULL,
PRIMARY KEY (agent_id, server_id),
FOREIGN KEY (agent_id) REFERENCES agents(id) ON DELETE CASCADE,
FOREIGN KEY (server_id) REFERENCES mcp_servers(id) ON DELETE CASCADE
);