MotionQL

Explore a feature in depth

Connections for 60+ databases

  • PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite, DuckDB, MongoDB, Redis and Valkey, Elasticsearch and OpenSearch, ClickHouse, Snowflake, BigQuery, Trino, Databricks, Spanner, DynamoDB, Cloud Firestore, Cassandra, InfluxDB, Neo4j, and any JDBC driver
  • Hosted services with their own dialogs: Supabase, Neon, RDS and Aurora, Azure SQL, Atlas, Elastic Cloud, Upstash, Astra and more
  • TLS with CA and client certificates; SSH tunnels with password or key, host-key pinning and jump hosts; SOCKS5 and HTTP proxies
  • Cloud sign-ins such as AWS IAM, Entra ID and OIDC where the database supports them
  • Import connections and saved queries from DBeaver, DataGrip, pgAdmin, MySQL Workbench, Azure Data Studio, Navicat, Compass and Studio 3T

Projects and environments

  • Group one application's databases of every engine into a project with Development, Test, Staging and Production
  • Production confirms every write, on every engine, enforced in the app's main process and written to the audit log
  • Read-only environments, colour stripes on tabs and a Project Home with pinned objects, saved queries and notes
  • Cross-database links: orders.customerId in MongoDB to customers.id in PostgreSQL, with a diagram and jump to related records
  • Export a project as a folder you can commit to Git, or share it with your team

SQL editor and table tools

  • SQL editor with schema-aware completion, a result tab per statement, pinned results and result compare
  • Per-tab sessions and manual transactions, with confirmations for DROP, TRUNCATE and unbounded DELETE or UPDATE
  • Visual SQL Query Builder that joins on foreign keys, and ER diagrams with a design mode
  • Table tab with WHERE / ORDER BY, editing by primary key, charts, and export to CSV, JSON, Excel, SQL INSERT or Markdown
  • Engine-specific tools: PostgreSQL roles, RLS and partitions, Oracle PL/SQL, ClickHouse merges, Snowflake warehouses, BigQuery cost guard

Logs, analytics and server insights

  • Logs & analytics for every family: the server's own log, slow operations grouped by shape and live metrics
  • PostgreSQL: EXPLAIN, pg_stat_statements, activity and locks, vacuum health and an index advisor
  • MySQL, MariaDB and TiDB: statement digests, processes, locks and deadlocks, waits and I/O
  • ClickHouse query log, Redis slow log and memory, Elasticsearch cluster health, Cassandra and InfluxDB panels
  • Ask AI on any panel: what to fix first, with the plan or statistics as context

Tools made for each NoSQL engine

  • Redis and Valkey: key browser by namespace, every data type, console, slow log, pub/sub and RDB analysis
  • Elasticsearch and OpenSearch: Discover with a time range, documents, console, mappings and index administration
  • DynamoDB scan, query and PartiQL; Cloud Firestore collections, typed edits, indexes and Security Rules; Cassandra rows and CQL; InfluxDB Flux and SQL with charts
  • Neo4j and Memgraph: Cypher console with a graph view, label browser and schema

MongoDB: collection tab and query builder

  • Filter, projection, sort, skip and limit in shell syntax, or build them visually
  • Tree, table and JSON views with a column picker and in-place editing
  • Collation, read and write concern, read preference, maxTimeMS and hint; cancel any query
  • Explain tab, plus a COLLSCAN warning badge on slow filters, without running the query
  • Document version history with one-click revert; copy as Extended JSON or shell
  • Split panes and tab groups with live results in every pane; Load all opens 50,000 documents in a few seconds

MongoDB: IntelliShell

  • mongosh-style commands with autocomplete, history, snippets, Query Assist and explain
  • Commands are parsed as literals, never eval'd, so nothing you paste can execute
  • Optional Script mode runs real JavaScript (variables, loops, functions) in a local QuickJS sandbox
  • Common helpers including rs.*, sh.*, db.aggregate and exact NumberLong math

MongoDB: aggregation editor

  • Stage-by-stage preview of the documents after every stage
  • Full operator library, options and templates
  • Convert any find into a pipeline in one click
  • AI pipeline debugging when you want it

MongoDB: SQL Query and Query Code

  • Read-only SELECT with joins, grouping and ordering, translated to MongoDB find or aggregate
  • Open and save .sql files
  • Generate code for mongo shell, Node.js, Python, Java, C#, PHP, Ruby, Go and Rust from deterministic templates

Import, export, compare and sync

  • CSV, JSON, JSON Lines, Excel and SQL INSERT for tables, collections, indices and keys, with column mapping and typing
  • Streamed jobs with progress and cancel; insert, upsert, replace and merge modes
  • MongoDB: copy collections, dump and restore, and Data Compare & Sync with dry-run preview
  • SQL schema and data compare between tables (Pro)

Migration and Data Masking

Pro
  • Move data between databases: SQL to MongoDB, Redis to MongoDB or SQL, and more, with type mapping and a dry run
  • SQL to MongoDB: choose reference or embed for each relationship, with preview and progress
  • Data Masking with eleven methods and a preview before anything is written
  • Reschema operations to restructure documents safely

MongoDB: schema and data model

  • Schema analysis with CSV, Markdown and HTML reports
  • Schema Compare & History: snapshots, drift, and validator, index and option diffs
  • ER diagrams inferred from field names, DBRefs, views and matching values; export to PNG, SVG, Mermaid and JSON
  • Value Search across databases and collections

MongoDB: administration and monitoring

  • Index management with hidden indexes, $indexStats usage, live build progress and Index Review
  • Live server monitoring from serverStatus, dbStats and top; running operations with kill, query profiler and topology view
  • Users and custom roles with a privilege inspector; edit users and change passwords
  • GridFS browser with previews and drag-and-drop upload; views, transactions with dry-run, change stream viewer, oplog history
  • In-use encryption: CSFLE and Queryable Encryption

MongoDB Atlas

Pro
  • Organizations, projects, clusters, database users and IP access lists
  • Pause and resume clusters
  • Create a connection from any cluster
  • Atlas Search and Vector Search index management

Tasks and dashboards

Pro
  • Schedule exports, imports, copies, compares, masking, migrations, dumps, scripts and snapshots
  • Once, interval, daily, weekly and cron schedules with a run log
  • A background runner keeps tasks going while the app is closed; run them from scripts with --cli
  • Dashboards with ten chart types on live query results, shared filters, present mode and PDF export
  • Share dashboards through the workspace folder or the Team Server

AI assistant

  • Gemini, Anthropic Claude, or any OpenAI-compatible endpoint including local models, with your own key
  • Natural language to SQL, MongoDB queries and pipelines, Cypher, Redis commands and search queries; explain plans; fix errors; index advice
  • Ask Your Database for natural-language lookups
  • Ask AI opens as a chat beside every table, collection, editor and panel; run its draft right there or put it in the editor
  • Fix with AI sends a failed query and its error into the same chat; backup Gemini models when Gemini is busy
  • Off for every connection until you allow it. Sends schema, never row or document values or credentials

Security and governance

  • Read-only, AI and server-side JavaScript policies enforced in the app's main process
  • Secrets encrypted with your OS keychain and never shown in the UI
  • Local audit log with credential redaction; app lock with idle timeout
  • Machine-wide policy.json for MDM and GPO, validated fail-closed

Team Server

Enterprise
  • Self-hosted, with OpenID Connect SSO (Okta, Entra ID, Google Workspace) and SCIM 2.0
  • Shared connections (never with secrets), queries, scripts, snippets and tasks with version history
  • Signed policies applied by every desktop as a floor, even offline
  • Hash-chained central audit log you can forward to your SIEM

Platforms

Your next query deserves a better IDE.

Create a free account, download MotionQL, and paste your Pro key. You'll be querying in under two minutes.