looker-get-connection-table-columns

A “looker-get-connection-table-columns” tool returns all the columns for each table specified.

About

A looker-get-connection-table-columns tool returns all the columnes for each table specified.

It’s compatible with the following sources:

looker-get-connection-table-columns accepts a conn parameter, a schema parameter, a tables parameter with a comma separated list of tables, and an optional db parameter.

Example

tools:
    get_connection_table_columns:
        kind: looker-get-connection-table-columns
        source: looker-source
        description: |
          This tool retrieves a list of columns for one or more specified tables within a
          given database schema and connection.

          Parameters:
          - connection_name (required): The name of the database connection, obtained from `get_connections`.
          - schema (required): The name of the schema where the tables reside, obtained from `get_connection_schemas`.
          - tables (required): A comma-separated string of table names for which to retrieve columns
            (e.g., "users,orders,products"), obtained from `get_connection_tables`.
          - database (optional): The name of the database to filter by. Only applicable for connections
            that support multiple databases (check with `get_connections`).

          Output:
          A JSON array of objects, where each object represents a column and contains details
          such as `table_name`, `column_name`, `data_type`, and `is_nullable`.

Reference

fieldtyperequireddescription
kindstringtrueMust be “looker-get-connection-table-columns”.
sourcestringtrueName of the source Looker instance.
descriptionstringtrueDescription of the tool that is passed to the LLM.
Last modified December 19, 2025: chore(main): release 0.24.0 (#2162) (f520b4e)