Kensa ("Inspection") is the fastest way to prototype backends, test SQL, and manage data without leaving your editor. It creates a local SQLite database instantly and auto-configures your environment.
✨ Features
🚀 Zero Config: Creates a .kensa/db folder and automatically updates your .env with the DATABASE_URL.
🐿️ Built-in Explorer: View all your local databases and tables in the sidebar.
✏️ Excel-Like Editing: Double-click any cell to edit data. Changes are staged and committed in batches.
⚡ Quick Actions: Run SQL, drop tables, or insert rows via the Command Palette or context menu.
📥 Schema Export: Export your entire database structure to a .sql migration file with one click.
🛠️ Developer Ready: Works perfectly with Node.js, Next.js, Python, Go, and Prisma.
🚀 Quick Start
Open the Command Palette (Ctrl+Shift+P / Cmd+Shift+P).
Run Kensa: Create Database.
Give it a name (e.g., auth).
Kensa will create the DB and copy the connection string to your clipboard!
📸 Usage
Managing Data
View Table: Click a table in the "Kensa" sidebar to open the data grid.
Edit Data: Type directly into cells. Edited cells turn yellow. Click the floating Commit button to save.
Insert Row: Right-click a table -> Insert Row.
Add Column: Right-click a table -> Add Column.
Running SQL
Highlight any SQL query in your code editor.
Right-click -> Run SQL (or use the Command Palette).
View results instantly in a split pane.
⚙️ Requirements
VS Code ^1.90.0 or higher.
No other dependencies! (It uses a bundled SQLite engine).
