SQLTab – Chat with your SQLite database

Hacker News

Demo: http://www.sqltab.com/static/average_earning.gif Try it here: https://www.sqltab.com/demo Main features: - AI-powered SQL assistant. Allows (one-click) execution and undo/redo of SQL generated by the AI. - GUI to rename, remove, and reorder columns in SQLite tables. - Undo/redo support using SQLite's savepoints [1]. - JSON data expansion: https://www.sqltab.com/static/json_expand.gif - The pivot table extension [2] is loaded and available for use. The AI is also aware of it. Privacy & Data: - Databases are stored locally in the browser using OPFS. - Database schema is sent to OpenAI as part of the chat session's context window. If the chat session contains results of data querying, then that will also be sent to OpenAI with the next message. Tech stack: - WASM build of SQLite (using a custom fork of the official repo [3]). - React + Mantine for the UI. - esbuild to build the frontend (invoked from Go). So much faster than the alternatives. - Hosted on Cloudflare Pages, deployed via wrangler CLI. - Single API endpoint just to proxy OpenAI calls in order to hide my API key. Hosted on Cloudflare Pages Functions (very practical but only for simple things). Technical notes: - The entire application is a static website except for the OpenAI proxy. Planning to support user-supplied API keys to (optionally) get rid of this. - OPFS storage comes with some limitations (e.g., no incognito mode on mobile, same DB can't be opened in multiple tabs). - gpt-4o is used for the LLM. Might switch to gpt-4o-mini to save costs. Why not DuckDB? - I got some out-of-memory errors when expanding JSON data. SQLite worked fine on the same data. - No OPFS support yet. PRs have been pending for a year now. If you want to reset the demo, just delete the IMDB.sqlite database (disk icon in the top-left corner -> "Delete DB") and load the demo URL again in the browser. Please let me know if you have ideas about how to make this more useful. [1] https://www.sqlite.org/lang_savepoint.html [2] https://github.com/jakethaw/pivot_vtab [3] https://sqlite.org/wasm/doc/trunk/about.md

Visit product View on Hacker NewsNov 20, 2024

Share card

Actual performance

1points

2comments

Did not reach leaderboard

Launch Intel predictions

Analyze your own launch →

Product HuntOn track for Day 1 leaderboard · Strong signals: user, context, openai · Missing: mac, agents, macos

91%91% predicted probability of success on Product Hunt, based on ML models trained on real launch data.

best fitHighest predicted score across all platforms for this description.

Indie HackersFits the IH revenue-focused audience · Missing: supports, reddit linkedin, podcasting

71%71% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.

Hacker NewsStrong engagement from HN community · Strong signals: ide, io · Missing: https docs, excited, just released

65%65% predicted probability of success on Hacker News, based on ML models trained on real launch data.

nativeThis product was originally launched on this platform.

AppSumoMay struggle as an AppSumo deal · Strong signals: host, calls · Missing: plus, platform, intuitive

39%39% predicted probability of success on AppSumo, based on ML models trained on real launch data.

TrustMRRLess likely to generate early MRR · Missing: mobile apps, ios, personal

38%38% predicted probability of success on TrustMRR, based on ML models trained on real launch data.

Acquire.comPre-revenue stage for this audience · Missing: arr, mrr, revenue

14%14% predicted probability of success on Acquire.com, based on ML models trained on real launch data.

BetaListMay not resonate with beta-testers · Strong signals: chat · Missing: web3, crypto, cryptocurrency

0%0% predicted probability of success on BetaList, based on ML models trained on real launch data.

Incorrect prediction on native model

Similar products

Statey – the database your AI shares across every chat, over MCP23%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Statey – the database your AI shares across every chat, over MCP

Hacker News4

SummaDB, a hierarchical database that syncs with PouchDB60%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

SummaDB, a hierarchical database that syncs with PouchDB

Hacker News5

Noms – The versioned, forkable, syncable database68%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Noms – The versioned, forkable, syncable database

Hacker News43

A reactive Database61%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

A reactive Database

Hacker News1

A reactive Database61%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

A reactive Database

Hacker News1

Relations in a NoSQL database68%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Relations in a NoSQL database

Hacker News6

SleekDB – A NoSQL Database68%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

SleekDB – A NoSQL Database

Hacker News2

An experiment with Gnocchi (the database) – Part 257%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

An experiment with Gnocchi (the database) – Part 2

Hacker News2

Digestable Ingredient Database68%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Digestable Ingredient Database

Hacker News2

NebulaDB, my first attempt at a database63%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

NebulaDB, my first attempt at a database

Hacker News30

Browse all products Analyze your launch