data-peek

A fast, keyboard-first SQL client for PostgreSQL, MySQL, SQL Server, SQLite, and ClickHouse (beta).
Open it, run the query, get the answer, get back to work.

Website · Download · Docs · Changelog

Why data-peek

• Fast. Opens in about two seconds and stays light on memory. No splash screens, no project setup.
• Keyboard-first. Cmd/Ctrl+K reaches every action. Every shortcut is documented.
• Local and private. Credentials are encrypted with your OS keychain. No telemetry, no account, no cloud sync.
• Grows with the task. A quick SELECT stays quick, and query plans, live diffs, ER diagrams, and an AI assistant are there when the job gets bigger.

Install

Or grab a build from Releases: .dmg for macOS (signed and notarised), .exe for Windows, and .AppImage, .deb, or .tar.gz for Linux.

No install: npx @data-peek/cli doctor

Eight Postgres schema checks from the terminal. Each finding comes with the SQL that fixes it.

npx @data-peek/cli doctor postgres://user:pass@localhost:5432/app
npx @data-peek/cli doctor "$DATABASE_URL" --fail-on warning   # fail CI on warnings

It finds tables without a primary key, foreign keys without an index, duplicate, unused, and invalid indexes, bloat, never-vacuumed tables, and nullable foreign keys. These are the same checks as Schema Intel in the app. See packages/cli.

See it work

Watch Mode: pin a SELECT and watch cells change live.	Query plans: EXPLAIN ANALYZE as a tree, with the slow node and its fix.
MCP server: agents can read freely; every write waits for your approval.	Time Machine: scrub back through past results and diff any two runs.

More clips (command palette, ER diagrams, the AI assistant, inline editing) are on datapeek.dev.

Features

Query editor

• Monaco editor with schema-aware autocomplete that understands table aliases
• Multiple tabs and windows, plus cross-tab references: name a tab and query its result from another as @name
• Step through multi-statement scripts one statement at a time, with manual transactions on PostgreSQL
• Saved queries with folders and tags, reusable snippets, and SQL notebooks that mix SQL cells with Markdown
• A sidebar omnibar (/) that searches tables, columns, functions, saved queries, and history

Results and data

• Inline editing with a preview of the generated INSERT/UPDATE/DELETE before you commit
• Smart filters and sorting on results without re-running the query
• Foreign key navigation, a JSON/JSONB editor, and one-click column statistics
• Export to CSV, JSON, or Excel, or share a result as an image
• CSV import with column mapping and type inference, PostgreSQL .sql dump import, and an FK-aware fake data generator
• Data masking that blurs sensitive columns for demos and screenshots

Performance

• EXPLAIN viewer with an interactive plan tree
• Query telemetry with a timing waterfall, and a benchmark mode reporting p50/p90/p99
• Performance hints for missing indexes, N+1 patterns, and slow queries, each with a suggested fix
• Cancel a running query, or kill a blocking one from the health monitor

Live data

• Watch Mode re-runs a read-only query every 500 ms to 5 min and highlights changed cells. It refuses to poll anything that writes.
• Time Machine snapshots past results locally, so you can scrub back and diff any two runs (Cmd/Ctrl+Shift+H)
• Scheduled queries on a cron, with run history and desktop notifications
• PostgreSQL LISTEN/NOTIFY with a live event log
• Dashboards built from your queries, with charts, KPIs, and tables

Schema and monitoring

• Schema explorer for tables, views, functions, procedures, triggers, and sequences
• Table designer for creating and altering tables: columns, indexes, constraints, and partitions
• Interactive ER diagrams
• Health monitor with active queries, table sizes, cache hit ratios, and lock detection
• Schema Intel diagnostics for unindexed foreign keys, duplicate or unused indexes, missing primary keys, and table bloat, with suggested SQL fixes

AI and agents

• AI assistant that turns plain English into SQL and builds charts from results. It knows your schema.
• Bring your own key (OpenAI, Anthropic, Google, Groq, or local Ollama models), or bring your own agent: point it at your installed Claude Code, Codex, or Antigravity CLI and use the subscription you already have
• A built-in MCP server (off by default) that exposes your connections to AI agents. Reads are capped and run read-only, and every write needs your approval in the app.

Connections and security

• PostgreSQL, MySQL, Microsoft SQL Server, SQLite, and ClickHouse. ClickHouse support is in beta and covers querying and browsing, so inline editing and the table designer stay off for ClickHouse connections.
• SSH tunnels through bastion hosts, using a password or a key
• Credentials encrypted with the OS keychain, and no telemetry
• An optional tamper-evident audit log of every statement you run. It stays local.

The docs cover every feature in depth.

Pricing

The source is MIT licensed. The pre-built app is free for personal use: side projects, learning, open source, students, educators, non-profits, and solo founders, with every feature included. Using it at a for-profit company of two or more people, or as a freelancer or agency billing clients, needs a Pro licence. Details are in LICENSE.md.

data-peek is a single-maintainer project, and two commitments in SUSTAINABILITY.md say so up front:

• No kill switch. If the licence server ever goes away, your activated version keeps working forever, offline.
• Dormancy pledge. After 12 months of maintainer inactivity, the commercial-licence requirement is waived for every released version.

Contributing

Contributions are welcome, and data-peek is taking part in Hacktoberfest. Issues labelled good first issue say what to change and how to tell when it's done. Read CONTRIBUTING.md before opening a PR.

git clone https://github.com/Rohithgilla12/data-peek.git
cd data-peek
pnpm install
pnpm dev          # desktop app with hot reload

apps/
  desktop/     Electron app (main process, preload, React renderer)
  docs/        docs.datapeek.dev
  web/         datapeek.dev marketing site and licence API
packages/
  cli/         @data-peek/cli, the `doctor` command
  shared/      Types and logic shared across apps (IPC contract, Schema Intel checks)
  ui/          Shared shadcn/ui components

Support

• GitHub Issues for bugs and feature requests
• GitHub Sponsors to support development
• @gillarohith on X