How to use TabulaSQL

1. Installing TabulaSQL

Grab the build for your platform from the download page. TabulaSQL ships as a standalone desktop app for macOS, Windows, and Linux - no runtime or dependencies to install separately.

Builds are not code-signed. On macOS, Gatekeeper may say the app can't be opened or is damaged: right-click the app and choose Open, or clear the quarantine flag with xattr -cr /Applications/TabulaSQL.app. Full steps are on the download page.

2. Adding a connection

Minimum versions: MySQL 5.7+ / MariaDB 10.4+.

Click the + button above the connections list, fill in your host, port, username, password, and optional database name, then save. Use Test connection before saving if you want to verify credentials first. Passwords are stored encrypted on your machine.

Need to reach a server behind a bastion host? Enable the SSH tunnel option and authenticate with a key or password. Colour-label connections so staging and production stay visually distinct. Duplicate an existing connection from the sidebar when you need a near-identical copy with a different name or colour.

Already have connections exported from another machine? Right-click the connections panel and choose Import Connections to load a .dbmconn or .json file.

If you edit a connection that is already open, TabulaSQL closes that session and reconnects with the new settings after you save.

3. Browsing objects

Click a connection to open it. The object explorer lists databases with tables, views, procedures, functions, triggers, and events. Click a table to open its data in the grid, or use the filter (plain text or regex) to find objects in large schemas.

Right-click any object for context actions: open, copy, backup, paste SQL templates, alter DDL, and more.

4. Running a query

Type SQL into the editor at the top of a query tab. Schema-aware autocomplete suggests tables, columns, and keywords as you go - trigger it manually with Ctrl/Cmd + Space if it doesn't show up automatically.

Press Ctrl/Cmd + Enter to run the whole script (multiple statements are fine), or select a portion and press Ctrl/Cmd + Shift + Enter to run just that selection. Use Explain to see the query plan before running anything expensive. Past queries are kept in a searchable history per connection.

5. Editing table data

Double-click any cell in the data grid to edit it in place. A single click only highlights the row so you can keep your place while scrolling sideways. Changed cells are highlighted until you save. Use the toolbar to filter rows, set the page size, or add a new row with + Row.

Select rows with the checkbox column, Shift-click ranges, or Ctrl/Cmd + A. Right-click a cell for more: insert, duplicate, or delete rows, set a value to NULL, an empty string, or its column default, follow foreign keys to related records, and export exactly the rows you've selected as CSV, JSON, or SQL.

6. Safe Lock mode

Use the lock icon in the top-right corner when you are on a production server. With Safe Lock on, saves, inserts, deletes, and row duplicates show the SQL first and wait for confirmation. Turn it off for everyday local work; deletes still ask for confirmation either way.

7. Managing schema

Right-click any table in the sidebar to create or alter it, manage indexes, inspect foreign keys, or rename, truncate, and drop it. Create, alter, and drop views, procedures, functions, triggers, and events via DDL in the editor. Destructive actions are shown in red and always ask for confirmation first.

At the database level you can also truncate or empty a database: clear all data, or drop all objects, while keeping the database itself.

8. Import & export

Import a .sql file into the active database, export SQL dumps (pure PHP, no mysqldump required), or export result sets as CSV, JSON, or SQL.

Copy tables, views, procedures, functions, triggers, and events between connections with the copy wizard: chunked, foreign-key safe, with live progress.

9. Keyboard shortcuts

The most useful shortcuts to build muscle memory for:

The full list is available inside the app from the keyboard shortcuts icon in the top-right corner.

10. Troubleshooting

Can't connect? Double-check host/port, that your MySQL or MariaDB server accepts your client, and try an SSH tunnel if the server isn't publicly reachable. Still stuck, or think you've found a bug?