Tabletist
github.com/igor-alexandrov/tabletist- Category
- Developer Tools
- Rank
- No. 1200Tools index
- Pricing
- Open Source
- Type
- APP
- Use case
- Data Processing
- Interfaces
- Desktop
- GitHub
- 210 stars
- Latest release
- v0.7.0
- Date
About
A native desktop database client written in Rust with egui for PostgreSQL, MySQL and MariaDB, SQLite and BigQuery, running on Linux, macOS and Windows. It supports saved connections tagged by environment, TLS, SSH tunnels, and a read-only default for production. Edits stay pending until Save, which writes in one transaction and stops on rows someone else changed, and Review SQL shows the statements first.
What it does
Tabletist is a GUI program for looking at and changing data in a database: pick a saved server, open a table into a grid, filter and page through it, run queries in an editor, and copy or export results as CSV, JSON or Markdown. It draws its own window instead of embedding a browser. It can also act as a gatekeeper for coding agents such as Claude Code and Cursor, letting them run read-only queries against the servers you allow without ever seeing the password.
Why it's ranked here
The safety design is unusually specific and written down. Read-only mode is enforced by the database session, not guessed from the SQL text. A save is one transaction that writes nothing when another person changed the same row. Agent access starts off for every server, can hide tables or mask columns, and every call lands in a log that never stores rows. The author's own measurements on one Linux machine put startup at 89 ms against roughly two seconds for DBeaver and Beekeeper Studio. MIT licensed, with signed release checksums.
What's good
Conflict handling on save shows what you loaded, what the server holds now and your edit side by side, then lets you keep yours, take the server's or overwrite. Before any save, a Review SQL view shows the exact statements. Production gets extra friction: the SQL editor never runs read-write there, and a save asks first. On remote servers the common steps (opening a table, loading a page, counting rows) are built to wait on one network round trip each. The agent query checker refuses writes, locks, multiple statements and views that call risky functions such as sleep or advisory locks.
Tradeoffs
The docs call it young and list the gaps: no pasting rows, no importing a file into a table, and no editing of binary values, values over 256 KiB, views, or tables without a primary key or unique index. BigQuery is read-only, and the interface is English only. Agents cannot write at all. The docs also admit that an extension function or a foreign table can still reach a hidden table, so strict isolation needs a separate database user. Linux release binaries need glibc 2.39 or newer, and the Arch packages were not published yet when the README was fetched.
How to use it well
Pick it if you spend the day in PostgreSQL, MySQL or SQLite and want a fast desktop client that is hard to misuse against production, or if you want to give a coding agent read access to a real database without handing over credentials. Install with the Homebrew cask on macOS, the setup program on Windows, or the AppImage on Linux; the demo flag opens a sample database to try. For agents, switch the server on in the Agents settings, allow one connection, and give it a dedicated low-privilege database user. Skip it if you need to import files or paste rows into tables.
Technical notes+
Cargo.toml defines a Rust 2024-edition workspace (app crate plus tabletist-core, tabletist-db, tabletist-mcp, tabletist-menubar, tabletist-appkit, tabletist-sqlite-ffi) with unsafe_code = "forbid", eframe/egui on the glow backend, and patched egui and winit forks for Wayland clipboard fixes. crates/tabletist-db/src/lib.rs shows a Connection type whose Access defaults to ReadOnly, forces BigQuery to read-only, and routes agent queries through run_agent_read, which checks dialect, binds values as placeholders, and asks the engine (SQLite authorizer, PostgreSQL/MySQL plans) whether hidden data would be read. crates/tabletist-mcp/src/server.rs serves stdio sessions only, caps each session at 16 concurrent calls, strips control and bidi characters from agent-supplied names, and truncates logged requests to 200 characters.
Observed
- License
- MIT
- Language
- Rust, egui UI
- Databases
- PostgreSQL, MySQL, MariaDB, SQLite, BigQuery (BigQuery read-only)
- Platforms
- Linux, macOS, Windows
- Interfaces
- Desktop GUI; MCP server over stdio for coding agents (read-only)
- Install surface
- Homebrew cask and formula, Windows installer, Linux AppImage and tar.gz, build from source with Cargo
- Unsafe code
- Forbidden at workspace level in Cargo.toml
- Credential storage
- System keyring; passwords never passed to agents
Read from README.md, Cargo.toml, docs/_guide/what-is-tabletist.md, docs/_guide/agents.md, docs/_guide/speed-and-security.md, crates/tabletist-mcp/src/server.rs, crates/tabletist-db/src/lib.rs, LICENSE.
Tags
Tech Stack
Media
Comments (0)
No comments yet
Editorially curated, with community endorsements as a secondary signal. Corrections welcome.