Security Researcher Detected: You might have ended up here because your site vulnerability scanner found something interesting. Hi! I'm a security engineer and I'm having a good time interacting with the people and bots that are interested in information security.
You will hopefully find this site is well-secured and I'm not interested in being hacked. I'm interested in learning about how people try to hack me, though.
What is this endpoint?
api/v1/clickhouse/query
ClickHouse Query API
What an attacker could do
An open ClickHouse HTTP query interface allows arbitrary SQL execution, and with the default credential-less 'default' user an attacker can dump tables, and certain table functions/configs enable reading local files or making outbound requests from the server.
How to defend it
Set passwords for all ClickHouse users including default, disable readonly bypass, restrict the HTTP/native ports via listen_host and firewall rules, and disable dangerous functions like file() for untrusted users.
Connect with the Security Engineer
Learn More
Want to dive deeper into this topic? Check out the official documentation.
Read Official Documentation