MCP Builder Example 1 Database Query Tool

Sub-skill of mcp-builder: Example 1: Database Query Tool (+1).

vamseeachanta Updated

File contents

Example 1: Database Query Tool (+1)

Example 1: Database Query Tool

server.setRequestHandler(CallToolRequestSchema, async (request) => {
  if (request.params.name === "query_database") {
    const { sql, params } = request.params.arguments;
    const result = await db.query(sql, params);
    return { content: [{ type: "text", text: JSON.stringify(result, null, 2) }] };
  }
});

Example 2: API Integration

server.setRequestHandler(CallToolRequestSchema, async (request) => {
  if (request.params.name === "fetch_weather") {
    const { city } = request.params.arguments;
    const response = await fetch(`https://api.weather.com/v1/${city}`);
    const data = await response.json();
    return { content: [{ type: "text", text: `Temperature: ${data.temp}F` }] };
  }
});

vamseeachanta/workspace-hub/tree/main/.agents/skills/_archive/development/mcp-builder/example-1-database-query-tool commit 973085279a

Frequently asked questions

npx skillmds@latest add vamseeachanta/mcp-builder-example-1-database-query-tool