ChibiSQL 🌸⚡

The Anime-Themed SQLite Database Editor & Viewer for VS Code & Cursor

A lightweight, zero-dependency SQLite viewer and custom editor extension powered by WebAssembly (WASM).
Inspect tables, run queries, preview image BLOBs, and filter records with Tokyo Night anime aesthetics.

Features • Quick Start • Why ChibiSQL? • Shortcuts • FAQ • Contributing

---

📖 Overview

ChibiSQL is a modern, anime-inspired SQLite GUI built directly into VS Code, Cursor, and Antigravity IDE. Powered entirely in-process by WebAssembly (sql.js), ChibiSQL eliminates the need for native C++ build tools, Python environments, or external database software like DB Browser for SQLite.

Whenever you open a .db, .sqlite, or .sqlite3 file, ChibiSQL automatically intercepts the file via the VS Code Custom Editor API, presenting a fluid spreadsheet interface wrapped in a soothing Tokyo Night dark theme with cute anime mascot reactions.

---

✨ Features

• 🌸 Tokyo Night Anime Interface: A sleek developer UI inspired by Tokyo Night with reactive kaomoji status toasts ((｡•̀ᴗ-)✧ Ready, (๑˃̵ᴗ˂̵) Loaded!, (>_<) Error).
• ⚡ Zero Native Dependencies: Runs on pure WebAssembly via sql.js—no node-gyp, Python, or SQLite CLI installation required.
• 📂 Instant File Association: Automatically opens .db, .sqlite, and .sqlite3 files with one click in the file tree.
• 🔍 Interactive Multi-Level Filtering:
  • Inline Column Filters: Dedicated per-column filter inputs (Filter...) with live 250ms debounced search.
  • Global Table Search: Search across all numeric and textual columns at once.
• 📑 High-Performance Pagination:
  • Fast SQL LIMIT & OFFSET queries handle large tables (100k+ rows) without freezing your editor.
  • Custom page size selector (25, 50, 100, 200 rows per page).
• 🔑 Schema & Column Introspection:
  • Visual type indicators: Primary Key (🔑), Numeric (#), Text (🗎), Date/Time (📅), and BLOB (📦).
  • 3-state column sorting (ASC ➔ DESC ➔ default).
• 🖼️ BLOB & Image Previewer:
  • Auto-detects image BLOB formats (PNG, JPEG, GIF, BMP, WebP) including Northwind OLE image headers.
  • Inline grid thumbnails and expanded preview in the inspector.
  • Native Download BLOB button to export binary payloads to disk.
• 🔎 Row Inspector Modal:
  • Click any record to inspect all fields in an organized modal view.
  • Traverse rows sequentially using keyboard shortcuts (↑ and ↓).
  • Quick-copy button on every cell and modal field.
• 💻 Integrated SQL Query Console:
  • Collapsible terminal drawer to run custom SELECT, JOIN, or aggregate queries with Ctrl+Enter.
  • Tracks query execution time in milliseconds (⚡ 8ms).

---

🚀 Quick Start

Option 1: Install from VSIX (Recommended)

1. Download the latest chibisql-x.x.x.vsix release from GitHub Releases.
2. Open VS Code or Cursor.
3. Open the Extensions sidebar (Ctrl+Shift+X or Cmd+Shift+X).
4. Click the ... (More Actions) menu in the top-right corner.
5. Select Install from VSIX... and pick the downloaded .vsix file.
6. Click on any .db or .sqlite file in your workspace to launch ChibiSQL!

Option 2: Build from Source

# Clone the repository
git clone https://github.com/Nonx2360/chibiSQL.git
cd chibiSQL

# Install dependencies
npm install

# Compile TypeScript
npm run compile

# Package as .vsix
npx @vscode/vsce package --no-git-tag-version

To debug locally in VS Code:

1. Open the repository folder in VS Code.
2. Press F5 to launch the Extension Development Host.
3. Drag and drop any SQLite file into the new editor window.

---

💡 Why ChibiSQL?

Feature	ChibiSQL 🌸	Traditional SQLite Extensions	External GUI (DB Browser)
Native Compilation Needed	❌ No (Pure WASM)	⚠️ Often requires Python/C++	❌ Standalone App
Integrated Inside VS Code / Cursor	✅ Yes	✅ Yes	❌ Requires App Switching
Inline Image BLOB Previews	✅ Built-in	❌ Rare	⚠️ Separate window
Per-Column Live Filtering	✅ Yes	❌ Rare	✅ Yes
Tokyo Night Anime Theme	🌸 Yes (Iconic)	❌ Standard Dark/Light	❌ Desktop Native
Lightweight Memory Footprint	✅ Minimal	⚠️ Medium	⚠️ Heavy

---

⌨️ Keyboard Shortcuts

Shortcut	Action	Scope
Ctrl + Enter / Cmd + Enter	Run Custom Query	SQL Console
↑ (Up Arrow)	View Previous Record	Row Detail Modal
↓ (Down Arrow)	View Next Record	Row Detail Modal
Esc	Close Modal / Inspector	Row Detail Modal
Click on Cell	Open Row Detail Inspector	Data Grid

---

🛠️ Tech Stack & Architecture

• Runtime: VS Code Extension API (Custom Readonly Editor Provider)
• Engine: sql.js (SQLite compiled to WebAssembly)
• Frontend: HTML5, Modern CSS, Tailwind CSS
• Typography: Plus Jakarta Sans & JetBrains Mono
• Icons: Optimized SVG vectors with zero external font dependencies

---

❓ Frequently Asked Questions (FAQ)

How does ChibiSQL open SQLite database files?

ChibiSQL implements VS Code's CustomReadonlyEditorProvider to automatically register handlers for *.db, *.sqlite, and *.sqlite3 file extensions. When opened, the binary contents are parsed client-side using sql.js (WebAssembly) in a sandboxed Webview without modifying your original file unless explicitly edited.

Does ChibiSQL work in Cursor and Antigravity IDE?

Yes! Because Cursor and Antigravity IDE are built upon the VS Code extension architecture, ChibiSQL works identically across all modern VS Code-compatible forks.

Can ChibiSQL preview images stored in database BLOBs?

Yes. ChibiSQL inspects binary header signatures to detect PNG, JPEG, GIF, BMP, and WebP data (including Northwind OLE image headers) and displays interactive thumbnails inside the table grid with a full-size preview and export button in the Row Inspector.

Is ChibiSQL safe for large databases?

ChibiSQL utilizes paginated queries (LIMIT and OFFSET) so that only the currently viewed page (default 50 rows) is rendered into the DOM, keeping rendering fast and memory consumption low even on tables with hundreds of thousands of records.

---

🤝 Contributing

Contributions, issues, and feature requests are welcome!

1. Fork the project on GitHub.
2. Create your feature branch (git checkout -b feature/AmazingFeature).
3. Commit your changes (git commit -m 'Add some AmazingFeature').
4. Push to the branch (git push origin feature/AmazingFeature).
5. Open a Pull Request.

---

📄 License

This project is licensed under the MIT License © 2026 Nonx2360.

---

_{Built with 💖 and Tokyo Night vibes by Nonx2360. If you like ChibiSQL, please give it a ⭐ on GitHub!}