| 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); |