Changelog
What's new
Every release of the MotionQL desktop app and Team Server.
[1.7.1] — 2026-11-10
Changed
- Double-click a value to edit it right there. In a SQL table (every SQL database type), a double-click on a cell now opens a text box in the cell itself instead of a pop-up: Enter or clicking elsewhere keeps the value, Escape puts the old one back, and Apply saves the changes as before. Shift+Enter (or right-click → Edit value…) still opens the full editor for NULL, DEFAULT and SQL expressions; multi-line text and PostgreSQL arrays, ranges, enums and JSON open it on a double-click. In MongoDB's table and tree views, clicking elsewhere now saves a changed value too (it used to drop it), and in the tree a double-click anywhere in the value cell edits it, even an empty string. Read-only connections, views, history ("as of") rows and key columns stay read-only: a double-click opens no editor there.
[1.7.0] — 2026-11-10
Changed
- Ask AI opens in the same place on every screen, for every database type. Whatever you ask AI about (a table, a collection, the SQL editor, an aggregation, a plan, an index, a server panel) now opens in one Ask AI panel on the right of the tab, never on top of what you are looking at. Hiding the panel closes what is in it; AI help inside dialogs stays in the dialog.
- MongoDB collections get the Ask AI chat. The "AI Assistant" sub-tab is replaced by an Ask AI button that opens a chat beside the documents. It keeps the conversation until you hide it or close the tab. The queries it suggests can be run right away ("Run here") or put in the query bar. When a query fails or finds nothing, "Fix with AI" sends it and the error into the same chat. A failed query now shows in the view instead of a pop-up.
- Elasticsearch / OpenSearch documents lose their "AI Assistant" sub-tab the same way: Ask AI opens the panel on the right.
- The SQL editor's Ask AI is the same chat as a table's. The Write SQL / Fix error / Explain form is replaced by the chat, which keeps the conversation while the tab is open. Describe the query you want, or use "Explain my query" and "Make it faster" on the statement under the cursor. A draft can run right away ("Run here") or go into the editor ("Put in editor"); it replaces the selection, else it is added after your last statement, so nothing you typed is lost. "Ask AI to fix" and "Send the error of the last run" send the failed statement and its error into the same conversation.
- One Ask AI per screen. The Ask AI button in the top toolbar (and "Ask AI about this screen" in the command palette) now opens the Ask AI panel of the tab you are on (a table, collection, SQL editor, console, index or panel) instead of opening a separate Assistant tab. Tabs without their own Ask AI still open the Assistant tab.
[1.6.1] — 2026-11-09
Changed
- Updates are easier to see and install. Settings → Updates now has Download and Restart and install buttons, a progress bar and the release notes, instead of only saying a version is available. When MotionQL finds a new version it opens the details once by itself, and a version found from Settings shows in the toolbar straight away.
Added
- "Updated to X" notice. On the first launch after an update, MotionQL says which version you now have and what's new in it.
[1.6.0] — 2026-11-09
Changed
- Ask AI on a SQL table opens beside the rows. It is now a chat in a right-side panel, like the Query Builder, instead of replacing the table. The conversation stays with the tab until you hide the panel or close the tab, so you can follow up. A draft can run right there ("Run here"); when a run fails, "Fix with AI" (or "Send the error of the last run" in the chat) sends the query and its error into the same conversation.
- The Connections sidebar lists only the database types you have connections for. Empty sections such as Redis & Valkey, Elasticsearch or DynamoDB no longer take room; "+" at the top of the sidebar still adds any type. Settings → General → "Show database types without connections in the sidebar" brings them back.
[1.5.0] — 2026-11-08
Added
- Cloud Firestore and the Firestore emulator. Connect with gcloud credentials, Sign in with Google, a service account key or an access token, to any database of a project. Browse collections, subcollections and collection groups with a query builder, count, paging and a types summary; edit documents as typed JSON (timestamps, references, geopoints, bytes, vectors, server timestamps and increments) with set, merge and update, copy, move and delete with subcollections; a query console in the Firebase JavaScript SDK syntax with Explain; composite indexes, single-field exemptions and TTL policies; database settings, operations and Security Rules; JSON, JSON Lines and CSV import and export. Read-only and production modes work as for the other databases.
- AI on every Firestore screen: write, explain and fix queries, explain empty results, design composite indexes, advise on the data model and write or review Security Rules. Documents are never sent.
- One-click license activation. A
motionql://activatelink (the website's "Open in MotionQL" button) opens the app at Settings → License and asks you to confirm before it activates the key, whether the app was closed or already running.
Security
- Patched dependency advisories: dompurify (in the Monaco editor), follow-redirects, ip-address, @azure/msal-node and, in the team server, fast-uri.
npm auditreports no production vulnerabilities. - Electron 44.9.3 (eMudhra certificate mitigation).
[1.4.0] — 2026-11-05
Added
- Ask AI on Logs & Analytics and every remaining screen that did not have it yet.
- AI tools (MCP) for saved connections: create, change, test, open and delete saved connections.
- Last year and custom time ranges in monitoring and dashboards.
Changed
- Faster button tooltips: a themed tooltip appears after 300 ms (immediately when moving along a toolbar), including icon-only buttons.
- The macOS app is signed with a Developer ID and notarized by Apple, so it opens without a security warning. In-app updates are turned on for signed builds.
[1.3.0] — 2026-10-21
MotionQL is now an IDE for every database you run, not only MongoDB.
Added
- 60+ databases and hosted services. PostgreSQL and its family (Supabase, Neon, TimescaleDB, Citus, CockroachDB, YugabyteDB, Redshift and more), MySQL, MariaDB, Percona and TiDB, SQL Server and Azure SQL, Oracle and Autonomous Database, SQLite and DuckDB, Redis and Valkey, Elasticsearch and OpenSearch, ClickHouse, Snowflake, Google BigQuery, Trino and Starburst, Databricks SQL, Cloud Spanner, Amazon DynamoDB, Cassandra and ScyllaDB, InfluxDB, Neo4j and Memgraph, plus Db2, Firebird, H2, HSQLDB and Derby through a JDBC bridge. Each engine is rated Deep or Good in the app.
- Tools made for each engine. A Redis key browser, console and RDB analysis (Pro); Elasticsearch Discover, documents, console and administration; DynamoDB scan, query and PartiQL; Cassandra rows and CQL; InfluxDB Flux and SQL with charts; Cypher with a graph view for Neo4j and Memgraph.
- SQL editor for every SQL engine: schema-aware completion, a result tab per statement, pinned results and result compare, manual transactions with Commit and Rollback, and confirmations for risky statements.
- SQL Query Builder and ER diagrams with a design mode; tables join on their foreign keys.
- Server insights: PostgreSQL EXPLAIN, pg_stat_statements, activity and locks, vacuum health and an index advisor; MySQL digests, processes and deadlocks; ClickHouse query log, merges and storage; SQL Server, Oracle, Snowflake and BigQuery panels.
- Logs & analytics for every database: the server's own log, slow operations grouped by shape, live metrics, history from the database itself, storage growth, usage by client and local alerts.
- Projects and environments for every engine: Development, Test, Staging and Production, with Production confirming every write and read-only environments refusing them, enforced in the app's main process.
- Cross-database links: connect
orders.customerIdin MongoDB tocustomers.idin PostgreSQL or a Redis key pattern, see them in a diagram and jump to related records. - Scripts folder and Git version control (Pro), a PostgreSQL routine debugger (Pro), SQL schema and data compare (Pro), and Supabase and Neon branches (Pro).
- Test data for every engine and Load demo data for MongoDB, Redis and Elasticsearch connections.
- Migration between databases (Pro), with AI mapping suggestions in the import, export and migration wizards.
- AI for every database family: SQL, MQL, Cypher, CQL, Flux, Redis commands and search queries, checked against your schema before they are offered. Ask AI about any plan, panel or empty result.
- Paste a connection string from Vercel, Neon, Supabase, Prisma or Upstash and the dialog fills itself in.
- Import connections and saved queries from DBeaver, DataGrip, pgAdmin, MySQL Workbench, Azure Data Studio and Navicat, as well as Compass and Studio 3T.
Changed
- The theme follows your system by default.
- A visual and accessibility pass over every screen, in light and dark, down to 1024px windows.
[1.2.1] — 2026-10-06
Fixed
- AI with Gemini: masking rules, "Which fields are PII?", "Build dashboard" and "Explain indexes" now work (Gemini rejected their requests before). AI-built pipelines no longer fail when Gemini escapes
$in a stage. - AI backup models now take over when the main model hangs, not only when it returns an error, and Test connection names the model that actually answered.
- Query Builder: the sort reaches Explain and Query Code, Add Condition adds one row, and tab titles count per kind.
- Aggregation: field pickers list the collection's fields, including arrays for $unwind.
- Document history: dates show correctly, revert works, and the selected entry follows the theme.
- Compare & Sync: the sync preview is visible again.
- Collection lists refresh after a copy; the grid refreshes after a bulk edit and counts update after an insert.
- Data masking: number noise keeps the original decimals, and "Already exists" no longer shows after a write.
- Test data: values seen in arrays become choices for generated data.
- Create Index form layout, Index Review keeps its results across tab switches.
- Server Monitoring: memory is shown and the trend charts fit their cards.
- Dashboards: chart colours stay the same per category, and the chart editor and toolbar fit.
- Tasks: the editor background, the keychain notice and the Counts column.
- SQL Migration can use saved PostgreSQL and MySQL connections, including SSH tunnels.
- No more stray tooltips in the SQL editor and results grid.
[1.2.0] — 2026-10-05
Added
- Ask AI on nearly every screen: the chart editor and dashboard builder, profiler, server monitoring, index review, import, export, test data, bulk edit, value search, the document editor, roles, the task scheduler, the data model, schema compare, connection errors, the SQL editor, and "Ask AI about this screen" in the command palette. Each helper suggests something you then apply; nothing runs on its own, and every helper follows the connection's "Allow AI" policy.
- Gemini backup models: when Gemini is busy or rate-limited, MotionQL retries on a backup model and says which model answered (Settings → AI → Backup models).
Changed
- Help text and secondary panels stay hidden until you ask for them.
- Dialogs close with Escape and keep keyboard focus inside them.
Fixed
- The sidebar's Export and Import menu items now open the right tools.
[1.1.0] — 2026-10-04
Added
- SQL client for PostgreSQL, MySQL, MariaDB, SQL Server and Oracle: browse objects, run SQL, edit table rows.
- Split panes and tab groups, with live results in every pane.
- Real Server Monitoring (serverStatus, dbStats, top, server log) and a real explain with index suggestions in the visual Query Builder.
- Import connections from Compass, Studio 3T and Robo 3T.
- Edit users and change passwords; GridFS previews and drag-and-drop upload.
- Dashboards shared through the workspace folder or the Team Server.
- A guide to getting a free Gemini API key.
- Linux AppImage and deb packages.
Changed
- Every screen was redesigned to be more compact. Secondary panels (previews, stats, help, history, rarely used options) open and close with a button, and each screen remembers your choice. The sidebar can be hidden with Ctrl/Cmd+Alt+B.
- Faster results: the first rows no longer wait for the document count; opening a collection, filtering, paging, aggregations and saving an edit are 1.5–8× faster. Load all opens 50,000 documents in a few seconds.
- Lower memory: about 30% less RAM at idle and with a collection open; heavy parts load only when first used.
Fixed
- Selecting rows or opening Bulk Edit no longer blanks the window.
- Schema analysis averages and sample counts are correct; index usage dates are shown.
- A provider picked in AI settings no longer flips back to Gemini.
[1.0.1] — 2026-10-03
Fixed
- Gemini API keys with a dot (newer Google keys look like
AQ.…) are accepted, and spaces, line breaks, zero-width characters and quotes picked up when pasting a key are removed.
[1.0.0] — 2026-10-03
First general-availability release of the MotionQL desktop app for macOS (arm64, x64), Windows (x64) and Linux (x64), and of the self-hosted MotionQL Team Server.
Connections and authentication
- Connection Manager with folders, tags, colors and
dev/staging/prodenvironments (production warning banner), quick connect on Cmd/Ctrl+1–9, health indicator, duplicate, and export/import with secrets stripped or encrypted with a password. - Standalone, seed lists,
mongodb+srv, replica sets with read preference and tags, sharded clusters through mongos, direct and load-balanced connections, and Unix domain sockets. - TLS with CA and client certificate files; SSH tunnels with password or key authentication, host-key pinning and up to four jump hosts; SOCKS5 and HTTP proxies.
- Authentication: SCRAM-SHA-256/1, X.509, LDAP (PLAIN), Kerberos (GSSAPI), AWS IAM and OIDC (browser sign-in with PKCE, and workload identity for Azure, GCP and Kubernetes).
Querying and editing
- Collection tab: filter, projection, sort, skip and limit in shell syntax; collation, read/write concern, read preference,
maxTimeMSand hint; visual query builder; cancel; tree, table and JSON views with a column picker; in-place editing; copy as Extended JSON or shell; explain tab; find-to-aggregation conversion; a COLLSCAN / in-memory sort badge on filtered or sorted queries (checked with aqueryPlannerexplain that does not run the query), linking to the plan and Index Review; document version history with revert. - IntelliShell: mongosh-style commands parsed without executing JavaScript, with autocomplete, history, snippets, Query Assist and explain; optional Script mode runs JavaScript in a local QuickJS sandbox (can be turned off by policy). Script mode covers the common mongosh helpers, including
rs.*,sh.*,db.aggregate,coll.explain(), exactNumberLongmath and cursor read preference and read concern; the list of what works is in docs/SHELL_COMPATIBILITY.md. Number literals are typed as in mongosh: whole numbers outside the 32-bit range are stored as Double, not Long. - Aggregation editor with stage-by-stage preview, full operator library, options and templates.
- SQL Query: read-only
SELECTwith joins, grouping and ordering, translated to MongoDB queries;.sqlfiles. - Query Code for mongo shell, Node.js, Python, Java, C#, PHP, Ruby, Go and Rust from deterministic templates.
Data movement and transformation
- Import and export: JSON, JSON Lines, CSV, BSON, Excel and SQL
INSERT; column mapping and typing; insert, upsert, replace and merge modes; streamed jobs with progress and cancel. - Copy collections; dump and restore in mongodump layout with optional gzip, or as one
mongodump --archivefile that mongorestore reads (and MotionQL restores archives from mongodump, gzipped or not). - Data Compare & Sync with field-level diffs, dry-run preview, selective sync and conflict policies.
- SQL Migration from PostgreSQL, MySQL, MariaDB, SQL Server and Oracle, with reference/embed relationships, preview and progress.
- Data Model: ER diagrams of a database with fields, keys and relationships inferred from field names, DBRefs, views and matching values; editable layout, relationships, cardinality and notes; export to PNG, SVG, Mermaid and JSON.
- Schema analysis with CSV, Markdown and HTML reports; Reschema operations; Data Masking with eleven masking methods and preview.
Administration and monitoring
- Index management including hidden indexes, usage stats from
$indexStats, live build progress (per shard through mongos) and the shard key with the index that backs it; server monitoring; running operations with kill; query profiler; topology view. - Users and custom roles with a privilege inspector.
- GridFS browser; views; multi-operation transactions with dry-run and review modes; change stream viewer.
- MongoDB Atlas: organizations, projects, clusters, database users and access lists; pause/resume clusters; create connections from clusters.
- Scheduled tasks (export, import, copy, compare, reschema, masking, SQL migration, dump, restore, script, schema snapshot, index review, continuous sync) with once, interval, daily, weekly and cron schedules, missed-run policy and a run log; an optional background runner (launchd, Task Scheduler, systemd user timer) runs them while the app is closed, and a
--cliruns them from scripts. - Dashboards: charts, metrics, tables and notes on a drag-and-resize grid, backed by live aggregations with shared filters, auto refresh and
maxTimeMS. A chart editor with a live preview covers column, bar, stacked, line, area, pie, doughnut, scatter, radar and polar-area charts, date grouping (hour to year), series, colour palettes, legends, axis titles, number formats and value labels. Built-in and saved templates, one-click layouts, a present mode, and export to PNG, multi-page PDF (A4 or Letter, cut between widgets), per-widget PNG and CSV, and dashboard JSON.
AI assistant (optional)
- Google Gemini, Anthropic Claude (native, with a model picker), or any OpenAI-compatible endpoint, with the customer's own key (stored encrypted); offline mode.
- Natural language to find, aggregation and SQL; explain plans; fix errors; index advice; pipeline debugging; compare summaries; masking suggestions; schema questions; SQL Migration relationship suggestions.
- Off by default for every connection; sends schema-level context, not documents; suggestions are validated before display.
Security and governance
- Sandboxed, context-isolated renderer with strict CSP; IPC sender verification and allow-listed methods; Electron fuses and integrity-checked
app.asar. - Secrets encrypted with the OS keychain and never exposed to the UI.
- Per-connection read-only, AI and server-side JavaScript policies enforced in the main process, including
$out/$mergeand explain-wrapped writes; typed-name confirmation for drops. - Local audit log with credential redaction; app lock with idle timeout, OS-lock and sleep triggers.
- Enterprise
policy.jsonfor updates, Team Server URL and sign-in requirement, license deployment, crash-report control and machine-wide security restrictions (read-only hosts, AI, server-side JavaScript, Script mode, background tasks, idle lock), all validated fail-closed.
Team Server (self-hosted)
- OpenID Connect SSO with PKCE (Okta, Microsoft Entra ID, Google Workspace and other OIDC providers) and SCIM 2.0 provisioning.
- Org roles, teams and folder permissions; shared connections (never with secrets), queries, aggregations, shell and SQL scripts, snippets and tasks, with version history.
- Signed effective policies applied by desktops as a floor, including offline.
- Hash-chained, signed and verifiable audit log with desktop event forwarding, export and SIEM forwarding (webhook, syslog over TLS).
- PostgreSQL or SQLite; Docker image running non-root on a read-only filesystem; CLI for keys, audit, users and SCIM tokens.
- Optional read-only web viewer (
MOTIONQL_WEB_VIEWER=true) at/web/: shared items with version history, team policy, and the audit log with filters, verification and export, behind the same SSO and roles. Its sessions are read-only on the server.
Platform
- Settings, rebindable keyboard shortcuts and a command palette; light and dark themes; accessibility improvements.
- Auto-update over HTTPS with signature verification, stable and beta channels, no downgrades, and enterprise controls; installers and updates are published to the public motionql-releases repository.
- 14-day trial and offline Ed25519-signed license keys, cancelled through the signed product manifest (
revokedLicenses); links to motionql.com to get, renew or upgrade a key; first-run EULA acceptance. - Opt-in crash reporting and a redacted diagnostics export.
- Signed and notarized builds with SHA-256 checksums, a CycloneDX SBOM and build-provenance attestations; third-party notices.
Known limitations
- No
.pkg(macOS) package; no Windows on Arm or Linux arm64 builds. - IBM Db2, SAP ASE and SQLite are not supported as SQL Migration sources.
- Map-Reduce is intentionally not supported.
- The Team Server web viewer is read-only; administration is through the desktop app, API and CLI.