The pattern TigZig uses: a FastAPI service that exposes database queries as MCP tools, so an MCP client like Claude can call them directly. The open-source reference exposes read-only SQL over Postgres and DuckDB, kept safe behind a layered security stack (read-only role, statement limits, timeouts).
The reference repository is https://github.com/amararun/shared-fastapi-database-mcp. A step-by-step build guide (Excel, Postgres, DuckDB and Claude over MCP) is at https://www.tigzig.com/post/talk-to-your-database-from-excel-postgres-duckdb-claude-mcp.
The hosted version (read-only SQL API + MCP, behind a multi-layer security stack) is documented at https://www.tigzig.com/apis/database, and the Database AI hub is at https://www.tigzig.com/database-landing.
Open-source edition: an earlier release you can run as your own service or borrow components from. Treat it as a reference implementation rather than a mirror of what is running here - the hosted service has moved on since.
Building something like this? How I work covers the rates, the availability and what I take on.