ClickHouse UIs: Schema visualiser
Mark Needham
Explore ClickHouse's Schema Visualizer UI by building a schema one query at a time. Starting with a sales table, we add incremental and cascading materialized views, a refreshable materialized view, a dictionary, and a Distributed table, and watch the diagram evolve.
Along the way, see how to inspect columns and CREATE statements, follow materialized view dependencies, and show or hide objects by type.
Both UIs ship with every ClickHouse server: the SQL Console at /ui and the Schema Visualizer at /schema.
Get started today
Interested in seeing how ClickHouse works on your data? Get started with ClickHouse Cloud in minutes and receive $300 in free credits.
Sign upRecent videos
View all Videos
Open House
Open House 2026: Day 1 Keynote
The latest ClickHouse announcements, featuring real-world use cases from Shopify, Zoox, Visa, and Cisco.
Open House
Fireside Chat: The state of data and AI with Bret Taylor (Sierra) and Aaron Katz (ClickHouse)
Aaron Katz (CEO, ClickHouse) and Bret Taylor (Co-Founder Sierra, Chairman of the Board, OpenAI) have an open conversation on the state of AI.
Open House, ClickHouse
How to build a great database (Alexey Milovidov)
The principles behind building a great database, and the new frontiers shaping the field.
Open House
Fireside Chat: Ecosystem and technology trends (Vercel, dbt Labs, CoreWeave)
Aaron Katz (CEO, ClickHouse), Guillermo Rauch (CEO, Vercel), Tristan Handy (CEO, dbt Labs), and Lukas Biewald (SVP of AI, CoreWeave) discuss how AI is changing the data landscape.
Follow us
