sqlkit

✨ Added

• DuckDB failure diagnosis and file-format reporting — DuckDB connection failures are translated into an explanation with the fix attached: file lock held by another process or connection, instance-configuration conflict, and storage-format incompatibility each get their own message, and the two lock cases offer retry as read-only inline in the connection form (the connecting modal shows the same explanation on connect). probe_database_file additionally reports the DuckDB storage-format version (header bytes 12..20, mapped to the oldest release that can open the file) and whether a sibling .wal write-ahead log is present, both shown under the file path.

• Create DuckDB / SQLite databases from the connection form — the file-based path field is editable again and gains New… / Open… actions backed by the native save dialog (extension appended automatically), an inline explanation of what will happen on connect (the engine creates a missing file, the file exists, is empty, is read-only, is a folder, is a different engine's file, or the parent folder is missing with a one-click "Create folder"), and a per-engine recent-files list with reveal/remove actions. DuckDB also gets the SQLite-style File / In-Memory tabs; in-memory connections are stored as named instances (memory:<label>) because unnamed DuckDB in-memory databases are private to a single connection and would otherwise give every pooled connection its own empty database. A new read-only access mode (access_mode=READ_ONLY) is meant to let DuckDB share a file with other processes (~ is expanded for file-based paths, and opening the same DuckDB file a second time with a conflicting access mode is blocked with "switch to that connection" / "open read-only" choices — read-only needs a bridge build with the HikariCP flag alignment below, and the form explains that until it ships). New Tauri commands: probe_database_file (existence, size, writability, header sniffing) and create_database_directory. scripts/verify-duckdb-jdbc-urls.sh records the DuckDB JDBC semantics these decisions rely on.

• Entitlements & version-lock subscription model (geekfun#56) — client-side implementation of the Ultimate entitlement contract: the two server-computed fields ultimateExpiresAt + versionLockHorizon are consumed via a new Rust entitlement module (persisted cache, offline tolerance, failure degradation, 5-minute refresh throttle, app.releaseDate <= versionLockHorizon unlock check). Rust command gates return ENTITLEMENT_REQUIRED for AI (agent loop/step, compaction, LLM validation), the whole Transfer module (import/export/migration/structure execution), SSH tunnel establishment, and the MCP bridge (config/policy save + auto-start). The frontend adds an entitlement store, Geekfun login entry, paid-feature gates with upgrade guidance on Data Studio, Transfer, AI assistant sidebar, ER diagram actions, AI/MCP settings, SSH tunnel option in the connection form, plus an Account & Plan settings tab showing the version-lock state with Geekfun login and logout (logout clears the local entitlement cache so entitlements never outlive the account session).

• Requesty provider preset in AI settings (OpenAI compatible, base URL https://router.requesty.ai/v1)

• Opper provider preset in AI settings (OpenAI compatible, base URL https://api.opper.ai/v3/compat)

• API Route provider preset in AI settings (OpenAI compatible, base URL https://global.api-route.com/v1)

• SSH tunnels for any connection — connect through a bastion, with multi-hop chains, reusable SSH profiles, an optional proxy hop, password or key auth (ED25519/RSA, optional passphrase), and trust-on-first-use host-key pinning plus an unpin command for when a server key changes.

• Cross-database browsing without reconnecting — table, column, index, foreign-key, view, routine and trigger panels can inspect any database on the server; PostgreSQL and SQL Server route through

See the assets to download this version and install.

👥 Contributors

• blankll (6 commits)

📋 Full Commit History

Changes from v0.8.7 to v0.8.8

• 9639ff5 release: v0.8.8 (blankll, 30 seconds ago)
• 80ed520 deps: bump data-studio-agent to v0.1.8 (blankll, 23 hours ago)
• fa28108 chore(deps): upgrade sqlparser 0.55 to 0.62 (blankll, 6 days ago)
• 162f939 fix(jdbc): execute statements via Statement.execute() instead of keyword sniffing (blankll, 6 days ago)
• b6433ac fix(queries): route WITH-prefixed statements through the query path on MySQL/SQLite (blankll, 6 days ago)
• 29fc28a fix(mcp): detect data-modifying WITH statements in read-only guard (blankll, 6 days ago)

📦 Downloads

See the assets below to download this version and install for your platform:

• macOS: Universal binary (Intel & Apple Silicon)
• Windows: x64 installer
• Linux: x64 AppImage/deb

Added

• DBA capabilities for session, slow-query, and privilege management (#138)

Fixed

• Use Pinia appStore as the single theme source for the editor (#137)

👥 Contributors

• VisionView (1 commit)
• blankll (1 commit)
• seven (2 commits)

📋 Full Commit History

Changes from v0.8.6 to v0.8.7

• ae02a06 release: v0.8.7 (blankll, 54 seconds ago)
• 3df8561 feat(sql): add session/slow-query/privilege DBA capabilities (#138) (seven, 2 days ago)
• 2f56ceb style: optimize the titlebar for Windows compatibility (#136) (VisionView, 5 days ago)
• 2e0d5df fix(theme): use Pinia appStore as single theme source for editor (#137) (seven, 5 days ago)

📦 Downloads

See the assets below to download this version and install for your platform:

• macOS: Universal binary (Intel & Apple Silicon)
• Windows: x64 installer
• Linux: x64 AppImage/deb

Added

• Guide agents to sqlkit tools for database access (#134)
• Advertise a discovery tool per connection in list_connections (#135)

Changed

• Bump data-studio-agent to v0.1.6

👥 Contributors

• blankll (3 commits)
• seven (2 commits)

📋 Full Commit History

Changes from v0.8.5 to v0.8.6

• ff7d5a5 release: v0.8.6 (blankll, 49 seconds ago)
• 2d73da5 deps: bump data-studio-agent to v0.1.6 (blankll, 5 minutes ago)
• a976db2 feat(mcp): advertise discovery tool per connection in list_connections (#135) (seven, 43 minutes ago)
• 7544574 chore: mcp description improvement (blankll, 19 hours ago)
• da9e2e9 feat(mcp): guide agents to sqlkit tools for database access (#134) (seven, 19 hours ago)

📦 Downloads

See the assets below to download this version and install for your platform:

• macOS: Universal binary (Intel & Apple Silicon)
• Windows: x64 installer
• Linux: x64 AppImage/deb