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

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

DB Connect v2.4.0

What's new

• ✨ Full PostgreSQL support — DB Connect now supports MySQL, PostgreSQL, Amazon Redshift, and DynamoDB. PostgreSQL gets transactions (BEGIN/COMMIT/ROLLBACK + auto-commit), an index manager, table relations (outgoing + incoming foreign keys), a full Alter Table designer, CSV/SQL import, connection-string paste-to-parse, and EXPLAIN ANALYZE.
• ✨ PostgreSQL-native features with no MySQL equivalent — an extensions viewer/installer (pg_extension), custom ENUM types (creatable and selectable directly in the table designer), materialized views (create/refresh/drop), array column types (TYPE[]), sequences (list/create/restart/drop, including SERIAL-owned sequence detection), table bloat stats (dead-tuple % and last-vacuum time) with one-click VACUUM/ANALYZE, and read-only visibility into Row-Level Security policies and declarative table partitioning.
• 🐛 Fixed a cross-engine autocomplete bug — the query editor's suggestion provider only ever called MySQL's schema-loading functions regardless of which engine a tab was actually connected to, so PostgreSQL and Redshift tabs never fetched column/table data through that path. It also never told the editor to reopen the suggestion list once a lazy load finished, so the very first reference to any not-yet-loaded table showed an empty dropdown on any engine. Both are fixed — suggestions now load per-engine and reappear automatically as soon as the data is ready.
• 🐛 Fixed a broken EXPLAIN viewer — PostgreSQL and Redshift query plans were being run through MySQL's severity heuristics and always showed as a false "full table scan" warning, regardless of the actual plan. Postgres/Redshift's text-based plans now render correctly.

Downloads

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

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

SHA256

f5648baec39481f37b39583593c78d561af207d4a7ebb00745db1ae947a6c13e  DBConnect-mac.zip
f5648baec39481f37b39583593c78d561af207d4a7ebb00745db1ae947a6c13e  DBConnect-mac-v2.4.0.zip
c9c72fc0936ab7ada59fa7d104df499e38188fb39a8450726ef1aaf80093ea95  DBConnect-macOS.dmg
c9c72fc0936ab7ada59fa7d104df499e38188fb39a8450726ef1aaf80093ea95  DBConnect-macOS-v2.4.0.dmg
972a2697e910fadb2c7bcb29b491a8b5272f915e9ae1be1373743f2a9da1193a  DBConnect-Windows-Setup.exe
972a2697e910fadb2c7bcb29b491a8b5272f915e9ae1be1373743f2a9da1193a  DBConnect-Windows-Setup-v2.4.0.exe
d4ec0e653b6318505dd02d53dee7a960ef473c28bf0b5c1897c11b8cff5a95a4  DBConnect-Windows.zip
d4ec0e653b6318505dd02d53dee7a960ef473c28bf0b5c1897c11b8cff5a95a4  DBConnect-Windows-v2.4.0.zip

v2.3.0

What's new

🔐 MCP server security hardening — per-install bearer token, Host/Origin request validation (closes a DNS-rebinding / malicious-webpage localhost-probing gap), a connection allow-list replacing "every open connection is reachable via MCP," and per-connection time-bounded write grants replacing the global write toggle. Also fixed a SQL-injection-style bypass in run_query's Redshift schema parameter and a read-only classifier gap around SELECT ... INTO disguised writes.

✨ DynamoDB PartiQL query mode — write real SQL-like statements (SELECT * FROM "table" WHERE ...) instead of building filters through the GUI, via AWS's native PartiQL support. Context-aware autocomplete (table names only right after FROM/INTO; attributes learned per-table from key schema and prior results). Cmd/Ctrl+Enter to run.

🛡️ Production safety for PartiQL — destructive PartiQL (DELETE/UPDATE) on a production-tagged connection now routes through the same confirmation dialog as SQL writes.

🐛 Fixed — a null-vs-empty-array bug that could freeze the app when opening a DynamoDB table with no GSIs; MCP tool responses returning a bare JSON array (rejected by strict MCP clients); silent result truncation on large DynamoDB PartiQL queries (now shows a warning).

Downloads

Platform	File
macOS (Intel + Apple Silicon, universal)	DBConnect-macOS.dmg
macOS (portable ZIP)	DBConnect-mac.zip
Windows x64 (installer)	DBConnect-Windows-Setup.exe
Windows x64 (portable ZIP)	DBConnect-Windows.zip

Or via Homebrew: brew install --cask shubhesh07/db-connect/db-connect

SHA256

acdb909eea847cfba4cb70cea7ca929f0fe8c8101b332e0c92ab61ae286edd8e  DBConnect-macOS-v2.3.0.dmg
655356bda7922b2ae93fe704365534320a773af8d754f342bfcbeb6621c929c9  DBConnect-mac-v2.3.0.zip
a51b0cc24e89615e6df189f87c64d1a15bfe457e78a35a5491983895364a35d0  DBConnect-Windows-Setup-v2.3.0.exe
3cc470c9347e9abb915b373b17d2a4354e686ca6342b4eea2f4babbfa11c2e0a  DBConnect-Windows-v2.3.0.zip

v2.2.0

What's New in v2.2.0

DynamoDB fixes

• Results grid no longer guesses which table produced a scan/query — was slow and could lock onto the wrong table when key names collided
• "Get Item" mode now actually gets the item instead of silently running a scan/query
• Table-info load failures now show an error instead of failing silently

Smarter SQL autocomplete

• WHERE col=val now suggests AND/OR + the next column instead of re-offering comparison operators on an already-complete condition

Explorer & editor UX

• Tables/views grouped into collapsible Tables (N) / Views (N) folders with counts shown up front
• Drop Table.../Drop View... added to the table context menu — still goes through the existing production/read-only safety confirmation on Run
• In-toolbar data-source switcher — rebind a query tab to a different connection without the sidebar

Performance

• Fixed a bug causing the sidebar's expanded table tree to fully re-render on every keystroke while typing a query — this was the main cause of reported typing lag
• Dropping/creating/altering a table or view now refreshes the sidebar automatically; disconnecting a connection clears its cached schema so reconnecting shows current state

Local MCP server

• Now works with Redshift connections too (previously MySQL-only)
• New DynamoDB tools: list tables, describe table, scan, query, get item, plus write tools when "Allow writes" is enabled
• Still off by default, localhost-only, read-only by default

v2.1.0

What's New in v2.1.0

MySQL productivity suite

• Stored procedure/function/trigger/event visibility (list + view SHOW CREATE definitions)
• Real database backup/restore via mysqldump/mysql (not just app-config backup)
• Full MySQL user management: create/alter/drop user, grant/revoke privileges
• SHOW VARIABLES viewer, connection-string paste-to-parse, auto-update check
• Table Relations view (foreign keys in both directions)
• Saved/reusable result-grid filters
• CSV import field-mapper (remap/skip columns, insert-vs-upsert)

Local MCP server

• Lets local MCP clients (Claude Code, Cursor, etc.) query your open connections
• Off by default, localhost-only, read-only by default — toggle under Sidebar → "MCP Server"

Connection UI redesign

• Permanent connection rail (replaces the old dropdown), ⌘P fuzzy switcher
• Brand-stripe engine picker + redesigned three-section connection form

Fixes

• Query-timeout setting no longer gets silently overridden by a hardcoded socket timeout
• Several "X failed: undefined" toast messages now show the real error
• Smoother scrolling and paste handling in the results grid
• Closed an identifier-injection gap in the Create Table flow

DB Connect v2.0.0

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.

DB Connect v1.0.0

DB Connect v1.0.0

First public release — a fast, lightweight desktop database IDE.

Supported Databases

• MySQL — Full SQL, transactions, SSH tunnels, table designer, index manager
• Amazon Redshift — SQL queries, schema browser, EXPLAIN plans
• DynamoDB — Visual scan/query/GetItem builder, item editor, GSI support

Downloads

Platform	File
macOS (DMG)	DBConnect-macOS.dmg
macOS (ZIP)	DBConnect-mac.zip
Windows (Installer)	DBConnect-Windows-Setup.exe
Windows (Portable)	DBConnect-Windows.zip

macOS Note

On first launch, run: xattr -cr /Applications/DBConnect.app