Documentation
Exploring data
Browse schemas, page through large tables, inspect rows, compare structures, and edit data safely.
TableR gives you a searchable schema explorer plus focused tools for reading, understanding, and editing table data without writing boilerplate queries. It is designed to stay smooth on real-world databases — hundreds of tables and tables with millions of rows.
Schema explorer
The explorer on the left is the map of your connection. Search narrows it instantly, and toggling it with Ctrl + B reclaims the whole width for the editor and results.
- Search across databases, schemas, tables, and columns at once.
- Expand an object to see its columns, keys, and indexes inline.
- Open a table straight into the data browser, or jump to its structure view.
- Toggle the explorer with Ctrl + B; use the quick switcher (Ctrl + P) to jump to an object by name.
Browse table data
Opening a table loads its rows into a virtualized grid built for scale. Only the visible rows render, so scrolling stays responsive whether the table has a hundred rows or a million.
- Pagination, sorting, and filtering to find the rows you care about.
- Column resizing, reordering, visibility, and pinning to shape the view.
- Per-table layout that is remembered, so a table reopens the way you left it.
The data grid is virtualized and pages results, so browsing a million-row table stays smooth and stays within bounded memory.
Inspect a single row
Wide tables are hard to read across. The row inspector opens one record in a tall, readable panel — long text, JSON, and binary-ish columns included — so you can study or copy a value without horizontal scrolling.
Understand structure
- Structure view for a table's columns, data types, keys, and indexes.
- Schema diff to compare two structures and spot drift between environments.
- Create-schema-object helpers that draft the DDL for common tasks so you can review it before running.
Metadata richness, explain plans, and schema editing depend on each database driver, so some engines expose more structure detail than others.
Edit data safely
TableR supports inline edits directly in the grid, with change tracking so you can see exactly what will be written. Edits, pastes, fills, and deletes target the rows you selected, and are staged for review before they commit — the same review-before-run principle used everywhere in the app.
Data edits are previewed and applied by you. Nothing is written silently, and Safe Mode still governs the underlying statements.
Move data in and out
Preview and import CSV files, and export any result set or table to CSV, JSON, Excel, or SQL-oriented formats. Large transfers stream with progress and can be cancelled, so a big export does not lock up the app.
Switch any result set between a table and a chart, then export it — the view you are looking at is the shape you can share.