AI Analyst for Investment Data with ClickHouse & Codex
Build a local AI analyst for investment firm data using Bruin CLI, ClickHouse, and Codex.
What
Goal - Build a local AI analyst for investment firm data using Bruin CLI, ClickHouse, and Codex.
Audience - Data engineers and analysts at investment firms working with ClickHouse.
Prerequisites
- Investment data already loaded in ClickHouse
- Bruin CLI installed
- Codex CLI installed and authenticated for
bruin ai enhance - Bruin MCP configured for Codex
More guides

Chat with an AI Agent
Use Bruin Cloud's chat to ask an AI agent about your data, generate reports, and run Bruin Cloud CLI tasks like pipeline status and history.

Configure AI Agents
Create and configure AI agents in Bruin Cloud - pick a project, add messaging integrations, attach a connection set, and set permissions.

Connect Bruin Cloud MCP to Claude Code
Set up the Bruin Cloud MCP so your AI agent can query pipelines, inspect runs, and trigger actions in Bruin Cloud directly from your terminal.