---
title: "Run a Full AI Database App as a Single HTML File. No Server. No Remote DB."
slug: run-a-full-ai-database-app-as-a-single-html-file-no-server-no-remote-db
date_published: 2025-10-19T07:08:32.487Z
original_url: https://www.tigzig.com/post/run-a-full-ai-database-app-as-a-single-html-file-no-server-no-remote-db
source: migrated
processed_at: 2025-12-03T12:00:00.000Z
---

# Run a Full AI Database App as a Single HTML File. No Server. No Remote DB.

Few days back I shared a custom implementation powered by SQL Rooms ([sqlrooms.org](http://sqlrooms.org)) to chat, query multi-GB files in conversational language. With DuckDB database running right in browser. [Live here](http://www.tigzig.com/sql-rooms)

Now, you can download the full thing - one HTML file that works right off your laptop. The entire React application is now compiled into a single, portable 3.5MB HTML file.

Double-click it, and you're running a full AI app. No installs. No backend. No server deploys. Download it, email it, or share it.

Imported a 1.6GB / 11M-row files - chatted with the data to run analysis and visualizations (see video)

## Try it

Download live cricket data files (100MB - 1.6GB unzipped) from my [Google Drive](https://drive.google.com/drive/u/1/folders/1VHD9UzeYaJF_dBPecnjucHpoGocf4IvR). Get a free Google Gemini API key with your Gmail account from [aistudio.google.com](http://aistudio.google.com), and have at it.

## Use cases

* Fully portable apps. Run directly from your local drive.
* Internal tools or lightweight AI utilities
* Share by email or keep on shared drive
* Replace static decks with live, interactive apps
* Works for AI, automation, or dashboards alike

## Technical Note

* The build uses Vite with the vite-plugin-singlefile plugin, which bundles all JS/CSS into the HTML. Code and methodology is in the repo.
* I have currently enabled only Google Gemini. CORS issue with OpenAI and Anthropic API calls but can be enabled with a simple proxy server.

## To build

Use Google Build (Free) or Lovable to setup your app and a working version. Then build locally with Claude Code, Cursor, or Gemini CLI and export via Vite singlefile plugin.

## Source Code

Docs: On app → "Docs" tab

## Credits: Original SQL Rooms

[sqlrooms.org](http://sqlrooms.org) from Foursquare. Architected by Ilya Boyandin


Cricket data from [Cricsheet](https://cricsheet.org), published under the [Open Data Commons Attribution License 1.0 (ODC-BY)](https://opendatacommons.org/licenses/by/1-0/).

<!-- blog-sidebar-related -->
## Related

Tools: [BRIQ](https://www.tigzig.com/briq), [Cricsheet File Processor](https://www.tigzig.com/csv-processor), [DUCKIT - CSV to DuckDB](https://www.tigzig.com/duckit-xlwings)

Explore: [Database AI Apps hub](https://www.tigzig.com/database-landing), [Database Query Tool (MCP)](https://www.tigzig.com/apis/database), [Browse all apps](https://www.tigzig.com/browse-apps)

More posts: [Chat, Query, and Transform Multi-GB Files - In Natural Language, Right in Your Browser with DuckDB.](https://www.tigzig.com/post/chat-query-and-transform-multi-gb-files-in-natural-language-right-in-your-browser-with-duckdb), [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://www.tigzig.com/post/run-advanced-analytics-locally-in-your-browser-no-server-no-remote-database-no-it-approvals), [Bundle your AI app or React dashboard into a single file.](https://www.tigzig.com/post/bundle-your-ai-app-or-react-dashboard-into-a-single-file)

---
Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar
Source: https://www.tigzig.com/post/run-a-full-ai-database-app-as-a-single-html-file-no-server-no-remote-db
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