db_search
Search your database knowledge layer for tables and columns matching a query. BM25 ranking returns relevant results with descriptions and highlighted snippets.
Instructions
Search the knowledge layer for tables/columns matching a query — BM25-ranked.
Use this BEFORE db_list_tables when you're looking for a specific concept
(e.g. "payments", "user email", "shipping address"). db_list_tables returns
every table; db_search returns just the relevant ones with descriptions and
highlighted snippets.
Searches across:
- Table names, descriptions, and aliases
- Column names, descriptions, and enum_values
Falls back gracefully to empty results if the query has invalid FTS5 syntax.
Args:
query: Search text. Supports FTS5 syntax: phrases ("foo bar"),
prefix matching (pay*), boolean operators (foo AND bar).
connection: Connection name. Defaults to first defined.
target: "tables", "columns", or "all" (default).
limit: Max results to return (default 10).
Returns:
{query, connection, target, result_count, results: [
{target_type, table_fqn, column_name, description, snippet, score}, ...
]}
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | ||
| connection | No | ||
| target | No | all | |
| limit | No |