Run a read-only SQL query against ClickHouse (telemetry data).

Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed. Results are capped at 500 rows by default.

Use this for product telemetry: active instances, version distribution, storage engines, deployment types, CPU architecture, cluster metrics.

Args: sql: A read-only SQL statement.

Examples: - SELECT count() FROM telemetry WHERE product = 'MySQL' - SELECT version, count() as n FROM telemetry GROUP BY version ORDER BY n DESC - SHOW TABLES

List all databases accessible in the ClickHouse instance.

List all tables in a ClickHouse database.

Args: database: Database name. If omitted, lists tables in the default database.

Show the schema (columns, types, comments) of a ClickHouse table.

Args: table: Table name. database: Database name. If omitted, uses the default database.

Get sample rows from a ClickHouse table (up to 100 rows).

Useful for understanding telemetry data structure before writing queries.

Args: table: Table name. database: Database name. If omitted, uses the default database. limit: Number of rows to return (1-100, default 10).

Run an Elasticsearch query (JSON DSL) against download/package data.

Use this for product download data: downloads by product, package type, OS, components, growth rates, EOL packages, Pro-builds.

Args: index: The Elasticsearch index to search. query_body: A JSON string containing the Elasticsearch query DSL. Supports match, term, range, bool, aggregations, etc. size: Max documents to return (default 500).

Examples: - {"query": {"match": {"product": "postgresql"}}, "size": 20} - {"size": 0, "aggs": {"by_package": {"terms": {"field": "package_type"}}}} - {"query": {"range": {"date": {"gte": "2025-01-01"}}}}

List all Elasticsearch indices with document counts and sizes.

Use this to discover available download/package data indices.

Show the field mapping (schema) for an Elasticsearch index.

Args: index: The index name to inspect.

Get sample documents from an Elasticsearch index (up to 100).

Useful for understanding download data structure before writing queries.

Args: index: The index name. size: Number of documents to return (1-100, default 10).