Twitter SQLite

Query your Twitter/X data with SQL — directly in the browser. Built with Waku, sql.js, and deployed on Cloudflare Workers.

Live demo →

Features

• Run SQL queries against your tweet archive in the browser
• Everything runs client-side — nothing is uploaded
• Drag & drop your own SQLite database file
• Pre-loaded with sample tweet data

Getting Started

npm install
npm run dev

Open http://localhost:3000.

Using Your Own Data

1. Request your Twitter archive or use twitter-to-sqlite
2. If using the Twitter archive, convert tweets.js to SQLite:

   node scripts/tweets-js-to-sqlite.mjs path/to/tweets.js output.db

3. Drop the .db file onto the app

Deployment

Deploys to Cloudflare Workers:

CLOUDFLARE=1 npm run build
wrangler deploy

Update the routes in wrangler.jsonc to use your own domain.

License

MIT