camelAI connects directly to ClickHouse—no dashboards needed. It speaks plain English and converts questions into ClickHouse SQL queries on the fly. ClickHouse's columnar storage and advanced aggregation functions are handled automatically, so you don't have to master complex analytical queries. Just ask questions about your time-series data, event logs, or any table in your database. camelAI generates optimized SQL, runs it with ClickHouse's blazing-fast engine, and returns results and charts in seconds.
Need real-time analytics at scale? camelAI lets you save any query or chart (we call these artifacts) into a dashboard. When you view a dashboard, each artifact automatically refreshes with the latest data from your ClickHouse tables. ClickHouse's columnar storage and materialized views optimize performance, so you can track billions of events across multiple dashboards without breaking a sweat. In just a few clicks, compile a snapshot of key metrics—like user behavior patterns, system telemetry, or real-time analytics—using live ClickHouse data.
camelAI's report generation feature harnesses ClickHouse's analytical power—running complex aggregations and exploring the schema over multiple iterations. If you store both raw events and pre-aggregated data, the AI can leverage both to create comprehensive analyses. In about 10 minutes, you get a full report packed with charts, conclusions, and recommendations, all based on live ClickHouse data. This is perfect for deep analytical questions, when you want the AI to mine your massive datasets and uncover patterns you might have missed.
Yes, your app connections are secure. We use secure key authentication to authenticate and authorize access to your ClickHouse instance. Your data is encrypted in transit and at rest. If you revoke access, the connection is immediately destroyed and we will no longer have access to that database.
camelAI's infrastructure is hosted on AWS. Data from applications is pulled only when necessary and limited to what you request in your prompt. It is stored in an EC2 cache for 5 minutes and then deleted. For more information, please see our Security Policy and our security blog post.
We use your ClickHouse credentials to establish a secure connection, pulling only the specific records you request. Credentials are stored securely and encrypted, and can be revoked at any time from your settings.
We only store queries temporarily (caching for up to 5 minutes) to fulfill your request. They are then deleted.
You can revoke credentials in your account settings. This immediately stops our ability to access your database.
No. We do not train on any user data, and we have opted out of data sharing for training. You can read more about OpenAI's API policies here.
