At Cult of Coders, I led an Elasticsearch-to-ClickHouse migration for analytical workloads, reducing infrastructure costs by up to 90% and improving average query performance by approximately 35%. I also designed and maintained distributed backend services and ETL pipelines for a multi-tenant platform.
I developed backend systems for authentication, policy management, REST and GraphQL APIs, data isolation, and Stripe billing. I also contributed to React admin panels and subscription features.
On SEOStack, I built a multi-tenant SEO analytics platform that processes data from Google Search Console and Google Analytics. Its stack includes TypeScript, Node.js, GraphQL, RabbitMQ, Elasticsearch, and ClickHouse.
I created ClickHouse MCP Agent, an open-source Python library and MCP server that lets AI agents query ClickHouse using natural language. It includes access controls, SQL generation, conversational context, and support for multiple LLM providers.
