A minimal, fast, desktop SQL client designed for developers needing quick data access without bloat. It supports multiple databases and offers AI-powered features for natural language querying and insights, aiming to streamline database interaction.

How It Works

Built with Electron for the desktop shell and React 19 with TypeScript for the frontend, data-peek prioritizes speed and a low memory footprint. It leverages the Monaco editor for a rich SQL query experience and integrates with various AI providers (OpenAI, Anthropic, Google, Groq, Ollama) for natural language to SQL translation and data visualization. This approach allows for powerful, AI-assisted database querying within a lightweight, native application.

Quick Start & Requirements

Installation is primarily via downloadable binaries for macOS (.dmg), Windows (.exe), and Linux (.AppImage, .deb, .tar.gz) from the Releases page. For Linux, the AppImage format supports auto-updates. Building from source requires cloning the repository, installing Node.js dependencies via pnpm install, and then building using pnpm build:<platform>.

Highlighted Details

• AI Assistant: Supports natural language to SQL queries, generates charts and insights, and is schema-aware. Integrates with multiple AI providers including local Ollama.
• Performance Analysis: Includes query telemetry with waterfall visualization, benchmark mode, EXPLAIN viewer, and indicators for missing indexes or N+1 patterns with auto-generated fix suggestions.
• Data Management: Features schema explorer, inline data editing (INSERT/UPDATE/DELETE), table designer, and JSON editor.
• Core Features: Fast startup (<2s), low memory usage, multi-database support (PostgreSQL, MySQL, MS SQL Server, SQLite), SSH tunnels, and secure credential storage.

Maintenance & Community

Development is supported via GitHub Sponsors. Bug reports and feature requests are managed through GitHub Issues. The primary developer can be reached on Twitter/X at @gillarohith.

Licensing & Compatibility

The project is licensed under the MIT License. However, pre-built binaries require a separate license for commercial use. Users should consult the LICENSE file for detailed terms regarding free versus commercial usage.

Limitations & Caveats

Automatic updates are exclusively supported for the Linux AppImage format; other Linux installations (.deb, .tar.gz) and macOS/Windows require manual downloads. Commercial use of pre-built binaries is restricted without a specific license.