User-defined Playground

ClickHouse Playground

Márk Sági-Kazár
by  Márk Sági-Kazár
on
Linux

A fast, open-source, column-oriented, analytical database.

Startup configuration
clickhouse
ClickHouse playground: A fast, open-source, column-oriented, analytical database.
Note

💡 To explore ClickHouse's scaling capabilities, check out the this multi-node 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.

How CH-UI reaches ClickHouse

The browser never talks to ClickHouse directly. CH-UI's server holds the ClickHouse client and runs your queries for you, connecting to http://127.0.0.1:8123 from inside the playground. You can point it elsewhere in /etc/ch-ui/server.yaml:

sudo systemctl restart ch-ui

The CH-UI tab goes through a Caddy proxy on port 13488 rather than CH-UI's own 3488. CH-UI sends X-Frame-Options: DENY, which would otherwise blank out the tab.

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()"
Credentials

If you need to connect from another client, use the following credentials:

  • Host: localhost
  • Port: 9000 (native) or 8123 (HTTP)
  • Username: default
  • Password: iximiuz
  • Database: default

Running Queries

Interactive Mode
From Files
Multiple 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

🧩 Related Content

🧪 Playgrounds

Happy learning! 🚀

Start
Settings