Features
Everything you need, for every database
One desktop app for SQL and NoSQL, from first connection to production migration. Here is all of it.
Explore a feature in depth
For every database
- Connections & security
- SQL editor & query builder
- Logs & analytics
- Projects & environments
- Cross-database links
- ER diagrams & design
- Notebooks
- Scripts folder & GitPro
- Table compare, backups & test data
- AI assistant & MCP server
- Import, export, dump & restore
- Migration between databasesPro
- Tasks, scheduling & CLIPro
- Charts & dashboards
- Test data generator
- Team & workspaceEnterprise
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
- macOS (Apple Silicon and Intel) and Windows, with Linux coming soon
- 60+ databases and hosted services: see the full list
- SHA-256 checksums with every release (installers are not yet code-signed)
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.