Warp SQL Server MCP

Instructions

Implementation Reference

• lib/tools/handlers/database-tools.js:44-71 (handler)

  Core handler function that constructs and executes SQL query to list tables in a database/schema

  async listTables(database = null, schema = 'dbo') {
    let query;
  
    if (database) {
      query = `
        SELECT 
          t.TABLE_SCHEMA as schema_name,
          t.TABLE_NAME as table_name,
          t.TABLE_TYPE as table_type
        FROM [${database}].INFORMATION_SCHEMA.TABLES t
        WHERE t.TABLE_SCHEMA = '${schema}'
        ORDER BY t.TABLE_SCHEMA, t.TABLE_NAME
      `;
    } else {
      query = `
        SELECT 
          t.TABLE_SCHEMA as schema_name,
          t.TABLE_NAME as table_name,
          t.TABLE_TYPE as table_type
        FROM INFORMATION_SCHEMA.TABLES t
        WHERE t.TABLE_SCHEMA = '${schema}'
        ORDER BY t.TABLE_SCHEMA, t.TABLE_NAME
      `;
    }
  
    const result = await this.executeQuery(query, 'list_tables');
    return this.formatResults(result);
  }

• index.js:261-264 (registration)

  Tool dispatch/registration in the main MCP server switch statement, calling the databaseTools handler

  case 'list_tables':
    return {
      content: await this.databaseTools.listTables(args.database, args.schema)
    };

• lib/tools/tool-registry.js:25-36 (schema)

  Tool schema definition including input validation schema for list_tables

  name: 'list_tables',
  description: 'List all tables in a specific database',
  inputSchema: {
    type: 'object',
    properties: {
      database: {
        type: 'string',
        description: 'Database name (optional, uses current database if not specified)'
      },
      schema: { type: 'string', description: 'Schema name (optional, defaults to dbo)' }
    }
  }

• index.js:241-242 (registration)

  Registration of the tool list handler which provides all tools including list_tables via tool-registry.js

  this.server.setRequestHandler(ListToolsRequestSchema, async () => ({
    tools: getAllTools()

• index.js:527-532 (handler)

  Wrapper handler method on the main server class for testing/compatibility purposes, delegates to databaseTools.listTables

  async listTables(...args) {
    try {
      return { content: await this.databaseTools.listTables(...args) };
    } catch (error) {
      throw new McpError(ErrorCode.InternalError, error.message);
    }