Db Gateway

Count documents matching a query

Create an alias for an index

Create a new index with optional settings and mappings

Delete an alias from an index

Delete a document by ID

Delete an index (WARNING: This permanently removes the index and all its data)

Get the health status of the ElasticSearch/OpenSearch cluster

Get basic information about the ElasticSearch/OpenSearch cluster

Get a document by its ID

Get detailed information about a specific index

Get the settings of an index

Get the mapping definition of an index

Index (create or update) a document

List all index aliases

List all indices in the ElasticSearch/OpenSearch cluster

Refresh an index to make recent changes searchable

Search for documents using Query DSL

Partially update an existing document

Increase the number of partitions for a topic (cannot decrease partitions)

Modify configuration settings for a Kafka topic

Create a new Kafka topic with specified partitions and replication factor

Delete a consumer group. Group must be inactive (no running consumers)

Delete a Kafka topic (WARNING: This permanently removes the topic and all its data)

Get detailed information about a consumer group including members and their assignments

Get detailed information about a Kafka topic including partitions, leaders, and replicas

Get Kafka cluster information including brokers, controller, and cluster ID

Get committed offsets for a consumer group on a specific topic

Get the most recent messages from a topic across all partitions

Read messages from a specific partition starting from a given offset

Get configuration settings for a Kafka topic (retention, cleanup policy, etc.)

Get offset information for each partition of a topic (current, high, low watermarks)

List all consumer groups in the Kafka cluster

List all topics in the Kafka cluster (excludes internal topics starting with __)

Produce a message to a Kafka topic (for testing purposes)

Reset consumer group offsets for reprocessing messages. Group must be inactive (no running consumers)

Search for messages by content (value contains search text). Scans from beginning of topic

Search for messages by key (exact match or contains). Scans from beginning of topic

Search for messages within a specific time range

Perform an aggregation pipeline on a MongoDB collection

Get statistics about a MongoDB collection (size, count, indexes, storage)

Count documents in a MongoDB collection matching an optional filter

Create an index on a specified MongoDB collection

Delete multiple documents from a MongoDB collection

Delete a single document from a MongoDB collection

Get distinct values for a field in a MongoDB collection

Drop a collection from a specified MongoDB database

Find multiple documents in a MongoDB collection

Find a single document in a MongoDB collection

Insert multiple documents into a MongoDB collection

Insert a single document into a MongoDB collection

List all collections in a specified MongoDB database

List all databases in MongoDB

List all indexes on a MongoDB collection

Update multiple documents in a MongoDB collection

Update a single document in a MongoDB collection

Describe the structure of a MySQL table

Execute multiple SQL queries sequentially on a single connection. Useful for running several queries at once. All queries share the same connection, so SET variables and temporary tables persist across queries. Returns an array of { query, result } pairs.

Execute SQL query on MySQL database

Get the execution plan for a SQL query (EXPLAIN)

Get CREATE TABLE statements for all tables in the current database

Get the CREATE TABLE statement for a specific MySQL table

Get all foreign key relationships between tables in the current database

Kill a MySQL connection/query by process ID

List all configured MySQL connections with their status (connected/disconnected)

List all databases the current user can see in MySQL

List all indexes on a specific MySQL table

Show all running queries and connections in MySQL (SHOW FULL PROCESSLIST)

Show MySQL server status variables (connections, queries, etc.)

Show all tables in the current MySQL database

Show MySQL server configuration variables

Get table statistics including row count, data size, and index size

Switch to a different MySQL database

Describe the structure of a PostgreSQL table

Execute multiple SQL queries sequentially on a single connection. Useful for running several queries at once. All queries share the same connection, so SET variables and temporary tables persist across queries. Returns an array of { query, result } pairs.

Execute SQL query on PostgreSQL database

Get the execution plan for a SQL query (EXPLAIN FORMAT JSON)

Get schema information for all tables in the current database (public schema)

Get the schema information for a specific PostgreSQL table

Get all foreign key relationships between tables in the current database

Terminate a PostgreSQL connection/query by PID (pg_terminate_backend)

List all configured PostgreSQL connections with their status (connected/disconnected)

List all databases the current user can see in PostgreSQL

List all indexes on a specific PostgreSQL table

Show all active queries and connections in PostgreSQL (pg_stat_activity)

Show PostgreSQL database statistics (connections, transactions, cache hits)

Show all tables in the current PostgreSQL database (public schema)

Show PostgreSQL server configuration variables (pg_settings)

Get table statistics including row count, size, and vacuum info

Switch to a different PostgreSQL database (reconnects)

Get the number of keys in the currently selected Redis database

Decrement the integer value of a key by one in Redis

Delete one or more keys from Redis

Set a key's time to live in seconds in Redis

Delete all keys of all Redis databases

Delete all keys of the currently selected Redis database

Get the value of a string key in Redis

Delete one or more hash fields from Redis

Get the value of a hash field in Redis

Get all fields and values of a hash in Redis

Set the string value of a hash field in Redis

Increment the integer value of a key by one in Redis

Get information and statistics about the Redis server

Find all keys matching the given pattern in Redis

List all configured Redis connections with their status (connected/disconnected)

Remove and get the first element in a list in Redis

Prepend one or multiple values to a list in Redis

Get a range of elements from a list in Redis

Publish a message to a Redis Pub/Sub channel and return the number of subscribers that received it

Remove and get the last element in a list in Redis

Append one or multiple values to a list in Redis

Add one or more members to a set in Redis

Incrementally iterate over Redis keys using cursor-based pagination (safer than KEYS for large datasets)

Set the string value of a key in Redis

Check if a member is a member of a set in Redis

Get all members of a set in Redis

Remove one or more members from a set in Redis

Subscribe to a Redis Pub/Sub channel for a fixed time window and return the messages received during that window (uses a dedicated subscriber connection)

Get the time to live for a key in Redis

Get the data type of a key in Redis (string, list, set, zset, hash, stream)

Add one or more members to a sorted set in Redis

Get a range of members from a sorted set in Redis

Remove one or more members from a sorted set in Redis

Run ANALYZE to update table statistics for query optimization

Cancel a running query by PID

Load data from S3 into a Redshift table using COPY command

Create a new schema in Redshift

Describe the structure of a Redshift table

Drop a schema from Redshift

Execute SQL query on Redshift database

Get Redshift cluster information (database, user, version)

Get disk usage information for tables

Get current table locks in Redshift

Get Redshift disk usage information. Shows top tables by size (Serverless/Provisioned) or node disk space (Provisioned only)

Get recent query history from STL_QUERY

Get execution plan for a specific query

Get currently running queries in Redshift

Get the CREATE TABLE statement for a Redshift table

Get constraints (PK, FK, UNIQUE) of a Redshift table

Get distribution style and distribution key of a Redshift table

Get column encoding/compression info of a Redshift table

Get sort keys of a Redshift table

Get table statistics (size, row count, skew, etc.)

Get groups that a user belongs to

Get WLM (Workload Management) configuration

Get current WLM queue state (queued, executing queries)

List all databases in Redshift cluster

List all groups in Redshift

List all schemas in the current Redshift database

List all users in Redshift

Show all tables in a Redshift schema

Truncate (empty) a Redshift table

Unload query results to S3 using UNLOAD command

Switch to a different Redshift database (reconnects)

Run VACUUM to reclaim space and/or re-sort rows