> ## Documentation Index
> Fetch the complete documentation index at: https://ngquct-feat-721-compare-sync.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Introduction

> Native macOS database client for MySQL, PostgreSQL, SQLite, MongoDB, Redis, and 20 more.

Native macOS client for 25 databases. Built with SwiftUI and AppKit, no Electron. The download is about 20 MB.

<Frame caption="TablePro - Native macOS Database Client">
  <img className="block dark:hidden" src="https://mintcdn.com/ngquct-feat-721-compare-sync/TlGri84ui62H4Saf/images/app.png?fit=max&auto=format&n=TlGri84ui62H4Saf&q=85&s=b88a64c240fc5bbb957223b1e874d120" alt="TablePro main interface" width="3024" height="1722" data-path="images/app.png" />

  <img className="hidden dark:block" src="https://mintcdn.com/ngquct-feat-721-compare-sync/TlGri84ui62H4Saf/images/app-dark.png?fit=max&auto=format&n=TlGri84ui62H4Saf&q=85&s=5c4daea004632b8267082756f377700d" alt="TablePro main interface" width="3024" height="1722" data-path="images/app-dark.png" />
</Frame>

## Features

**[SQL Editor](/features/sql-editor)**: Syntax highlighting, schema-aware autocomplete, Vim mode, multi-statement execution.
**[Data Grid](/features/data-grid)**: Inline editing, sorting, filtering, change tracking with undo/redo.
**[AI Assistant](/features/ai-assistant)**: Chat, inline suggestions, and Explain/Optimize across 13 providers, including GitHub Copilot, Claude, OpenAI, Gemini, xAI, and local llama.cpp, MLX, and Ollama.
**[MCP Server](/features/mcp)**: Expose your connections to Claude Desktop, Cursor, Raycast, and other MCP clients. The [External API](/external-api/index) adds a `tablepro://` URL scheme and one-click pairing.
**[Users & Roles](/features/users-roles)**: Manage database users, roles, and privileges on MySQL and PostgreSQL. Changes are staged, undoable, and shown as SQL before they run.
**[Secure Connections](/databases/ssh-tunneling)**: SSH tunnels authenticate with a password, a private key, an SSH agent, keyboard-interactive, or no credentials at all. Passwords stay in the Keychain, or [resolve at connect time](/features/connection-sharing#password-sources) from a file, an environment variable, a command, 1Password, HashiCorp Vault, or AWS Secrets Manager.
**[Safe Mode](/features/safe-mode)**: 6 per-connection protection levels, from no prompt at all to confirmation dialogs, Touch ID, and read-only.
**[Import & Export](/features/import-export)**: CSV, JSON, SQL, XLSX, MQL. Streaming export for large datasets.
**[CSV Inspector](/features/csv-inspector)**: Open `.csv` and `.tsv` files directly. Edit cells, insert and delete rows and columns, save in the original dialect.
**[Plugin System](/features/plugins)**: 5 bundled drivers covering 9 databases, plus 16 more drivers installable from the plugin registry.
**[iCloud Sync](/features/icloud-sync)**: Connections, groups, tags, settings, SSH profiles, saved queries and folders, favorite tables, and custom AI slash commands sync across Macs.
**[Themes](/customization/appearance)**: Light, dark, and custom editor themes. Per-connection color labels.

## Supported Databases

| Database             | Default Port     | Distribution |
| -------------------- | ---------------- | ------------ |
| MySQL                | 3306             | Built-in     |
| MariaDB              | 3306             | Built-in     |
| PostgreSQL           | 5432             | Built-in     |
| SQLite               | N/A (file-based) | Built-in     |
| Amazon Redshift      | 5439             | Built-in     |
| CockroachDB          | 26257            | Built-in     |
| PGlite               | 5432             | Built-in     |
| Microsoft SQL Server | 1433             | Plugin       |
| ClickHouse           | 8123             | Built-in     |
| Redis                | 6379             | Built-in     |
| MongoDB              | 27017            | Plugin       |
| Oracle Database      | 1521             | Plugin       |
| DuckDB               | N/A (file-based) | Plugin       |
| Beancount            | N/A (file-based) | Plugin       |
| Cassandra / ScyllaDB | 9042             | Plugin       |
| etcd                 | 2379             | Plugin       |
| Cloudflare D1        | N/A (API-based)  | Plugin       |
| DynamoDB             | N/A (API-based)  | Plugin       |
| BigQuery             | N/A (API-based)  | Plugin       |
| Snowflake            | N/A (API-based)  | Plugin       |
| Teradata             | 1025             | Plugin       |
| libSQL / Turso       | N/A (API-based)  | Plugin       |
| Elasticsearch        | 9200             | Plugin       |
| SurrealDB            | 8000             | Plugin       |
| Trino                | 8080             | Plugin       |

## System Requirements

* **macOS**: 14.0 (Sonoma) or later
* **Architecture**: Apple Silicon (arm64) or Intel (x86\_64). Downloads are per-architecture, and Homebrew picks the right one.

## Open Source

TablePro is free, open-source software licensed under the [GNU Affero General Public License v3.0 (AGPLv3)](https://www.gnu.org/licenses/agpl-3.0.html). The full source code is on GitHub.

<Card title="GitHub Repository" icon="github" href="https://github.com/TableProApp/TablePro">
  View source code, report issues, and contribute to TablePro.
</Card>