The developer agent harness for ClickHouse — MooseStack gives your AI coding agents the interfaces, context, code, and skills to build and ship applications on popular OSS realtime analytical infrastructure: safely, efficiently, and effectively. Including:
- ClickHouse (realtime OLAP)
- Redpanda (streaming)
- Temporal (workflow orchestration)
- Redis (internal state)
Generalist coding agents like Claude Code, Cursor, and Copilot work well for most coding tasks. But ClickHouse and realtime analytical infrastructure are specialized terrain. MooseStack sits between your agent and your data stack, and enables your agent to handle the stickiest parts of building out applications on real time analytical infra. Think:
- Optimizing data models & queries for OLAP
- Managing schema changes and migrations
- Building out realtime streaming ETL/ELT data pipelines
- Integrating analytics into your frontend application layer
In short, when everything is code, coding agents can thrive.
- Dev framework & CLI: AI-friendly framework and CLI enable coding agents to iterate quickly and safely on your analytical workloads
- Local-first experience: Full mirror of production environment on your laptop with
moose dev - Schema & migration management: Typed schemas in your application code, with automated schema migration support
- Code‑first infrastructure: Declare tables, streams, workflows, and APIs in TS/Python -> MooseStack wires it all up
- Git-native development: Version control, collaboration, and governance built-in
- Modular design: Only enable the modules you need. Each module is independent and can be adopted incrementally
- Moose Dev: Local dev server with hot-reloading infrastructure
- Moose Dev MCP: AI agent interface to your local dev stack
- Moose Language Server / LSP: In-editor diagnostics and autocomplete for agents and devs
- ClickHouse TS/Py Agent Skills: ClickHouse, OLAP, and data engineering best practices as agent-readable rules
- Moose Migrate: Code-based schema migrations for ClickHouse
- Moose Deploy: Ship your app to production
- Moose OLAP: Manage ClickHouse tables, materialized views, and migrations in code.
- Moose Streaming: Real‑time ingest buffers and streaming transformation functions with Kafka/Redpanda.
- Moose Workflows: ETL pipelines and tasks with Temporal.
- Moose APIs and Web apps: Type‑safe ingestion and query endpoints, code-first semantic layer, and bring your own API framework (Nextjs, Express, FastAPI, Fastify, etc.)
The fastest way to deploy your MooseStack application is with hosting from Fiveonefour, the creators of MooseStack. Fiveonefour provides automated preview branches, managed schema migrations, deep integration with GitHub and CI/CD, and an agentic harness for your realtime analytical infrastructure in the cloud.
Get started with Fiveonefour hosting →
MooseStack is open source and can be self-hosted. If you're only using MooseOLAP, you can use the Moose library in your app for schema management, migrations, and typed queries on your ClickHouse database without deploying the Moose runtime. For detailed self-hosting instructions, see our deployment documentation.
We welcome contributions! See the contribution guidelines.
MooseStack is open source software and MIT licensed.