Skip to content

DB Connect v2.0.0

Choose a tag to compare

View all tags
@shubhesh07 shubhesh07 released this 23 May 11:40
· 20 commits to main since this release
v2.0.0
b218057

DB Connect v2.0.0

A major release adding production-grade performance monitoring, smarter SQL autocomplete, Redshift + DynamoDB performance panes, and safer production-environment guards — all without changing the fast, dependency-free desktop feel.

Install — macOS (no Apple Developer account required)

One-line install from any terminal:

curl -fsSL https://github.com/shubhesh07/db-connect/releases/latest/download/install.sh | bash

Why this works without code-signing: curl downloads do not get macOS quarantine flags, so Gatekeeper never blocks the app. No "damaged" or "unidentified developer" dialog.

Alternative — DMG: Download DBConnect-macOS-v2.0.0.dmg, open it, and double-click install-mac.sh. The script copies the app to /Applications and clears the quarantine flag with xattr -cr automatically.

Manual fallback: Right-click DBConnect.app → Open the first time. macOS will ask for confirmation once, then never again.

Install — Windows

Download DBConnect-Windows-Setup-v2.0.0.exe and run it. The installer is unsigned — Windows SmartScreen may show a "More info → Run anyway" prompt the first time.

Highlights

Performance Monitoring (MySQL)

  • Slow Queries tab — performance_schema digests with sortable columns, runtime row-limit selector, and a client-side filter that matches rendered values
  • Live Activity tab — PROCESSLIST joined to INNODB_TRX, with one-click Kill Query (uses KILL QUERY via CONNECTION_ADMIN)
  • Locks tab — three sub-views: Blocking tree, Locks, Wait time, with an audit-store lifecycle for kill events
  • Index Health tab — unused indexes, redundant indexes, table-scan hot spots; suggestion-to-draft to copy DROP INDEX statements straight into a new tab
  • "Where this query is fired from" drill-down — per slow-query digest, expand to see top user@host aggregations + recent raw samples with full SQL_TEXT

Performance Monitoring (Redshift)

  • Slow queries, live activity, lock waits from STV_* / STL_* system views
  • Same UI shell as MySQL — nothing new to learn

Performance Monitoring (DynamoDB) — native, no CloudWatch

  • Per-table read/write capacity, throttle counts, hot-partition signals, GSI status
  • Reads DescribeTable only; no CloudWatch dependency or extra IAM grants

Smarter SQL Autocomplete

  • Step-aware suggestions — different completions for statement-start, after SELECT, after FROM / JOIN, in WHERE, after a column reference (operators), inside GROUP BY / ORDER BY
  • FROM-clause scoping — WHERE order_ now suggests columns of order_details (the table in scope), not random tables containing "order_"
  • Cross-database completions — db. lists tables in that database; db.table. lists columns
  • MySQL keyword + function catalogues — SELECT, UPDATE, DELETE, COUNT(...), NOW(), CONCAT(...) with prefix-match boost
  • After-column operators — typing WHERE col suggests = != > < LIKE NOT LIKE IN BETWEEN IS NULL ... as snippets
  • Same-server cross-database querying — pick a target DB per tab without losing autocomplete

Production Safety

  • Tiered destructive-op confirmation — DROP / TRUNCATE require typing the connection name; DELETE / UPDATE / ALTER show a one-click confirm with full statement preview. Replaces the easy-to-dismiss browser confirm() prompt
  • Server-side query cancel — Stop now issues KILL QUERY <thread_id> on MySQL and PG_CANCEL_BACKEND($1) on Redshift, instead of just disconnecting the client
  • Audit trail — destructive actions and kill events recorded to local SQLite for later review
  • Configurable persistent query timeout with clear error messages

Editor and UI

  • Monaco theme follows app theme — light/dark/system, with runtime switching
  • Sortable columns in every Performance pane
  • Expandable cells for long SQL/lock data
  • Row-count footer + per-panel client-side filter
  • Improved results-grid filter — works correctly for queries with no derivable source table

Other

  • SQL VIEW create and inspect for MySQL and Redshift
  • Connection-layer security hardening for credential handling and DB clients
  • 17 merged PRs · 130+ new tests

Compatibility

  • macOS 11+ (Intel or Apple Silicon — universal binary)
  • Windows 10+ x64
  • MySQL 5.7 / 8.0 / 8.1
  • Amazon Redshift (PostgreSQL wire protocol)
  • DynamoDB (any region; access key / SSO profile / IAM role auth)

Upgrading from v1.0.0

No migration required. Local data (~/.querypilot/) is fully backward-compatible:

  • Encrypted connection profiles
  • Query history
  • Saved queries

Known limitations

  • The macOS app is unsigned. The recommended install paths (curl-pipe or the bundled install-mac.sh) bypass Gatekeeper without xattr knowledge.
  • The "Where this query is fired from" drill-down reads from events_statements_history_long (a rotating ~10k-row buffer) — digests that fired heavily 24h ago but are quiet now may show an empty state. Tip: raise performance_schema_events_statements_history_long_size if needed.

Acknowledgements

Built incrementally across PRs #2–#13 with extensive test coverage. Source: shubhesh07/querypilot.

Assets 12
Loading