# AI doesn't always generate perfect ClickHouse schemas (yet)

DevFeed: [AI doesn't always generate perfect ClickHouse schemas (yet)](<https://devfeed.tech/articles/ai-doesn-t-always-generate-perfect-clickhouse-schemas-yet-4930.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/ai-generated-clickhouse-schemas-mistakes-and-advice>)

Author: Al Brown

Published: 2026-03-13T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>), [Agent Skills](<https://devfeed.tech/topics/agent-skills.md>), [Data Management](<https://devfeed.tech/topics/data-management.md>), [Optimization](<https://devfeed.tech/topics/optimization.md>), [Compression](<https://devfeed.tech/topics/compression.md>)

Tags: [agent-skills](<https://devfeed.tech/tags/agent-skills.md>), [ai](<https://devfeed.tech/tags/ai.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [compression](<https://devfeed.tech/tags/compression.md>), [data-management](<https://devfeed.tech/tags/data-management.md>), [optimization](<https://devfeed.tech/tags/optimization.md>)

## AI overview

This article examines common mistakes in AI-generated ClickHouse schemas, including unnecessary partitioning, per-column codecs, and projections. It recommends starting with a simple schema, measuring real workloads, and adding complexity only when the data justifies it.

## Source excerpt

This post walks through the common pitfalls we see when AI generates ClickHouse schemas, drawn from real conversations with our Solutions Architecture team and patterns across dozens of customer engagements.