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 database to pass to describe_object or run_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.