A comprehensive guide for self-hosting AnythingLLM with Docker, Caddy, and Ollama 🤖 What is AnythingLLM? AnythingLLM is a powerful, self-hosted AI knowledge management and chat platform that transforms how you interact with your data and AI models. It’s designed to be your personal AI workspace where you can combine multiple AI...
Continue reading...Hector Sanchez
Hector Sanchez is a Public Accountant with over 30 years of experience as accountant and financial analyst, and with diplomas in Corporate Finance and Data Science.
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 As someone who works at the intersection of data science and finance, I’m always looking for ways to make economic data more accessible. When I discovered the Model Context Protocol (MCP), I...
Continue reading...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 reference for your data engineering tasks!...
Continue reading...Building a Complete DuckLake Solution: From Local Development to Cloud Production
Introduction 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 development environment, then scaling it to a cloud-based production...
Continue reading...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 post to document my setup, and today I’m updating it with a more modern, simpler stack and...
Continue reading...