Tabellum Manual

User guide

Tabellum for desktop

How to use Tabellum on macOS, Windows and Linux: connect to PostgreSQL, MySQL and MariaDB, SQL Server, BigQuery, SQLite and MongoDB, browse and edit data, write SQL, draw charts and dashboards, design schemas, back up and restore, and work with the AI agent that writes nothing you have not approved.

Start reading Download the PDF Try it in the browser

  1. Chapter 1 Getting started Tabellum is a database client for PostgreSQL, MySQL and MariaDB, SQL Server, BigQuery, SQLite and MongoDB. It browses and edits data, runs SQL, draws charts…
  2. Chapter 2 Connections A connection is the address of one database and how to log in to it. Tabellum keeps as many as you like and can have several open at once.
  3. Chapter 3 Browsing and editing data Open a connection in the sidebar to see its schemas. Each schema groups its tables, views, functions, sequences and enum types; Users & roles lists the…
  4. Chapter 4 Writing SQL New query tab (the + above the tabs, or the palette) opens an editor on the connection chosen at its top. Type SQL and press Cmd+Enter or click Run…
  5. Chapter 5 Charts, dashboards and export Any result can be a chart: click the chart button in the status bar. Tabellum suggests one from the columns; change the kind, the column along x and the…
  6. Chapter 6 Diagrams, snapshots and comparing schemas The Diagram button next to a schema in the sidebar draws its tables and the foreign keys between them. Drag a table by its card to move it; Tabellum…
  7. Chapter 7 The schema designer The designer is a canvas for changing a schema the way you would draw it: add tables, drag foreign keys between columns, edit types and constraints. Nothing…
  8. Chapter 8 Views, users and roles New view next to a schema in the sidebar (or Save as view… above a table’s rows) opens the view designer: pick the source table, the columns to keep…
  9. Chapter 9 The AI agent The agent answers questions about your databases in plain language: it reads the schema, runs read-only queries, explains plans, drafts SQL into the editor…
  10. Chapter 10 Backup, restore and sync Right-click a connection in the sidebar and choose Back up…. The Mac App Store version backs up through the database connection itself: the schema and the…
  11. Chapter 11 Reference On Windows and Linux, press Ctrl where the table says Cmd. The Mac App Store version runs in Apple’s sandbox. Compared with the version downloaded from the…

Another guide: Tabellum for mobile.