Schema | DB Gateway MCP Server

DB Gateway MCP Server

Describes the environment variables required to run the server.

Name	Required	Description	Default
`DBS`	Yes	Comma-separated list of enabled engines (e.g., 'mysql,redis'). Required to determine which tools to register.
`KAFKA`	No	Kafka connection string(s). Alias is required. Multiple instances separated by semicolons.
`MYSQL`	No	MySQL connection string(s). Alias is required. Multiple instances separated by semicolons.
`REDIS`	No	Redis connection string(s). Alias is required. Multiple instances separated by semicolons.
`MONGODB`	No	MongoDB connection string(s). Alias is required. Multiple instances separated by semicolons.
`REDSHIFT`	No	Redshift connection string(s). Alias is required. Multiple instances separated by semicolons.
`READ_ONLY`	No	Set to 'true' to hide write tools and restrict queries to SELECT statements.	false
`POSTGRESQL`	No	PostgreSQL connection string(s). Alias is required. Multiple instances separated by semicolons.
`ELASTICSEARCH`	No	Elasticsearch connection string(s). Alias is required. Multiple instances separated by semicolons.
`DYNAMODB_REGION`	No	AWS region for DynamoDB.
`DYNAMODB_ACCESS_KEY_ID`	No	AWS access key ID for DynamoDB.
`DYNAMODB_SECRET_ACCESS_KEY`	No	AWS secret access key for DynamoDB.

Features and capabilities supported by this server

Capability	Details
`tools`	{}

Functions exposed to the LLM to take actions

Name	Description
mysql_execute_queryC	Execute SQL query on MySQL database
mysql_show_tablesA	Show all tables in the current MySQL database
mysql_describe_tableB	Describe the structure of a MySQL table
mysql_use_databaseC	Switch to a different MySQL database
mysql_list_databasesB	List all databases the current user can see in MySQL
mysql_get_schemaB	Get the CREATE TABLE statement for a specific MySQL table
mysql_show_processlistC	Show all running queries and connections in MySQL (SHOW FULL PROCESSLIST)
mysql_explain_queryA	Get the execution plan for a SQL query (EXPLAIN)
mysql_list_indexesA	List all indexes on a specific MySQL table
mysql_table_statsA	Get table statistics including row count, data size, and index size
mysql_show_statusC	Show MySQL server status variables (connections, queries, etc.)
mysql_show_variablesB	Show MySQL server configuration variables
mysql_kill_processB	Kill a MySQL connection/query by process ID
mysql_list_connectionsA	List all configured MySQL connections with their status (connected/disconnected)
mysql_get_all_schemasB	Get CREATE TABLE statements for all tables in the current database
mysql_get_table_relationshipsA	Get all foreign key relationships between tables in the current database
mysql_execute_batchA	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.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/sijunkim/db-gateway'

If you have feedback or need assistance with the MCP directory API, please join our Discord server