Execute SQL SELECT queries against Solr (advanced).

Prefer the search tool for Lucene/full-text queries. Use this when you need Solr's SQL interface explicitly.

Collection/Field Rules:

• Collections are used as table names (case-insensitive)

• Field names are case-sensitive and must exist in Solr schema

• SELECT * only allowed with LIMIT clause

• Unlimited queries restricted to docValues-enabled fields

• Reserved words must be backtick-escaped

WHERE Clause Differences:

• Field must be on one side of predicate

• No comparing two constants or two fields

• No subqueries

• Solr syntax in values:

  • '[0 TO 100]' for ranges

  • '(term1 term2)' for non-phrase OR search

• String literals use single-quotes

Supported Features:

• Operators: =, <>, >, >=, <, <=, IN, LIKE (wildcards), BETWEEN, IS [NOT] NULL

• Functions: COUNT(*), COUNT(DISTINCT), MIN, MAX, SUM, AVG

• GROUP BY: Uses faceting (fast) for low cardinality, map_reduce (slow) for high cardinality

• ORDER BY: Requires docValues-enabled fields

• LIMIT/OFFSET: Use 'OFFSET x FETCH NEXT y ROWS ONLY' syntax

  • Performance of OFFSET degrades beyond 10k docs per shard

Parameters:

• query: SQL query to execute

Semantic (vector) search combined with SQL filtering (advanced).

Extends sql-select with semantic search: natural language text is embedded and matched against a dense_vector/knn_vector field. Results rank by similarity; ORDER BY is not allowed in query.

Parameters:

• query: SQL query to execute

• text: Natural language text converted to a vector for similarity search

• field: Vector field name (optional; auto-detected when omitted)

• vector_provider: Optional model@host:port (e.g. nomic-embed-text@localhost:11434)

Vector similarity search combined with SQL filtering (advanced).

Extends sql-select with a query vector matched against a dense_vector/knn_vector field. ORDER BY is not allowed in query.

Parameters:

• query: SQL query to execute

• vector: Query vector (dimensions must match the vector field)

• field: Vector field name (optional; auto-detected when omitted)

Retrieve schema information for a Solr collection.

Returns field definitions, field types, and copy-field relationships from the Schema API. Call this before search when you need valid field names or types.

Parameters:

• collection: Solr collection name

Get the default embedding model used for semantic-select.

Returns model name, vector dimensionality, and service URL. Use this to ensure Solr vector fields match the embedding model dimensions.

List all available Solr collections in the cluster.

Full-text search with filtering, faceting, sorting, and pagination.

Queries Solr's /select handler using Lucene syntax. This is the preferred tool for natural-language questions about document content.

Parameters:

• collection: Solr collection name

• query: Main query q (Lucene syntax). Defaults to *:* when omitted.

• filter_queries: Optional filter queries (fq), applied without affecting score

• facet_fields: Field names to facet on (enables facet=true)

• sort: Solr sort clause, e.g. score desc or year_i desc

• start: Pagination offset (default 0)

• rows: Number of documents to return (default 10)

• fields: Restrict returned stored fields (fl). Omit to return the default set.

Examples:

• collection=films, query=title:star AND genre_s:sci-fi

• collection=films, query=*:*, filter_queries=['year_i:[2000 TO *]']