Connections · stop 6 of 12
search_all_databases
Finds which database holds a table, across every connection.
Works in read modeTool sets: query · meta · full
You might ask
“Which of our databases has the subscriptions table?”
Your assistant may call search_all_databases to answer.
How it works
- Searches every saved profile and every database it can reach (20 pairs by default).
- Databases without a schema index are indexed on first search, so the first call can take longer.
- Each hit carries the
databaseto pass todescribe_objectorrun_select.
Parameters
querystringrequired- Table/view name or keyword to search across all connections and databases.
limit_connectionsnumber- Max connection/database pairs to search. Default 20.
limit_per_databasenumber- Max hits per connection/database pair. Default 3.
What your assistant reads
The description nexql-mcp sends with the tool. It's how the assistant decides when to use it.
Cross-database schema search: find which connection/database owns a table or view across every configured profile and every database it can connect to. Databases without a schema index are indexed on first search. Query a hit with run_select's `database` argument.