TabulaSQL covers the full loop of working with MySQL, MariaDB, PostgreSQL & SQLite: connecting, browsing, querying, editing, and managing schema, in one focused desktop app. Below is a real walkthrough of the UI, not mockups.
Pick a driver in the connection form: MySQL/MariaDB, PostgreSQL, or a local SQLite file. Connect, browse, query, and edit all four. MySQL and MariaDB still have the deepest schema tools (indexes, foreign keys, routines, and a user manager). Minimum versions: MySQL 5.7+ / MariaDB 10.4+. Developed and tested against MySQL 8.4, MySQL 9.7, and MariaDB 11, plus PostgreSQL servers and SQLite files.
Connect to MySQL 5.7 and newer. Works with local installs, remote servers, and cloud-hosted MySQL that speak the standard protocol. Full schema tools, copy wizard, and user manager.
First-class MariaDB support from 10.4 up. Same MySQL-protocol connection flow, explorer, editor, schema tools, and user manager.
Add a PostgreSQL connection (default port 5432). Browse databases, tables, and views, run SQL, edit rows, use Explain with a plan tree, and open an ER diagram.
Point the connection at a local .sqlite file instead of a host. Browse tables and views, query, and edit without standing up a server.
Browse tables, open context menus, manage indexes and foreign keys, follow relations, filter and resize columns, create a connection, export credentials, run a JOIN with a stored function, and check EXPLAIN, all without leaving the keyboard path you already know.
Connections on the left, an object explorer for the active server, a multi-tab SQL editor in the middle, and a results panel underneath for table data, query output, messages, and schema info. No modal maze: the tools stay where you left them.
Every server you work with lives in one sidebar. Pick a driver first: MySQL/MariaDB, PostgreSQL, or SQLite. Click once to connect, see a live open badge when a session is active, and colour-code connections so staging never looks like production. Passwords are stored encrypted on your machine.
.dbmconn file with an optional passphrase, or as plain JSON. Perfect for onboarding a new laptop without retyping every password.
Duplicate a connection from the sidebar when you need a near-identical staging or read-only twin. Edit an open connection and TabulaSQL closes the old session and reconnects with the new host, credentials, or SSH settings automatically, so you are not stuck on a stale tunnel.
Tip
Colour-code production connections and keep Safe Lock on when you are browsing live data. That way a mistaken Save Changes still shows you the SQL first.
Drop in a .dbmconn or .json export, unlock encrypted files with your passphrase, preview what will be imported, and choose how each connection is handled. No cloud account required, just a file.
Expand a database and TabulaSQL lists tables, views, procedures, functions, triggers, and events in one tree. Filter with plain text or regex, multi-select objects for bulk copy, and refresh when the schema changes under you.
Stored procedures, functions, triggers, and events aren't second-class. Open their DDL in the editor to create, review, alter, or drop them yourself, using the same “edit the SQL” approach you already use for tables, instead of fighting a half-baked visual designer.
CodeMirror 6 editing with syntax highlighting, schema-aware autocomplete, multi-tabs, and multiple statements per run. Shortcuts match how you already work: Ctrl+Enter to run, Ctrl+Shift+Enter for a selection, Ctrl+Space for autocomplete, Ctrl+P for the command palette.
A real JOIN across orders and customers, calling the database function order_total(). Results land in the Table Data tab with timing and row counts.
The same workspace after a clean query run: editor on top, spreadsheet-style results below, database context always visible. From the toolbar you can Format SQL, save the statement, open optional AI text-to-SQL, or chart a numeric result column.
Version 1.0.9
These landed in recent app releases. They are optional extras on top of the same local-first workflow: no account, no telemetry, no paid unlock.
Open the AI drawer from the query toolbar or the command palette. TabulaSQL includes schema context so the model writes against your tables, not a generic example. Bring your own key for OpenAI, Anthropic, or an OpenAI-compatible base URL. Keys are encrypted in the local SQLite settings store; nothing is sent until you click Generate.
Ctrl/Cmd+P searches tables, saved queries, and actions: Ask AI, AI settings, ER diagram, and (on MySQL/MariaDB) the user manager. Arrow keys plus Enter run the highlighted item.
Open an entity-relationship view of the current database from the object menu or palette. Tables and foreign-key edges are built from the live schema, so you can see how a database is wired before writing a JOIN.
On MySQL and MariaDB connections, inspect users and hosts, read grants, and create a user with a database grant. PostgreSQL and SQLite keep their own admin paths; this panel is MySQL-protocol only.
Save a statement against the current connection and reload it later from the editor or palette. When a result has a numeric column, toggle Chart for a simple bar series (first text column as labels, first numeric column as values).
In the data grid, Import clipboard accepts CSV, TSV, or JSON and maps columns onto the open table so you can paste rows without a separate import wizard.
Open a table and you get a full grid: sort by clicking headers, page with first-row / row-count controls, filter with a dedicated dialog, resize columns when a VARCHAR is too wide, and edit cells in place. Single-click a row to keep it highlighted while you scroll sideways. Pending changes highlight in amber until you save or cancel.
=, LIKE, IN, BETWEEN, and IS NULL. Or right-click a cell and filter to “this value” in one move. Active filters show as chips you can clear anytime.
Hover an FK cell and jump to the related record, or right-click and choose Show Related Record…. The dialog shows the full parent row, the relationship path (for example orders.customer_id → customers.id), and a button to open that table in the grid. Real foreign-key constraints work, and Laravel-style xxx_id columns are recognised too.
Right-click any cell for insert/duplicate/delete row, set NULL / empty / default, quick filters, copy as CSV or INSERT, and export the whole result as CSV, JSON, or SQL. The same menu surfaces related-record navigation when you're on a foreign key.
Right-click a table for the structural work you do every week: create table, index manager, foreign key manager, or alter via DDL in the editor. The same DDL-in-editor pattern covers create, alter, and drop for views, procedures, functions, triggers, and events. Truncate or empty a database when you need a clean slate without deleting the database itself.
Whether you're backing up a schema, seeding a staging copy, or moving tables and routines between servers, TabulaSQL keeps the wizards short and the options explicit. SQL dumps are generated in pure PHP, so you don't need mysqldump installed.
DROP IF EXISTS and CREATE DATABASE. Download a dump you can re-run anywhere.
max_allowed_packet.
.sql file and run it against the active database, with per-statement error reporting. Useful for migrations, seed scripts, and restores without opening a terminal.
Table menus cover open, copy, backup, import, paste SELECT/INSERT/UPDATE/DELETE/CREATE templates, alter DDL, indexes, foreign keys, rename, truncate, and drop. Database menus add create table/view/routine shortcuts plus truncate and empty database. Tabs you leave open come back after a restart. No ribbon full of icons you never click.
Pick Auto, Light, Dark, or TabulaSQL Classic. Themes, AI settings, keyboard shortcuts, and Safe Lock live as compact icons in the top-right corner. The app is local-first: no account, no telemetry, credentials stay on disk you control.
macOS, Windows, and Linux. Built for MySQL, MariaDB, PostgreSQL & SQLite. MIT licensed. No trial, no “pro” tier, no account.