> ## Documentation Index
> Fetch the complete documentation index at: https://ngquct-feat-ai-sql-walkthroughs.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 18 more.

# TablePro

Native macOS client for 24 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-ai-sql-walkthroughs/REI9tfF_TGivM099/images/app.png?fit=max&auto=format&n=REI9tfF_TGivM099&q=85&s=8731160dc7681378f4b2baa3ae0bdd1d" alt="TablePro main interface" width="3024" height="1722" data-path="images/app.png" />

  <img className="hidden dark:block" src="https://mintcdn.com/ngquct-feat-ai-sql-walkthroughs/REI9tfF_TGivM099/images/app-dark.png?fit=max&auto=format&n=REI9tfF_TGivM099&q=85&s=15c5003baaa6253c821cac9b4ab618a6" 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 via GitHub Copilot, Claude, OpenAI, Gemini, xAI, or Ollama.
**[MCP Server](/features/mcp)**: Expose your connections to Claude Desktop, Cursor, Raycast, and other MCP clients. The [External API](/external-api) 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 with password and key authentication. Passwords stay in the Keychain, or come from 1Password, HashiCorp Vault, or AWS Secrets Manager at connect time.
**[Safe Mode](/features/safe-mode)**: 6 per-connection protection levels, from silent alerts to 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 15 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), universal binary

## 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>