list_tables
List all cached tables in a database connection, returning column details, types, and row estimates. Use for a quick schema overview before exploring relationships with describe_table.
Instructions
List a connection's cached tables, each with its columns.
Returns name, type, comment, row-count estimate, and per-column details (type, nullability, primary key). Reads the cache from introspect_connection (run that first if the result is empty). Use for a schema-wide overview; for one table's foreign keys and relationships, use describe_table. Read-only.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connection | Yes | Target database connection — its name or id (case-insensitive). List the available connections with list_connections. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |