Building Your First MCP Server: A Journey from API to AI Assistant
How I built a production-ready MCP server for Mexican economic data and what I learned along the way
AI
All posts
Page 6 of 12
The Powerful COPY Command in DuckDB / MotherDuck: A Quick Reference Guide
The COPY command in DuckDB and MotherDuck is a versatile tool for importing and exporting data. This guide provides a concise overview of how to use COPY both from the DuckDB CLI (SQL only) and from Python, including workflows with Ibis and pandas. Use this as a quick...
Data Science, Python, SQL
Building a Complete DuckLake Solution: From Local Development to Cloud Production
DuckLake is revolutionizing the lakehouse architecture by combining the simplicity of DuckDB with the power of modern data lake formats. In this comprehensive guide, I’ll walk you through building a complete DuckLake solution in two parts: first creating a local...
Data Science, SQL
A SysAdmin’s Complete Guide: From Crisis to Clean Server – The Ultimate Disk Space Recovery Playbook
Updated with advanced techniques and lessons learned from multiple real-world storage crises
Linux
How to Set Up a Powerful, Free Forever Server on Oracle Cloud (Caddy Edition)
Earlier in 2025, I signed up for Oracle’s “Free Forever” cloud offer. It was, and still is, one of the most generous free tiers available, especially for developers and hobbyists. I wrote a blog post to document my setup, and today I’m updating it with a more modern,...
Linux
The Ultimate Guide to Installing and Using Gemini CLI on Windows, Linux, and VS Code
In the fast-paced world of software development, efficiency is everything. What if you could bring the power of a cutting-edge AI directly into your terminal, ready to answer questions, explain code, and generate commands without ever leaving your command line? That’s...
AI
A Step-by-Step Guide to Installing Portainer with Docker and Caddy on an ARM Server
Managing a server with multiple Docker applications can quickly become a juggling act of docker ps, docker logs, and docker-compose commands. While powerful, the command line isn’t always the most efficient way to get a high-level view of your services.
Linux
Supercharging Your Cloud Server Management: Mountain Duck + Tailscale + ARM Ubuntu Done Right!
Managing files on a remote server can sometimes feel like navigating a maze. Public IPs, firewalls, SSH keys – it’s a lot to keep track of. But what if I told you there’s a “super cool” way to get seamless, secure file access, even to your Oracle ARM Ubuntu server, all...
Linux