ClickHouse Playground

🔧 System Components

• ClickHouse Server: High-performance columnar database engine optimized for analytics
• CH-UI: Web UI for ClickHouse - SQL editor, schema browser, and dashboards

🛠️ Tools

• clickhouse-client: Interactive command-line client for running queries
• clickhouse-local: Tool for processing local files with ClickHouse SQL
• ch-ui: Server binary behind the CH-UI tab

🎯 Getting Started

Using CH-UI

Open the CH-UI tab and sign in with the ClickHouse credentials:

• Username: default
• Password: iximiuz

CH-UI authenticates against ClickHouse itself, so those are the only credentials involved - there's no separate CH-UI account.

sudo systemctl restart ch-ui

Connecting to ClickHouse

# Connect using the interactive client
clickhouse-client

# Connect with specific database
clickhouse-client --database=default

# Execute single query
clickhouse-client --query "SELECT version()"

Running Queries

# Start interactive session
clickhouse-client

# Example queries in the client
SHOW DATABASES;
SELECT version();
SELECT name FROM system.tables LIMIT 5;

# Save your query to a file
echo "SELECT version()" > query.sql

# Run query from file
clickhouse-client < query.sql

# Run with output formatting
clickhouse-client --format=Pretty < query.sql

# Create file with multiple queries
cat << EOF > queries.sql
SHOW DATABASES;
SELECT version();
SELECT count() FROM system.tables;
EOF

# Run all queries
clickhouse-client --multiquery < queries.sql

📚 Learn More

• ClickHouse
  • Documentation
  • Training Materials
  • SQL Reference
• How to Learn ClickHouse
• CH-UI

🧩 Related Content

🧪 Playgrounds

• ClickHouse Cluster

Happy learning! 🚀