Skip to content

DB Connect v3.0.0 — Redis support, Redshift IAM/SSH/EXPLAIN, DynamoDB cost visibility

Choose a tag to compare

View all tags
@shubhesh07 shubhesh07 released this 23 Aug 06:28
· 7 commits to main since this release
v3.0.0
8d5f654

What's new

DB Connect 3.0.0 adds a fifth engine — Redis — and a round of deep fixes and productivity work across Redshift, DynamoDB, MySQL/PostgreSQL, the MCP server, and the app shell.

Redis (new engine)

  • ✨ Connect with just host:port — standalone vs. cluster is detected automatically and the remaining cluster nodes are discovered; Sentinel profiles are supported too. TLS, ACL user/password, DB index, SSH tunnel (standalone).
  • ✨ Visual key browser — glob/prefix filter, type filter, keys grouped into a collapsible : tree with per-folder counts, Results · Scanned X / Total progress, Load more and Scan all across every cluster master.
  • ✨ Type-aware key editor — string (with Format JSON), hash, list, set, sorted set, stream (read-only); rename (works across cluster slots), TTL edit, delete with confirm; read-only connections block edits. Type a prefix or glob in the key header to get a full results table in the main pane.
  • ✨ Analyze pane — Overview (version, uptime, clients, memory, keys, ops/s, hit rate, per-primary-node table, memory/keys share per node), Database Analysis (sampled memory-by-TTL histogram with extrapolate/no-expiry toggles, top namespaces by memory or keys with data types), Slow Log across all masters.
  • ✨ Raw command console with history recall, and Redis MCP tools (redis_scan_keys, redis_get_key, redis_server_info, redis_run_command — read-only unless a write grant is active).

Redshift

  • ✨ SSH tunnel and IAM authentication (provisioned GetClusterCredentials or serverless GetCredentials via your AWS profile/SSO/default chain).
  • ✨ Dialect-aware autocomplete — Redshift/PostgreSQL get DISTKEY/SORTKEY/ENCODE, UNLOAD/COPY/VACUUM, LISTAGG, APPROXIMATE COUNT(DISTINCT), DATE_TRUNC/DATEADD, NVL, DECODE, CONVERT_TIMEZONE, JSON_EXTRACT_PATH_TEXT, REGEXP_*…; MySQL-only suggestions no longer appear.
  • ✨ Structured EXPLAIN — rows, cost and distribution strategy parsed; DS_BCAST_INNER, DS_DIST_BOTH, nested loops and ≥1M-row sequential scans flagged as expensive.
  • ✨ Queue vs execution time (WLM) in slow queries, Generate UNLOAD… / COPY… statement builders on any table, table health badges (unsorted % / skew) in the tree, Spectrum external schemas browsable.
  • 🐛 Schema selection now pins search_path and the query to the same connection — previously they could land on different pooled connections and unqualified names silently resolved against public.
  • 🐛 Export-as-INSERT emitted MySQL syntax for Redshift/PostgreSQL; TIMESTAMPTZ lost its offset; BEGIN/COMMIT/ROLLBACK silently auto-committed — all fixed or clearly reported.

DynamoDB

  • ✨ Per-query cost visibility — every Scan/Query/PartiQL shows Items returned · Items scanned · Efficiency · RCUs consumed, with a warning when DynamoDB stopped at its 1 MB page.
  • ✨ Load more pagination, strongly-consistent read toggle, and IAM Role / default credential chain auth in the connection form.
  • 🐛 Query and Get Item failed on every table with a numeric partition/sort key ("provided key element does not match the schema") — key values are now typed from the key schema.
  • 🐛 Removing an attribute in the item editor reported success but left it in place.

MySQL / PostgreSQL / all engines

  • 🛡️ Inline edit/delete is blocked when no primary key is known — the previous all-columns fallback combined with MySQL's LIMIT 1 could silently modify the wrong of two look-alike rows.
  • 🛡️ Credential encryption at rest for PostgreSQL and Redis passwords and all SSH secrets; transaction-safe table editor (batch apply is all-or-nothing); server-side production guard on every execute path including MCP.
  • 🐛 Connecting to a slow or unreachable server no longer freezes queries and health checks on every other open connection (global lock held across the dial).
  • 🐛 The health check skipped Redis, so auto-reconnect recycled the client mid-scan.

MCP server

  • 🐛 Enabling the server could show "Not running" forever with no explanation — bind/token failures were logged but never surfaced. The real reason (e.g. port 47823 already in use) is now shown.
  • ✨ Redis tools added; Redis connections appear in list_connections.

App shell & performance

  • ✨ Connections grouped by database engine in the sidebar (MySQL / PostgreSQL / DynamoDB / Redshift / Redis), with a one-click switch back to custom groups.
  • ✨ Design refresh — surface/semantic tokens, native macOS title strip, new Modal/ContextMenu/ConfirmDialog primitives (no more window.confirm), regrouped editor toolbar, running overlay with elapsed time and Cancel.
  • ⚡ Typing no longer re-renders the whole app; memoized grid rows; async history recording; concurrent schema loads; Monaco bundled locally (no CDN).

Downloads

Platform File
macOS (Intel + Apple Silicon, DMG) DBConnect-macOS-v3.0.0.dmg
macOS (zip) DBConnect-mac-v3.0.0.zip
Windows (installer) DBConnect-Windows-Setup-v3.0.0.exe
Windows (zip) DBConnect-Windows-v3.0.0.zip

macOS users: curl -fsSL https://github.com/shubhesh07/db-connect/releases/latest/download/install.sh | bash — or brew upgrade --cask db-connect.

SHA256

bcc626e944326953e475827bf598b264ad9a5313767e76d1d5a0483b023e93a3  DBConnect-mac.zip
bcc626e944326953e475827bf598b264ad9a5313767e76d1d5a0483b023e93a3  DBConnect-mac-v3.0.0.zip
f388b88a16adc697ae14b56ac48f02417ae2bc9b30efbcd754dda049c78ee649  DBConnect-macOS.dmg
f388b88a16adc697ae14b56ac48f02417ae2bc9b30efbcd754dda049c78ee649  DBConnect-macOS-v3.0.0.dmg
420f2cdd9786e9ad4e6f7314125e59871321c446d3f1d88ce1d8b576fb0dafb7  DBConnect-Windows-Setup.exe
420f2cdd9786e9ad4e6f7314125e59871321c446d3f1d88ce1d8b576fb0dafb7  DBConnect-Windows-Setup-v3.0.0.exe
1a3b35082917a4b6c199687f64e226f0bb77f932d15f2987027b358d9727478d  DBConnect-Windows.zip
1a3b35082917a4b6c199687f64e226f0bb77f932d15f2987027b358d9727478d  DBConnect-Windows-v3.0.0.zip
Assets 11
Loading