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, providing a suite of professional tools for data management.
Features
Zero Config: Automatically creates a .kensa/db folder and updates your .env with the DATABASE_URL.
Visual ER Diagrams: Visualize your database structure and relationships. Export diagrams as high-quality SVGs.
Safe Table Editor: Excel-like grid editing with powerful safety features:
Undo: Revert any change instantly.
Fix State: Save a "safe checkpoint" of your data and reset to it anytime.
Smart Seed: Auto-populate tables with realistic dummy data (emails, names, dates) based on column types.
SQL Console: A dedicated, split-pane console for running complex queries and analyzing performance.
Schema Export: Export your entire database structure to a .sql migration file with one click.
Developer Ready: Works natively 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.
Enter a name (e.g., auth).
Kensa will create the DB and copy the connection string (sqlite:///...) to your clipboard.
Usage Guide
1. The Dashboard
The Kensa sidebar provides a quick overview of all local databases.
Console: Opens the SQL execution environment.
Tables: Opens the interactive table picker.
ER Diagram: Generates a visual relationship graph of your schema.
2. Table Editor
Click any table to open the grid view.
Edit: Double-click any cell to edit. Changes are staged locally (yellow).
Commit: Click Commit to save staged changes to the database.
Discard: Click Discard to revert staged changes.
Seed: Click Seed to instantly add 5 rows of realistic mock data.
Delete: Hover over rows or columns to access delete buttons.
3. Safe Editing Workflow (Snapshots)
Kensa prevents data loss during local development.
Undo: If you make a mistake (e.g., delete a row), click Undo to revert the table to its previous state.
Fix State: Before running a risky migration or test, click Fix State. This saves a permanent checkpoint.
Reset: If your tests corrupt the data, click Reset to Fixed to instantly restore the clean state.
4. ER Diagrams
Visualize relationships between tables.
Open the sidebar and click ER Diagram.
Kensa detects Foreign Keys and draws connections (Crow's Foot notation).
Click Download SVG to save a vector graphic of your schema (perfect for documentation).
5. SQL Console
Run raw SQL queries without external tools.
Open the console from the sidebar.
Type queries (e.g., SELECT * FROM users JOIN posts ON...).
Press Cmd+Enter or click Run.
View execution time and results in a clean table format.
Requirements
VS Code ^1.85.0 or higher.
Zero Dependencies: Kensa uses a bundled SQLite engine. You do not need SQLite installed on your machine.
