---
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://app.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