MotionQL
Logs & analytics

Your database's logs, slow queries and metrics, in one tab

One read-only tab per connection that reads the server's own log, metrics, slow operations and live activity, groups slow queries by shape, charts history the server already keeps, and raises alerts while you work.

MotionQL's Logs & analytics tab with live charts, slow operations grouped by shape and a log viewer

Overview tiles and live charts, slow operations by shape, and the server log, over the connection already open.

Watch

Projects, production guards and insights

Group every engine into a project, watch Production ask before a write, then Logs & analytics, pg_stat_statements and the ClickHouse query log.

Capabilities

What you can do with it

One tab, every engine

MongoDB getLog and system.profile, pg_stat_statements and PostgreSQL log files, MySQL performance_schema and slow_log, SQL Server error and Agent logs, Oracle's alert log, ClickHouse query_log, Redis SLOWLOG, Elasticsearch tasks and many more.

Slow operations by shape

Calls, total, mean and p95 time and share of time per query shape, so the one query that costs the most stands out.

A log viewer that groups

Severity and text filters, similar-message grouping, a severity-over-time chart and CSV or JSON export.

History from the database itself

Live, 1 h, 6 h, 24 h, 7 d or 30 d from what the server already keeps: Atlas measurements, Query Store, AWR, query history, CloudWatch and more. Where a server keeps nothing, record history on this computer.

Storage and usage

Table and collection sizes with growth per day, unused indexes first, and usage by user, client, application or database.

Alerts while you work

A metric above or below a threshold for N minutes, errors in the log or slow operations, checked on this computer with system notifications.

Read-only, always

It never changes anything on the server. Where a server does not expose something, the section says why and what would enable it.

Related features

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.