# TablePro

> TablePro is a native macOS database client for MySQL, PostgreSQL, SQLite, MongoDB, Redis and 20 more, built on AppKit and SwiftUI with a plugin-based driver system.

## Docs

- [Introduction](https://ngquct-docs-fix-500-query-results.mintlify.site/index.md): Native macOS database client for MySQL, PostgreSQL, SQLite, MongoDB, Redis, and 22 more
- [Installation](https://ngquct-docs-fix-500-query-results.mintlify.site/installation.md): Install TablePro via Homebrew or DMG on macOS 14.0+
- [Quick Start](https://ngquct-docs-fix-500-query-results.mintlify.site/quickstart.md): Connect to your first database and run a query in a few minutes
- [Switching to TablePro](https://ngquct-docs-fix-500-query-results.mintlify.site/switching.md): Move your connections from TablePlus, Sequel Ace, DBeaver, DataGrip, Beekeeper Studio or Navicat, what comes across, what does not, and how to get your shortcuts back
- [FAQ](https://ngquct-docs-fix-500-query-results.mintlify.site/faq.md): Short answers on licensing, privacy, offline use, database coverage, syncing, and moving from another client
- [Troubleshooting](https://ngquct-docs-fix-500-query-results.mintlify.site/troubleshooting.md): Symptom-first checks for launch, connection, plugin, tunnel and save failures
- [Changelog](https://ngquct-docs-fix-500-query-results.mintlify.site/changelog.md): Product updates and announcements for TablePro
- [Managing Connections](https://ngquct-docs-fix-500-query-results.mintlify.site/connections/index.md): Create, organize, and switch database connections
- [Connection form](https://ngquct-docs-fix-500-query-results.mintlify.site/connections/connection-form.md): The nine panes of the connection editor, the fields on each, and which drivers get which
- [Connection URL Reference](https://ngquct-docs-fix-500-query-results.mintlify.site/connections/urls.md): Every supported database URL scheme, format, and query parameter for imports and direct connections
- [SSH Tunneling](https://ngquct-docs-fix-500-query-results.mintlify.site/connections/ssh-tunneling.md): Route database connections through an SSH tunnel to reach servers in private networks
- [SSH Profiles](https://ngquct-docs-fix-500-query-results.mintlify.site/connections/ssh-profiles.md): Save SSH tunnel configurations as reusable profiles shared across connections
- [Cloudflare Tunnel](https://ngquct-docs-fix-500-query-results.mintlify.site/connections/cloudflare-tunnel.md): Reach a database behind Cloudflare Access by letting TablePro manage the cloudflared process
- [Cloud SQL Auth Proxy](https://ngquct-docs-fix-500-query-results.mintlify.site/connections/cloud-sql-proxy.md): Connect to Google Cloud SQL by letting TablePro manage the Cloud SQL Auth Proxy
- [SOCKS Proxy](https://ngquct-docs-fix-500-query-results.mintlify.site/connections/socks-proxy.md): Route a database connection through a SOCKS5 proxy, with remote DNS (socks5h) so the proxy resolves the database hostname
- [AWS IAM Authentication](https://ngquct-docs-fix-500-query-results.mintlify.site/connections/aws-iam.md): Connect to Amazon RDS and Aurora with IAM database authentication instead of a static password
- [SSL/TLS](https://ngquct-docs-fix-500-query-results.mintlify.site/connections/ssl.md): Configure encrypted database connections, per-driver defaults, and certificate verification
- [Connection Sharing](https://ngquct-docs-fix-500-query-results.mintlify.site/features/connection-sharing.md): Export connections to a file, share links, import from other apps, and resolve passwords from secret managers
- [Open Project Folder](https://ngquct-docs-fix-500-query-results.mintlify.site/features/project-folder-import.md): Create a connection from the database settings already in your project's config files
- [Supported Databases](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/index.md): All 27 engines TablePro connects to, their default ports, and which ones need a plugin
- [Plugins & Themes](https://ngquct-docs-fix-500-query-results.mintlify.site/features/plugins.md): Install database drivers, import and export formats, and themes from the plugin registry, and keep them updated
- [Amazon DynamoDB](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/dynamodb.md): Connect to Amazon DynamoDB with PartiQL queries, GSI/LSI browsing, and DynamoDB Local support
- [Amazon Redshift](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/redshift.md): Connect to Redshift clusters and Serverless over the PostgreSQL wire protocol, with DISTKEY and SORTKEY metadata display
- [Beancount](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/beancount.md): Backend requirements, the table layout, source locations, includes, and BQL support
- [Cassandra / ScyllaDB](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/cassandra.md): Connect to Cassandra and ScyllaDB clusters, browse keyspaces, and run CQL queries
- [ClickHouse](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/clickhouse.md): Connection settings, the URL format, and the parts and partition tools for ClickHouse
- [Cloudflare D1](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/cloudflare-d1.md): Connect to Cloudflare D1 databases over the Cloudflare REST API
- [CockroachDB](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/cockroachdb.md): Connect to CockroachDB clusters over the PostgreSQL wire protocol, including CockroachDB Cloud with cluster routing
- [Dameng DM8](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/dameng.md): Dameng DM8 over its native wire protocol, with no DM client stack to install
- [DuckDB](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/duckdb.md): Open local DuckDB files or connect to a remote DuckDB server over Quack
- [Elasticsearch](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/elasticsearch.md): Connect to Elasticsearch with a Query DSL console, index browsing, and document editing
- [etcd](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/etcd.md): Connect to etcd v3 clusters with prefix-based key browsing and an etcdctl-style command editor
- [Google BigQuery](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/bigquery.md): Connect to Google BigQuery with Service Account, ADC, or OAuth auth
- [libSQL / Turso](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/libsql.md): Connect to Turso cloud databases, self-hosted sqld, or local libSQL files
- [MariaDB](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/mariadb.md): Connect to MariaDB 10.x and later through the bundled MySQL driver
- [Microsoft SQL Server](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/mssql.md): Connect to SQL Server and Azure SQL Database with the FreeTDS-based driver plugin
- [MongoDB](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/mongodb.md): Connect to MongoDB with MQL shell queries, collection browsing, and automatic Atlas SRV setup
- [MySQL](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/mysql.md): Connect to MySQL 5.7 and later with the bundled MariaDB Connector/C driver
- [Oracle Database](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/oracle.md): Connection settings, SSL modes, auth compatibility, and column type support for Oracle
- [PGlite](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/pglite.md): Connect to a PGlite database over its socket server using the PostgreSQL wire protocol
- [PostgreSQL](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/postgresql.md): Connect to PostgreSQL 12 and later with the libpq driver, including PostGIS display, AWS IAM auth, and pg_dump backups
- [Redis](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/redis.md): Browse keys by namespace, manage TTLs, and run Redis commands directly from the editor
- [Snowflake](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/snowflake.md): Connect to Snowflake with password, key-pair, SSO, or OAuth auth
- [SQLite](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/sqlite.md): Open and query SQLite database files directly, no server needed
- [SurrealDB](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/surrealdb.md): Connect to SurrealDB with namespace and database browsing, SurrealQL, and inline record editing
- [Teradata](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/teradata.md): Browsing databases and objects on Teradata Vantage, with TLS and transaction mode
- [Trino](https://ngquct-docs-fix-500-query-results.mintlify.site/databases/trino.md): Catalogs and schemas, type mapping, EXPLAIN variants, and the auth a Trino cluster accepts
- [SQL Editor](https://ngquct-docs-fix-500-query-results.mintlify.site/features/sql-editor.md): Write and run SQL with syntax highlighting, multi-statement execution, find and replace, and a built-in formatter
- [Code Folding](https://ngquct-docs-fix-500-query-results.mintlify.site/features/code-folding.md): Collapse statements, CTEs, subqueries and BEGIN blocks in the SQL editor and every other code view
- [SQL Files](https://ngquct-docs-fix-500-query-results.mintlify.site/features/sql-files.md): Open .sql files as query tabs, save back to them, and resolve edits made outside TablePro
- [Autocomplete](https://ngquct-docs-fix-500-query-results.mintlify.site/features/autocomplete.md): Schema-aware SQL autocomplete for keywords, tables, columns, and functions
- [Query Parameters](https://ngquct-docs-fix-500-query-results.mintlify.site/features/query-parameters.md): Use :name placeholders in SQL queries, fill values in a panel, execute with prepared statements
- [Vim Mode](https://ngquct-docs-fix-500-query-results.mintlify.site/features/vim-mode.md): Vim motions, text objects, registers, marks, and search inside the SQL editor
- [Query History](https://ngquct-docs-fix-500-query-results.mintlify.site/features/query-history.md): Every executed query is saved to a local SQLite database with full-text search
- [Query Insights](https://ngquct-docs-fix-500-query-results.mintlify.site/features/query-insights.md): Which queries you run most, which cost the most time, and which got slower
- [Data Grid](https://ngquct-docs-fix-500-query-results.mintlify.site/features/data-grid.md): Sort, size, hide, chart and copy the rows a table or a query puts in the grid
- [Query Results](https://ngquct-docs-fix-500-query-results.mintlify.site/features/query-results.md): Result tabs, pinning, the row cap, and what a failed or non-SELECT statement shows
- [Filtering](https://ngquct-docs-fix-500-query-results.mintlify.site/features/filtering.md): Build a WHERE clause from the filter bar, or write one by hand, and save it as a preset
- [Change Tracking](https://ngquct-docs-fix-500-query-results.mintlify.site/features/change-tracking.md): Queue cell edits, row inserts and deletions, review the SQL, then save
- [Cell and Row Viewers](https://ngquct-docs-fix-500-query-results.mintlify.site/features/json-viewer.md): View and edit JSON, PHP serialized, and binary cell values, set per-column display formats, and inspect whole rows in the sidebar
- [CSV Inspector](https://ngquct-docs-fix-500-query-results.mintlify.site/features/csv-inspector.md): Open, view, and edit CSV and TSV files without importing them into a database
- [Table Structure](https://ngquct-docs-fix-500-query-results.mintlify.site/features/table-structure.md): Browse and edit columns, indexes, foreign keys, triggers, and DDL with a visual structure editor
- [Table Operations](https://ngquct-docs-fix-500-query-results.mintlify.site/features/table-operations.md): Drop, truncate, run maintenance, manage views, and switch databases from the sidebar
- [ER Diagram](https://ngquct-docs-fix-500-query-results.mintlify.site/features/er-diagram.md): View table relationships as an interactive entity-relationship diagram
- [EXPLAIN Visualization](https://ngquct-docs-fix-500-query-results.mintlify.site/features/explain-visualization.md): View query execution plans as diagrams, trees, or raw output
- [Server Dashboard](https://ngquct-docs-fix-500-query-results.mintlify.site/features/server-dashboard.md): Monitor active sessions, server metrics, and slow queries in real time
- [Users & Roles](https://ngquct-docs-fix-500-query-results.mintlify.site/features/users-roles.md): Manage database users, roles, and privileges without writing GRANT statements by hand
- [Import & Export](https://ngquct-docs-fix-500-query-results.mintlify.site/features/import-export.md): Export to CSV, JSON, SQL, MQL, or XLSX. Import SQL, JSON, and CSV files with column mapping and transaction safety
- [Backup & Restore](https://ngquct-docs-fix-500-query-results.mintlify.site/features/backup-restore.md): Dump and restore PostgreSQL or Redshift databases with pg_dump and pg_restore, with progress, cancel, and SSH tunnel reuse
- [AI Assistant](https://ngquct-docs-fix-500-query-results.mintlify.site/features/ai-assistant.md): Built-in AI for SQL: chat with tool calling, inline suggestions, explain, optimize, and fix-error across 14 providers
- [MCP Server](https://ngquct-docs-fix-500-query-results.mintlify.site/features/mcp.md): Built-in Model Context Protocol server that lets AI clients query your databases through TablePro
- [Features Overview](https://ngquct-docs-fix-500-query-results.mintlify.site/features/overview.md): Every feature page, grouped the way the sidebar groups them
- [Query Tabs](https://ngquct-docs-fix-500-query-results.mintlify.site/features/tabs.md): Each tab keeps its own SQL, results, sorting, and filters, and comes back after a restart
- [Connections strip](https://ngquct-docs-fix-500-query-results.mintlify.site/features/workspace-rail.md): Switch between every connection and database you have open from a narrow strip on the leading edge of the window
- [Open Quickly](https://ngquct-docs-fix-500-query-results.mintlify.site/features/open-quickly.md): Search objects and queries in one connection or across every open connection
- [Favorites](https://ngquct-docs-fix-500-query-results.mintlify.site/features/favorites.md): Mark tables as favorites and save frequently used queries with optional keyword shortcuts
- [Keyboard Shortcuts](https://ngquct-docs-fix-500-query-results.mintlify.site/features/keyboard-shortcuts.md): Every keyboard shortcut in TablePro, plus how to rebind them in Settings > Keyboard
- [iCloud Sync](https://ngquct-docs-fix-500-query-results.mintlify.site/features/icloud-sync.md): Sync connections, table favorites, settings, and SSH profiles across Macs and iOS via iCloud
- [Handoff](https://ngquct-docs-fix-500-query-results.mintlify.site/features/handoff.md): Resume the active connection or table on another device signed into the same iCloud account
- [Licensing](https://ngquct-docs-fix-500-query-results.mintlify.site/features/licensing.md): Activate and deactivate a license key, what each tier includes, and how offline validation works
- [Team Plan](https://ngquct-docs-fix-500-query-results.mintlify.site/features/team.md): Share one license across your team, manage seats on the web, and join with an invite code
- [Settings](https://ngquct-docs-fix-500-query-results.mintlify.site/customization/settings.md): Every settings tab, its controls, and their defaults
- [General Settings](https://ngquct-docs-fix-500-query-results.mintlify.site/customization/general-settings.md): Language, startup behavior, sidebar layout, query timeout, the command line tool, updates, and reset
- [Appearance](https://ngquct-docs-fix-500-query-results.mintlify.site/customization/appearance.md): Themes, per-theme fonts, color customization, and connection colors
- [Editor Settings](https://ngquct-docs-fix-500-query-results.mintlify.site/customization/editor-settings.md): SQL editor, Vim mode, line numbers, indentation, and query parameter settings
- [Data Settings](https://ngquct-docs-fix-500-query-results.mintlify.site/customization/data-settings.md): Data grid, pagination, query result cap, JSON viewer, and query history
- [Notifications](https://ngquct-docs-fix-500-query-results.mintlify.site/customization/notifications.md): Which finished operations notify you, how long work has to run first, and what the notification carries
- [iPhone and iPad](https://ngquct-docs-fix-500-query-results.mintlify.site/ios/index.md): Browse tables, run queries, and edit rows on eight database engines from a synced connection list
- [Privacy](https://ngquct-docs-fix-500-query-results.mintlify.site/security/privacy.md): Every outbound request the app can make, what each one carries, and where its off switch is
- [Safe Mode](https://ngquct-docs-fix-500-query-results.mintlify.site/features/safe-mode.md): Per-connection query execution controls, from no restrictions to full read-only lockdown
- [Acknowledgements](https://ngquct-docs-fix-500-query-results.mintlify.site/features/acknowledgements.md): The open source libraries TablePro ships, and the licenses that cover them
- [External API](https://ngquct-docs-fix-500-query-results.mintlify.site/external-api/index.md): URL scheme, MCP server, pairing flow, terminal, and iOS Shortcuts for driving TablePro from other apps
- [Versioning](https://ngquct-docs-fix-500-query-results.mintlify.site/external-api/versioning.md): Which MCP protocol versions TablePro accepts, and the stability policy for the URL scheme, tools, and resources
- [URL Scheme](https://ngquct-docs-fix-500-query-results.mintlify.site/external-api/url-scheme.md): Every tablepro:// deep link action with parameters and examples
- [Connection Import](https://ngquct-docs-fix-500-query-results.mintlify.site/external-api/connection-import.md): Every query parameter a tablepro://import link accepts, and which ones the app refuses
- [Terminal and DDEV](https://ngquct-docs-fix-500-query-results.mintlify.site/external-api/terminal.md): Opening databases and files from a shell script, and wiring up a ddev tablepro command
- [Raycast Extension](https://ngquct-docs-fix-500-query-results.mintlify.site/external-api/raycast.md): Install and pair the TablePro Raycast extension, and use its commands and AI tools
- [iOS Shortcuts](https://ngquct-docs-fix-500-query-results.mintlify.site/external-api/ios-shortcuts.md): Add rows to a table or open a connection from the Shortcuts app on iPhone and iPad
- [MCP Clients](https://ngquct-docs-fix-500-query-results.mintlify.site/external-api/mcp-clients.md): Connect Claude Desktop, Claude Code, Cursor, VS Code, Cline, Continue, Zed, Windsurf, Antigravity, Goose, and custom clients to TablePro
- [MCP Protocol](https://ngquct-docs-fix-500-query-results.mintlify.site/external-api/mcp-protocol.md): Wire contract for TablePro MCP server: protocol versions, required metadata, headers, result envelope, cache hints, and error codes
- [MCP Tools](https://ngquct-docs-fix-500-query-results.mintlify.site/external-api/mcp-tools.md): The 46 tools TablePro's MCP server exposes, with arguments, defaults, result shapes, and scope requirements
- [MCP Resources](https://ngquct-docs-fix-500-query-results.mintlify.site/external-api/mcp-resources.md): Read-only resources for connections, schema, tables, and query history, with their URI templates
- [MCP Prompts](https://ngquct-docs-fix-500-query-results.mintlify.site/external-api/mcp-prompts.md): The eight prompts TablePro renders from a live schema, and how completion/complete fills their arguments
- [MCP Subscriptions](https://ngquct-docs-fix-500-query-results.mintlify.site/external-api/mcp-subscriptions.md): subscriptions/listen, the notification filter TablePro honors, and what it deliberately does not send
- [Pairing](https://ngquct-docs-fix-500-query-results.mintlify.site/external-api/pairing.md): One-click flow that issues a scoped MCP token to an extension through a PKCE-style code exchange
- [Tokens](https://ngquct-docs-fix-500-query-results.mintlify.site/external-api/tokens.md): Token model, scopes, connection allowlists, expiry, revocation, and the activity log
- [Development Overview](https://ngquct-docs-fix-500-query-results.mintlify.site/development/overview.md): Build TablePro from source, contribute, or write a database driver plugin
- [Development Setup](https://ngquct-docs-fix-500-query-results.mintlify.site/development/setup.md): Clone, configure signing, and build TablePro in Xcode
- [Architecture](https://ngquct-docs-fix-500-query-results.mintlify.site/development/architecture.md): How the app, plugin system, and core services fit together
- [Building](https://ngquct-docs-fix-500-query-results.mintlify.site/development/building.md): Debug builds, the plugin compile check, clean builds, and what CI runs on a pull request
- [Releasing](https://ngquct-docs-fix-500-query-results.mintlify.site/development/releasing.md): Release builds, notarization, DMG packaging, static libraries, and the release tag
- [Code Style](https://ngquct-docs-fix-500-query-results.mintlify.site/development/code-style.md): Swift conventions, tooling, naming, and file organization rules
- [Plugin Development](https://ngquct-docs-fix-500-query-results.mintlify.site/development/plugin-development.md): Write a database driver plugin, implement the PluginKit protocols, and package it as a .tableplugin bundle
- [Plugin Registry](https://ngquct-docs-fix-500-query-results.mintlify.site/development/plugin-registry.md): Registry manifest format, binary selection, publishing, and PluginKit compatibility
- [Testing a Custom Plugin](https://ngquct-docs-fix-500-query-results.mintlify.site/development/testing-plugins.md): Load a locally built driver plugin in a debug build of TablePro

## Optional

- [GitHub](https://github.com/TableProApp/TablePro)
- [Download](https://tablepro.app/download)
- [Discord](https://discord.gg/hCNmUUbnD4)
- [Telegram](https://t.me/tablepro_app)