0001_initial_schema.sql•915 B
-- D1 Database Schema for BYOB MCP Tool Registry
DROP TABLE IF EXISTS tools;
CREATE TABLE tools (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL UNIQUE,
description TEXT NOT NULL,
-- JSON Schema definition for the tool's input parameters
input_schema TEXT NOT NULL,
-- Which container class to use (e.g., 'echo', 'jq')
container_class TEXT NOT NULL,
-- Optional: Container instance type (defaults to 'lite')
instance_type TEXT DEFAULT 'lite',
-- Optional: Default port the container exposes (defaults to 8080)
container_port INTEGER DEFAULT 8080,
-- Optional: Entrypoint command to run in container
entrypoint TEXT,
-- Creation timestamp
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);
-- Index for fast lookups by name
CREATE INDEX idx_tools_name ON tools(name);
-- Index for listing by container class
CREATE INDEX idx_tools_container_class ON tools(container_class);