Engineering
How we made our IDEs data-aware with a Go MCP Server
How we built a Go-based MCP server to make AI Assistants AI data-aware, bridging code and database, which ended up transforming the way we code.
Mariano Gappa, +1 •
Back to all blog posts
About
Mariano is part of CloudQuery's software development team. During 15 years working in software development, Mariano has worked in a wide variety of languages and platforms. His greatest experience lies in Python, Go, MySQL, PHP, Kubernetes and AWS but his varied career has shown that he can turn his hand to anything.
Prior to joining CloudQuery, Mariano worked in a number of software engineering roles at various businesses. In each role, he contributed to significant efficiency gains and performance improvements for the products he worked on, delivering 25x performance improvements in some cases.
Hailing from Argentina, Mariano has worked in software engineering roles for businesses in his home country, New Zealand and the U.K.
Engineering
We Built an MCP Server and These Are the Gotchas Nobody Talks About
Lessons we learned from building an MCP server to bridge LLMs with cloud infrastructure databases. What we learned about tool descriptions, naming, context limits, and quirks, and how we fixed them.
Mariano Gappa, +1 •
Tutorials
How to Work with CloudQuery Syncs within Databricks
Learn how to set up CloudQuery syncs within Databricks, including data transformation and visualization of your cloud asset inventory.
Mariano Gappa •
Engineering
How We Handle Billion-Row ClickHouse Inserts With UUID Range Bucketing
How we solved memory explosion issues in ClickHouse when processing billions of rows of cloud configuration data using an Insert-Splitter with UUID-range bucketing technique.
Mariano Gappa, +1 •
Engineering
Six Months with ClickHouse at CloudQuery (The Good, The Bad, and the Unexpected)
After six months using ClickHouse as CloudQuery’s default backend, here’s what we learned about performance, JOIN limitations, sorting keys, materialized views, and why real-world benchmarking matters.
Herman Schaaf, +2 •
CloudQuery News
Introducing The JSON Flattener Transformer Integration
CloudQuery introduces the JSON Flattener Transformer Integration, a new transformer integration that enables you to flatten JSON source data into separate columns at your destination.
Mariano Gappa •
Tutorials
How to run CloudQuery syncs within Argo Workflows
This blog post demonstrates how to integrate CloudQuery with Argo Workflows to sync XKCD comics into a MongoDB database, outlining the setup of configuration files, API authentication, and running the workflow using Argo CLI.
Mariano Gappa •
Tutorials
Using CloudQuery Within Apache Airflow
If your team's workflow is based on Apache Airflow, introducing CloudQuery syncs into it is simple! Learn how to set up a basic Airflow DAG that syncs the whole catalog of XKCD comics into a local SQLite database.
Mariano Gappa •