​

Database Terminal

TablePro includes an embedded terminal that auto-launches the appropriate database CLI tool for your active connection. Instead of switching to a separate terminal app, you get a native terminal right inside the database client.

​

Opening the Terminal

• Menu: View > Open Terminal
• Keyboard shortcut: `Ctrl+Cmd+“

The terminal automatically detects which CLI tool to use based on the connection type and launches it with the correct host, port, username, and database arguments.

​

Supported Databases

If the CLI tool is not installed, TablePro shows an error with the install command.

​

SSH Tunnel Support

For SSH-tunneled connections, TablePro uses a two-step strategy:

1. Local CLI via tunnel (preferred): Runs the CLI on your Mac, connecting through the existing SSH tunnel (localhost:tunnelPort). Works with Docker and containerized databases where the CLI isn’t installed on the remote host.
2. Remote CLI via SSH (fallback): If the CLI isn’t installed locally, SSHs into the remote host and runs the CLI there.

SSH remote mode supports:

• Inline SSH configuration
• SSH profiles (uses the resolved snapshot)
• Private key authentication
• Jump hosts (multi-hop tunnels)

Password-based authentication for the database is passed through environment variables, keeping it out of the process argument list.

​

Docker and Container Support

When the database runs inside a Docker container on the SSH host, the local CLI approach works automatically. The SSH tunnel forwards to the container’s exposed port, and the CLI on your Mac connects through it. No need for docker exec or installing CLI tools on the Docker host. Requirement: The CLI tool must be installed on your Mac (e.g., brew install mariadb for MariaDB).

​

Settings

Open Settings > Terminal to customize:

​

Display

• Font: Choose from system monospace fonts (Menlo, SF Mono, Monaco, Courier New, JetBrains Mono)
• Font size: 9 to 24 points (default: 13)
• Cursor style: Block, bar, or underline
• Cursor blink: Enable or disable cursor blinking
• Scrollback lines: 1,000 to 50,000, or unlimited
• Option as Meta: Use the Option key as Meta for terminal shortcuts like Alt+B (word back) and Alt+F (word forward)

​

Theme

Pick from 300+ built-in terminal themes. Color swatches preview the background, foreground, and cursor colors for each theme.

​

CLI Paths

Override the auto-detected CLI path for any database type. Useful when you have multiple versions installed or the CLI is in a non-standard location. Leave empty to auto-detect from system PATH and common Homebrew locations.

​

Notifications

• Terminal bell: Enable or disable the terminal bell sound

​

Context Menu

Right-click inside the terminal for:

• Copy (Cmd+C)
• Paste (Cmd+V)
• Select All (Cmd+A)

​

Connection Handling

• The terminal connects when the tab opens and disconnects when you close the tab
• If the CLI process exits, a “Disconnected” view appears with the exit code and a Reconnect button
• Pressing Enter on the disconnected view reconnects
• The terminal uses the active database from your current session, not just the connection default
• Terminal tabs persist across app restarts and auto-reconnect on launch

​

Keyboard Shortcuts

Settings changes (font, theme, cursor style) apply immediately to all open terminals without reconnecting.

​

Known Limitations

• No Cmd+F search: Scrollback search is not available in the embedded terminal. Use Ctrl+R for readline reverse search or pipe output through grep.
• Oracle passwords: Oracle’s sqlplus requires the password in the connect string (no environment variable support). The password may be visible in process listings.