SQL Server MCP

Instructions

Implementation Reference

• src/tools/schema.ts:64-74 (handler)

  Implements the core logic for the 'get-tables' tool by querying INFORMATION_SCHEMA.TABLES to retrieve and return a list of base tables in the database.

  async getTables() {
      const tables = await database.query(`
          SELECT TABLE_NAME, TABLE_TYPE
          FROM INFORMATION_SCHEMA.TABLES
          WHERE TABLE_TYPE = 'BASE TABLE'
      `);
  
      if (!tables.length) return this.toResult("No tables found in the database.");
  
      return this.toResult(`Tables found in the database:\n${JSON.stringify(tables)}`);
  }

• src/tools/schema.ts:10-14 (registration)

  Registers the 'get-tables' tool with the MCP server, providing its name, description, and binding it to the getTables handler method.

  server.tool(
      "get-tables",
      "Get a list of all tables in the database",
      tools.getTables.bind(tools)
  );