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

# ClickHouse guides

> Guides for working with ClickHouse — data modelling, performance, examples, OSS deployment, and more.

Pick an area to dive into.

<CardGroup cols={2}>
  <Card title="Data formats" icon="file-code" href="/guides/clickhouse/data-formats/intro">
    Working with CSV, Parquet, Arrow, Avro, JSON, SQL, binary, and template/regex formats.
  </Card>

  <Card title="Data modelling" icon="diagram-project" href="/guides/clickhouse/data-modelling">
    Schema design, primary indexes, denormalization, backfilling, compression, and working with arrays/joins.
  </Card>

  <Card title="Performance & monitoring" icon="gauge-high" href="/guides/clickhouse/performance-and-monitoring/query-optimization">
    Query optimization, the analyzer, and techniques for understanding query execution.
  </Card>

  <Card title="Aggregate combinator examples" icon="calculator" href="/guides/clickhouse/examples/aggregate-function-combinators/anyIf">
    Worked examples of every aggregate-function combinator (`-If`, `-Map`, `-Array`, `-State`, `-Merge`, `-Resample`, etc.).
  </Card>

  <Card title="Self-managed upgrade" icon="arrow-up" href="/guides/oss/update">
    Upgrade procedure for self-managed ClickHouse deployments.
  </Card>

  <Card title="OSS best practices" icon="lightbulb" href="/guides/oss/best-practices/sizing-and-hardware-recommendations">
    Sizing, hardware recommendations, and operational tips for running ClickHouse OSS.
  </Card>

  <Card title="Deployment and scaling" icon="server" href="/guides/oss/deployment-and-scaling">
    Replication, sharding, Keeper, monitoring, and end-to-end deployment examples.
  </Card>
</CardGroup>