Skip to content

nabinkhair42/datalens

Repository files navigation

DataLens

The web-native, collaborative database IDE.

Query, visualize, and manage your databases with a modern interface that works anywhere.

Next.js React TypeScript Tailwind CSS PostgreSQL Drizzle Better Auth Biome Vitest

DataLens

Features

SQL Editor

  • CodeMirror 6 with PostgreSQL syntax highlighting and autocomplete
  • Execute queries with Ctrl+Enter, save with Ctrl+S
  • Query history tracking and saved query templates
  • Export results as CSV or JSON

Table Browser

  • Interactive data grid with sorting, filtering, and pagination
  • Inline cell editing with type-aware inputs (booleans, enums, dates, JSON)
  • Add new records inline (NeonDB-style) or bulk delete with confirmation
  • Column visibility toggle with search

Schema Explorer

  • Hierarchical schema/table/column browser
  • Primary key, foreign key, and type annotations
  • Expandable table details with column metadata

Connection Management

  • Support for PostgreSQL (MySQL, SQLite, MongoDB, MSSQL planned)
  • Test connections before saving (latency + version info)
  • SSH tunnel support with key-based auth
  • AES-256-GCM encryption for stored credentials

Keyboard Shortcuts

Shortcut Action
Ctrl+Enter Execute query
Ctrl+S Save query
Ctrl+R Refresh table data
Ctrl+I Insert new row
Delete / Backspace Delete selected rows
Escape Discard / deselect

Database Support

Database Status
PostgreSQL Fully supported
MySQL Planned
SQLite Planned
MongoDB Planned
SQL Server Planned

About

The web-native, collaborative database IDE

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors