{"id":"tables_schema","name":"Tables Schema","alias":"TablesSchema","aliases":[],"description_short":"Agent that retrieves the schema (field names and types) for a given table","description_long":"List all fields from a given table, including enum values when known.","description_tool_prompt":"List all fields (names, types, and enum values when known) from a given table. When a field has `enum`, use those values in filters. If `bitmask` is true, test nonzero flags with `column & value != 0` (values are combinable); for a zero/no-flags value, use `column = 0`.","source":null,"conversation_examples":[],"tags":[],"available_in_chat":false,"available_in_deepthink":true,"available_in_mcp":true,"mcp_audience":"all","config":{"type":"object","properties":{},"required":[]},"item":{"type":"object","properties":{"table_name":{"description":"Name of the table to get schema for. Wildcard not allowed.","title":"Table Name","type":"string"}},"required":["table_name"]},"response":{"$defs":{"TableField":{"properties":{"name":{"title":"Name","type":"string"},"type":{"title":"Type","type":"string"},"mode":{"title":"Mode","type":"string"},"fields":{"anyOf":[{"items":{"$ref":"#/$defs/TableField"},"type":"array"},{"type":"null"}],"default":null,"title":"Fields"},"description":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"description":"Optional documentation for this field","title":"Description"},"enum":{"anyOf":[{"items":{"$ref":"#/$defs/TableFieldEnumValue"},"type":"array"},{"type":"null"}],"default":null,"description":"Known discrete values for this field. Each entry has value, name, and optional extra. Absent when the field is not an enum.","title":"Enum"},"bitmask":{"anyOf":[{"type":"boolean"},{"type":"null"}],"default":null,"description":"If true, enum values are combinable flags. Test a nonzero flag with `column & value != 0`; for a zero/no-flags value, use `column = 0`.","title":"Bitmask"}},"required":["name","type","mode"],"title":"TableField","type":"object"},"TableFieldEnumValue":{"description":"One known discrete value of a table field (regular enum or bitmask flag).","properties":{"value":{"anyOf":[{"type":"integer"},{"type":"string"}],"title":"Value"},"name":{"title":"Name","type":"string"},"extra":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"title":"Extra"}},"required":["value","name"],"title":"TableFieldEnumValue","type":"object"}},"properties":{"table_name":{"description":"Name of the table","title":"Table Name","type":"string"},"fields":{"description":"List of field definitions with name, type, and enum values when known","items":{"$ref":"#/$defs/TableField"},"title":"Fields","type":"array"},"found":{"description":"Whether the table was found in the available tables","title":"Found","type":"boolean"}},"required":["table_name","fields","found"],"title":"TablesSchemaProcessedItem","type":"object"},"has_canvas":false,"open_canvas_automatically":false}