List the live connection state of every configured database (postgres/redis/elasticsearch), including state, readOnly mode, last error, and next retry time.

Reload the databases.config.yml configuration file from disk, recreate connections, and reconnect.

Run a read-only SELECT query against a configured Postgres connection.

Run any SQL statement (INSERT/UPDATE/DELETE/DDL) against a configured Postgres connection. Blocked when that connection's own readOnly mode is enabled.

List all tables in the specified schema of a configured Postgres connection.

Describe the columns of a table in the specified schema of a configured Postgres connection.

List all database schemas.

List all views in the specified schema.

List all indexes for a given table in the specified schema.

List all triggers in the specified schema.

Get statistics for a given table in the specified schema, including table size, index size, and estimated row count.

List constraints (foreign keys, primary keys, check constraints) on a table in the specified schema.

Run EXPLAIN on a read-only SELECT query to analyze query performance.

Get active queries currently running on the server.

List all user-defined functions in the specified schema.

List all sequences in the specified schema.

Get metadata and size information about the current database.

Terminate an active query by PID. Blocked when that connection's own readOnly mode is enabled.

Run VACUUM ANALYZE on a table to clean dead tuples and update database statistics. Blocked when that connection's own readOnly mode is enabled.

List all materialized views in the specified schema.

Refresh a materialized view. Blocked when that connection's own readOnly mode is enabled.

Retrieve index usage statistics for all user tables in the specified schema.

Get active lock information from the database catalog.

Get the slowest SQL queries based on execution time from pg_stat_statements (if the extension is enabled).

Explain a query's execution plan simulating hypothetical indexes using the hypopg extension (if installed).

Get a comprehensive database health report (connections, buffer cache, invalid indexes, dead rows, and replication).

Get size statistics for the database and all tables/indexes in a schema.

Find indexes that have never been used (zero scans since last stats reset). Great for identifying candidates to DROP to save space and reduce write overhead.

Find redundant indexes where one index's leading columns are a subset of another, making the smaller one unnecessary.

Find queries that have been running longer than a given threshold in seconds.

Find tables that have high sequential scan counts relative to index scans, suggesting they might benefit from new indexes.

Estimate table and index bloat using pg_stat_user_tables statistics (dead tuples vs live tuples ratio). Returns tables where dead tuple ratio exceeds a threshold.

Get the value stored at a Redis key.

Set a Redis key to a value. Blocked when that connection's own readOnly mode is enabled.

Set multiple string keys to their values in a single command (e.g. for seeding test/sample data) — far more efficient than one redis_set call per key. Blocked when that connection's own readOnly mode is enabled.

Delete a Redis key. Blocked when that connection's own readOnly mode is enabled.

List Redis keys matching a glob pattern (e.g. 'user:*'). Capped at 1000 keys; result is truncated=true with a total count if there are more.

Get the remaining time to live (in seconds) of a Redis key, or -1 if it has none.

Get the value of a hash field.

Set the value of a hash field. Blocked when that connection's own readOnly mode is enabled.

Delete one or more hash fields. Blocked when that connection's own readOnly mode is enabled.

Get all fields and values of a hash.

Check if a hash field exists.

Add a member to a set. Blocked when that connection's own readOnly mode is enabled.

Remove a member from a set. Blocked when that connection's own readOnly mode is enabled.

Get all members of a set. Capped at 1000 members; result is truncated=true with a total count if there are more.

Check if a value is a member of a set.

Prepend a value to a list. Blocked when that connection's own readOnly mode is enabled.

Append a value to a list. Blocked when that connection's own readOnly mode is enabled.

Remove and return the first element of a list. Blocked when that connection's own readOnly mode is enabled.

Remove and return the last element of a list. Blocked when that connection's own readOnly mode is enabled.

Get a range of elements from a list. Capped at 1000 elements; result is truncated=true with a total count if there are more.

Get the length of a list.

Check key existence.

Set a key's time to live in seconds. Blocked when that connection's own readOnly mode is enabled.

Retrieve the internal data type of a key.

Increment the integer value of a key. Blocked when that connection's own readOnly mode is enabled.

Decrement the integer value of a key. Blocked when that connection's own readOnly mode is enabled.

Delete all keys from the current database. Blocked when that connection's own readOnly mode is enabled.

Get Elasticsearch cluster health: status (green/yellow/red), node count, and shard counts.

List all indices with document count, size, and health status.

Get stats (doc count, store size, segments) for a specific index.

Run a search query against an index using Elasticsearch Query DSL.

Count documents in an index matching a query (or all documents if no query is given).

Get a document by id from an index.

Index (create or overwrite) a document. Blocked when that connection's own readOnly mode is enabled.

Index (create or overwrite) multiple documents into one index in a single request via the Elasticsearch _bulk API (e.g. for seeding test/sample data) — far more efficient than one es_index_doc call per document. Reports per-document success/failure rather than aborting the whole batch on one bad document. Blocked when that connection's own readOnly mode is enabled.

Partially update a document by id. Blocked when that connection's own readOnly mode is enabled.

Delete a document by id. Blocked when that connection's own readOnly mode is enabled.

Delete all documents in an index matching a query. Blocked when that connection's own readOnly mode is enabled.

Run a read-only SELECT/SHOW/EXPLAIN query against a configured MySQL connection.

Run any SQL statement (INSERT/UPDATE/DELETE/DDL) against a configured MySQL connection. Blocked when readOnly mode is enabled.

List all databases on a MySQL connection.

List tables in a MySQL database.

List views in a MySQL database.

Show column definitions and metadata for a MySQL table.

Get the exact CREATE TABLE DDL statement for a MySQL table.

Get the exact CREATE VIEW DDL statement for a MySQL view.

Show all indexes for a specified MySQL table.

List triggers in a MySQL database.

List stored procedures and functions in a MySQL database.

List table constraints and foreign keys in a MySQL database.

Get size, row count estimates, and index sizes for tables in a MySQL database.

List currently running queries and processes in MySQL.

Kill a running query or connection thread by ID in MySQL. Blocked when readOnly mode is enabled.

Get the execution plan for a MySQL query.

Show server status variables in MySQL.

Analyze key distribution for a MySQL table. Blocked when readOnly mode is enabled.

List all databases in MongoDB.

List all collections in a MongoDB database.

Query documents from a MongoDB collection.

Find distinct values for a specified field in a MongoDB collection.

Run an aggregation pipeline on a MongoDB collection.

Count documents matching a filter in a MongoDB collection.

Insert a single document into a MongoDB collection. Blocked when readOnly mode is enabled.

Insert multiple documents into a MongoDB collection. Blocked when readOnly mode is enabled.

Update a single document matching filter in MongoDB. Blocked when readOnly mode is enabled.

Update multiple documents matching filter in MongoDB. Blocked when readOnly mode is enabled.

Delete a single document matching filter in MongoDB. Blocked when readOnly mode is enabled.

Delete multiple documents matching filter in MongoDB. Blocked when readOnly mode is enabled.