AgentServer/apps/server/drizzle/0004_mcp_servers.sql

CREATE TABLE `mcp_servers` (
	`id` text PRIMARY KEY NOT NULL,
	`name` text NOT NULL,
	`title` text NOT NULL,
	`description` text DEFAULT '' NOT NULL,
	`transport` text NOT NULL,
	`enabled` integer DEFAULT true NOT NULL,
	`url` text DEFAULT '' NOT NULL,
	`headers` text DEFAULT '{}' NOT NULL,
	`command` text DEFAULT '' NOT NULL,
	`args` text DEFAULT '[]' NOT NULL,
	`env` text DEFAULT '{}' NOT NULL,
	`allow_network` integer DEFAULT false NOT NULL,
	`read_paths` text DEFAULT '[]' NOT NULL,
	`write_paths` text DEFAULT '[]' NOT NULL,
	`tool_policies` text DEFAULT '{}' NOT NULL,
	`tools_cache` text DEFAULT '[]' NOT NULL,
	`tools_updated_at` text,
	`created_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL,
	`updated_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `mcp_servers_name_unique` ON `mcp_servers` (`name`);--> statement-breakpoint
ALTER TABLE `profiles` ADD `mcp_server_ids` text DEFAULT '[]' NOT NULL;