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.
- Author
- G1Joshi ↗
- Repository
- Agent-Skills ↗
- Licence
- MIT
- Last repository change
- 01.10.2026
Assessment and security
- Files in this package
- 1
- Scripts
- 0
- HTML comments
- 0
- URLs in SKILL.md
- 1
No signals detected. Repository changed on 01.10.2026, without references to retired models or APIs.
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
- When to Use
- Quick Start
- Core Concepts
- Common Patterns
- Best Practices
- Troubleshooting
- References
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.