MinCPionS / sql /create_tools.sql
KoRiF
implement MCP server search engine
4dc29ae
raw
history blame contribute delete
392 Bytes
CREATE TABLE IF NOT EXISTS tools (
space_id TEXT NOT NULL,
tool_name TEXT NOT NULL,
description TEXT,
input_schema TEXT, -- JSON schema
output_type TEXT,
endpoint_type TEXT DEFAULT 'schema',
FOREIGN KEY(space_id) REFERENCES spaces(space_id) ON DELETE CASCADE,
PRIMARY KEY (space_id, tool_name)
);
CREATE INDEX IF NOT EXISTS idx_tool_name ON tools(tool_name);