introspect_connection
Read and cache a database's schema (tables, columns, foreign keys) for a given connection. Refresh after schema changes to update the cache used by list and describe tools.
Instructions
Read the target database's structure (tables, columns, foreign keys) and cache it.
Run once per connection before querying, and again after the schema changes. Idempotent — re-running refreshes the cache. The cache is what list_tables, describe_table, and get_semantic_context read from. Returns counts of cached objects plus the number of embeddings generated.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connection | Yes | Target database connection — its name or id (case-insensitive). List the available connections with list_connections. | |
| generate_embeddings | No | Also build vector embeddings for semantic schema search. Needs an embedding provider; otherwise keyword matching is used. |