Calíope tools — Calíope Help

SQL Editor Write, format and run SQL with syntax highlight, autocomplete and safe mode.

Dashboard Live server metrics: connections, QPS, memory and cache hit rate.

AI Assistant Turn natural language into SQL with the provider you choose; the cloud ones require your own API key.

Catalogs Browse tables, views, routines, triggers, events and indexes with live DDL.

Query Builder Assemble SELECTs with joins and filters visually, without writing SQL.

Server information Variables, status, version, engines and capabilities of the connected server.

Process list See and kill running queries on the server (SHOW PROCESSLIST).

SQL alerts Your own rules over SQL queries, warning when a value crosses its threshold.

Backup Selective backup of databases, tables and data with scheduling and retention.

User admin Create, edit and delete accounts; assign privileges at database or table level.

Table maintenance OPTIMIZE, ANALYZE, REPAIR and CHECK across one or many tables at once.

Data migration Copy tables, views, routines and triggers between servers with granular options.

ER Diagram Interactive entity-relationship diagram with drag, zoom and FK navigation.

Schema diff Diff between two databases: tables, columns, indexes and routines added or changed.

Replication monitor Replication status, lag and current errors.

Binlog viewer Explore binary log events with filters by date, database and operation type.

Snippets Library of reusable snippets (queries or commands), grouped by engine and synced.

Query log Local history of every executed SQL with times, rows and search filters.

Server health monitor Alerts and historical charts: hit rate, threads, throughput and response times.

SQLite Editor Open and edit local SQLite files: structure, data, SQL and pragmas, with no server.

DuckDB Editor Open local DuckDB files and explore their structure and data with analytical SQL, with no server.

File Previewer Read .md, .sql, .json, .csv and .log files read-only, with rendered Markdown and auto-refresh.

Error log What has gone wrong in the app, with its date, its device and what to do about it. Works offline.

Global search and replace Find text across every text column of a database and replace it in bulk, seeing how each row will look before anything is written.

Reports Save a query with its parameters and a defined output, then run it whenever you like: the same report gives the same result.

Replication topology A whole replication group at a glance: each member with its role, its lag and whether it answers.

Slow query log What the server recorded about the queries that went over its threshold, from every client that connects to it — with the controls to turn the log on, move the threshold and see where it is being written.

Website Opens the caliope.org page for Calíope users in the browser: what’s new, the Help, the DBA Handbook, the blog and a search across all three.

MongoDB collections Browse databases, collections and documents, and edit them as JSON.

MongoDB query Filter documents or run an aggregation pipeline.

MongoDB indexes Inspect, create and drop a collection’s indexes.

MongoDB server Server status, running operations, users and roles.

MongoDB commands Send a command to the server and see its response.

MongoDB profiler Which operations the server recorded for crossing the threshold, and what level each database’s profiler is at.

Key browser Browse keys by prefix with their type and TTL, and open each one to see its value.

Server panel Memory, hit rate, expired keys, clients and operations per second, with persistence and pub/sub.

Memory analyzer Walks every key, with a brake, and adds up the memory each prefix uses.

Slow commands The commands the server recorded for going over its threshold, with the two settings that govern the log.

Connected clients Every connection open on the server, what it is doing, and the option to disconnect it.

Command console Send a command to the server and see its response; the dangerous ones are refused.

Node topology Each node’s role, its replication lag in bytes and, in a cluster, which slots it serves.

CQL Query Runs CQL at the consistency you choose, page by page, with tracing and the server's warnings.

Keyspace explorer Keyspaces, tables, views, types and indexes in the schema, with their DDL and a sample of rows.

Cluster The nodes in the ring: data center, rack, status, version and token ownership.

Node The node you are connected to: settings, caches, thread pools, compactions and disk per table.

Connected clients Every connection open on the node: address, user, driver, protocol and TLS.

Traces and slow queries Traced sessions with their events, and what the server records as slow.

Roles and permissions The roles, which ones they belong to and which permissions they hold; create, grant and revoke.

Query Runs Query DSL, SQL and the product's own query language, with documents, a table and aggregations.

Indices Indices with their health, mapping, settings and shards; sample documents, aliases, templates and pipelines.

Cluster health Cluster health, its nodes, shard allocation and why a shard is left unassigned.

Node One node in detail: JVM heap, GC, CPU, disk, thread pools and hot threads.

Running tasks The tasks running on the cluster, parents and children, and cancelling the ones that allow it.

Snapshots Repositories and their snapshots, with state and failures; take a new one.

Users and roles Users, roles and role mappings; create and delete users, assign roles and manage API keys.