Miguel P Z MiguelElGallo

🐓 Hi, I'm Miguel Peredo Zürcher

🏗️ Seasoned Data Platform Solutions Architect and Principal Data Engineer with 20+ years of experience designing and delivering enterprise data platforms across automotive, banking, and manufacturing sectors in Europe.

☁️ I architect end-to-end solutions on Azure and Snowflake — from data ingestion and data modeling to governance and self-service analytics — while staying hands-on with 🐍 Python, SQL, CI/CD (Azure DevOps & GitHub Actions), and Infrastructure as Code.

🤖 I actively pioneer the use of LLMs and AI Agents (RAG, PydanticAI, Semantic Kernel, MCP) to enhance data engineering workflows and platform intelligence.

🎓 Certified on Azure, Snowflake, Google Cloud, with an MSc in Software & Systems Engineering and executive courses from Stanford and Harvard Business School.

🏆 Featured projects

Some of my projects are also available through agent plugin marketplaces and Microsoft's Awesome AZD catalog:

🧩 iParq

Inspect Parquet metadata from your terminal or your coding agent.

codex plugin marketplace add MiguelElGallo/iparq
codex plugin add iparq@iparq

_{VS Code: Chat: Install Plugin From Source}

📄 md-to-pdf

Turn Markdown (with Mermaid diagrams) into polished PDFs.

codex plugin marketplace add MiguelElGallo/md-to-pdf
codex plugin add md-to-pdf@md-to-pdf

_{VS Code: Chat: Install Plugin From Source}

⚡ FastAPI + Snowflake on Azure Functions

azd init --template MiguelElGallo/simple-fastapi-snow-azd

📈 Simple Streamlit on Azure App Service

azd init --template MiguelElGallo/simple-streamlit-azd

🤖 FastMCP on Azure App Service

azd init --template MiguelElGallo/myfirstmcp-openai

📼 LinkedIn video demos

Press ▶ on a cover to watch the video. Each demo links to the repository behind it.

🆕 HelloJev: smarter pipeline failure decisions _{⏱ 42 sec · ▶ Watch video · 📦 Repository}
tgrep for VS Code _{⏱ 24 sec · ▶ Watch video · 📦 Repository}	tgrep for Codex _{⏱ 24 sec · ▶ Watch video · 📦 Repository}
docdr _{⏱ 28 sec · ▶ Watch video · 📦 Repository}	Databricks Metric View _{⏱ 28 sec · ▶ Watch video · 📦 Repository}
Agent Plugin Forge _{⏱ 38 sec · ▶ Watch video · 📦 Repository}	Team skills: one shared home _{⏱ 60 sec · ▶ Watch video · 📦 Repository}

🗺️ All repositories

_{🤖 This level is regenerated every Sunday by a GitHub Copilot SDK agent.}

Here are the repositories I maintain or contribute to: _{🕹️ High-score table · sorted by stars, then latest push · 📊 data · 🤖 AI}

#	Repository	⭐	What it does	🐍 Python libraries	☁️ Azure services	Tags
🥇	mpzsql	28	Arrow Flight SQL DuckDB lakehouse	`azure-identity` `duckdb` `grpcio` `pyarrow` `pyjwt`	Blob Storage, Container Apps, PostgreSQL	📊
🥈	iparq	25	Parquet metadata inspection CLI	`pyarrow` `pydantic` `rich` `typer`	-	📊
🥉	modelando	11	Bilingual data modeling materials	-	-	📊
04	api-elt	9	ELT pipeline for APIs	`dlt` `python-dotenv`	-	📊
05	azquack	6	DuckDB Quack protocol Azure	`duckdb`	Blob Storage, Container Apps	📊
06	snowflake-semantic-view-skill	6	Snowflake semantic view skill	-	-	📊 🤖
07	FastAPI-in-Snowflake	4	FastAPI in Snowflake containers	`fastapi` `passlib` `python-jose` `snowflake-connector-python` `uvicorn`	-	📊
08	SynapseApacheIceBergExperiment	4	Apache Iceberg on Synapse Spark	-	Synapse Analytics	📊
09	evsnow	3	Event Hubs to Snowflake streaming	`azure-eventhub` `azure-identity` `pydantic-ai` `snowflake-connector-python`	Event Hubs	📊 🤖
10	simple-streamlit-azd	3	Streamlit on Azure App Service	`numpy` `pandas` `streamlit`	App Service	📊
11	sensormatrix	1	ESP32 sensor testing framework	`pydantic` `pyserial` `pyyaml` `typer`	-	📊
12	snapshottest	1	Inline snapshot testing demo	`httpx` `inline-snapshot` `rich` `typer`	-	-
13	ragsql	1	RAG-powered SQL queries	`langchain` `openai` `snowflake-connector-python`	-	📊 🤖
14	md-to-pdf	-	Markdown to PDF converter	-	-	-
15	agent-plugin-forge	-	Agent Skills to Plugins	`jsonschema` `license-expression` `pydantic` `pyyaml` `semantic-version`	-	🤖
16	HelloJev	-	Pipeline failure decisions AI	-	-	📊 🤖
17	RioArriba	-	River shooter arcade game	-	-	-
18	st	-	Token saver for repositories	-	-	-
19	docdr	-	Documentation doctor skill	-	-	🤖
20	bricksgdpr	-	Databricks dbt GDPR demo	`dbt-core` `dbt-databricks`	-	📊
21	homebrew-iparq	-	Homebrew iparq tap	-	-	-
22	dbtobsb	-	dbt Core Databricks observability	-	-	📊
23	skill-metric-view-dbr	-	Databricks metric view skill	-	-	📊 🤖
24	Modelando2025	-	Data modeling 2025 materials	`mkdocs-material` `mkdocs-git-committers-plugin` `mkdocs-i18n`	-	📊
25	api-test-pilot	-	Contract-driven API testing	`httpx` `jsonschema` `pydantic` `pyyaml` `typer`	-	🤖
26	azure-ducklake-quack	-	Azure DuckLake Entra routing	-	Container Apps, PostgreSQL	📊
27	evbricks	-	Event Hubs Databricks streaming	`aiohttp` `azure-eventhub` `azure-identity` `databricks-zerobus-ingest-sdk`	Event Hubs	📊
28	bricks-cli	-	dbt on Databricks CLI	-	-	📊
29	codemode	-	Code Mode vs MCP comparison	`mcp` `pydantic`	-	🤖
30	neoquack	-	DuckDB Quack free tiers	`duckdb` `fastapi` `httpx` `psycopg`	-	📊
31	SnowflakeCortexCLI	-	Snowflake Cortex CLI security	-	-	📊 🤖
32	snowdag	-	Airflow dbt Snowflake containers	-	-	📊
33	fastapi-free	-	FastAPI free-threading benchmark	`fastapi` `prometheus-client` `uvicorn`	-	-
34	ir-support-site	-	iOS app support pages	-	-	-
35	snow_iceberg_snowstorage	-	Snowflake Iceberg DuckDB	-	-	📊
36	snowmcpaz	-	Snowflake MCP Azure auth	-	-	📊 🤖
37	jwtaztoken	-	Azure JWT token inspector	`cryptography` `httpx` `pyjwt` `rich` `typer`	-	-
38	dlthubarrow	-	dlt Arrow on Azure	`azure-monitor-opentelemetry` `dlt` `psutil` `pyarrow` `snowflake-connector-python`	Container Apps, Key Vault	📊
39	snowdcm	-	Snowflake DCM objects	-	-	📊
40	dlthubsnow	-	dlt in Snowflake	`dlt` `requests`	-	📊
41	Arrow_as_source	-	Arrow universal dataset	`arrow` `duckdb` `polars` `pyarrow`	-	📊
42	ghs	-	Sync env with GitHub	`pydantic` `python-dotenv` `typer`	-	-
43	myfirstmcp-openai	-	FastMCP Azure App Service	`gunicorn` `mcp` `uvicorn`	App Service	🤖
44	CallAPIfromLLM	-	LLM API calling demo	-	-	🤖
45	snowtofu	-	Snowflake OpenTofu IaC	-	Storage Account	📊
46	simple-fastapi-snow-azd	-	FastAPI Snowflake Functions	`fastapi` `snowflake-sqlalchemy`	Functions	📊
47	embeddindataengineering	-	OpenAI embeddings Fabric	-	-	📊 🤖
48	mycv	-	Personal CV repository	-	-	-
49	dltHub-teesting	-	dltHub pytest testing	`dlt` `duckdb` `mypy` `pytest`	-	📊
50	ChartToMD	-	Chart to markdown RAG	`aiohttp` `azure-identity` `pydantic` `typer`	-	🤖
51	SnowCLI	-	Snowflake CLI GitHub Actions	-	-	📊
52	rag-graph	-	Graph RAG approaches	-	-	🤖
53	opeanai-rag-test	-	OpenAI RAG Spanish	`openai` `python-dotenv`	-	🤖
54	ragvectordb	-	Multiple vector databases	-	AI Search	📊 🤖
55	azdcodespaces	-	AZD in Codespaces	-	-	-
56	azureaisearch	-	Azure AI Search embeddings	-	AI Search	🤖
57	azopenai_adx	-	Data Explorer embeddings	-	Data Explorer	📊 🤖
58	semker	-	Semantic Kernel examples	`semantic-kernel`	-	🤖
59	dvsat	-	Data Vault satellite demo	-	-	📊
60	JoinOrAssociation	-	BI tool fan trap handling	-	-	📊

💾 Last saved: 2026-09-27

Navigation Menu

Miguel P Z MiguelElGallo

Achievements