SQL editor and query workflow
Write SQL with syntax highlighting, schema-aware autocomplete, multi-tab results, Vim mode, query history, and transaction-based batch execution. Failed batches can roll back.
TablePro
TablePro is a free, open-source database client for Mac to query, inspect, and edit data across 29 database engines with native SQL and AI tools.
Native database client for macOS
TablePro is a free, open-source database client for macOS. It provides native drivers for 29 database engines, including MySQL, PostgreSQL, MariaDB, SQLite, Redis, MongoDB, SQL Server, Oracle, ClickHouse, BigQuery, Snowflake, and others. Nine drivers are bundled in the app; the remaining drivers are downloaded when selected.
The app combines a SQL workbench with a data grid for browsing and editing database records. Query results open in tabs, edits stay in memory until committed, and connections can use SSH tunnels, SSL/TLS, Unix sockets, or TCP/IP depending on the database. It is designed for Mac users who need one client for local databases, hosted services, and remote environments without putting a cloud service in the connection path.
Key features
Data grid editing
Browse, filter, sort, insert, delete, and edit rows in a type-aware grid. Changes remain pending until you save, with undo and redo available during the session.
Database inspection tools
View query plans as expandable, cost-coloured trees and inspect raw EXPLAIN output. PostgreSQL users can also open JSONB values in a tree editor.
AI SQL assistant
Use an AI assistant to explain, optimize, fix, or generate SQL. Results arrive as a diff and require an explicit Apply action; the assistant can use cloud providers or local Ollama models.
Connections and migration
Connect through SSH tunnels and jump hosts, import connections from TablePlus, Sequel Ace, DBeaver, DataGrip, Beekeeper Studio, or Navicat, and resolve credentials through supported macOS and external secret sources.
Controlled database automation
Use scoped MCP tools with saved connections, configurable read/write permissions, confirmation for destructive operations, and optional authentication and TLS for remote access.
Use cases
MySQL and MariaDB administration
Connect to MySQL 5.7+, MySQL 8.0+, or MariaDB 10.3+ over TCP, Unix socket, or SSH. Browse schemas, edit rows, modify structures, and export data without switching between separate utilities.
PostgreSQL development and troubleshooting
Work with PostgreSQL 12+ on local servers or hosted services such as RDS, Cloud SQL, Azure, Supabase, and Neon. Inspect EXPLAIN plans, edit JSONB values, and view server activity from the client.
Multi-database projects
Use one Mac application to query a mixed environment spanning relational, document, key-value, embedded, cloud, and analytics engines. Drivers can be selected as needed, with no restart after installation.
Data review and controlled edits
Review and update records through the grid while keeping changes staged until commit. Use filtering, sorting, CSV/JSON/SQL export, and database structure editors for routine data work.
Agent-assisted database work
Give compatible coding agents scoped access through MCP rather than sharing database passwords. Start with read-only or confirmation-based permissions and require explicit confirmation for destructive DDL.
Pros and Cons
Pros
- Free version is described as the full app rather than a time-limited trial, and the project is open source under AGPLv3.
- Supports 29 database engines through native drivers, with Apple Silicon and Intel builds.
- Keeps edits pending until an explicit save or commit, and provides query rollback and safety controls for destructive operations.
- Includes SSH tunneling, schema-aware SQL assistance, import tools, and database-specific inspection features.
Cons
- The product is macOS-only and requires macOS 14 Sonoma or later.
- Some database drivers are downloaded on demand rather than included in the initial app bundle.
- The supplied site content does not specify the price or exact scope of the optional licensed features.
FAQ
Is TablePro free to use?
TablePro is free and open source under AGPLv3. The source states that the free version is not a trial or demo and is available on every Mac, with no per-Mac limit. Optional licensed features are available, but the supplied pages do not specify their price or exact limits.
What Mac versions and processors does TablePro support?
The download page requires macOS 14 Sonoma or later. TablePro provides builds for Apple Silicon and Intel Macs, and the product pages describe it as a universal binary.
How do I install TablePro?
Download the DMG, open it, drag TablePro to the Applications folder, and launch it. The site also documents Homebrew installation with brew install --cask tablepro on the MySQL and PostgreSQL client pages.
Which databases can TablePro connect to?
TablePro includes native drivers for 29 database engines. Nine drivers ship inside the app, while the other 20 are downloaded the first time they are selected, with signature verification and no restart.
Can I connect to a remote database through SSH?
Yes. The connection workflow supports built-in SSH tunnels, including password, key, agent authentication, jump hosts, and custom ports. PostgreSQL and MySQL pages also describe TCP/IP, Unix socket, and SSL/TLS connection options.
Quick Facts
- Category
- Developer tool / database client
- Platform
- macOS 14 Sonoma or later
- Architecture
- Apple Silicon and Intel
- Database support
- 29 engines; 9 drivers bundled and 20 downloaded on demand
- License
- AGPLv3 open source
- Installation
- DMG or Homebrew cask; no account required
TablePro Alternatives
ByteAsk
ByteAsk is a terminal-first AI coding agent for C and C++ that edits repos and verifies changes with compilers, debuggers, sanitizers, and tests.
CreateOS Sandbox
CreateOS Sandbox is an isolated compute environment for running code and agent workloads in Firecracker micro-VMs with private networking and SDK, CLI, or MCP control.
hob
hob is an independent workspace for coding agents, with local control over sessions, terminals, history, routing, and follow-up work.
Ably Chat
Ably Chat is a chat API platform for custom realtime chat apps, with rooms, typing indicators, presence, reactions, message updates and usage-based pricing.
MacSpoof
MacSpoof is a macOS MAC address changer that lets you change or randomize your Wi‑Fi MAC to reconnect and limit device logging on public Wi‑Fi.
Manta AI
Manta AI is an autonomous web app testing tool that maps app behavior, catches regressions, and generates tests from a URL, no scripts or selectors needed.