# Database AI & Text-to-SQL

Connect AI to databases (PostgreSQL, MySQL, DuckDB), run natural language queries, build text-to-SQL agents, analyze data with multi-agent frameworks.

## Apps (8)

### Quants, Technicals, Financials with DB connection via Flowise
- App: https://flowise-docker-custom.tigzig.com/chatbot/dc7495c5-e3dd-4410-afb2-737863ca3dc7
- Docs: https://tigzig.com/app-documentation/analyzer-agent.html
- AI Docs: https://tigzig.com/ai/apps/analyzer-agent.md
- Quants, Technicals, Financials with DB connection via Flowise

### Advanced analytics with Deepseek R1, connect to any Database
- App: https://flowise-docker-custom.tigzig.com/chatbot/daa92f93-3b9e-4fef-8f30-684f795e1c40
- Docs: https://tigzig.com/app-documentation/analyzer-deepseek.html
- AI Docs: https://tigzig.com/ai/apps/analyzer-deepseek.md
- Advanced analytics with Deepseek R1, connect to any Database

### DATS-4 Database AI Suite
- App: https://rexdb.tigzig.com
- Docs: https://tigzig.com/app-documentation/analyzer.html
- AI Docs: https://tigzig.com/ai/apps/analyzer.md
- Connect to any PostgreSQL or MySQL database, analyze CSV/TXT files up to 1.5GB, run multi-agent AI models for advanced analytics with charts and PDF reports.

### BRIQ - In-Browser DuckDB Analytics
- App: https://briq.tigzig.com
- Docs: https://tigzig.com/app-documentation/briq.html
- GitHub: https://github.com/amararun/shared-sql-rooms-tigzig-new
- AI Docs: https://tigzig.com/ai/apps/briq.md
- Natural language to SQL with DuckDB running entirely in the browser. Data stays local - nothing uploaded to servers. Supports CSV, Parquet, JSON, TSV, pipe-delimited, and DuckDB database files.

### ChatGPT connected to Supabase, Neon and Aiven databases for sports data
- App: https://chatgpt.com/g/g-68a6ef6973b881919c92458f5b369557-cricket-tour-de-france-data-explorer
- Docs: https://tigzig.com/app-documentation/cricket-tour-de-france-gpt.html
- AI Docs: https://tigzig.com/ai/apps/cricket-tour-de-france-gpt.md
- ChatGPT connected to Supabase, Neon and Aiven databases for sports data

### MCP Server: Database (Cricket SQL)
- App: https://rbicc.net/mcp-server-database
- Docs: https://db-mcp.tigzig.com/docs
- GitHub: https://github.com/amararun/shared-fastapi-database-mcp
- AI Docs: https://tigzig.com/ai/apps/mcp-server-database.md
- Read-only SQL query API for Postgres and DuckDB, exposed as MCP tools for AI clients. Contains ~1M rows of ODI cricket data (Postgres/Supabase) and ~1M rows of T20 cricket data (DuckDB).

### Connect ChatGPT to any MySQL & PG database
- App: https://chatgpt.com/g/g-6748a1c469648191a9a2253a46be82a3-rex-2-connect-to-any-database
- Docs: https://tigzig.com/app-documentation/rex2-gpt.html
- AI Docs: https://tigzig.com/ai/apps/rex2-gpt.md
- Connect ChatGPT to any MySQL & PG database

### Connect ChatGPT to Supabase (OLD)
- App: https://chatgpt.com/g/g-6785000cec888191985d29429888a373-supabase-connect
- Docs: https://tigzig.com/app-documentation/supabase-connect.html
- AI Docs: https://tigzig.com/ai/apps/supabase-connect.md
- Connect ChatGPT to Supabase (OLD)

## Blog Posts (58)

- [Are You Rate Limiting the Wrong IPs? A SlowAPI Story.](https://tigzig.com/post/are-you-rate-limiting-the-wrong-ips.html) — Tags: security, fastapi, cloudflare, infrastructure
  How modern multi-hop architectures (Vercel serverless + Cloudflare + FastAPI) cause SlowAPI to rate limit the wrong IPs. Covers the CF-Connecting-IP overwrite problem, X-Forwarded-For spoofing, the custom header fix, and a detailed FAQ on IP extraction across different proxy setups (Caddy, nginx, Docker, direct).
  AI-readable: https://tigzig.com/ai/posts/are-you-rate-limiting-the-wrong-ips.md
- [Talk to Your Database from Excel via Claude & MCP - Part 2](https://tigzig.com/post/talk-to-your-database-from-excel-mcp-part-2.html) — Tags: claude-in-excel, mcp
  Part 2 of connecting Excel to databases via Claude MCP. Two new server options: open public server hardened with 23 defense layers (rate limits, concurrency caps, SQL validation) and OAuth-secured server via Auth0 with JWT validation for client sharing. Full source code open as single Python file. Includes standard MCP security advice and link to 80+ item security checklist.
  AI-readable: https://tigzig.com/ai/posts/talk-to-your-database-from-excel-mcp-part-2.md
- [Talk to Your Database from Excel - Postgres, DuckDB - via Claude in Excel with MCP](https://tigzig.com/post/talk-to-your-database-from-excel-postgres-duckdb-claude-mcp.html) — Tags: claude-in-excel, mcp, duckdb, database-ai
  Public MCP server enabling SQL queries against live Postgres (Supabase, ODI cricket) and DuckDB (T20 cricket) databases from Claude in Excel. Covers 2 million rows of ball-by-ball data from 2013-2025. Built with FastAPI, asyncpg, and fastapi-mcp. Includes detailed tool docstrings for schema context, 1000-row response cap, read-only security, rate limiting, and SQL validation. Open source, single-file Python backend.
  AI-readable: https://tigzig.com/ai/posts/talk-to-your-database-from-excel-postgres-duckdb-claude-mcp.md
- [How I Built a Sub-Second Movie Similarity Engine With a 10-Line SQL Query](https://tigzig.com/post/movie-similarity-engine-sql-jaccard-duckdb.html) — Tags: duckdb, database-ai
  Movie similarity engine using weighted Jaccard similarity in pure SQL on DuckDB. Pre-computes token lists from 97M person-to-title records, filtering to 12,000 movies with 10,000+ votes. Tokens encode genre, directors, actors (weighted by billing), writers, decade, runtime, and rating band via token duplication. A single 10-line SQL query compares one movie against all others in under 1 second. Returns matching factors for explainability. Open source.
  AI-readable: https://tigzig.com/ai/posts/movie-similarity-engine-sql-jaccard-duckdb.md
- [From 12 second queries to under 1s: Optimizing a 230 Million Row Dashboard - 14 Bottlenecks I Had to Fix](https://tigzig.com/post/from-12-second-queries-to-under-1s-optimizing-230-million-row-dashboard.html) — Tags: duckdb, fastapi, infrastructure
  Documents 14 optimization techniques that reduced query times from 9-12 seconds to under 1 second on a 230M-row DuckDB dashboard (16GB). Covers pre-computed denormalized tables, single-blob dashboard cache, in-memory query caching, ORDER BY index conflicts, adaptive queries, EXISTS vs CTE (15x gap), client-side computation from loaded data, Docker container memory mismatch with DuckDB, and autocomplete race condition fixes. Open source with dual Hetzner/Oracle backends.
  AI-readable: https://tigzig.com/ai/posts/from-12-second-queries-to-under-1s-optimizing-230-million-row-dashboard.md
- [Architecture & Setup for a Dashboard with Hundreds of Millions of Records - Powered by DuckDB](https://tigzig.com/post/custom-dashboard-duckdb-fastapi-230-million-rows.html) — Tags: duckdb, fastapi, infrastructure, react
  Architecture guide for building a custom dashboard with 230M rows on DuckDB (16GB). Covers FastAPI backend with read-only and admin endpoints, React frontend on Vercel, serverless proxy for API security, dual backend setup (Hetzner/Oracle), data pipeline with pre-computed denormalized tables, Clerk auth toggle, query timer, and smart search. Addresses Docker container memory mismatch with DuckDB. Open source, runs on 8 EUR/month Hetzner VPS.
  AI-readable: https://tigzig.com/ai/posts/custom-dashboard-duckdb-fastapi-230-million-rows.md
- [Found a Python library that does all the heavy lifting for working with SEC EDGAR API - EdgarTools from Dwight Gunning](https://tigzig.com/post/edgartools-sec-edgar-python-library.html) — Tags: portfolio-analytics, fastapi
  Review of EdgarTools Python library by Dwight Gunning for SEC EDGAR data. Features built-in XBRL standardization for cross-company financial comparison, 10-30x speed improvement via PyArrow and lxml, automatic SEC rate limit compliance, and coverage of 10-K, 10-Q, 8-K, 13F, and Form 4 filings. Includes built-in MCP server for AI tool integration. Author is using it as backbone for a FastAPI quarterly comparison tool.
  AI-readable: https://tigzig.com/ai/posts/edgartools-sec-edgar-python-library.md
- [ChatGPT connected to your databases. One-click deployment instructions for AI Coders](https://tigzig.com/post/chatgpt-connected-databases-ai-coder-deployment.html) — Tags: database-ai, custom-gpt, ai-coders
  Custom GPT connected to three live databases (Supabase, Neon, Aiven) for natural language querying of cricket and Tour de France data. Features a 'Copy for AI Coders' button that provides deployment instructions for Claude Code or Google Antigravity to handle end-to-end setup including backend, frontend, and database provisioning. FastAPI server sits between ChatGPT and databases.
  AI-readable: https://tigzig.com/ai/posts/chatgpt-connected-databases-ai-coder-deployment.md
- [CinePro - 230M Rows, 16GB Database, Instant Queries with DuckDB](https://tigzig.com/post/cinepro-movie-explorer-duckdb.html) — Tags: duckdb, fastapi, react
  CinePro movie analytics dashboard built on 230M rows (16GB) of IMDb data in a single DuckDB file. Features type-as-you-search across 15M people, multi-filter discovery, Jaccard similarity for finding similar movies, career timeline analysis, side-by-side comparisons, and live query timer. Runs on $7/month Hetzner VPS alongside 40 other backends. Dual backend (Hetzner/Oracle) with UI toggle. Fully open source.
  AI-readable: https://tigzig.com/ai/posts/cinepro-movie-explorer-duckdb.md
- [BRIQ App: DuckDB AI in Browser - 500MB Files, 4M+ Records, No Database Setup](https://tigzig.com/post/briq-duckdb-ai-browser-no-database-setup.html) — Tags: duckdb, database-ai
  BRIQ is a browser-based DuckDB AI tool for querying flat files up to 1.5GB using natural language. No database setup or credentials needed. Upload CSV/TSV files, auto-converts to DuckDB in-browser, query with plain English. Data stays in browser except for LLM API calls. Built on SQL Rooms AI. Also available as single-file HTML for offline use. Supports merging, appending, and transforming multiple files. Open source.
  AI-readable: https://tigzig.com/ai/posts/briq-duckdb-ai-browser-no-database-setup.md
- [LLM Costing for Database AI Apps. Live Experience. Live App. Open Source](https://tigzig.com/post/llm-costing-for-database-ai-apps-live-experience-live-app-open-source.html) — Tags: database-ai, text-to-sql
  LLM cost analysis from 250+ structured tests on database AI apps. Key findings: single-step agents cost $0.50-$2.00 per 100 queries (80% of jobs), multi-agent setups run $15-$20 per 100 queries (10-50x multiplier). Claude Sonnet 4 leads quality, GPT-5 close but costs volatile. Links to DATS-4 open-source text-to-SQL suite with live app and 49-page field guide.
  AI-readable: https://tigzig.com/ai/posts/llm-costing-for-database-ai-apps-live-experience-live-app-open-source.md
- [Analyze Live Data | AWS-Azure DW | via Custom GPT & LLM Apps](https://tigzig.com/post/analyze-data-aws-azure-custom-gpt.html) — Tags: custom-gpt, database-ai
  Demonstrates connecting Custom GPTs and LLM apps to live AWS (RDS-MySQL) and Azure (MySQL) data warehouses for natural language querying. Covers data transformations, analysis, table operations, cross-warehouse operations, and ML model building. Uses FastAPI server as intermediary. Series includes upcoming guides on Flowise AI deployment, LLM cost-performance tradeoffs, and security considerations.
  AI-readable: https://tigzig.com/ai/posts/analyze-data-aws-azure-custom-gpt.md
- [Flowise is my goto platform for GenAI and LLM apps](https://tigzig.com/post/flowise-is-my-goto-platform-for-genai-llm-app-development.html) — Tags: database-ai, custom-gpt
  Overview of FlowiseAI as a preferred platform for GenAI and LLM app development. Highlights include integrated RAG with LangChain and LlamaIndex, 10-15+ vector database integrations (Pinecone, Vectara), Custom Tool for API calls, multi-LLM support including Groq and Gemini free tier, and Make.com/Zapier automation workflows. Open source, Y Combinator backed, 21K GitHub stars.
  AI-readable: https://tigzig.com/ai/posts/flowise-is-my-goto-platform-for-genai-llm-app-development.md
- [Mistakes I Made Building Text-to-SQL Agents in Live Projects. My 2025 Learnings](https://tigzig.com/post/mistakes-i-made-building-text-to-sql-agents-live-projects-2025-learnings.html) — Tags: text-to-sql, database-ai
  Documents mistakes from building production text-to-SQL agents over one year. Covers architecture (over-engineering for analytics when users need operations), context sharing (schema in YAML, business rules, categorical distributions), agent constraints (LIMIT rules, query caps, debug protocols, NULLIF for division), model selection (GPT-4.1-mini for routine, reserve premium for hard tasks), cache hit monitoring, and security (write access controls). Reduced cost from $20+ to under $2 per 100 queries.
  AI-readable: https://tigzig.com/ai/posts/mistakes-i-made-building-text-to-sql-agents-live-projects-2025-learnings.md
- [Large File Upload for Database AI Text-to-SQL Apps: A Practical Guide](https://tigzig.com/post/large-file-upload-for-database-ai-text-to-sql-apps.html) — Tags: database-ai, text-to-sql, fastapi
  Comprehensive guide documenting 30+ patterns for handling large file uploads (up to 1.6GB) through FastAPI backends. Covers chunked streaming (94% memory reduction at 1GB), Neon instant database provisioning, async handling with thread pools, Polars over Pandas, PostgreSQL COPY command (10-100x faster than INSERT), connection pooling with stale detection, timeout configuration, rate limiting, delimiter detection, and column sanitization. Tested with 11.8M rows.
  AI-readable: https://tigzig.com/ai/posts/large-file-upload-for-database-ai-text-to-sql-apps.md
- [Releasing REX-2: AI Decision Intelligence](https://tigzig.com/post/releasing-rex2-ai-decision-intelligence.html) — Tags: database-ai, text-to-sql
  REX-2 is an open-source AI decision intelligence tool featuring natural language to SQL and Python, interactive tables with stats, PDF report generation, and connections to any MySQL/PostgreSQL database. Supports temporary on-the-fly databases via Neon. Built with React, FastAPI, FlowiseAI, Auth0. Includes complex analysis capabilities like cards segment profiling and statistical charts via E2B sandbox. Four GitHub repos with video build guide.
  AI-readable: https://tigzig.com/ai/posts/releasing-rex2-ai-decision-intelligence.md
- [Try Text-to-SQL on Real Data - Multi-Million Rows & GB+ Sizes](https://tigzig.com/post/try-text-to-sql-on-real-data-gb-files-multi-million-rows.html) — Tags: text-to-sql, database-ai, duckdb
  DATS-4 text-to-SQL app with sample datasets from 64 rows (14KB) to 11.8M rows (1.6GB). Two-click setup creates temporary Postgres database via Neon API, uploads data, and connects AI agent. Nine LLM options from Gemini 2.0 Flash to Claude 4.5 Sonnet. Features dual agents (general and advanced), file uploads, working tables, CSV export, interactive table viewer, Python charts via E2B, and PDF output. Open source with seven GitHub repos.
  AI-readable: https://tigzig.com/ai/posts/try-text-to-sql-on-real-data-gb-files-multi-million-rows.md
- [Segment 1M customers from 10M transactions (640MB CSV) with natural language queries / Text-to-SQL - entirely in your browser. No server. No remote database. No IT approvals.](https://tigzig.com/post/run-advanced-analytics-locally-in-your-browser-no-server-no-remote-database-no-it-approvals.html) — Tags: duckdb, text-to-sql
  Browser-based analytics tool (DABX-1) using DuckDB-WASM and text-to-SQL AI for processing multi-GB files locally. Demonstrated segmenting 1M customers from 10M transactions (640MB CSV) entirely in-browser. Built on SQL Rooms framework. Available as a 3.5MB single HTML file. Supports CSV, TSV, Parquet. Data never leaves the machine.
  AI-readable: https://tigzig.com/ai/posts/run-advanced-analytics-locally-in-your-browser-no-server-no-remote-database-no-it-approvals.md
- [Gemini 3 Pro Added to Database AI Suite. Tested Against Claude Sonnet 4.5 and GPT-5.1.Results: Claude still leads. GPT-5.1 is solid. Gemini 3 Pro lands third.](https://tigzig.com/post/gemini-3-pro-added-to-database-ai-suite-tested-against-claude-sonnet-4-5-and-gpt-5-1-results-claud.html) — Tags: database-ai, text-to-sql
  Benchmark of Gemini 3 Pro against Claude Sonnet 4.5 and GPT-5.1 for multi-step database analysis in DATS-4. Scoring: Claude 115, GPT-5.1 100, Gemini 3 Pro 90. Tested on 1M customer + 10M transaction credit card analysis on AWS RDS MySQL. Includes detailed cost breakdown per 100 questions across reasoning and execution tiers.
  AI-readable: https://tigzig.com/ai/posts/gemini-3-pro-added-to-database-ai-suite-tested-against-claude-sonnet-4-5-and-gpt-5-1-results-claud.md
- [Two models added to Database AI Suite this week: GPT-5.1 and KIMI 2 Thinking.](https://tigzig.com/post/two-models-added-to-database-ai-suite-this-week-gpt-5-1-and-kimi-2-thinking.html) — Tags: database-ai, text-to-sql
  Evaluation of GPT-5.1 and KIMI 2 Thinking added to DATS-4 Database AI Suite. Covers reasoning model recommendations for advanced analysis planning and execution cost breakdown. GPT-5.1 is 20% cheaper than GPT-5 with reduced token bloat. GPT-4.1-mini recommended as execution workhorse. Multi-step workflows cost approximately $15 per 100 questions.
  AI-readable: https://tigzig.com/ai/posts/two-models-added-to-database-ai-suite-this-week-gpt-5-1-and-kimi-2-thinking.md
- [Instant Database Setup for AI Apps. With Neon.com](https://tigzig.com/post/instant-database-setup-for-ai-apps-with-neon-com.html) — Tags: database-ai, infrastructure
  Guide to using Neon.com for instant Postgres database provisioning via API in under 1 second. Used in the DATS-4 app for on-demand database creation when users upload CSV files. Covers the full workflow from CSV upload to AI-ready database. Notes Neon's free tier supports up to 30 projects with 15GB total storage. References Replit, Retool, and Vercel as large-scale users.
  AI-readable: https://tigzig.com/ai/posts/instant-database-setup-for-ai-apps-with-neon-com.md
- [Database AI, built for day-to-day work. Five categories, ten micro apps. Live, open source, free.](https://tigzig.com/post/database-ai-built-for-day-to-day-work-five-categories-ten-micro-apps-live-open-source-free.html) — Tags: database-ai, text-to-sql
  Overview of 10 open-source Database AI micro-apps across 5 categories: Custom Builds, Rapid Deploy, ChatGPT, Realtime Voice, and xlwings Lite. All support natural language to SQL for Postgres, MySQL, and DuckDB. Includes chart visualization, table transformation, and on-the-fly database connections. Modular architecture allows mixing frontend and backend components.
  AI-readable: https://tigzig.com/ai/posts/database-ai-built-for-day-to-day-work-five-categories-ten-micro-apps-live-open-source-free.md
- [Run a Full AI Database App as a Single HTML File. No Server. No Remote DB.](https://tigzig.com/post/run-a-full-ai-database-app-as-a-single-html-file-no-server-no-remote-db.html) — Tags: database-ai, duckdb
  Single-file deployment of a full AI database app based on SQL Rooms and DuckDB-WASM. The entire React application compiles into a portable 3.5MB HTML file. Demonstrated importing 1.6GB / 11M-row files for in-browser analysis. Built using vite-plugin-singlefile. Supports Gemini API for natural language querying. No backend or server required.
  AI-readable: https://tigzig.com/ai/posts/run-a-full-ai-database-app-as-a-single-html-file-no-server-no-remote-db.md
- [Chat, Query, and Transform Multi-GB Files - In Natural Language, Right in Your Browser with DuckDB.](https://tigzig.com/post/chat-query-and-transform-multi-gb-files-in-natural-language-right-in-your-browser-with-duckdb.html) — Tags: duckdb, text-to-sql
  In-browser analytics tool using DuckDB-WASM and SQL Rooms for querying multi-GB files via natural language. Demonstrated analyzing a 1.6GB, 11M-row CSV file entirely locally. Supports CSV, TSV, pipe-delimited, and Parquet files. Data stays in browser; only schema and sample rows sent to LLM. Supports Gemini, OpenAI, and Claude APIs. Open source.
  AI-readable: https://tigzig.com/ai/posts/chat-query-and-transform-multi-gb-files-in-natural-language-right-in-your-browser-with-duckdb.md
- [Connect ChatGPT to Multiple Remote Databases](https://tigzig.com/post/connect-chatgpt-to-multiple-databases.html) — Tags: custom-gpt, database-ai
  Architecture for connecting a Custom GPT to multiple remote Postgres databases (Supabase, Neon, Aiven) via FastAPI. Uses function calling with OpenAPI schema, YAML semantic layer for schema context, and routing rules. Demonstrated querying 2.5M rows across 340MB of cricket (ODI/T20) and Tour de France data spanning 122 years. Open source with full repo.
  AI-readable: https://tigzig.com/ai/posts/connect-chatgpt-to-multiple-databases.md
- [Sonnet 4.5. Released yesterday. Now live on DATS-4 SQL Agent Suite. Solid upgrade, but more 4.2 than 4.5.](https://tigzig.com/post/sonnet-4-5-released-yesterday-now-live-on-dats-4-sql-agent-suite-solid-upgrade-but-more-4-2-than.html) — Tags: database-ai, text-to-sql
  Evaluation of Claude Sonnet 4.5 for multi-step database analysis in DATS-4. Scores: Sonnet 4.5 (115), Sonnet 4 (100), GPT-5 (95), Qwen3 Max (90), DeepSeek R1 (85). Same cost as Sonnet 4. Tested on credit card data mart builds (1M customers, 10M transactions on AWS RDS MySQL) and RBI weighted scoring. Includes per-100-question cost analysis.
  AI-readable: https://tigzig.com/ai/posts/sonnet-4-5-released-yesterday-now-live-on-dats-4-sql-agent-suite-solid-upgrade-but-more-4-2-than.md
- [Cricket (ODI/T20) & Tour de France stats from a Custom GPT connected to 3 live databases.](https://tigzig.com/post/cricket-odi-t20-tour-de-france-stats-from-a-custom-gpt-connected-to-3-live-databases.html) — Tags: custom-gpt, database-ai
  Custom GPT connected to three live Postgres databases (Supabase, Neon, Aiven) for querying 2.5M rows of cricket ODI/T20 ball-by-ball data (2003-2025) and 122 years of Tour de France history. Dynamically routes queries to the correct database. Computes player stats, rankings, charts. Open-source FastAPI backend with OAuth support.
  AI-readable: https://tigzig.com/ai/posts/cricket-odi-t20-tour-de-france-stats-from-a-custom-gpt-connected-to-3-live-databases.md
- [Can an AI SQL Agent build a weighted scoring system from scratch?](https://tigzig.com/post/can-an-ai-sql-agent-build-a-weighted-scoring-system-from-scratch.html) — Tags: database-ai, text-to-sql
  Walkthrough of using DATS-4 SQL Agent to build a weighted composite scoring system for ranking Indian banks on credit cards using RBI monthly data. Covers the full process: load data to temporary Postgres, instruct agent to derive variables and design scoring, review SQL reasoning, iterate on weights, and export as PDF report.
  AI-readable: https://tigzig.com/ai/posts/can-an-ai-sql-agent-build-a-weighted-scoring-system-from-scratch.md
- [Go from a 200MB flat file with 1.5M records to analysis in minutes with my open-source AI-SQL App](https://tigzig.com/post/go-from-a-200mb-flat-file-with-1-5m-records-to-analysis-in-minutes-with-my-open-source-ai-sql-app.html) — Tags: database-ai, text-to-sql
  Step-by-step guide to loading a 200MB, 1.5M-record ODI cricket dataset into a free Neon Postgres database and querying it via DATS-4 with natural language. Covers database setup, file upload, and natural language querying with charting. Notes that production use requires data engineering, semantic layers, and cleaning beyond the demo workflow.
  AI-readable: https://tigzig.com/ai/posts/go-from-a-200mb-flat-file-with-1-5m-records-to-analysis-in-minutes-with-my-open-source-ai-sql-app.md
- [Qwen3 Max now live on DATS-4 SQL Agent Suite for Advanced Analysis Better than DeepSeek R1, closer to Claude Sonnet 4 - at a lower cost.](https://tigzig.com/post/qwen3-max-now-live-on-dats-4-sql-agent-suite-for-advanced-analysis-better-than-deepseek-r1-closer-t.html) — Tags: database-ai, text-to-sql
  Benchmark of Qwen3 Max added to DATS-4 SQL Agent Suite. Quality scores: Claude Sonnet 4 (100), GPT-5 (95), Qwen3 Max (90), DeepSeek R1 (85). Cost per 100 advanced analysis questions ranges from $14.25 (Gemini 2.5 Flash) to $27.50 (GPT-5). Each advanced question triggers 7-10 SQL queries. Tested on credit card data mart and RBI ranking tasks.
  AI-readable: https://tigzig.com/ai/posts/qwen3-max-now-live-on-dats-4-sql-agent-suite-for-advanced-analysis-better-than-deepseek-r1-closer-t.md
- [Database AI & SQL - Now choose you LLM: GPT-5, Deepseek, Qwen 3 Thinking. Live. Open Source.](https://tigzig.com/post/database-ai-sql-now-choose-you-llm-gpt-5-deepseek-qwen-3-thinking-live-open-source.html) — Tags: database-ai, text-to-sql
  DATS-4 Database AI Suite update adding LLM selection: Claude Sonnet 4, GPT-5, DeepSeek, and Qwen 3 Thinking. Demonstrates self-healing agent behavior (recovers from SQL errors by inspecting data). Full-stack features include on-the-fly database connect, instant Postgres creation, agent reasoning traces, and PDF outputs. Built on 15+ months of live client operations.
  AI-readable: https://tigzig.com/ai/posts/database-ai-sql-now-choose-you-llm-gpt-5-deepseek-qwen-3-thinking-live-open-source.md
- [Database AI & SQL Agent - Connect to any database on-the-fly. Live. Open Source](https://tigzig.com/post/database-ai-sql-agent-connect-to-any-database-on-the-fly-live-open-source.html) — Tags: database-ai, text-to-sql
  Demo of DATS-4 core text-to-SQL workflow: paste database credentials (MySQL/Postgres) in any format, AI parses them to valid JSON, then query in natural language. Agent shows full transparency: reasoning, generated SQL, and results in tables and charts. Supports data transformation, table creation, merges, and CSV export. Open source.
  AI-readable: https://tigzig.com/ai/posts/database-ai-sql-agent-connect-to-any-database-on-the-fly-live-open-source.md
- [Free, Production-Grade Databases. Get setup in minutes. Great for testing and development](https://tigzig.com/post/free-production-grade-databases-get-setup-in-minutes-great-for-testing-and-development.html) — Tags: database-ai, infrastructure
  Comparison of three free database providers for AI app development: Neon (sub-1-second Postgres via API, best for AI apps), Supabase (auth integration), and Aiven (5GB free tier, supports both Postgres and MySQL). Used across DATS-4, Custom GPT, and Realtime Voice AI deployments. Includes a spec sheet comparing features.
  AI-readable: https://tigzig.com/ai/posts/free-production-grade-databases-get-setup-in-minutes-great-for-testing-and-development.md
- [Database & SQL AI: On-the-fly database transformation with natural language. Connect, transform, and export instantly.](https://tigzig.com/post/database-sql-ai-on-the-fly-database-transformation-with-natural-language-connect-transform-and.html) — Tags: database-ai, text-to-sql
  DATS-4 Database AI Suite workflow for on-the-fly data transformation: connect to any MySQL/Postgres database, instruct the agent in natural language to create derived variables and transformations, review agent reasoning and SQL, and export results to CSV. Also supports direct CSV uploads and temporary Postgres instances. Open source.
  AI-readable: https://tigzig.com/ai/posts/database-sql-ai-on-the-fly-database-transformation-with-natural-language-connect-transform-and.md
- [AI for Databases: Field Guide, Live Apps & Lessons](https://tigzig.com/post/ai-for-databases-field-guide-live-apps-lessons.html) — Tags: database-ai, text-to-sql
  50-page practitioner's field guide on AI for databases based on 15+ months of live client deployments. Covers security checklists, datamart design, 3-agent orchestration architecture, LLM recommendation matrix, cost analysis (simple vs advanced queries), usage patterns, and platform stack. Includes 8 live apps across 4 variants plus full source code.
  AI-readable: https://tigzig.com/ai/posts/ai-for-databases-field-guide-live-apps-lessons.md
- [xlwings lite |Connect to Remote Databases](https://tigzig.com/post/python-in-excel-with-xlwings-lite-part-2-connect-to-remote-databases.html) — Tags: xlwings-lite, python-in-excel, database-ai
  xlwings Lite Part 2: connecting Excel to remote PostgreSQL databases via a custom FastAPI web layer. Demonstrates exploring tables, pulling records, running custom SQL, then performing EDA with descriptive stats, frequency tables, distribution plots, and building an XGBoost response model with evaluation metrics, decile table, and ROC/Gains chart. Includes FastAPI server source code, Render deployment guide, and 20-minute video walkthrough.
  AI-readable: https://tigzig.com/ai/posts/python-in-excel-with-xlwings-lite-part-2-connect-to-remote-databases.md
- [AI-Powered Automation: Connect ChatGPT to n8n](https://tigzig.com/post/7d905dcc.html) — Tags: custom-gpt, database-ai
  Connecting ChatGPT to n8n workflows for automation including backend database updates (Postgres, Google Sheets), Python processing via FastAPI (markdown-to-PDF), Google Apps Script automation (formatted PDFs, slides, emails), dynamic database connections, and AI content enhancement. Setup uses Custom GPT with OpenAPI action schema connecting to n8n webhook endpoints. Includes n8n workflow JSON, FastAPI server repos, and video walkthrough.
  AI-readable: https://tigzig.com/ai/posts/7d905dcc.md
- [Quick Deploy Advanced Analysis Multi-Agent with Flowise](https://tigzig.com/post/quick-deploy-advanced-analysis-multi-agent-with-flowise.html) — Tags: database-ai
  Four-step quick deployment guide for a multi-agent advanced analytics system using Flowise AI. Import agent schemas, update credentials, deploy a FastAPI SQL connector, and adjust security settings. Supports reasoning models (Deepseek, Gemini, Sonnet 3.7) with a sequential agent architecture. Tips cover free database setup (Neon, Aiven, Supabase), adding new reasoning models via OpenRouter, and customizing agent routing.
  AI-readable: https://tigzig.com/ai/posts/quick-deploy-advanced-analysis-multi-agent-with-flowise.md
- [AI Co-Analyst — Live Multi-Agent App. Cost, quality, reliability — what works? what doesn’t?](https://tigzig.com/post/ai-co-analyst-live-multi-agent-app-cost-quality-reliability.html) — Tags: database-ai, text-to-sql
  Detailed benchmarking of LLM models (Sonnet 3.7, Deepseek-R1, Gemini 2.0 Flash, o3-mini) for AI co-analyst use cases. Covers quality rankings, cost per query (8.5c to 20.5c for reasoning queries), latency ranges (1-10+ minutes), and API reliability. Architecture uses Flowise sequential agents (LangGraph) with router, reasoning, and executor (GPT-4o) agents. Includes live demo app, 5 repos, 7 Flowise schemas, and video build guide.
  AI-readable: https://tigzig.com/ai/posts/ai-co-analyst-live-multi-agent-app-cost-quality-reliability.md
- [Multi-Agents (Sequential) with Reasoning – Connect to any database - o3-mini / Deepseek-R1 / Flash-2.0. Built with Flowise.](https://tigzig.com/post/multi-agents-sequential-reasoning-connect-database-o3-mini-deepseek-r1-flash-2-0-flowise.html) — Tags: database-ai
  Multi-agent sequential architecture built with Flowise (LangGraph backend) offering 6 database agent options with o3-mini, Deepseek-R1, and Gemini Flash 2.0. Flow: router agent directs to general analyst or advanced route where reasoning LLM generates analysis plan and SQL, then GPT-4o executor verifies and runs queries. Supports any database connection, NL-to-SQL, NL-to-Python charts. Includes Flowise agent templates and tool schemas.
  AI-readable: https://tigzig.com/ai/posts/multi-agents-sequential-reasoning-connect-database-o3-mini-deepseek-r1-flash-2-0-flowise.md
- [Google Gemini 2.0 Flash — solid API performance, great quality, and cheaper than GPT-4-mini. The new workhorse?](https://tigzig.com/post/google-gemini-2-0-flash-api-performance-quality-cheaper-gpt-4o-mini.html) — Tags: database-ai
  Evaluation of Gemini 2.0 Flash API for production LLM workloads. Benchmarks against GPT-4o-mini, GPT-4o, and Claude 3.5 Sonnet across automation, web scraping, structured output, and OCR tasks. Gemini 2.0 Flash shows quality matching GPT-4o, reasoning comparable to Deepseek-R1, and pricing below GPT-4o-mini ($0.10/$0.40 per million input/output tokens) with a generous free tier (15 req/min, 1500 req/day).
  AI-readable: https://tigzig.com/ai/posts/google-gemini-2-0-flash-api-performance-quality-cheaper-gpt-4o-mini.md
- [AI Driven Advanced Analytics. Reasoning based Sequential Agents. Connect to any database — o3-mini/deepseek-r1 / gemini-flash-2.0.](https://tigzig.com/post/ai-driven-advanced-analytics-reasoning-based-sequential-agents-connect-to-any-database-o3-mini-d.html) — Tags: database-ai, text-to-sql
  Open-source advanced analytics app using sequential agents (LangGraph via Flowise) with reasoning models (o3-mini, Deepseek-R1, Gemini Flash 2.0) and GPT-4o executor. Features NL-to-SQL, NL-to-Python charts, file upload with on-the-fly Postgres DB creation (Neon), execution logs, and agent reasoning view. Built with React/TypeScript/Vite, FastAPI backends, deployed on Vercel and Hetzner. Includes 1-hour video guide, 4 repos, and 6 Flowise schemas.
  AI-readable: https://tigzig.com/ai/posts/ai-driven-advanced-analytics-reasoning-based-sequential-agents-connect-to-any-database-o3-mini-d.md
- [Connect ChatGPT to Supabase in 10 mins.](https://tigzig.com/post/connect-chatgpt-to-supabase-in-10-mins.html) — Tags: custom-gpt, database-ai
  Step-by-step guide to connect a Custom GPT to a Supabase PostgreSQL database in 10 minutes. Deploy a FastAPI server (SQL Alchemy) on Render, create a Custom GPT with OpenAPI action schema, and enable NL-to-SQL, charts, and Python statistical analysis through ChatGPT. Same process works for any PostgreSQL or MySQL database. Includes GitHub repo, video demo, and API key security setup.
  AI-readable: https://tigzig.com/ai/posts/connect-chatgpt-to-supabase-in-10-mins.md
- [Chat with database: 20 AI platforms you need to know](https://tigzig.com/post/chat-with-database-20-ai-platforms-you-need-to-know.html) — Tags: database-ai
  Survey of 20 AI platforms for database chat and analysis, covering production tools and prototypes from simple to complex. Platforms reviewed include Datalang, Ask-Your-Database, Blaze SQL, Wren AI, SQL Chat, Julius AI, Quills AI, Vanna AI, and others. Highlights unique features: SQL editors, data modeling, graph builders, RAG pipelines, API layers. Compares with REX platform features including file upload, on-the-fly DB creation, and real-time voice.
  AI-readable: https://tigzig.com/ai/posts/chat-with-database-20-ai-platforms-you-need-to-know.md
- [Connect, Chat and Analyze Any Database with ChatGPTFast, Simple, and Powerful.](https://tigzig.com/post/connect-any-database-with-chatgpt.html) — Tags: custom-gpt, database-ai
  Guide to connecting ChatGPT to any MySQL or PostgreSQL database using REX-2's FastAPI backend and Custom GPT actions. Setup involves creating a GPT with ready-to-use instructions and JSON schema, then deploying FastAPI on Render. Enables NL-to-SQL, voice-to-SQL, data transformation, statistical analysis, and Python charts through ChatGPT or REX UI. Includes instant database creation via Neon and file upload capabilities.
  AI-readable: https://tigzig.com/ai/posts/connect-any-database-with-chatgpt.md
- [REX-2: Your AI Analyst on Call](https://tigzig.com/post/rex-2-your-ai-analyst-on-call.html) — Tags: database-ai, text-to-sql
  Demo of REX-2 AI analyst workflow: create a database on the fly, upload 100MB CSV/TXT files, and query with voice or text for analysis tables and charts in under 150 seconds. Features include NL-to-SQL, interactive tables with sorting/filtering/stats, statistical analysis, AI reports, and PDF generation. Supports connecting to existing MySQL/PostgreSQL warehouses. Uses Windows voice dictation (Win+H) for voice input.
  AI-readable: https://tigzig.com/ai/posts/rex-2-your-ai-analyst-on-call.md
- [REX-2 : AI Driven Analytics](https://tigzig.com/post/rex-2-ai-driven-analytics-python-connect-to-any-database.html) — Tags: database-ai, text-to-sql
  Release notes for REX-2 AI decision intelligence platform. Features NL-to-SQL, NL-to-Python, statistical analysis, Python charts, interactive tables, PDF reports, connection to any MySQL/PostgreSQL warehouse, on-the-fly temporary database creation via Neon, and CSV/TXT file upload. Built with React/TypeScript/Vite/Shadcn, Flowise AI backend, E2B for Python execution, FastAPI for DB connectivity, deployed on Vercel and Hetzner via Coolify. Four GitHub repos included.
  AI-readable: https://tigzig.com/ai/posts/rex-2-ai-driven-analytics-python-connect-to-any-database.md
- [AI Analytics Assistant: 5 Part Implementation Guide](https://tigzig.com/post/ai-analytics-assistant-5-part-implementation-guide.html) — Tags: database-ai, text-to-sql
  Five-part implementation guide (2+ hours video) for building an AI analytics assistant with voice and text input. Covers Flowise AI agent setup, Make.com workflow integration, Google Apps Script automation, custom React frontend development with Claude Dev and Cursor AI, and Vercel deployment. Each part includes hands-on walkthroughs with timestamps. Source code, JSON schemas, and blueprints available on GitHub.
  AI-readable: https://tigzig.com/ai/posts/ai-analytics-assistant-5-part-implementation-guide.md
- [How to connect Custom GPT to live data warehouses. Implementation Guide](https://tigzig.com/post/connect-custom-gpt-to-live-data-warehouses-implementation-guide.html) — Tags: custom-gpt, database-ai
  Implementation guide for connecting Custom GPT to live data warehouses (AWS RDS MySQL and Azure MySQL simultaneously) using OpenAPI custom actions. Covers FastAPI SQL connector deployment on Render, JSON action schema generation for OpenAI, and security/monitoring considerations. Enables querying, transformation, analysis, and charting via text or voice (including Hindi/Hinglish). Includes Medium article, GitHub repo, and cost analysis.
  AI-readable: https://tigzig.com/ai/posts/connect-custom-gpt-to-live-data-warehouses-implementation-guide.md
- [How to update Excel, Google Sheet and backend Databases with Natural Language commands with Voice Agents](https://tigzig.com/post/how-to-build-ai-action-agents-beyond-chat-with-voice-agents.html) — Tags: voice-ai, database-ai
  Part 1 of a 5-part series on building voice-enabled LLM action agents (VTEXER). Demonstrates updating Excel, Google Sheets, and remote databases, generating PDF reports and slides, querying MySQL, and emailing results via natural language voice commands. Uses Flowise AI ReAct agents with function calling, Make.com automation workflows, Google Apps Script, and FastAPI backend. Built with React.js frontend, all code generated by AI tools.
  AI-readable: https://tigzig.com/ai/posts/how-to-build-ai-action-agents-beyond-chat-with-voice-agents.md
- [How to update Excel, Google Sheet and backend Databases with Natural Language commands with Voice Agents](https://tigzig.com/post/how-to-update-excel-google-sheets-and-databases-with-ai-voice-agents.html) — Tags: voice-ai, database-ai
  Part 2 implementation guide for AI voice action agents. Hands-on 45-minute video showing how to set up Flowise ReAct agents and Make.com webhooks to update Excel, Google Sheets, and databases via voice commands. Covers two go-live scenarios: Flowise native UI and full custom voice bot UI. Deployable source code on GitHub produces a functional voice bot. Integrates with 1000+ platforms via Make.com connectors.
  AI-readable: https://tigzig.com/ai/posts/how-to-update-excel-google-sheets-and-databases-with-ai-voice-agents.md
- [How to use AI Assisted Coding Tools like Claude Dev and Cursor AI to develop LLM Apps with natural language commands. And deploy to open internet.](https://tigzig.com/post/build-ai-voice-action-agent-app-in-react-js-in-natural-language.html) — Tags: voice-ai, ai-coders
  Part 4: using AI-assisted coding tools (Claude Dev VS Code extension and Cursor AI) to build LLM voice agent apps with natural language instructions. Demonstrates building a React.js voice bot with voice-to-text, chat completion, and text-to-speech components, then deploying to Vercel. Covers GitHub-to-Vercel deployment pipeline, multilingual support, and API endpoint routing to Flowise LLM agents.
  AI-readable: https://tigzig.com/ai/posts/build-ai-voice-action-agent-app-in-react-js-in-natural-language.md
- [Meet REX-1: Your Realtime AI Analytics Agent System (Web Version)](https://tigzig.com/post/rex1-your-realtime-ai-analytics-agent-system-web-version.html) — Tags: database-ai, text-to-sql
  REX-1 real-time AI analytics agent built on OpenAI's Realtime API (~$1/min). Connects to data warehouses (AWS, Azure, MySQL) for voice-driven text-to-SQL, statistical analysis, Python charts, web scraping, stock technical charts, and reporting automation. Backend uses Flowise AI agents, Make.com workflows, and custom FastAPI servers. Includes 90-minute build guide video, non-realtime free tier with voice input, and detailed architecture walkthrough.
  AI-readable: https://tigzig.com/ai/posts/rex1-your-realtime-ai-analytics-agent-system-web-version.md
- [GenAI App | LLM Analytics Assistant: Simplifying Data Transformation & Insights. AWS & Azure MySQL DW Example](https://tigzig.com/post/genai-llm-app-analytics-assistant-aws-azure-mysql.html) — Tags: database-ai, text-to-sql
  LLM analytics assistant app demonstrating data transformation and analysis on AWS MySQL with million-to-10M-row datasets. Covers creating customer profiles, summary tables, merging data via natural language instructions through Flowise AI platform. Details architecture with modular FastAPI processing server, model selection trade-offs (GPT-3.5 at ~$1 for 478 queries over 10 hours), cost optimization strategies, and split workflow approaches to minimize LLM token ingestion costs.
  AI-readable: https://tigzig.com/ai/posts/genai-llm-app-analytics-assistant-aws-azure-mysql.md
- [VOICE MODE - Querying & Analyzing Data with Custom GPT AWS - Azure Data Warehouse](https://tigzig.com/post/voice-mode-query-analyze-database-aws-azure-custom-gpt.html) — Tags: voice-ai, custom-gpt, database-ai
  Demonstration of ChatGPT voice mode for querying and analyzing an Azure MySQL data warehouse via Custom GPT. Shows inserting conditional fields, creating distributions from calculated fields, generating charts, creating summary tables, merging datasets, and table operations via voice commands. Applications include senior leadership voice dashboards, ad-hoc query support, and rapid data transformations. Part 2 of the AWS/Azure data warehouse series.
  AI-readable: https://tigzig.com/ai/posts/voice-mode-query-analyze-database-aws-azure-custom-gpt.md
- [LLM App | FastAPI Server | Web](https://tigzig.com/post/blog-llm-app-get-yahoo-financials-flowise-fastapi.html) — Tags: database-ai, fastapi, portfolio-analytics
  YFIN Bot: an LLM app built with Flowise AI and FastAPI for extracting Yahoo Finance data (balance sheet, P&L, cash flow, quarterly income, closing prices) for listed equities. Uses Langchain Function Agent with custom tool, GPT-3.5-Turbo, and a Python/yfinance FastAPI server deployed on Render. Available as web app and Custom GPT on GPT Store. All code generated by ChatGPT and Gemini.
  AI-readable: https://tigzig.com/ai/posts/blog-llm-app-get-yahoo-financials-flowise-fastapi.md
- [Building Machine Learning Models with ChatGPT - Part 2: Modeling Process Listing & EDA](https://tigzig.com/post/build-machine-learning-model-with-chatgpt-exploratory-data-analysis-eda.html) — Tags: custom-gpt, database-ai
  Part 2 of building ML models with ChatGPT: getting detailed modeling process documentation and exploratory data analysis (EDA). Shows how prompting ChatGPT to share process steps, results, plots, and distributions before model building produces comprehensive EDA output. Demonstrates that specific instructions yield specific outputs, with video walkthrough of the iterative prompt refinement process.
  AI-readable: https://tigzig.com/ai/posts/build-machine-learning-model-with-chatgpt-exploratory-data-analysis-eda.md
- [Build Machine Learning Model with ChatGPT prompts: Random Forest example.](https://tigzig.com/post/build-machine-learning-model-chatgpt.html) — Tags: custom-gpt, database-ai
  Building a Random Forest propensity model entirely through ChatGPT prompts: data preprocessing, model building, validation, decile tables, feature importance, and scoring code generation. Covers tips for managing GPT limits (start with low complexity: 30 trees, depth 3), avoiding overfitting, using Google Colab T4 GPU for intensive tasks, and data security (anonymize PI data, use scrambled data). Includes five sequential base prompts for replication.
  AI-readable: https://tigzig.com/ai/posts/build-machine-learning-model-chatgpt.md

## Related Topics

- [Python in Excel (xlwings Lite)](https://tigzig.com/ai/tags/python-in-excel.md)
- [Claude in Excel](https://tigzig.com/ai/tags/claude-in-excel.md)
- [DuckDB - Analytics & Dashboards](https://tigzig.com/ai/tags/duckdb.md)
- [MCP Servers & Agents](https://tigzig.com/ai/tags/mcp-servers.md)
- [Portfolio & Quantitative Analysis](https://tigzig.com/ai/tags/portfolio-quants.md)