vw_model_capabilities

Creates, updates, deletes, gets or lists a vw_model_capabilities resource.

Overview

Name	vw_model_capabilities
Type	View
Id	anthropic.models.vw_model_capabilities

Fields

The following fields are returned by this view:

Name	Datatype	Description
id	string	Unique model identifier, e.g. claude-sonnet-5.
display_name	string	Human-readable name of the model.
batch	boolean	Whether the model supports the Message Batches API.
citations	boolean	Whether the model supports citations.
code_execution	boolean	Whether the model supports the code execution tool.
context_management	boolean	Whether the model supports context management.
effort	boolean	Whether the model supports the effort parameter.
xhigh	boolean	Whether the xhigh effort tier is supported.
high	boolean	Whether the high effort tier is supported.
max	boolean	Whether the max effort tier is supported.
medium	boolean	Whether the medium effort tier is supported.
low	boolean	Whether the low effort tier is supported.
image_input	boolean	Whether the model accepts image input.
pdf_input	boolean	Whether the model accepts PDF input.
structured_outputs	boolean	Whether the model supports structured outputs.
thinking	boolean	Whether the model supports extended thinking.
adaptive	boolean	Whether adaptive thinking is supported.
enabled	boolean	Whether manually-enabled thinking is supported.
created_at	string	RFC 3339 timestamp when the model was released.
max_input_tokens	integer	Maximum number of input tokens accepted by the model.
max_tokens	integer	Maximum number of output tokens the model can generate.
type	string	Object type; always model.

SELECT Examples

SELECT
  id,
  display_name,
  batch,
  citations,
  code_execution,
  context_management,
  effort,
  xhigh,
  high,
  max,
  medium,
  low,
  image_input,
  pdf_input,
  structured_outputs,
  thinking,
  adaptive,
  enabled,
  created_at,
  max_input_tokens,
  max_tokens,
  type
FROM anthropic.models.vw_model_capabilities;

SQL Definition

Sqlite3

SELECT
  id,
  display_name,
  JSON_EXTRACT(capabilities, '$.batch.supported') AS batch,
  JSON_EXTRACT(capabilities, '$.citations.supported') AS citations,
  JSON_EXTRACT(capabilities, '$.code_execution.supported') AS code_execution,
  JSON_EXTRACT(capabilities, '$.context_management.supported') AS context_management,
  JSON_EXTRACT(capabilities, '$.effort.supported') AS effort,
  JSON_EXTRACT(capabilities, '$.effort.xhigh.supported') AS xhigh,
  JSON_EXTRACT(capabilities, '$.effort.high.supported') AS high,
  JSON_EXTRACT(capabilities, '$.effort.max.supported') AS max,
  JSON_EXTRACT(capabilities, '$.effort.medium.supported') AS medium,
  JSON_EXTRACT(capabilities, '$.effort.low.supported') AS low,
  JSON_EXTRACT(capabilities, '$.image_input.supported') AS image_input,
  JSON_EXTRACT(capabilities, '$.pdf_input.supported') AS pdf_input,
  JSON_EXTRACT(capabilities, '$.structured_outputs.supported') AS structured_outputs,
  JSON_EXTRACT(capabilities, '$.thinking.supported') AS thinking,
  JSON_EXTRACT(capabilities, '$.thinking.types.adaptive.supported') AS adaptive,
  JSON_EXTRACT(capabilities, '$.thinking.types.enabled.supported') AS enabled,
  created_at,
  max_input_tokens,
  max_tokens,
  type
FROM anthropic.models.models

Postgres

SELECT
  id,
  display_name,
  json_extract_path_text(capabilities::json, 'batch', 'supported') AS batch,
  json_extract_path_text(capabilities::json, 'citations', 'supported') AS citations,
  json_extract_path_text(capabilities::json, 'code_execution', 'supported') AS code_execution,
  json_extract_path_text(capabilities::json, 'context_management', 'supported') AS context_management,
  json_extract_path_text(capabilities::json, 'effort', 'supported') AS effort,
  json_extract_path_text(capabilities::json, 'effort', 'xhigh', 'supported') AS xhigh,
  json_extract_path_text(capabilities::json, 'effort', 'high', 'supported') AS high,
  json_extract_path_text(capabilities::json, 'effort', 'max', 'supported') AS max,
  json_extract_path_text(capabilities::json, 'effort', 'medium', 'supported') AS medium,
  json_extract_path_text(capabilities::json, 'effort', 'low', 'supported') AS low,
  json_extract_path_text(capabilities::json, 'image_input', 'supported') AS image_input,
  json_extract_path_text(capabilities::json, 'pdf_input', 'supported') AS pdf_input,
  json_extract_path_text(capabilities::json, 'structured_outputs', 'supported') AS structured_outputs,
  json_extract_path_text(capabilities::json, 'thinking', 'supported') AS thinking,
  json_extract_path_text(capabilities::json, 'thinking', 'types', 'adaptive', 'supported') AS adaptive,
  json_extract_path_text(capabilities::json, 'thinking', 'types', 'enabled', 'supported') AS enabled,
  created_at,
  max_input_tokens,
  max_tokens,
  type
FROM anthropic.models.models