list-sql-instances
Use this tool to retrieve and display all Cloud SQL instances within your current GCP project, enabling quick access and management of your database resources.
Instructions
List all Cloud SQL instances in the current project
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Implementation Reference
- index.ts:591-618 (handler)Executes the logic to list Cloud SQL instances in the selected GCP project using SqlInstancesServiceClient, handles errors, and returns formatted JSON.} else if (name === "list-sql-instances") { if (!selectedProject) { return createTextResponse("No project selected. Please select a project first."); } try { const sqlClient = new SqlInstancesServiceClient({ fallback: 'rest' // Use HTTP/1.1 fallback mode instead of gRPC }); const request = { project: selectedProject }; const [response] = await sqlClient.list(request); return createTextResponse(JSON.stringify({ instances: (response?.items || []).map(instance => ({ name: instance.name || null, databaseVersion: instance.databaseVersion || null, state: instance.state || null, region: instance.region || null })) }, null, 2)); } catch (error: any) { console.error('Error listing SQL instances:', error); return createTextResponse(`Error listing SQL instances: ${error.message}`); }
- index.ts:185-193 (registration)Registers the 'list-sql-instances' tool with the MCP server, specifying its name, description, and empty input schema (no parameters required).{ name: "list-sql-instances", description: "List all Cloud SQL instances in the current project", inputSchema: { type: "object", properties: {}, required: [], }, },
- index.ts:258-263 (schema)TypeScript interface defining the shape of each SQL instance object returned in the tool's response.interface SQLInstance { name: string | null; databaseVersion: string | null; state: string | null; region: string | null; }