1. MooseStack
  2. Configuration
  3. ClickHouse Configuration

ClickHouse Configuration

Configure the OLAP database connection.

Security Warning

NEVER put production credentials in moose.config.toml. For production environments or when connecting to external infrastructure, ALWAYS use environment variables and/or secrets to securely inject credentials.

[clickhouse_config]# Database name (Default: "local")db_name = "local"# ClickHouse user (Default: "panda")user = "panda"# ClickHouse password (Default: "pandapass")password = "pandapass"# Whether to use SSL for connection (Default: false)use_ssl = false# ClickHouse host (Default: "localhost")host = "localhost"# ClickHouse HTTP port (Default: 18123)host_port = 18123# ClickHouse native protocol port (Default: 9000)native_port = 9000
KeyEnv VariableDefaultDescription
db_nameMOOSE_CLICKHOUSE_CONFIG__DB_NAME"local"The database name to use.
userMOOSE_CLICKHOUSE_CONFIG__USER"panda"Database user.
password
MOOSE_CLICKHOUSE_CONFIG__PASSWORD
"pandapass"
SECRET. Use env var in prod.
use_sslMOOSE_CLICKHOUSE_CONFIG__USE_SSLfalseEnable SSL connection.
hostMOOSE_CLICKHOUSE_CONFIG__HOST"localhost"ClickHouse server host.
host_portMOOSE_CLICKHOUSE_CONFIG__HOST_PORT18123HTTP interface port (and Docker bind port in dev).
native_portMOOSE_CLICKHOUSE_CONFIG__NATIVE_PORT9000Native TCP protocol port.
  • Overview
  • Quick Start
  • Templates / Examples
Fundamentals
  • Moose Runtime
  • MooseDev MCP
  • Data Modeling
MooseStack in your App
  • App / API frameworks
Modules
  • Moose OLAP
  • Moose Streaming
  • Moose Workflows
  • Moose APIs
Deployment & Lifecycle
  • Moose Migrate
  • Moose Deploy
Reference
  • API Reference
  • Data Types
  • Table Engines
  • CLI
  • Configuration
    • Core Settings
    • Project Settings
    • TypeScript
    • Telemetry
    • Git
    • Features
    • Migrations
    • Infrastructure
    • ClickHouse
    • Redpanda
    • Redis
    • Temporal
    • HTTP Server
    • State Storage
    • Security
    • JWT
    • Admin API
    • Development
    • Dev Environment
  • Observability Metrics
  • Help
  • Changelog
Contribution
  • Documentation
  • Framework
FiveonefourFiveonefour
Fiveonefour Docs
MooseStackTemplates
Changelog
Source506