mysql_list_databases
Retrieve a complete list of all databases available on your MySQL server for database management and connection setup.
Instructions
List all databases on the MySQL server
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Implementation Reference
- src/index.ts:346-364 (handler)The main handler function implementing the mysql_list_databases tool. It checks for an active MySQL connection, executes the 'SHOW DATABASES' SQL query, formats the results as JSON, and returns them in the MCP response format.private async handleListDatabases() { if (!this.pool) { throw new Error("Not connected to MySQL. Use mysql_connect first."); } try { const [results] = await this.pool.execute("SHOW DATABASES"); return { content: [ { type: "text", text: `Available databases:\n${JSON.stringify(results, null, 2)}`, }, ], }; } catch (error) { throw new Error(`Failed to list databases: ${error instanceof Error ? error.message : String(error)}`); } }
- src/index.ts:157-164 (registration)Tool registration in the ListTools response, including name, description, and input schema (empty properties, no required parameters).{ name: "mysql_list_databases", description: "List all databases on the MySQL server", inputSchema: { type: "object", properties: {}, }, },
- src/index.ts:160-163 (schema)Input schema definition for the mysql_list_databases tool, specifying an empty object (no input parameters needed).inputSchema: { type: "object", properties: {}, },
- src/index.ts:253-254 (registration)Dispatch/registration in the CallToolRequest switch statement, routing calls to mysql_list_databases to the handleListDatabases function.case "mysql_list_databases": return await this.handleListDatabases();