Skip to main content

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.

​
Settings

Open with Cmd+,. Settings are grouped into tabs.

General

Language, updates, query timeout, restore session.

Appearance

Theme, accent colour, sidebar.

Editor

Font, Vim mode, line numbers, JSON viewer.

Keyboard

Custom shortcuts.

AI

Providers, chat modes, custom slash commands, context, per-connection rules.

Terminal

Font, theme, CLI paths.

MCP

Server config, tokens, activity log, connected clients.

Plugins

Manage drivers and exporters.

Account

License, iCloud sync, linked folders.

​
General

​
Language

System (default), English, Tiếng Việt, Türkçe. Changing the language requires restarting TablePro.

​
Startup Behavior

OptionDescription
Show Welcome ScreenDisplay the welcome screen with recent connections
Reopen Last SessionAuto-reconnect to your last database

​
Query Execution Timeout

Maximum seconds a query runs before cancellation. Default 60, range 0-600 (0 means no limit). Enforced at the database level: statement_timeout (PostgreSQL), max_execution_time (MySQL), max_statement_time (MariaDB), sqlite3_busy_timeout (SQLite). Applies on new connections; change requires reconnect.

​
Software Update

SettingDefaultDescription
Automatically check for updatesOnPeriodic background check
Check for Updates…-Check now
Powered by Sparkle. Also available from the TablePro menu.

​
Privacy

SettingDefaultDescription
Share anonymous usage dataOnOS version, architecture, locale, database types every 24 hours
No queries or database content is transmitted.

​
Query History

SettingDefaultDescription
Max Entries10,0000 = unlimited
Max Days900 = keep forever
Auto CleanupOnRemove old entries automatically
Clear All History-One-click wipe

​
Tabs

SettingDefaultDescription
Reuse clean table tabOffClick a new table to replace the current tab if untouched
Enable preview tabsOnSingle-click opens a preview tab; double-click or interaction makes it permanent
Group all connections in one windowOffForce all tabs into one window regardless of connection
A tab is “clean” when it’s a table tab (not query/create), unpinned, no unsaved changes, and no interactions (sort, filter, selection).

​
AI

The AI tab configures providers and chat behavior. See AI Assistant for usage. The tab has these sections.

​
Enable AI Features

Master switch. Turning it off hides every other AI section in this tab and disables chat, inline suggestions, and editor actions.

​
Active Provider

The provider used by default. Override it per turn from the model picker in the chat composer.

​
Providers

List of configured providers. Click a row to open its detail sheet, or pick Add Provider… to add one. The choices are GitHub Copilot (OAuth device flow), Claude, OpenAI, OpenRouter, Gemini, Ollama (no auth, local), and a custom OpenAI-compatible endpoint. API keys are stored in the macOS Keychain. Removing a provider deletes its key.

​
Inline Suggestions

SettingDefaultDescription
Enable inline suggestions while typingOffShow ghost-text completions in the SQL editor. Requires an active provider.
With Copilot active, suggestions come from Copilot’s inline-completion model. With any other provider, they come from chat completions.

​
Context

Controls what the AI sees automatically each turn. New installs default all three toggles to off, so the AI sees only what you attach with @ mentions or what tools pull in.
SettingDefaultDescription
Include database schemaOffAuto-attach the active connection’s schema
Include current queryOffAuto-attach the active editor tab’s text
Include query resultsOffAuto-attach the most recent query result snapshot
Max schema tables20Cap on tables formatted into the schema attachment, range 1-100
Existing installs keep their previous values.

​
Custom Slash Commands

Add, edit, or delete user-defined slash commands. Each command has a name, an optional description, and a prompt template. Templates support these placeholders, substituted at send time:
  • {{query}}: the current editor query.
  • {{schema}}: the formatted schema for the active connection (capped by Max schema tables).
  • {{database}}: the active database name.
  • {{body}}: text typed after the command in the composer (e.g. /review WHERE clauses passes WHERE clauses).
Save needs a name and a non-empty template.

​
Privacy

SettingDefaultDescription
Connection policyAsk Each TimeDefault AI policy applied to new connections. Per-connection overrides live in the connection form.
For per-connection AI rules (system-prompt additions tied to a specific database), see Per-connection AI rules. Those are configured in the connection form, not here.

​
MCP

The MCP tab covers the External API surface. The server lazy-starts on first use and exposes the following sections:
  • MCP Server: enable toggle and live status. The server runs on a free port in the 51000-52000 range. See MCP Server.
  • MCP Configuration: row limit defaults, query timeout, “log MCP queries in history”.
  • Authentication: list, create, and revoke bearer tokens. Issued by the pairing flow or generated manually. See Tokens.
  • Activity Log: every authentication, tool call, and resource read with token, category, action, connection, and outcome. 90-day retention. Backed by ~/Library/Application Support/TablePro/mcp-audit.db.
  • Network: remote access toggle, TLS certificate, fingerprint, and PEM export.
  • MCP Setup: one-click config snippets for Claude Code, Claude Desktop, and Cursor.
  • Connected Clients: live list of MCP clients connected to the server.

​
Plugins

Manage database driver and exporter plugins from Settings > Plugins. Split-view: list on the left, details on the right.
  • Installed: built-in (MySQL, PostgreSQL, SQLite, ClickHouse, SQL Server, Redis, CSV, JSON, SQL) plus user-installed plugins. Toggle on/off in the detail pane.
  • Browse: install drivers from the registry (MongoDB, DuckDB, Oracle, Cassandra, Etcd, Cloudflare D1, DynamoDB, BigQuery, libSQL).
  • Sideload: click + or drag a .tableplugin / .zip onto the view. TablePro verifies the code signature.
Built-in plugins can be disabled but not uninstalled.
Only install plugins from sources you trust. Code-signature checks do not guarantee plugin behavior.

​
License & Account

Activate, deactivate, or view your license under Settings > Account. Validation is local (cryptographic signature) and re-checks every 7 days. iCloud sync, linked folders, and account info live on the same tab. See iCloud Sync.

​
Data Grid

Data grid font, row height, date format, NULL display, page size, and row count estimation live on the Editor tab. See Data Grid for usage and behavior.

​
Settings Storage

~/Library/Preferences/com.TablePro.plist
Reset to defaults: 
rm ~/Library/Preferences/com.TablePro.plist
rm -rf ~/Library/Caches/com.TablePro
Resetting preferences does not affect saved connections or query history.

​
Defaults via defaults write

Advanced flags not exposed in the UI:
SettingCommand
Custom plugin registrydefaults write com.TablePro com.TablePro.customRegistryURL <url>
Clear custom registrydefaults delete com.TablePro com.TablePro.customRegistryURL