Skip to content

Releases: developer82/Spiral

Spiral 1.0.1

25 Jun 18:40
@developer82 developer82
1.0.1
e4da09e

Choose a tag to compare

View all tags
Spiral 1.0.1 Latest
Latest

Spiral v1.0.1 🌀

A small update adding finer control over the Explorer connection list.

🔍 Explorer

  • Connection status filter — the connection list filter panel (sliders icon) now has a Status section with two options:

    • Online — show only currently connected connections.
    • Offline — show only connections that are not connected (disconnected, connecting, or error).

    The options are mutually exclusive: selecting one deselects the other, and clicking the already-selected option clears it to show all connections regardless of state. Status is combined (ANDed) with the existing Provider and Environment filters.

  • Sort by connection status — the sort panel gains a Status option that groups the connection list into Online and Offline sections.

  • Reorder tabs by drag-and-drop — drag any editor tab onto another to drop it at that position; the dragged tab dims and the drop target shows a colored indicator on its left edge. Reordering doesn't change which tab is active or open.

  • Duplicate a connection — right-click any saved connection and choose Duplicate to clone all of its settings into a new connection. A small dialog asks for the new name (pre-filled with "«name» - Copy"); confirming adds the copy to the list instantly, carrying over the host, port, credentials, and every provider-specific option of the original.

🔌 Connections

  • Enter Password on connect — opening a connection whose password isn't saved now prompts for credentials instead of silently failing. The Enter Password dialog pre-fills the username when one is stored (otherwise you can type it), takes the password, and connects with the entered credentials. Tick Remember password to save it (encrypted) so future connects skip the prompt. SQLite connections — which have no authentication — never prompt, and background auto-connect on startup stays silent.

  • PostgreSQL SSL / TLS — the connection dialog now has an SSL Mode dropdown for Postgres connections (disable, allow, prefer, require, verify-ca, verify-full), matching the standard PostgreSQL sslmode parameter. For the verify modes you can point at a CA certificate file (with a Browse… picker), and any encrypted mode accepts an optional Server Name (SNI). New connections default to prefer, so encryption is used automatically when the server supports it. This fixes the no pg_hba.conf entry for host … no encryption error when connecting to managed Postgres services such as Aiven, Heroku, Supabase, Neon, and Amazon RDS that require SSL.

🧭 Navigation

  • Profile in the title bar — when the side navigation bar is hidden, the user profile button now moves up to the title bar instead of disappearing. On Windows and Linux it sits just left of the window control buttons; on macOS it sits just left of the Spiral logo. Click it to jump straight to User Profile settings.

⚙️ Settings

  • Show Grid Lines moved from Appearance to Results View Config → Table Options, and fixed — the toggle now actually draws row/column borders in the Query Results table (it previously had no effect). The lines also use a stronger, more visible color across all themes.

Thanks for using Spiral! 🙌

Assets 11
Loading

Spiral 1.0.0

23 Jun 13:29
@developer82 developer82
1.0.0
07c86f4

Choose a tag to compare

View all tags
Spiral 1.0.0

Spiral v1.0.0 🌀

The first public release of Spiral — a cross-platform desktop database client and administration tool for SQL and NoSQL databases. Connect, explore, query, compare, and administer your databases from a single fast, modern app.

Spiral runs on Windows, macOS, and Linux.

✨ Highlights

  • Six database engines, one client — SQL Server, MySQL, PostgreSQL, SQLite, MongoDB, and Redis.
  • Local AI query generator — generate SQL from natural language, running entirely on your machine. No data leaves your computer.
  • Visual schema comparison & sync — diff two databases and generate (or run) a sync script, with optional revert scripts.
  • Interactive ERD, execution plans, and client statistics — understand your schema and queries visually.
  • Full user & security management across every supported engine.
  • Backup & restore for all six engines.

🗄️ Database Support

  • SQL Server — SQL/Windows/Entra auth, server & database user management, server roles, native backup/restore with an SSMS-style dialog and server-side file browser.
  • MySQL — user@host user management (server & database level), backup/restore via mysqldump/mysql with a pure-JS fallback.
  • PostgreSQL — backup/restore via pg_dump/pg_restore/psql (Plain, Custom, Tar, Directory formats).
  • SQLite — single-file backup (VACUUM + gzip) and safe restore with integrity checks and pre-restore snapshots.
  • MongoDB — URI or structured connections, full auth (SCRAM, X.509, Kerberos, LDAP, AWS IAM), TLS, SSH tunneling, collection & document editing, aggregations, user management, mongodump/mongorestore with JS EJSON fallback.
  • Redis — standalone/cluster/sentinel, ACL user management, live server dashboard, key/value Database Explorer with namespace grouping, lossless DUMP-based backup/restore.

All connections support SSH tunneling and TLS/SSL where applicable.

🔍 Explorer

  • Lazy-loaded, cached object tree down to columns, keys, constraints, triggers, indexes, statistics.
  • Connection list with search, filter, and sort.
  • Environments with color coding and query-safety guards for production.
  • Create/edit tables, views, stored procedures, functions, and types.
  • Mini-ERD visual query builder that auto-generates JOINs from foreign keys.

⚡ Query Editor

  • Monaco editor with SQL formatting.
  • Execution Plan — graphical SSMS-style operator tree with cost bars, hover stats, minimap.
  • Client Statistics — time, query profile, and network metrics.
  • Optional auto-include of plans/statistics on every run.
  • Export results to CSV and JSON (nested-object output for dotted column names).

🤖 Local AI Assistant

  • Powered by SQLCoder 7B via node-llama-cpp — nothing sent to external servers.
  • Model downloaded on first use (verified, cancellable); not bundled.
  • Reads your schema automatically, streams responses, inserts SQL straight into the editor.
  • Available for all SQL providers.

🧩 Smart Execution Documentation (SED)

Annotate long-running scripts with markdown checklist comments and run them as a live task list — per-task status, resume-on-error, optional confetti on success.

🔀 Compare

  • Create, save, and run schema comparisons between two connections/databases.
  • Covers tables, columns, keys, constraints, indexes, triggers, views, procedures, functions, users, roles, schemas, and row-level data.
  • Create Script, Sync All, and per-finding Sync — with Swap direction toggle and optional revert scripts.
  • Export full reports to JSON with an opt-in secrets prompt.

🎨 Experience

  • Section-card layout, resizable panels, platform-aware styling (native-feeling macOS toolbars).
  • i18n — English and Hebrew with full RTL.
  • Tips & Tricks ambient notifications.
  • User profiles with avatar, display name, password protection, auto-lock.
  • Automatic updates with in-app release notes.

🔒 Privacy

  • AI runs 100% locally.
  • Anonymous analytics guide development — no connection details, credentials, query text, or result data are ever collected — and can be disabled in Settings → General → Usage Analytics.

📦 Installation

  • Windows — .exe installer
  • macOS — .dmg (Intel & Apple Silicon)
  • Linux — .AppImage, .deb, .rpm

Thanks for trying Spiral. Feedback and bug reports welcome! 🙌

Loading