Skip to content
Skills Library
Data & analytics · Tool integration

tableplus

/tableplus

Expert TablePlus assistance covering relational/NoSQL GUI database management, SSH tunneling, query editing, schema migrations, and connection workspaces. Use when connecting to databases securely, executing SQL scripts, managing PostgreSQL/MySQL/Redis instances, or debugging queries.

Licence
MIT
Last repository change
01.10.2026

Assessment and security

100/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content35 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
1
Scripts
0
HTML comments
0
URLs in SKILL.md
1
Deprecation

No signals detected. Repository changed on 01.10.2026, without references to retired models or APIs.

Licence

MIT, open: use and modify while retaining author attribution.

What it does and when to use it

Expert TablePlus assistance covering relational/NoSQL GUI database management, SSH tunneling, query editing, schema migrations, and connection workspaces. Use when connecting to databases securely, executing SQL scripts, managing PostgreSQL/MySQL/Redis instances, or debugging queries.

Original author description

Expert TablePlus assistance covering relational/NoSQL GUI database management, SSH tunneling, query editing, schema migrations, and connection workspaces. Use when connecting to databases securely, executing SQL scripts, managing PostgreSQL/MySQL/Redis instances, or debugging queries.

How it works

  1. When to Use
  2. Quick Start
  3. Core Concepts
  4. Common Patterns
  5. Best Practices
  6. Troubleshooting
  7. References
Original SKILL.md headings · 128 lines, 651 words
SKILL.md preview
---
name: tableplus
description: Expert TablePlus assistance covering relational/NoSQL GUI database management, SSH tunneling, query editing, schema migrations, and connection workspaces. Use when connecting to databases securely, executing SQL scripts, managing PostgreSQL/MySQL/Redis instances, or debugging queries.
---

# TablePlus

TablePlus is a native app (Swift on Mac, C# on Windows) known for being incredibly **fast** and **lightweight**.

## When to Use

- **Native Multi-Database Administration**: Connecting to PostgreSQL, MySQL, Redis, SQLite, SQL Server, and Cassandra natively.
- **Secure Bastion & SSH Tunneling**: Querying internal production and staging databases through bastion jump-hosts securely.
- **Inline Table Data Editing**: Modifying column values, adding rows, and previewing generated SQL before committing changes.
- **Database Backup & Migration Inspection**: Dumping database schemas, restoring SQL snapshots, and reviewing pending migrations.

## Quick Start

### 1. Open Database via TablePlus CLI URL

```bash
# Connect directly to Postgres instance via connection string
tableplus "postgres://postgres:secret@localhost:5432/my_database"
```

### 2. Essential Shortcuts

```text
Cmd + T          - Open New SQL Tab
Cmd + Enter      - Run Current Statement
Cmd + Shift + E  - Run All Statements
Cmd + P          - Quick Open Table
Cmd + S          - Commit Staged Changes
```

## Core Concepts

### Bastion SSH Tunnel Connection Configuration

Connecting securely to an Amazon RDS PostgreSQL database via a private VPC jump-host:

```text
TablePlus Connection Settings:
- Driver: PostgreSQL
- Host: prod-db.internal.vpc (or 10.0.4.15)
- Port: 5432
- User: db_admin
- Database: production_v2
- Password: [SECURE_PASSWORD]

SSH Tunnel Tab:
- SSH Host: bastion.example.com
- SSH Port: 22
- SSH User: ec2-user
- Auth Method: SSH Key
- Private Key: ~/.ssh/bastion-id_ed25519
```

### TablePlus Connection URI Scheme

Opening database connections directly from terminal or scripts:

```bash
# Connect to local PostgreSQL
open "tableplus://postgres:password@localhost:5432/my_app_dev?statusColor=007AFF&env=local"

# Connect via custom connection string with SSH Tunnel parameters
open "postgresql://admin:secret@prod-db:5432/analytics?sslmode=require"
```

### Inline Data Modification & Commit Preview

- Double-click table in sidebar (e.g. `users`).
- Double-click any cell to modify values in-place (turns yellow to indicate uncommitted state).
- Press `Cmd + Shift + P` (or `Ctrl + Shift + P`) to **Preview SQL Changes**:
  ```sql
  UPDATE "users" SET "is_active" = TRUE WHERE "id" = '9b1deb4d-3b7d-4bad-9bdd-2b0d7b3dcb6d';
  ```
- Press `Cmd + S` (`Ctrl + S`) to execute and commit transaction atomically.

## Common Patterns

### Atomic Staged Edits Review

**Problem**: Review generated SQL statements before committing GUI cell modifications.  
**Solution**: Inspect the staged SQL script generated by TablePlus.

```sql
-- Generated review script in TablePlus (Cmd + Shift + D)
BEGIN;
UPDATE "public"."users" SET "status" = 'active' WHERE "id" = '42';
UPDATE "public"."orders" SET "processed" = true WHERE "user_id" = '42';
COMMIT;
```

### Redis Key Inspection & Scanning

**Problem**: Inspect Redis cache keys without blocking single-threaded Redis process.  
**Solution**: Run safe cursor scanning from TablePlus query workspace.

```bash
# TablePlus Redis Console execution
SCAN 0 MATCH session:* COUNT 100
```

## Best Practices

**Do**:

- Assign distinct Environment Colors (Red for Production, Orange for Staging, Green for Local) in connection settings.
- Enable **Safe Mode** on production database connections to enforce confirmation dialogs for `UPDATE` and `DELETE` queries.
- Authenticate bastion hosts using modern Ed25519 SSH keys with passphrase protection.
- Preview generated SQL (`Cmd+Shift+P`) before committing inline modifications to production tables.

**Don't**:

- Store plaintext production database passwords in unencrypted cloud backup profiles.
- Run unbounded queries (`SELECT * FROM logs`) on billion-row tables without `LIMIT` clauses.
- Share exported TablePlus connection files containing embedded private keys or passwords.

## Troubleshooting

| Error                                                              | Cause                                                       | Solution                                                                                       |
| ------------------------------------------------------------------ | ----------------------------------------------------------- | ---------------------------------------------------------------------------------------------- |
| `SSH Tunnel: Connection refused`                                   | Bastion host port 22 blocked or SSH key permissions invalid | Verify SSH key has `chmod 600` permissions and bastion security group permits inbound traffic. |
| `pq: SSL is required` when connecting to AWS RDS / Heroku Postgres | SSL mode disabled in connection settings                    | In TablePlus connection settings, set **SSL Mode** to `REQUIRED` or `VERIFY-CA`.               |
| Query output truncated or slow on large tables                     | Default limit fetching thousands of heavy columns           | Add explicit `LIMIT 100` to query or adjust row pagination limit in TablePlus preferences.     |

## References

- [TablePlus Documentation](https://tableplus.com/)

Versions

The database has no other skills named tableplus.

Database snapshot: 13.11.2026 · package version abe8875e86d6 (SHA-256 digest of the entire package)

Downloads in the last 30 days: 0 · ranking

Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.

Similar skills

  • 100database-design
    Database schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases. Use for designing schemas, writing migrations, or optimizing queries.
  • 95data-storage-migrations
    Use this capability for database schema design, SQL/NoSQL selection, migrations, indexing, query review, connection pooling, backups, object storage, event storage, data retention, and data lifecycle planning. Trigger on database, schema, migration, index, SQL, PostgreSQL,…
  • 100agent-database-expert
    Specialist subagent: Expert database architect and engineer for PostgreSQL, MongoDB, Redis, and all major databases. Use when designing schemas, optimizing queries, planning migrations, implementing caching, or troubleshooting database performance.
  • 100sql-toolkit
    Query, design, migrate, and optimize SQL databases. Use when working with SQLite, PostgreSQL, or MySQL — schema design, writing queries, creating migrations, indexing, backup/restore, and debugging slow queries. No ORMs required.
  • 100sql-expert
    Expert-level SQL database design, querying, optimization, and administration across PostgreSQL, MySQL, and SQL Server. Use when the user mentions database, PostgreSQL, MySQL, or query optimization, or when the task involves Database Design, Advanced Queries, Indexes and…
  • 90database-engineer
    Database architecture design, schema optimization, query performance tuning, and data migration. Handles PostgreSQL, MySQL, MongoDB, Redis. Use when user asks to design database, optimize queries, create migrations, or improve database performance. Do NOT use for frontend or application logic.

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.