📝 Introduction Today I successfully set up MCPO (MCP-to-OpenAPI) to work seamlessly with Open WebUI, providing access to powerful external APIs through the Model Context Protocol. This post documents the entire process, scripts, and configuration needed for a smooth installation. 🎯 What is MCPO? MCPO is a bridge that converts...
Continue reading...Installing AnythingLLM on Oracle ARM Ubuntu Server
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...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...