ClickHouse icon

ClickHouse

Query, insert, update, delete, and manage ClickHouse tables. Supports AI agent tool use with schema discovery, auto-pagination for large results, and parameterized queries.

Actions11

Get Table Info

AI-generated

Summary

Retrieves metadata for a ClickHouse table, including engine, size, and optional column schema.

Inputs

  • table (required) — The table to get info for. Choose from the list, or specify an ID using an expression.
  • options — Additional options such as overriding the database or including column information.

Output shape

single JSON object containing table metadata; optionally includes a columns array when Include Columns is enabled.

If Include Columns is true the response adds a columns field with column definitions; otherwise only basic table properties are returned. The operation returns an error if the table does not exist.

Examples

Example 1: Fetch schema for the `events` table

Set Table Name to events; ensure Include Columns is enabled (default).

Example 2: Check only basic table info without column details

Set Table Name to logs and set Include Columns to false.

Links

Discussion