DB Gateway MCP Server

List all tables in DynamoDB

Get detailed information about a DynamoDB table

Create a new DynamoDB table

Delete a DynamoDB table (WARNING: This permanently removes the table and all its data)

Get an item from a DynamoDB table by its primary key

Create or replace an item in a DynamoDB table

Update an existing item in a DynamoDB table

Delete an item from a DynamoDB table

Query items from a DynamoDB table using key conditions

Scan all items in a DynamoDB table (use with caution on large tables)

Get multiple items from one or more DynamoDB tables in a single request

Put or delete multiple items in one or more DynamoDB tables

Perform multiple Put, Update, Delete, or ConditionCheck operations atomically across one or more tables

Get the health status of the ElasticSearch/OpenSearch cluster

Get basic information about the ElasticSearch/OpenSearch cluster

List all indices in the ElasticSearch/OpenSearch cluster

Get detailed information about a specific index

Get the mapping definition of an index

Get the settings of an index

Get a document by its ID

Search for documents using Query DSL

Count documents matching a query

Perform aggregations on documents

List all index aliases

Create a new index with optional settings and mappings

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

Refresh an index to make recent changes searchable

Index (create or update) a document

Partially update an existing document

Delete a document by ID

Perform bulk operations (index, update, delete) in a single request

Create an alias for an index

Delete an alias from an index

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

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

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

Create a new Kafka topic with specified partitions and replication factor

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

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

Modify configuration settings for a Kafka topic

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

List all consumer groups in the Kafka cluster

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

Get committed offsets for a consumer group on a specific topic

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

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

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

Read messages from a specific partition starting from a given offset

Get the most recent messages from a topic across all partitions

Search for messages within a specific time range

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

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

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

List all databases in MongoDB

List all collections in a specified MongoDB database

Drop a collection from a specified MongoDB database

Create an index on a specified MongoDB collection

Find a single document in a MongoDB collection

Find multiple documents in a MongoDB collection

Insert a single document into a MongoDB collection

Insert multiple documents into a MongoDB collection

Update a single document in a MongoDB collection

Update multiple documents in a MongoDB collection

Delete a single document from a MongoDB collection

Delete multiple documents from a MongoDB collection

Perform an aggregation pipeline on a MongoDB collection

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

List all indexes on a MongoDB collection

Count documents in a MongoDB collection matching an optional filter

Get distinct values for a field in a MongoDB collection

Execute SQL query on MySQL database

Show all tables in the current MySQL database

Describe the structure of a MySQL table

Switch to a different MySQL database

List all databases the current user can see in MySQL

Get the CREATE TABLE statement for a specific MySQL table

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

Get the execution plan for a SQL query (EXPLAIN)

List all indexes on a specific MySQL table

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

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

Show MySQL server configuration variables

Kill a MySQL connection/query by process ID

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

Get CREATE TABLE statements for all tables in the current database

Get all foreign key relationships between tables in the current database

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

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

Describe the structure of a PostgreSQL table

Switch to a different PostgreSQL database (reconnects)

List all databases the current user can see in PostgreSQL

Get the schema information for a specific PostgreSQL table

Show all active queries and connections in PostgreSQL (pg_stat_activity)

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

List all indexes on a specific PostgreSQL table

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

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

Show PostgreSQL server configuration variables (pg_settings)

Terminate a PostgreSQL connection/query by PID (pg_terminate_backend)