Skip to main content
Version: 26.2 Preview

SHOW AI PROVIDERS

Lists the registered AI providers, one row per provider. The api_key column is always masked. Results can be filtered by name pattern or by provider type.

Syntax

SHOW AI PROVIDERS [ LIKE '<pattern>' | TYPE { embedding | rerank | text } ]

Parameters

ParameterDescription
LIKE '<pattern>'Only show providers whose name matches the SQL LIKE pattern.
TYPE <type>Only show providers of the given type (embedding, rerank, or text).

Return columns

ColumnDescription
NameProvider name.
TypeProvider type (embedding / rerank / text).
IsDefaultWhether this provider is the default for its type (true/false).
EndpointEndpoint URL.
ModelModel name.
DimensionsEmbedding dimension (embedding providers).
MaxDocumentsMax documents per rerank request (rerank providers).
TimeoutMsPer-request HTTP timeout in milliseconds.
ApiKeyMasked API key.
CommentProvider comment.

Examples

SHOW AI PROVIDERS;
SHOW AI PROVIDERS LIKE 'open%';
SHOW AI PROVIDERS TYPE rerank;

See also