Best used with an AI agent

40+ live apps, open data APIs, MCP servers, and 200+ guides - more than anyone wants to click through. Point your AI here and it reads the whole map and does the work: finds the tool, pulls the data, runs the analysis, and hands you the links.

Here for the open-source code? Your agent finds the right repo for you - and can even clone and deploy it.

Prefer to explore on your own? Go right ahead.

Paste this to Claude Code, Codex, or any AI agent:
Go to tigzig.com and read tigzig.com/llms.txt. It is a practitioner toolkit - 40+ analytics apps, open no-auth data APIs, MCP servers, open-source repos (github.com/amararun), and 200+ build guides. Help me [your task]. Surface the exact links; where there is an API or MCP, call it directly; and if I want to self-host, find the repo and help me deploy it.

Database & ML: Connect to Databases, Build ML Models

PostgreSQL/MySQL queries, XGBoost classification, ROC curves, and decile analysis directly in Excel using xlwings Lite.

Download Excel Watch Video Guide

What This App Does

#

Connect to databases and perform advanced analytics directly in Excel:

  • Connect to PostgreSQL/MySQL databases via FastAPI
  • Explore tables, run custom SQL queries
  • Statistical analysis and exploratory data analysis (EDA)
  • Build ML models with XGBoost classifier
  • Decile tables, ROC curves, gains charts
  • Model scoring and evaluation metrics

Important Note

The ML pipeline demonstrates capabilities - it is not a point-and-click app. For new datasets, work iteratively with an AI coder to adapt the script.

How to Use

#
  1. Download & Install: get the app and install xlwings Lite
  2. Configure Database: update connection credentials in the MASTER sheet
  3. Built-in Functions:
    • list_tables - list all database tables
    • get_custom_query - run SQL queries
    • perform_eda - exploratory data analysis
    • score_and_deciles - XGBoost + decile tables

How It Works

#

Database Connectivity

  • FastAPI server handles database connections
  • API requests connect to PostgreSQL/MySQL
  • Responses returned to Excel for processing

ML Processing

  • All processing occurs locally in xlwings
  • XGBoost runs directly in the browser environment
  • Generates charts and tables for analysis

Free Database Options

Resources

xlwings Lite

Official website with installation instructions and examples
xlwings Documentation

Comprehensive documentation with Excel object reference and API docs
FastAPI Server Code

Database connectivity implementation on GitHub
xlwings Lite

Built with xlwings Lite

Created by Felix Zumstein, it brings Python into Excel seamlessly - enabling native support for databases, AI agents, LLMs, advanced analytics, ML, APIs, and complete automation workflows.

Bugs,issues,questions? Drop a note: [email protected]