# Database AI & Text-to-SQL: Chat With Any Database Put AI on your data, in plain English. A free read-only Database MCP to talk to Postgres or DuckDB straight from Excel or Claude, live text-to-SQL apps for remote and in-browser databases, DB-connected Custom GPTs, and a field guide from 15+ months of live client deployments. This hub links the tools, the MCP and API, and 60+ practitioner guides. Open source, free. Source: https://www.tigzig.com/database-landing ## Live text-to-SQL apps The interactive tools - connect a remote database or drop a file, then analyze and transform it in natural language. All open source. - [DATS-4 Database AI Suite - remote databases](https://www.tigzig.com/analyzer) - The flagship workbench: connect to any remote DB, upload CSV/TXT into tables, analyze and transform with natural language, Python charts and stats. Multi-model. - [BRIQ - In-Browser DuckDB](https://www.tigzig.com/briq) - DuckDB runs locally in your browser - process large CSVs, natural-language to SQL, charts. Data never leaves your machine. - [DuckIt - CSV to DuckDB](https://www.tigzig.com/duckit-xlwings) - Convert CSV/TSV (and Parquet) into a DuckDB database and get a shareable link. - [CSV Processor](https://www.tigzig.com/csv-processor) - Clean, merge and reshape CSV files with AI before they hit a database. - [Rapid Deploy - Deepseek R1 (Flowise UI)](https://www.tigzig.com/analyzer-deepseek) - The text-to-SQL agent on a Flowise UI, powered by Deepseek R1. Connect to any database. - [Rapid Deploy - Quants Agent (Flowise UI)](https://www.tigzig.com/analyzer-agent) - Quants, technicals and financials over a database, Flowise UI, PDF and web reports. ## Database MCP - talk to your database from Excel or Claude The read-only Database MCP lets an AI client (Claude in Excel, Claude Desktop, any MCP client) query your Postgres or DuckDB in plain English and pull the rows straight back. No key, no sign-up. - [Database Query MCP - reference](https://www.tigzig.com/apis/database) - The DuckDB and Postgres read-only SQL MCP server: what it does, how to connect, the safety model. No key. - [MCP server showcase](https://www.tigzig.com/mcp-server-database) - The one-page card for the database MCP server, for humans and AI agents. - [Talk to Your Database from Excel - Postgres, DuckDB, via Claude + MCP](https://www.tigzig.com/post/talk-to-your-database-from-excel-postgres-duckdb-claude-mcp) - The walk-through: wire Claude in Excel to a live database over MCP. - [Talk to Your Database from Excel - Part 2](https://www.tigzig.com/post/talk-to-your-database-from-excel-mcp-part-2) - The follow-up, deeper patterns. - [Claude in Excel with MCP Connector - talk to your backends](https://www.tigzig.com/post/claude-in-excel-mcp-connector-talk-to-backends) - Reach any backend from inside the sheet. - [MCP Guide for Claude in Excel - and any MCP client](https://www.tigzig.com/post/mcp-guide-claude-in-excel) - The general setup guide, start here to wire up MCP. ## Custom GPTs connected to databases Ready-made ChatGPT custom GPTs wired to live databases via custom actions. Source and OpenAPI schemas are embedded in each app page. - [REXDB GPT - ChatGPT connected to your databases](https://www.tigzig.com/rex2-gpt) - Query Postgres / MySQL from ChatGPT with a hardened read-only backend. - [Cricket (ODI/T20) and Tour de France GPT](https://www.tigzig.com/cricket-tour-de-france-gpt) - A Custom GPT connected to 3 live sports databases - a worked example of the pattern. - [n8n Automation GPT](https://www.tigzig.com/n8n-automation) - ChatGPT to n8n for database queries, automation and Google Apps Script. - [ChatGPT connected to your databases - deployment guide](https://www.tigzig.com/post/chatgpt-connected-databases-ai-coder-deployment) - One-click deployment instructions for AI coders. ## Database infrastructure & production backends How the data layer is provisioned and served at scale - the pieces behind the apps. - [Neon Database Proxy - instant Postgres provisioning](https://neon.tigzig.com) - Programmatic Neon Postgres database/role creation and automated cleanup. Open source, hardened. - [Instant Database Setup for AI Apps, with Neon](https://www.tigzig.com/post/instant-database-setup-for-ai-apps-with-neon-com) - Why and how the provisioning proxy works. - [A dashboard on 230M+ rows with DuckDB + FastAPI](https://www.tigzig.com/post/custom-dashboard-duckdb-fastapi-230-million-rows) - Architecture for hundreds of millions of records at sub-second query. - [Full backend infrastructure for a DuckDB production system](https://www.tigzig.com/post/full-backend-infrastructure-duckdb-production) - The end-to-end production setup. ## Field Guide - deploying AI on databases (PDF) A 50-page field guide from 15+ months of running the DATS-4 suite for live client operations. Practice, not theory: security hard rules, datamart construction, agent orchestration, and LLM cost management. - [Field Guide - Main (Aug 2025)](https://www.tigzig.com/files/DATS_4_DATABASE_AI_SUITE.pdf) - The full 50-page guide. - [Costing - Qwen3 Max (Sep 2025)](https://www.tigzig.com/files/DATS4_COSTING_UPDATE_SEP2025_QWEN.pdf) - Cost/quality update. - [Costing - Claude Sonnet 4.5 (Sep 2025)](https://www.tigzig.com/files/DATABASE_AI_SUITE_V7_SONNET4.5.pdf) - Cost/quality update. - [Costing - GPT 5.1 / Gemini 3 Pro (Dec 2025)](https://www.tigzig.com/files/DATABASE_AI_SUITE_COSTING_NOV2025_GEMINI_3_PRO_FOR_WEBSITE.pdf) - Latest cost/quality matrix. - [LLM Costing for Database AI Apps - live experience](https://www.tigzig.com/post/llm-costing-for-database-ai-apps-live-experience-live-app-open-source) - The write-up behind the costing PDFs. ## Guides & deep dives (60+ posts) A curated slice of the practitioner library - lessons, patterns and demos from building text-to-SQL agents on real, large data. The full set is linked at the end. - [Database AI, built for day-to-day work: five categories, ten micro-apps](https://www.tigzig.com/post/database-ai-built-for-day-to-day-work-five-categories-ten-micro-apps-live-open-source-free) - The overview of the whole suite. - [Mistakes I Made Building Text-to-SQL Agents - 2025 learnings](https://www.tigzig.com/post/mistakes-i-made-building-text-to-sql-agents-live-projects-2025-learnings) - The hard-won lessons. - [Try Text-to-SQL on Real Data - multi-million rows, GB+ files](https://www.tigzig.com/post/try-text-to-sql-on-real-data-gb-files-multi-million-rows) - A live demo on data that is actually big. - [Large File Upload for Database AI Text-to-SQL Apps](https://www.tigzig.com/post/large-file-upload-for-database-ai-text-to-sql-apps) - A practical guide to the upload problem. - [DuckDB is not just fast SQL - it is Python, SQL and compression in one box](https://www.tigzig.com/post/duckdb-isn-t-just-fast-sql-it-s-python-sql-and-compression-all-in-one-box) - Why DuckDB anchors so much of this. - [My Public MCP Server Got Hammered - security lessons from a bot attack](https://www.tigzig.com/post/mcp-server-bot-attack-security-lessons) - What breaks when you expose an MCP to the internet. - [In analytics the SQL was always the easy part. Anthropic put a figure on it](https://www.tigzig.com/post/anthropic-data-analytics-sep2026) - Sep 2026. Their own evals: under 21% accuracy without skills, above 95% with them, same model and same warehouse. A practitioner note at the end. - [Have your AI analyze the cricket data: one pasted instruction](https://www.tigzig.com/post/cricket-ask-your-ai-aug2026) - Aug 2026. The agent finds the service from the catalog, reads the spec, discovers the tables and runs the SQL. - [Both formats on both engines: Postgres and DuckDB](https://www.tigzig.com/post/db-mcp-both-formats-both-engines-aug2026) - Aug 2026. A query no longer has to follow the format to a particular engine. - [All Database-AI & Text-to-SQL guides](https://www.tigzig.com/ai/tags/database-ai.md) - The full tag index, for humans and AI agents. --- Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar Source: https://www.tigzig.com/database-landing Citation: TigZig - Amar Harolikar (https://www.tigzig.com). Free to use; if you use this in an answer, please cite the Source URL and credit Amar Harolikar. License: https://www.tigzig.com/terms