> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-detect-table-modification.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> Overview of the ClickHouse guides

# ClickHouse guides

This section contains the following guides:

<CardGroup cols={2}>
  <Card title="Data formats" icon="file-lines" href="/guides/clickhouse/data-formats/intro">
    Examples for importing from and exporting to various data formats, including CSV and TSV, Parquet, JSON, binary formats, SQL dumps, and templates with regular expressions.
  </Card>

  <Card title="Data modelling" icon="diagram-project" href="/guides/clickhouse/data-modelling/index">
    Guides on data modelling in ClickHouse, including schema design, sparse primary indexes, denormalization, backfilling data, and data compression.
  </Card>

  <Card title="Performance & monitoring" icon="gauge-high" href="/guides/clickhouse/performance-and-monitoring/query-optimization">
    Guides for optimizing query performance, understanding the analyzer, and dynamic column selection.
  </Card>

  <Card title="Aggregate combinator examples" icon="calculator" href="/guides/clickhouse/examples/aggregate-function-combinators/anyIf">
    Examples of using aggregate function combinators such as `-If`, `-Map`, `-SimpleState`, `-State`, `-Merge`, `-Resample`, `-Array`, and `-ForEach`.
  </Card>

  <Card title="Self-managed upgrade" icon="circle-arrow-up" href="/guides/oss/update">
    A guide on upgrading a self-managed ClickHouse installation, including upgrade paths and version compatibility considerations.
  </Card>

  <Card title="OSS best practices" icon="list-check" href="/guides/oss/best-practices/sizing-and-hardware-recommendations">
    Sizing and hardware recommendations and usage recommendations for open-source ClickHouse.
  </Card>

  <Card title="Deployment and scaling" icon="server" href="/guides/oss/deployment-and-scaling/index">
    Deployment guides with examples of deploying ClickHouse for scaling and/or fault tolerance, including ClickHouse Keeper configuration and monitoring.
  </Card>
</CardGroup>