SQLSSH Features — Secure All-in-One Database Client & SSH Terminal

Cross-Platform

SQLSSH runs natively on every major platform. The same powerful feature set is available whether you're on a desktop workstation or a mobile device.

Windows

Standalone .exe with multi-window support and taskbar integration.

macOS

Native app optimized for Apple Silicon (M1/M2/M3/M4) and Intel CPUs.

Linux

Portable AppImage with Linux Secret Service API integration.

iOS

Full-featured app with FaceID and native Keychain integration for iPad and iPhone.

Android

Optimized interface with fingerprint unlock and Android Keystore encryption.

Supported Databases

SQLSSH natively connects to 11 database engines out of the box. Each engine has a dedicated driver with dialect-specific SQL optimizations, ensuring maximum compatibility and performance.

PostgreSQL

MySQL

Oracle DB

SQL Server (MSSQL)

SQLite

MariaDB

CockroachDB

YugabyteDB

Amazon Aurora PostgreSQL

Amazon Aurora MySQL

AWS Redshift

Engine-Aware Drivers: Each database engine uses a dedicated driver with custom SQL dialect handling — including Oracle SYS_GUID() auto-wrapping, Oracle TO_DATE formatting, MSSQL IDENTITY_INSERT toggling, and MySQL-specific routines support.

Connection Management

Create, edit, and organize database connections with a fully featured connection form that adapts to each database engine.

Connection Form

Name, host, port, database, username, and password fields
Port auto-fills based on selected database engine
SQLite: dedicated file path picker for local .db files
Oracle: Service Name / SID connection mode
Test Connection button to verify before saving
Edit existing connections with pre-filled form data

📸 connection_form.png

Connection Organization

Connection list with search and filter
Folder organization for grouping connections (Pro)
Color-coded database type badges
Quick connect action from connection card
Duplicate and delete connections
Free tier: max 2 connections / Pro: unlimited

📸 connections_list.png

SSL/TLS Encryption

Enable SSL/TLS toggle for encrypted database connections
SSL modes: require, verify-ca, verify-full
Custom CA certificate file path picker
Client certificate authentication support

📸 ssl_config.png

SSH Tunneling

SSH tunnel toggle with host, port, username fields
Auth methods: Password or Private Key
Private key source: File picker or saved Key Manager keys
Passphrase-protected key support
Jump Host / Bastion server (multi-hop) tunneling

📸 ssh_tunnel_config.png

Proxy Support

SOCKS5 Proxy — Route connections through a SOCKS5 proxy with optional username/password authentication
HTTP CONNECT Proxy — Use HTTP CONNECT tunnel for environments behind corporate proxies
Configurable proxy host, port, and credentials

SQL Editor

A professional-grade SQL code editor with syntax highlighting, multi-query execution, and engine-aware formatting tools.

Code Editor

Full SQL syntax highlighting with keyword coloring
Line numbers and code gutter
Multi-line query input with scrollable editor area
Monospace font (Fira Code) for code readability
Query editor auto-resizing for comfortable editing

📸 sql_editor.png

Query Execution

Run All — Execute the entire editor content
Run Selected — Execute only highlighted/selected SQL
Multi-statement execution (separated by semicolons)
Execution timer showing query duration
Row count display after successful execution
Error messages with line-level detail from the database

📸 query_execution.png

Editor Toolbar

Run / Run Selected buttons with keyboard shortcuts
Database context selector (switch active database)
Clear editor content
Copy query to clipboard
Format SQL (auto-format on execute option for Pro)
Toggle between SQL Editor and Visual Query Builder

📸 editor_toolbar.png

Multi-Tab Query Sessions

Open multiple independent query tabs
Each tab maintains its own editor content and results
Tab rename and reorder support
Close individual tabs or close all
Tabs persist across session within the workspace

📸 multi_tab_editor.png

Schema Browser

A comprehensive visual tree navigator for exploring your database structure. Browse databases, schemas, tables, columns, views, sequences, and routines — all from a collapsible sidebar panel.

Tree Navigation

Database Level: List all databases in the connection
Schema Level: Browse schemas within each database (public, dbo, custom schemas)
Category Folders: Tables, Views, Sequences, Routines — engine-aware visibility
Table Level: Expand to see columns with data types, PK/FK indicators
Lazy-loaded data — schemas, tables, and columns load on expand
Search/filter across the entire tree hierarchy
Scroll position preserved during refresh

📸 schema_browser_tree.png

Engine-Specific Objects

Each engine shows only the object types it supports:

Object Type	PG	MySQL	SQLite	MSSQL	Oracle
Tables	✓	✓	✓	✓	✓
Views	✓	✓	✓	✓	✓
Sequences	✓	—	—	✓	✓
Routines	✓	✓	—	✓	✓

Context Menu Actions

Right-click (long-press on mobile) on any schema object to access quick actions:

📂 Database

Create Schema (PG/MSSQL)
Refresh

📁 Schema

Create Table
Import Data
Export Schema
Refresh

🗃️ Table

SELECT * …
Insert Data
Create Column
Modify Table
Duplicate Table
Import Data
Export Data
Truncate Table
Drop Table

📊 Column

Modify Column
Duplicate Column
Drop Column

👁️ View

SELECT * …
Drop View

🔢 Sequence

Drop Sequence
Copy Name

⚙️ Routine

Drop Function/Procedure
Copy Name

Data Management

Create, modify, and manage database objects visually without writing raw DDL — SQLSSH generates the SQL for you.

Create Table

Visual table designer with column name, type, and constraints
Engine-specific data type dropdowns
Primary Key, Not Null, Unique, Default value configuration
SQL preview before execution

📸 create_table.png

Modify Table

Rename tables with dialect-specific ALTER statements
Add, modify, and drop columns
Modify column types and constraints
Duplicate column definitions

📸 modify_table.png

Insert Data

Form-based row insertion with field labels matching column names
Data type validation before insert
Null toggle per field
Generates INSERT INTO statement and executes

📸 insert_row.png

Duplicate Table

Clone table structure with a new name
Option to include existing data or structure only
Engine-specific CREATE TABLE AS / SELECT INTO generation

📸 duplicate_table.png

Import Data

Import CSV or JSON files directly into a table
File picker for selecting source file
Column mapping preview
Bulk INSERT generation for efficient loading

📸 import_data.png

Export Data & Schema

Export query results to CSV, JSON, or SQL INSERT format
Custom CSV delimiter (comma, semicolon, tab, pipe)
Include/exclude column headers option
Desktop: choose save folder, mobile: system share sheet
Export entire schema structure as SQL DDL

📸 export_dialog.png

Destructive Actions with Confirmation

All destructive DDL operations show a confirmation dialog with the exact SQL that will be executed:

Truncate Table — Remove all data while keeping the table structure
Drop Table — Permanently delete the table and all its data
Drop Column — Remove a specific column from a table
Drop View — Remove a view definition
Drop Sequence — Remove a sequence object
Drop Routine — Remove a function or stored procedure

Results & Data Grid

Examine query results in a fast, scrollable data grid with sorting, pagination, and instant data export.

Data Grid

High-performance scrollable table for large result sets
Column headers with data type indicators
Horizontal and vertical scroll for wide tables
Row count and execution time display
Cell value copy on tap
Null values highlighted distinctively

📸 data_grid.png

Pagination

Page-based navigation for large result sets
Configurable rows per page
Page dropdown selector for quick jumps
Previous / Next page buttons
Total rows indicator

📸 pagination.png

Interactive Charts

Bar Chart — Visualize categorical data distributions
Line Chart — Plot trends and time-series data
Pie Chart — Show proportional breakdowns
Customizable X-axis and Y-axis column selection
Toggle between data grid and chart view

📸 interactive_charts.png

Visual Query Builder

Build SELECT queries without writing SQL. Choose your schema, table, columns, filters, sorting, grouping, and limit — see the generated SQL in real time and execute with one click.

1

Select Schema

Pick from available schemas loaded from the connection.

2

Select Table

Choose a table from the selected schema.

3

Select Columns

Use filter chips to pick specific columns or leave empty for SELECT *.

4

Add Filters (WHERE)

Add conditions with column, operator (=, !=, >, <, LIKE, ILIKE, IN, IS NULL, IS NOT NULL), and value.

5

Order By

Select a column and direction (ASC/DESC) for result ordering.

6

Group By

Choose a column for aggregation grouping.

7

Limit & Execute

Set row limit, preview the generated SQL, and execute instantly.

📸 visual_query_builder.png

Query History & Snippets

Automatically track every executed query and save your most-used SQL commands as bookmarked snippets for instant reuse.

Query History

Auto-records the 50 most recent executed queries
Timestamp and database context for each entry
Tap to re-insert query into the editor
Swipe to delete individual history entries
Full query preview in expandable card

📸 query_history.png

Saved Queries (Bookmarks)

Bookmark queries to pin them permanently
Bookmarked items pinned at the top of the history list
Free tier: up to 10 saved queries
Pro tier: up to 500 saved queries
One-tap execution of saved queries

📸 saved_queries.png

SSH Terminal

A full interactive SSH command terminal built directly into the application. Run server commands, manage files, edit scripts, and monitor infrastructure without leaving SQLSSH.

Terminal Features

Full interactive Bash/Zsh/sh shell session
ANSI color support for colorful terminal output
Terminal resizing and scrollback buffer
Keyboard shortcuts for common operations
Copy/paste support from terminal output
Multiple concurrent SSH sessions

📸 ssh_terminal.png

SSH Client Manager

Save SSH client connection profiles (host, port, username)
Auth methods: Password, Private Key (file or Key Manager)
Passphrase-protected keys with secure storage
Jump Host / Bastion server for multi-hop SSH
SOCKS5 and HTTP CONNECT proxy routing
Quick connect from saved SSH client list
Edit, duplicate, and delete saved SSH profiles

📸 ssh_client_manager.png

SSH Key Manager

Store, import, and organize private SSH keys securely on-device. Keys are encrypted using the platform's secure enclave and never exposed as plaintext.

Import Keys — Import existing id_rsa, id_ed25519, or other PEM-format private keys from file
Create Keys — Generate new SSH key pairs directly in-app
Passphrase Support — Store passphrase-protected keys with encrypted passphrase storage
Key Selection — Reference saved keys when configuring SSH tunnels or SSH client profiles
Secure Storage — Keys stored in iOS Keychain / Android Keystore / Windows DPAPI
Delete Keys — Remove keys permanently from secure storage

📸 ssh_key_manager.png

Tunneling & Proxy

Access databases inside private subnets and behind firewalls using SSH bastion tunneling, jump hosts, and proxy servers.

SSH Bastion / Jump Host

Multi-hop SSH tunneling through a bastion server
First hop: App → Jump Host (public IP)
Second hop: Jump Host → Database Server (private VPC)
Independent auth for jump host and tunnel (Password or Key)
Full passphrase and Key Manager integration

📸 jump_host_config.png

SOCKS5 & HTTP Proxy

SOCKS5 proxy with optional authentication
HTTP CONNECT proxy for corporate environments
Configurable host, port, username, and password
Works in combination with SSL/TLS and SSH tunneling

📱 App

→

🔒 Proxy / Bastion

→

🗄️ Database

Security & Biometrics

SQLSSH is built with a local-first, zero-knowledge security architecture. Your credentials never leave your device unencrypted.

Biometric App Lock

FaceID — iOS/macOS biometric authentication
Fingerprint — Android/Windows biometric scanner
PIN Code — Fallback numeric passcode entry
Auto-lock on app minimize / background
Configurable lock timeout

📸 biometric_lock.png

Credential Encryption

AES-256 Encryption — All stored passwords and keys encrypted at rest
Hardware-Backed Storage — iOS Keychain, Android Keystore, Windows DPAPI
Zero-Knowledge — Credentials stored locally, never sent to servers
Direct IP Connection — No middleman proxy servers between app and database

Multi-Factor Authentication (MFA)

TOTP-Based MFA — Google Authenticator, Authy, or any TOTP app
QR Code Setup — Scan QR to enroll a new authenticator device
Recovery Codes — Backup recovery codes in case of device loss
MFA for Sync — Required MFA verification before resetting sync encryption password

Cloud Sync (E2EE)

Synchronize your connection profiles, query history, and SSH clients across all your devices with end-to-end encrypted cloud sync. Your data is encrypted locally before upload — we can never read your credentials.

How Sync Works

Master Password — Set a secret key used for AES-256 E2EE encryption
Data encrypted on-device before upload
Encrypted blob stored in secure cloud
Decrypted on-device upon download to other devices
Master password never transmitted — zero-knowledge architecture

📸 sync_setup.png

Synced Data

Database connection profiles (all fields including SSH tunnel config)
SSH client profiles
Saved query bookmarks
Connection folder organization

Sync Management

Change master password with OTP/MFA verification
Reset master password (re-encrypts from local data)
Force push local data to cloud
Pull latest data from cloud

Multi-Session Tabs

Open multiple database connections simultaneously in separate workspace tabs. Switch between different servers, databases, and query contexts instantly.

Tab Bar — Horizontal tab strip showing all open sessions
Independent Workspaces — Each tab has its own SQL editor, results grid, and schema browser
Quick Switch — Tap tabs to switch between sessions instantly
Close Tabs — Close individual sessions or close all
Session Persistence — Tabs maintain state (query text, results) until closed
Free tier: 1 session / Pro: up to 10 concurrent sessions

📸 multi_session_tabs.png

Themes & Settings

Customize your workspace appearance and behavior with premium themes, font settings, and advanced query configuration.

Themes

Free: Basic Light and Dark themes
Pro: 5 Premium Dark + 5 Premium Light themes
Real-time theme preview
Consistent theming across all screens

📸 theme_settings.png

Editor Settings

Configurable query timeout duration
Auto-format SQL on execute (Pro)
Editor font size customization
Default row limit per query

Localization

Multi-language support with localization provider
Translatable UI strings across the entire application
Language selection in Settings screen

Account & Profile

Manage your account, subscription, devices, and support tickets directly from the app.

Profile Management

View and update account email
Change password
Enable/disable Multi-Factor Authentication (MFA)
View subscription tier (Free / Pro)
Subscription management and upgrade

Device Management

View all logged-in devices
Device name, platform, and last active time
Revoke access from specific devices
Device limit based on subscription tier

Support & Roadmap

Submit support tickets directly from the app
View and track ticket status
Browse product roadmap and upcoming features
Feature request submissions

Upgrade to Pro

In-app upgrade flow
Feature comparison between Free and Pro tiers
Pricing: $4.99/month
All premium features unlocked instantly

Every Feature, Explained.