Skip to content
ExtransloadPublic

About

One fast client for your databases, from PostgreSQL to Redis. Desktop app or browser tab.

Resources

Contributing

Security policy

Stars

1 star

Watchers

0 watching

Forks

Repository files navigation

TablePeek

A fast, local-first database client, as a desktop app or in your browser.

CI Latest release License: AGPL-3.0-only

Install · Features · Screenshots · Documentation · Changelog

TablePeek in 20 seconds: connecting to PostgreSQL, Quick Look on a JSON cell, SQL completion, a chart, the ER diagram, MySQL, ClickHouse, MongoDB and Elasticsearch, then a Django session in Redis and its CLI

Query, browse and edit PostgreSQL, MySQL/MariaDB, SQLite, SQL Server, Oracle, CockroachDB, ClickHouse, Cassandra, ScyllaDB, MongoDB, Elasticsearch, OpenSearch and Redis/Valkey from one place. Everything runs on your machine: no account, no cloud relay. The interface is in English and Korean.

Two ways to run it, one TablePeek

Desktop app In your browser
Platforms macOS (Apple silicon), Windows macOS, Linux, Windows
Install brew install --cask extransload/tap/tablepeek, or the Windows installer Unpack the tablepeek archive and run ./tablepeek serve
Window Its own window, solid, glass or see-through A tab in the browser you already use
Updates Downloads, checks the signature, and restarts into the new version Tells you a new release is out
Shortcuts Mac-style tab keys (⌘T, ⌘W, ⇧⌘[ ]), kept apart Browser-safe keys (⌥T, ⌥W, ⌥[ ]), kept apart

Both are the same app, served by the same local server: saved connections, settings, themes and history live in ~/.tablepeek, and the open connections and their tabs come back after an update or a restart. Passwords stay in the OS keychain.

Install

macOS (Apple silicon)

brew install --cask extransload/tap/tablepeek

Windows: run TablePeek-…-setup.exe from the latest release. It installs for the current user, without admin rights.

In the browser (macOS, Linux, Windows): download the tablepeek-… archive for your platform from the latest release, unpack it, and run:

./tablepeek serve          # opens TablePeek in your browser
./tablepeek serve --demo   # with a sample database to look around

The builds are not signed with a paid certificate, so the first launch of a downloaded file needs one extra click; Homebrew handles that for you. The install guide covers every download, first launch, updating, and building from source.

Features

Work with data

  • Fast on big results. Rows stream in and draw on a canvas grid; any query can be cancelled.
  • Safe edits. Cells change through the primary key, with explicit transactions, and safe mode asks before an UPDATE or DELETE without WHERE (or EXPLAIN ANALYZE on a write).
  • Smart SQL editor. Completion for tables, columns, functions and joins from foreign keys; beautify, snippets, saved queries and history.
  • Peek at a result. A short result is summed up by its shape above its rows: big numbers, the biggest share, the month that stands out, with bars in the number cells. Worked out by rules, so nothing leaves your machine.
  • Inspect anything. Quick Look turns any cell into a JSON tree, hex, or the row a foreign key points to; charts and pivots of any result; an ER diagram laid out for you.
  • Import and export. CSV, JSON, XML and SQL, plus dump and restore, as background jobs.

Every kind of database

  • SQL engines share one workbench, each with its own dialect, plans and server tools.
  • MongoDB gets cards, JSON and table views, an aggregation builder, schema analysis, indexes, a mongosh tab and change streams.
  • Elasticsearch and OpenSearch get index browsing, Query DSL and SQL, a Dev Tools console, mappings and cluster views.
  • Redis and Valkey get a RedisInsight-style browser: a key tree, an editor per type, a terminal-style CLI, slow log and server info. Values decode as JSON, MessagePack, Python pickle (Django sessions), PHP and Java serialized data, Protobuf, vectors, timestamps and more.

Make it yours

  • Themes and a background picture. Light, dark or the system's, with dozens of themes, syntax and value colours per theme, and a photo behind the app. Every area's opacity has its own slider.
  • Text size where you are. ⌘+, ⌘− and ⌘0 size the editor, the table or the interface, whichever has focus.
  • Keyboard first. Every setting steps with ▲ ▼ or takes a typed number; every shortcut can be rebound.
  • Motion that helps. Trees and sections open and close smoothly, and Reduce motion turns it all off.

AI, on your terms

  • Write SQL with AI. Opt-in and off by default. Press ⌘E, describe a query, and the SQL for the connection's schema is written into the editor for you to accept or reject, or suggested as you type. Use your ChatGPT subscription, the Codex CLI on your machine, or a Gemini API key. Rows are never sent, and nothing runs until you do.
  • MCP for AI clients. tablepeek mcp lets an AI client such as Claude Desktop list connections, read the schema and run read-only queries against a running TablePeek.

Secure by default. The server listens on loopback only, behind a per-run token; passwords live in the OS keychain; TLS, client certificates, and SSH or HTTP tunnels for every engine that takes them.

Screenshots

The same tour at full size, with typing sounds and quiet music (30 seconds):

tablepeek-demo.mp4

TablePeek over a Milky Way background picture, as a desktop app showing a PostgreSQL query and in a browser tab showing a Redis key decoded from a Python pickle

SQL results and row detail Redis, with a pickled Django session decoded
PostgreSQL query results in the canvas grid with the selected row's fields beside it Redis workbench with the key tree and a Django session decoded from a Python pickle into a JSON tree
Quick Look SQL completion
Quick Look showing a JSON column as a tree with its fields SQL completion suggesting joins from foreign keys, with the join condition in an info panel
ER diagram Charts and pivots
ER diagram of a shop schema with one table's relations highlighted Bar chart of revenue by category with a value tooltip
Redis CLI, terminal style Appearance: background picture and per-area opacity
Redis CLI with typed, coloured replies running down from the top Settings docked beside the app, with the background picture and opacity sliders

Documentation

License

TablePeek is free software under the GNU Affero General Public License v3.0, version 3 only (AGPL-3.0-only). Copyright © 2026 Extransload.

You may use, study, change and share it. If you distribute a changed version, or let other people use a changed version over a network, you must offer them its complete source under the same license. The bundled Oracle driver (crates/vendor/oracledb) keeps its own license (UPL-1.0 OR Apache-2.0), and every other library keeps its own.

About

One fast client for your databases, from PostgreSQL to Redis. Desktop app or browser tab.

Resources

Contributing

Security policy

Stars

1 star

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages