Add tool definition generation from entity schemas #243
Description
Context
Compass knows the schema of every table, the parameters of every API, and the structure of every dataset. It can auto-generate tool/function definitions that let AI agents interact with those entities directly.
Scope
- New endpoint that generates tool/function definitions from entity schemas
- Output formats: OpenAPI tool spec, MCP tool definition, JSON Schema
- For tables: generate query tool definitions with column names, types, and descriptions as parameters
- For APIs: generate call tool definitions from stored API schemas
- Configurable scope: per-entity, per-namespace, or per-service
Why
Instead of an AI agent needing custom integration code for every data source, Compass can generate the tool definitions automatically. The agent connects to Compass's MCP server and gets tools for interacting with any entity in the catalog.