Database Connection
Find your Hardal database host, port, username, and password so you can connect directly with any MySQL or ClickHouse-compatible tool.
Your Hardal signal comes with a read-only ClickHouse database you can query directly — no exports, no waiting for data pipelines. Connect any MySQL-compatible client, BI tool, or notebook and start writing SQL against your live event data.
Get your connection details
Open Database Settings
Log into your Hardal dashboard, select your signal, then go to Settings → Database. Your connection details are on this page.
Copy your credentials
You'll see five values to copy:
| Field | Description |
|---|---|
| Host | Database server hostname |
| Port | Connection port (typically 8123) |
| Username | Read-only database user |
| Password | Secure access password |
| Server IP | Direct IP — useful for firewall allowlisting |
Each field has a copy button. Use it — database hostnames are long and easy to mistype.
Connect using the connection string
For tools that accept a connection string directly, copy the pre-built string from the same page:
http://username:password@server-ip:port
This format works with most database clients and BI tools out of the box.
Your database credentials are read-only. They can query data but cannot modify or delete anything. Treat the password as a secret — don't commit it to source control.
Connect with analytics tools
Looker Studio
Build dashboards and scheduled reports
Hex
Data science notebooks and collaborative analysis
Tableau
Advanced visualisations and data exploration
Power BI
Microsoft ecosystem reporting
Not sure what data is in your database? See the Data Model for table schemas and example queries.