Skip to content

A minimal, fast, database client desktop application. Built for developers who want to quickly peek at their data without the bloat.

License

Notifications You must be signed in to change notification settings

Rohithgilla12/data-peek

Repository files navigation

data-peek

GitHub Downloads (all assets, all releases)

A minimal, fast SQL client desktop application with AI-powered querying. Built for developers who want to quickly peek at their data without the bloat. Supports PostgreSQL, MySQL, and Microsoft SQL Server.

Data Peek - SQL Client

Screenshots

AI Assistant - Generate charts and insights AI Assistant Charts
AI Assistant - Natural language to SQL AI Assistant Queries
ER Diagrams - Visualize relationships ER Diagrams
Command Palette - Quick actions Command Palette
Light Mode Light Mode

Features

  • AI Assistant - Ask questions in plain English, get SQL queries. Generate charts and insights (BYOK)
  • Fast - Opens in under 2 seconds, low memory footprint
  • Query Editor - Monaco editor with SQL syntax highlighting and autocomplete
  • Command Palette - Cmd+K to access everything instantly
  • Multi-tab Support - Work with multiple queries simultaneously
  • Inline Editing - Edit table data directly with INSERT/UPDATE/DELETE
  • ERD Visualization - See table relationships visually
  • Query Plans - Analyze query performance with EXPLAIN ANALYZE viewer
  • Saved Queries - Bookmark your favorite queries for quick access
  • Dark/Light Mode - Easy on the eyes
  • Keyboard-First - Power users shouldn't need a mouse
  • Secure - Connection credentials encrypted locally, no telemetry

Installation

Download

Download the latest release for your platform from Releases.

  • macOS: .dmg (Intel & Apple Silicon)
  • Windows: .exe installer
  • Linux: .AppImage, .deb, or .tar.gz (Arch)

macOS: "App is damaged" Fix

Since the app isn't notarized with Apple yet, macOS Gatekeeper may show a warning. To fix:

Option 1: Terminal command

xattr -cr /Applications/data-peek.app

Option 2: Right-click to open

  1. Right-click (or Control+click) on data-peek.app
  2. Select "Open" from the menu
  3. Click "Open" in the dialog

This only needs to be done once. Proper code signing is coming soon!

Linux: Auto-Updates

Auto-updates only work with the AppImage format. If you installed via .deb or .tar.gz, you'll need to manually download new releases from the Releases page.

Format Auto-Update
AppImage Yes
.deb No (manual update)
.tar.gz No (manual update)

For the best experience with automatic updates, we recommend using the AppImage.

Build from Source

# Clone the repository
git clone https://github.com/Rohithgilla12/data-peek.git
cd data-peek

# Install dependencies
pnpm install

# Run in development mode
pnpm dev

# Build for your platform
pnpm build:mac    # macOS
pnpm build:win    # Windows
pnpm build:linux  # Linux

Troubleshooting: Electron not found

If you get errors about Electron not being found after pnpm install:

# Option 1: Run the setup script
pnpm setup:electron

# Option 2: Rebuild native modules
pnpm rebuild

# Option 3: Clean install (nuclear option)
pnpm clean:install

This can happen when pnpm's cache skips Electron's postinstall script that downloads platform-specific binaries.

Tech Stack

Layer Technology
Desktop Electron
Frontend React 19 + TypeScript
UI shadcn/ui + Tailwind CSS
State Zustand
Query Editor Monaco
Database pg (PostgreSQL), mysql2 (MySQL), mssql (SQL Server)

Project Structure

apps/
  desktop/     # Electron desktop application
  web/         # Marketing website + licensing
packages/
  shared/      # Shared types for IPC

Development

# Install dependencies
pnpm install

# Start desktop app with hot reload
pnpm dev

# Start web app
pnpm dev:web

# Lint all workspaces
pnpm lint

# Build desktop app
pnpm build

Star History

Star History Chart

License

MIT License - see LICENSE for details.

Pre-built binaries require a license for commercial use. See the license file for details on free vs. commercial use.

Contributing

Contributions are welcome! Please see CONTRIBUTING.md for guidelines.

Support

About

A minimal, fast, database client desktop application. Built for developers who want to quickly peek at their data without the bloat.

Topics

Resources

License

Contributing

Stars

Watchers

Forks

Sponsor this project

 

Packages

No packages published