Search database schema
search_schemaRetrieve relevant database tables, columns, types, and relationships by performing a semantic search over a stored schema index using a natural-language question.
Instructions
Semantic search over the database schema stored in Pinecone. Call this FIRST for any text-to-SQL request: pass the user question verbatim and you get back the relevant tables, columns, types and relationships to write the query against.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top_k | No | How many schema chunks to retrieve (default 8). | |
| tables | No | Restrict the search to these table names, when you already know them. | |
| database | No | Restrict to one database/schema — omit to search all of them. | |
| question | Yes | The natural-language data question, e.g. "top 10 accounts by transaction volume last month". | |
| namespace | No | Pinecone namespace override. |