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

List Databases

AI-generated

Summary

List databases matching a SQL LIKE pattern

Inputs

  • pattern — Filter database names using a SQL LIKE pattern (default "%analytics%" )

Output shape

array of objects each containing database name, engine, and comment

Returns JSON rows from system.databases; no pagination; optional pattern filter

Examples

Example 1: List only analytics‑related databases

Pattern set to "%analytics%"

Example 2: List all databases

Pattern left empty

Example 3: List databases in a specific database

Pattern left empty; choose database via credentials

Links

Discussion