> ## Documentation Index
> Fetch the complete documentation index at: https://docs.tablepro.app/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 a dozen more.

# TablePro

Native macOS client for every database. Built on SwiftUI and AppKit. Ships under 50 MB, launches in under a second.

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

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

## Why TablePro?

<CardGroup cols={2}>
  <Card title="Native Performance" icon="bolt">
    Swift & Apple frameworks. No Electron. Pure macOS responsiveness.
  </Card>

  <Card title="Multiple Databases" icon="database">
    17 databases: MySQL, PostgreSQL, SQLite, MongoDB, Redis, Oracle, and more.
  </Card>

  <Card title="Smart Autocomplete" icon="wand-magic-sparkles">
    Context-aware autocomplete with schema and syntax awareness.
  </Card>

  <Card title="Secure Connections" icon="lock">
    SSH tunnels with password and key authentication.
  </Card>

  <Card title="AI SQL Assistant" icon="sparkles">
    Inline suggestions, chat, and context-menu actions. GitHub Copilot, Claude, OpenAI, Ollama, more.
  </Card>
</CardGroup>

## Key Features

**SQL Editor**: Syntax highlighting, autocomplete, Vim mode, multi-statement execution.
**Data Grid**: Inline editing, sorting, filtering, change tracking with undo/redo.
**CSV Inspector**: Open `.csv` and `.tsv` files natively. Edit cells, insert and delete rows and columns, undo/redo, save preserving the original dialect.
**Import & Export**: CSV, JSON, SQL, XLSX, MQL. Streaming export for large datasets.
**AI Assistant**: Chat, inline suggestions, and Explain/Optimize via GitHub Copilot, Claude, OpenAI, or Ollama.
**MCP Server**: Expose your connections to AI tools via the Model Context Protocol.
**External API**: Drive TablePro from Raycast, Cursor, Claude Desktop, and other MCP clients. URL scheme, MCP, and one-click pairing.
**Plugin System**: 5 bundled drivers (covering 7 databases) plus 10 more from the plugin registry. Third-party plugins supported.
**iCloud Sync**: Sync connections, groups, tags, settings, and SSH profiles across Macs.
**Safe Mode**: 6 per-connection protection levels from silent alerts to Touch ID and read-only.
**Themes**: 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     |
| 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       |
| 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       |
| libSQL / Turso       | N/A (API-based)  | Plugin       |
| Elasticsearch        | 9200             | Plugin       |

## System Requirements

* **macOS**: 14.0 (Sonoma) or later
* **Architecture**: Apple Silicon (arm64) or Intel (x86\_64)
* **Storage**: \~50 MB for the application (\~200 MB recommended free disk space including data)

## Getting Started

<CardGroup cols={2}>
  <Card title="Quick Start" icon="rocket" href="/quickstart">
    Download and connect in 5 minutes
  </Card>

  <Card title="Installation" icon="download" href="/installation">
    System requirements and setup
  </Card>
</CardGroup>

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