Calíope tools

Visual catalog of every tool available in the main toolbar.

Where it is: Workspace › Tools › Main toolbar

• 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 Master/slave replication status, lag and current errors.
• Binlog viewer Explore binary log events with filters by date, database and operation type.
• Snippets Library of reusable SQL fragments, 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.
• 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: the primary with its binlog, and each replica with its lag and its two threads.
• 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.
• 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.

Keywords: catalog, tools, toolbar, index, features